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
• Status: Can't repeat
• Category: MySQL Server: mysqldump Command-line Client
• Severity: S3 (Non-critical)
• Version: 5.1.32
• OS: Any (Discovered on Fedora 10, but probably all)
• CPU Architecture: Any

[27 Mar 2009 23:38] Markus Popp

Description:
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"