MySQL 5.5.10 - Unable to Find any Databases During Replication
Symptom
R1Soft is aware of an issue with this specific version of MySQL (5.5.10). During the replication (backup) process we are unable to find any databases and receive the following errors in the CDP Agent logs.
2012-XX-XX 11:15:54,304 ERROR - TASK(daily): Database instance 'Horde' failed to backup
com.r1soft.backup.server.worker.WorkerException: Database instance backup error
at com.r1soft.backup.server.worker.db.mysql.MySQLInstanceBackupWorker.backupDBsTablesFromInformationSchema(MySQLInstanceBackupWorker.java:285)
at com.r1soft.backup.server.worker.db.mysql.MySQLInstanceBackupWorker.backupInstance(MySQLInstanceBackupWorker.java:206)
at com.r1soft.backup.server.worker.db.mysql.MySQLInstanceBackupWorker.run(MySQLInstanceBackupWorker.java:182)
at com.r1soft.backup.server.task.DataProtectionPolicyTask$BackupDatabaseInstances.run(DataProtectionPolicyTask.java:1674)
Caused by: java.sql.SQLException: ResultSet is from UPDATE. No Data.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7158)
at com.r1soft.backup.server.worker.db.mysql.MySQLInstanceBackupWorker.backupDBsTablesFromInformationSchema(MySQLInstanceBackupWorker.java:242)
Cause
We send the following query to mysql: SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES
All mysql 5.x versions have the 'information_schema.tables' database and the error says we did not query with SELECT and instead sent an update… and no update query is used in MySQL backup.
Resolution
Upgrade your MySQL Server to 5.5.13 or greater.
Related Articles
| Page: MySQL 5.5.10 - Unable to Find any Databases During Replication (Knowledge Base) Labels: mysql, database, backup |
| Page: Restoring Large Number of MySQL Databases (Knowledge Base) Labels: mysql |
| Page: Error restoring MySQL database - MySQLD executable not found! (Knowledge Base) Labels: mysql, database, restore |
| Page: MySQL 5.5.10 - Unable to Find any Databases During Replication (Knowledge Base) Labels: mysql, database, backup |
| Page: Error restoring MySQL database - MySQLD executable not found! (Knowledge Base) Labels: mysql, database, restore |
| Page: Database Disk Image Malformed (Knowledge Base) Labels: database, disk, image, malformed, disksafe, hardware, faults |
| Page: How To - Restore the Server Backup Manager H2 Database from backup (Knowledge Base) Labels: h2, internal, database |
| Page: MySQL 5.5.10 - Unable to Find any Databases During Replication (Knowledge Base) Labels: mysql, database, backup |
| Page: How to change the location of the backing file in a replication policy. (Linux Agents) (Knowledge Base) Labels: backup, replication, performance, configuration, cdp_agent, backing, file |