I have an PHP that do application
$sql = "SET AUTOCOMMIT=0";
$db->execQuery($sql);
$sql = "DELETE FROM TABLE X WHERE...";
if($db->execQuery($sql)){
print "ERROR ";
exit(0);
}$sql = "INSERT INTO TABLE ....";
if($db->execQuery($sql)){
print "ERROR ";
exit(0);
}I have a persistent connection to MySQL
DELETE is succeed, but INSERT IS FAILED and i simply exit,
i know that i should do ROLLBACK OR COMMIT OR SET AUTOCOMMIT=1 before exit
However, if i don't do it, another session will wait for this PHP session to finish his transaction and lock wait timeout will arise
How to force to kill process which make lock of table ? since PHP make many persistent connection to MySQL and i don't know
which one is locking the table :(
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
