"lock table tabname" issue
Posted by:
justin ux
Date: October 29, 2008 09:47AM
Hi,
I locked a table by "lock table tab1;" by root loged in, and then my network connection broke without loging out the Mysql server. I logged in again,I used "unlock tables;" to unlock table , but when I query the tables , the sql was locked ,can't be executed.
And if I want to query other tables , the query sql was also locked ,it is not useful to "unlock tables". I had to restart the Mysql server.
What's the problem? How can unlock table in this situation when the network broke?
Thanks
Justin
Subject
Written By
Posted
"lock table tabname" issue
October 29, 2008 09:47AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.