Skip to end of metadata
Go to start of metadata

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
Labels:
mysql mysql Delete
database database Delete
backup backup Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.