Bug #19629 FLUSH TABLES WITH READ LOCK doesn't work in some cases

• Submitted: 9 May 2006 8:33
• Modified: 9 May 2006 9:07
• Reporter: [ name withheld ]
• Status: Not a Bug
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.0.20
• OS: Linux (Linux 2.6.12)
• CPU Architecture: Any

[9 May 2006 8:33] [ name withheld ]

Description:
FLUSH TABLES WITH READ LOCK doesn't work if I do like below.

./mysql -u root -p temptable <<<"flush tables with read lock ;"

or

ssh remote_machine /pathToMySQL/bin/mysql -u root -p temptable <<<"flush tables with read lock ;"

Here, root surely has Lock_table_priv and lock tables wirh read lock works when I do on mysql console like below.

mysql>flush tables with read lock ;

I didn't set up root password here for the other reason and it works well except above.

Please, let me know what I did wrong.

How to repeat:
Try to do like below.

./mysql -u root -p temptable <<<"flush tables with read lock ;"

or

ssh remote_machine /pathToMySQL/bin/mysql -u root -p temptable <<<"flush tables with read lock ;"

and try to update tables. Even though it is locked, db data is updated.

[9 May 2006 9:07] Hartmut Holzgraefe

We're sorry, but the bug system is not the appropriate forum for 
asking help on using MySQL products. Your problem is not the result 
of a bug.

Support on using our products is available both free in our forums
at http://forums.mysql.com and for a reasonable fee direct from our
skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

Additional info:

all locks are released when a client connection is closed