|
Hello, While trying to make some inserts in the database, we get the following errors. This inserts are voluntary uncorrect, (existing keys etc...) for test purposes. I'm a bit disapointed by this message telling that RecoveryLog may be corrupted. What can make this happen ? What should we do to avoid such corruption ? 08:23:41,034 ERROR sequoia.controller.recoverylog Failed to log rollback for transaction 22 com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Column 'sql_data_param' cannot be null at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715) at com.mysql.jdbc.Connection.execSQL(Connection.java:3249) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1541) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1455) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1440) at org.continuent.sequoia.controller.recoverylog.events.LogRequestEvent.execute(LogRequestEvent.java:102) at org.continuent.sequoia.controller.recoverylog.events.LogRollbackEvent.execute(LogRollbackEvent.java:76) at org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThread.java:732) 08:23:41,036 ERROR sequoia.controller.recoverylog WARNING! Your recovery log is probably corrupted, you should perform a restore log operation 08:23:41,036 ERROR sequoia.controller.recoverylog Logger thread was unable to log LogRequestEvent: Log entry: log id15 (T) transactionId:22 requestId:0 vlogin:matisse status: E sql:rollback params:null because of com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Column 'sql_data_param' cannot be null com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Column 'sql_data_param' cannot be null at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715) at com.mysql.jdbc.Connection.execSQL(Connection.java:3249) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1541) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1455) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1440) at org.continuent.sequoia.controller.recoverylog.events.LogRequestEvent.execute(LogRequestEvent.java:102) at org.continuent.sequoia.controller.recoverylog.events.LogRollbackEvent.execute(LogRollbackEvent.java:76) at org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThread.java:732) 08:23:41,041 ERROR sequoia.controller.recoverylog Recovery log was unable to update request completion status: [EMAIL PROTECTED]: UPDATE RECOVERY SET exec_status='S',update_count=0,exec_time=0 WHERE log_id=15 --
Gérard
BUNEL |
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
