MySQL 5.5.10 - Unable to Find any Databases During Replication

{page-title}

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)
{code}

{kb-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.

{kb-resolution}
Upgrade your MySQL Server to 5.5.13 or greater.



{kb-related-articles}