View Full Version : transaction deadlock when using "autocommit"

03-03-2003, 04:01 AM

Transaction is a big problem in MySQL --> here is what I have done
Since the DB is InnoDB, I tried to "set autocommit=0" so that it can be rollback if it wants, and data will not be actually updated into the file disk unless a "commit" is performed.

I typed:

$autocommit = "SET autocommit=0";
$setcommit = mysql_query($autocommit);
echo "<font color = yellow> Setcommit = $setcommit </font><BR>";

and then it worked once, but then for the second time, when I go to mySQL and try to do something, it came an error of :

ERROR 1205: Lock wait timeout exceeded; Try restarting transaction

which is probably the deadlock problem...I have to release the lock by
i) show processlist; (and see which thread is sleeping)
ii) kill thread_id;

Does anyone know how to perform transaction with php using InnoDB?

03-03-2003, 06:18 AM
Read our forum rules. Don't crosspost!!!