mysqldump from RHEL6 fails against RHEL5 server

Solution Verified - Updated -

Environment

  • Red Hat enterprise Linux 6
  • mysql-5.1.66

Issue

  • mysqldump from RHEL6 fails against RHEL5 server fails with following message.
Error: Couldn't read status information for table general_log ()
mysqldump: Couldn't execute 'show create table `general_log`': Table 'mysql.general_log' doesn't exist (1146)

Resolution

This bug is addressed in bz877557.

Update to the new mysql version, once an official fix is released.

Workaround

Reverting back to the older mysql versions.

Root Cause

This happens because general_log table is not available in the RHEL5 mysql-server and an new code included in mysql-5.1.66 assumes that general_log and slow_log exists.

Diagnostic Steps

Dropping general_log in RHEL6 also reproduced the issue.

mysql> use mysql;

mysql> SET GLOBAL general_log = 'OFF';
Query OK, 0 rows affected (0.00 sec)

mysql> DROP TABLE general_log;
Query OK, 0 rows affected (0.25 sec)

$ mysqldump --all-databases --lock-all-tables > dump.sql
Error: Couldn't read status information for table general_log ()
mysqldump: Couldn't execute 'show create table `general_log`': Table 'mysql.general_log' doesn't exist (1146)

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.

Comments