Bug #62480 Backup error code 1556

• Submitted: 20 Sep 2011 14:07
• Modified: 20 Oct 2011 14:53
• Reporter: Hugo Sarkisian
• Status: No Feedback
• Category: MySQL Server: Command-line Clients
• Severity: S3 (Non-critical)
• Version: Server 5.1
• OS: Windows (XP 2002 SP3)
• CPU Architecture: Any

[20 Sep 2011 14:07] Hugo Sarkisian

Description:
Hi,

When I perform a data dump of my databases, I receive the following errors in the log report...

Could you help me understand this message?

Thanks and best regards,

Hugo

09:47:24 Dumping mysql (general_log)
Running: "mysqldump.exe" --defaults-extra-file="c:\docume~1\hsarki~1\locals~1\temp\tmp9wpbqs"  
--no-create-info=FALSE --order-by-primary=FALSE --force=FALSE --no-data=FALSE --tz-utc=TRUE 
--flush-privileges=FALSE --compress=FALSE --replace=FALSE --host=localhost --insert-ignore=FALSE 
--extended-insert=TRUE --user=root --quote-names=TRUE --hex-blob=FALSE --complete-insert=FALSE 
--add-locks=TRUE --port=3306 --disable-keys=TRUE --delayed-insert=FALSE --create-options=TRUE 
--delete-master-logs=FALSE --comments=TRUE --default-character-set=utf8 --max_allowed_packet=1G 
--flush-logs=FALSE --dump-date=TRUE --lock-tables=TRUE --allow-keywords=FALSE --events=FALSE "mysql" "general_log"

mysqldump: Got error: 1556: You can't use locks with log tables. when doing LOCK TABLES
Operation failed with exitcode 2

09:47:24 Dumping mysql (slow_log)
Running: "mysqldump.exe" --defaults-extra-file="c:\docume~1\hsarki~1\locals~1\temp\tmpic5efr"  
--no-create-info=FALSE --order-by-primary=FALSE --force=FALSE --no-data=FALSE --tz-utc=TRUE 
--flush-privileges=FALSE --compress=FALSE --replace=FALSE --host=localhost --insert-ignore=FALSE 
--extended-insert=TRUE --user=root --quote-names=TRUE --hex-blob=FALSE --complete-insert=FALSE 
--add-locks=TRUE --port=3306 --disable-keys=TRUE --delayed-insert=FALSE --create-options=TRUE 
--delete-master-logs=FALSE --comments=TRUE --default-character-set=utf8 --max_allowed_packet=1G 
--flush-logs=FALSE --dump-date=TRUE --lock-tables=TRUE --allow-keywords=FALSE --events=FALSE "mysql" "slow_log"

mysqldump: Got error: 1556: You can't use locks with log tables. when doing LOCK TABLES
Operation failed with exitcode 2

How to repeat:
***every time a backup is perform***

[20 Sep 2011 14:17] MySQL Verification Team

Which exactly version of server are you using 5.1.XX?.

[20 Sep 2011 14:26] Hugo Sarkisian

5.2.31 CE (Revision 7115)

[20 Sep 2011 14:53] Valeriy Kravchuk

So, you probably use old version of mysqldump from old version of Workbench. Error message is clear - you can not lock general_log table. This was a known bug in mysqldump, see bug #26121 and bug #34306.

Please, check what exact mysqldump binary is used (full pathname) and send the results of:

mysqldump --version

for it.

[20 Oct 2011 23: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".