Hi,
Try changing the sqlsrc field to LONGTEXT in your VDB definition. BLOB is
limited to 64K.
Cheers, Robert
On 8/5/08 8:03 PM, "季虎" <[EMAIL PROTECTED]> wrote:
Hi dudes:
I had a table with BLOB filed.
And i had change the field sql_paras in table recover table to blob type too.
But sequoia still report the following errors
|!%> completionLogId: -1 because of com.mysql.jdbc.MysqlDataTruncation: Data
truncation: Data too long for column 'sqlsrc_param' at row 1
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column
'sqlsrc_param' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3374)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1737)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2022)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1940)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1925)
at
org.continuent.sequoia.controller.recoverylog.events.LogRequestEvent.execute(LogRequestEvent.java:103)
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThread.java:735)
19:53:17,178 ERROR sequoia.controller.recoverylog Recovery log was unable to
update request completion status: [EMAIL PROTECTED]: UPD RECOVERY SET
exec_status='S',update_count=1,exec_time=32,completion_log_id=52 WHERE log_id=52
Any body help me?
--
Robert Hodges, CTO, Continuent, Inc.
Email: [EMAIL PROTECTED]
Mobile: +1-510-501-3728 Skype: hodgesrm
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
