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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]