|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: Transaction newbie question
From: Mike Gollub (crankyinmv
yahoo.com)
Date: Thu Nov 20 2003 - 17:38:14 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
OK, I don't seem to be getting a response. Let me try to simplify:
I'm running a PHP application with MySQL.
I'm in a transaction involving only BDB tables. Actually the whole database has nothing but BDB
tables.
I attempt a query which fails with error number 1213. The full text message is something like:
Can't get lock because of a deadlock.
My questions:
1. When the query fails am I still inside the transaction, or has it already been rolled back ?
2. If the transaction has not been rolled back, how many times should I re-try the query before
giving up and re-starting the transaction ?
3. If the transaction has been rolled back, what is a reasonable number of times to re-start the
transaction ?
- Mike.
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]