Bug #71643 Mysql automatic unlocking after certain time

• Submitted: 10 Feb 2014 5:33
• Modified: 14 Mar 2014 7:09
• Reporter: Anupam Gupta
• Status: No Feedback
• Category: MySQL Server: Connection Handling
• Severity: S1 (Critical)
• Version: 5.5
• OS: Microsoft Windows (window server 2008,2003)
• CPU Architecture: Any
• Tags: locking, MySQL, setting variables

[10 Feb 2014 5:33] Anupam Gupta

Description:
i am facing issue in client-server communication as the client is locking the server mysql table with write lock.if Due to any network issues the connection breaks, the table remains in locked state. when we try to unlock it from server via"unlock tables" its not working. i have to kill the process id of the connection to resume work.i have to deal with almost 200 client and in this situation all the production is held up.

i want to design a solution for the purpose such that whenever the mysql find the table locked for more than 5 minutes, it automatically unlock the tables.
kindly advice me some server variable setting to solve the purpose

How to repeat:
 server communication as the client is locking the server mysql table and due to any network issues the connection breaks, hence the table is in locked state. when we try to unlock it from server via"unlock tables" its not working. i have to kill the process id of the connection to resume work

[14 Feb 2014 7:09] Shane Bester

Please see if the following help you:

http://dev.mysql.com/doc/refman/5.5/en/bug-reports.html
http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_wait_timeout
http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_interactive_tim...

[15 Mar 2014 1:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".