View Source

{page-title}

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

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