Bug #43928 mysqldump complains about locking of log tables despite them being ignored
Submitted: 27 Mar 2009 23:38 Modified: 14 Apr 2009 9:03
Reporter: Markus Popp Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server: mysqldump Command-line Client Severity:S3 (Non-critical)
Version:5.1.32 OS:Any (Discovered on Fedora 10, but probably all)
Assigned to: CPU Architecture:Any

[27 Mar 2009 23:38] Markus Popp
I tried to create a dump of the mysql database, but excluding general_log and slow_log tables:

$  mysqldump --database mysql --opt --ignore-table=mysql.general_log --ignore-table=mysql.slow_log > mysql.sql

Though I explicitly asked the log tables to be ignored, MySQL complains about locking issues regarding these tables:

mysqldump: Got error: 1556: You can't use locks with log tables. when using LOCK TABLES

How to repeat:
see above (initially I had --opt at the end, but to make sure --opt doesn't override the previous --ignore-table's I put it before them ... the result was the same in both cases)

Suggested fix:
If locking tables are to be ignored, mysqldump should not care about locking issues related to them.
[30 Mar 2009 7:05] Sveta Smirnova
Thank you for the report.

I can not repeat described behavior. Additionally there were bug #26121 and bug #34306 about very same problem which were fixed already. Are you sure you run latest version of mysqldump and MySQL server? If so, please, provide your configuration file.
[10 Apr 2009 20:45] Markus Popp
Appears to work in MySQL 5.1.33, so this can be closed.
[14 Apr 2009 9:03] Sveta Smirnova
Thank you for the feedback.

Closed as "Can't repeat"