Opened 5 years ago

Last modified 4 years ago

#1246 open defect

Syndie: java.sql.SQLDataException: data exception: string data, right truncation

Reported by: killyourtv Owned by:
Priority: minor Milestone:
Component: apps/syndie Version:
Keywords: Cc:
Parent Tickets: Sensitive: no

Description

Pulling from an archive, I received several instances in the log:

java.sql.SQLDataException: data exception: string data, right truncation;  table: MESSAGEATTACHMENT column: NAME
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source)
	at syndie.db.ImportPost.insertAttachment(ImportPost.java:1077)
	at syndie.db.ImportPost.setMessageAttachments(ImportPost.java:1041)
	at syndie.db.ImportPost.importMessageBody(ImportPost.java:553)
	at syndie.db.ImportPost.importMessage(ImportPost.java:535)
	at syndie.db.ImportPost.process(ImportPost.java:489)
	at syndie.db.Importer.importPost(Importer.java:325)
	at syndie.db.Importer.processMessage(Importer.java:225)
	at syndie.db.Importer.processMessage(Importer.java:178)
	at syndie.db.SyncInboundFetcher.importData(SyncInboundFetcher.java:537)
	at syndie.db.SyncInboundFetcher.access$600(SyncInboundFetcher.java:26)
	at syndie.db.SyncInboundFetcher$DataImporter.run(SyncInboundFetcher.java:526)
	at java.lang.Thread.run(Thread.java:744)
Caused by: org.hsqldb.HsqlException: data exception: string data, right truncation;  table: MESSAGEATTACHMENT column: NAME
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.Table.enforceTypeLimits(Unknown Source)
	at org.hsqldb.Table.insertSingleRow(Unknown Source)
	at org.hsqldb.StatementDML.insertSingleRow(Unknown Source)
	at org.hsqldb.StatementInsert.getResult(Unknown Source)
	at org.hsqldb.StatementDMQL.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 14 more
Caused by: org.hsqldb.HsqlException: data exception: string data, right truncation
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.types.CharacterType.convertToTypeLimits(Unknown Source)
	... 21 more

Subtickets

Change History (2)

comment:1 Changed 5 years ago by killyourtv

Also reported by hummingbird in ​Syndie

While watching the Logs tab (doing tests locally with 2 of my Syndies: one client, one server) I saw this error:

2014/05/19 08:52:07.534
java.sql.SQLDataException: data exception: string data, right truncation;  table: MESSAGEATTACHMENT column: NAME
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source)
	at syndie.db.ImportPost.insertAttachment(ImportPost.java:1077)
	at syndie.db.ImportPost.setMessageAttachments(ImportPost.java:1041)
	at syndie.db.ImportPost.importMessageBody(ImportPost.java:553)
	at syndie.db.ImportPost.importMessage(ImportPost.java:535)
	at syndie.db.ImportPost.process(ImportPost.java:489)
	at syndie.db.Importer.importPost(Importer.java:325)
	at syndie.db.Importer.processMessage(Importer.java:225)
	at syndie.db.Importer.processMessage(Importer.java:178)
	at syndie.db.SyncInboundFetcher.importData(SyncInboundFetcher.java:537)
	at syndie.db.SyncInboundFetcher.access$600(SyncInboundFetcher.java:26)
	at syndie.db.SyncInboundFetcher$DataImporter.run(SyncInboundFetcher.java:526)
	at java.lang.Thread.run(Thread.java:744)
Caused by: org.hsqldb.HsqlException: data exception: string data, right truncation;  table: MESSAGEATTACHMENT column: NAME
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.Table.enforceTypeLimits(Unknown Source)
	at org.hsqldb.Table.insertSingleRow(Unknown Source)
	at org.hsqldb.StatementDML.insertSingleRow(Unknown Source)
	at org.hsqldb.StatementInsert.getResult(Unknown Source)
	at org.hsqldb.StatementDMQL.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 14 more
Caused by: org.hsqldb.HsqlException: data exception: string data, right truncation
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.types.CharacterType.convertToTypeLimits(Unknown Source)
	... 21 more

comment:2 Changed 4 years ago by str4d

Status: new → open
Note: See TracTickets for help on using tickets.