Title: ALTRAN OUEST
Gérard,
Your RecoveryLog definition is probably not correct. The
sqlParamColumnType attribute shoud NOT have a 'not null' constraint.
Hope this will solve your issue,
Emmanuel
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
Chef
de Projet
____________________________________________________________________
Technopôle
Brest Iroise
Site du Vernis – CS 23866
29238
Brest Cedex 3
Tél : + 33 2 98 05 43 21
Fax : + 33 2 98 05 20 34
www.altran.com
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
--
Emmanuel Cecchet
Chief Scientific Officer, Continuent
Blog: http://emanux.blogspot.com/
Open source: http://www.continuent.org
Corporate: http://www.continuent.com
Skype: emmanuel_cecchet
Cell: +33 687 342 685
|
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
