Opened 3 years ago

Last modified 3 years ago

#1944 open defect

Syndie v1.107b : error messages in the logs when sync with a archive

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

Description

When synchronizing with archives, since several days I see this kind of error messages. I don't know if this is a bug, perhaps this is related to a bad message.

2017/02/11 09:55:34.447
java.sql.SQLException: IO error: RowInputBinary
	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.insertToChannel(ImportPost.java:877)
	at syndie.db.ImportPost.importMessage(ImportPost.java:530)
	at syndie.db.ImportPost.process(ImportPost.java:489)
	at syndie.db.Importer.importPost(Importer.java:327)
	at syndie.db.Importer.processMessage(Importer.java:227)
	at syndie.db.Importer.processMessage(Importer.java:180)
	at syndie.db.SyncInboundFetcher.importData(SyncInboundFetcher.java:543)
	at syndie.db.SyncInboundFetcher.access$600(SyncInboundFetcher.java:28)
	at syndie.db.SyncInboundFetcher$DataImporter.run(SyncInboundFetcher.java:531)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.hsqldb.HsqlException: IO error: RowInputBinary
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.rowio.RowInputBinary.readInt(Unknown Source)
	at org.hsqldb.index.NodeAVLDisk.<init>(Unknown Source)
	at org.hsqldb.RowAVLDisk.<init>(Unknown Source)
	at org.hsqldb.persist.RowStoreAVLDisk.get(Unknown Source)
	at org.hsqldb.persist.DataFileCache.getFromFile(Unknown Source)
	at org.hsqldb.persist.DataFileCache.get(Unknown Source)
	at org.hsqldb.persist.RowStoreAVLDisk.get(Unknown Source)
	at org.hsqldb.index.NodeAVLDisk.findNode(Unknown Source)
	at org.hsqldb.index.NodeAVLDisk.getRight(Unknown Source)
	at org.hsqldb.index.NodeAVLDisk.child(Unknown Source)
	at org.hsqldb.index.IndexAVL.insert(Unknown Source)
	at org.hsqldb.persist.RowStoreAVL.indexRow(Unknown Source)
	at org.hsqldb.persist.RowStoreAVLDisk.indexRow(Unknown Source)
	at org.hsqldb.TransactionManager2PL.addInsertAction(Unknown Source)
	at org.hsqldb.Session.addInsertAction(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)
	... 12 more
Caused by: java.io.EOFException
	at org.hsqldb.lib.HsqlByteArrayInputStream.readInt(Unknown Source)
	... 33 more

2017/02/11 09:55:34.447  Error importing the message
2017/02/11 09:55:34.424  No read keys known for MQ30Zs-sqBZIflIUJRO~vCMSMR2FV80M-jLenxuV~1A=
2017/02/11 09:55:34.405
java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_CT_10143 table: CHANNELMESSAGE
	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.insertToChannel(ImportPost.java:877)
	at syndie.db.ImportPost.importMessage(ImportPost.java:530)
	at syndie.db.ImportPost.process(ImportPost.java:489)
	at syndie.db.Importer.importPost(Importer.java:327)
	at syndie.db.Importer.processMessage(Importer.java:227)
	at syndie.db.Importer.processMessage(Importer.java:180)
	at syndie.db.SyncInboundFetcher.importData(SyncInboundFetcher.java:543)
	at syndie.db.SyncInboundFetcher.access$600(SyncInboundFetcher.java:28)
	at syndie.db.SyncInboundFetcher$DataImporter.run(SyncInboundFetcher.java:531)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_CT_10143 table: CHANNELMESSAGE
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.Constraint.getException(Unknown Source)
	at org.hsqldb.index.IndexAVL.insert(Unknown Source)
	at org.hsqldb.persist.RowStoreAVL.indexRow(Unknown Source)
	at org.hsqldb.persist.RowStoreAVLDisk.indexRow(Unknown Source)
	at org.hsqldb.TransactionManager2PL.addInsertAction(Unknown Source)
	at org.hsqldb.Session.addInsertAction(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)
	... 12 more

2017/02/11 09:55:34.405  Error importing the message
2017/02/11 09:55:34.372  No read keys known for MQ30Zs-sqBZIflIUJRO~vCMSMR2FV80M-jLenxuV~1A=
2017/02/11 09:55:33.940  Fetching [http://syndielzlvbxdsah.onion:8080/shared-index.dat] proxy 127.0.0.1:8118
2017/02/11 09:55:29.989  Fetching [http://6d2tru665udiixwb7miyml7joxusehwmrbikyjjpwwwdpand2lza.b32.i2p/shared-index.dat] proxy 127.0.0.1:4444
2017/02/11 09:55:12.326  Fetching [http://syndie.echelon.i2p/shared-index.dat?i2paddresshelper=4W79xrs~ZVo2nXynH8Dyl4gOTL2qQoCOyndoJaXDkt5bGDemvaCp6AayGWxMM1aFLfZayS6dy79-UGK2xabOMatg~zcvb3QNOgelAXpMhLBb3htZchXHoWed73Zu8HhBM9RkU2hEoknVIQ6wYWCDTabPwTy0AiMgnL7sPvlIUr3OoYx6K6~QUJ4aY3qhOxlT7~agx~AB8YG9lRpwMcooCy-vxwDOIP3pX71sy-0ag~-lE4UmQ3MSSzlNp7KquzKkMk07BD7TpDrxJpfi9zCqsFCuYYHnHTrsyVApFS-DZZdb0aNHPeKmenimJIiDQgueU3xwVvdINv1puT3Zkzt2H1rMqqu5SMLsesjcRuPsaCazL40J5-7f2aZ1~mGJbxUxQY~53y9eSoCR7-n1W~qL4i6LxwEXpFS4IXWi3lA8hq7i-NqMZwbwHP8elAFg~kNaW9cgeRn~LX0lCZc5ztbYc2qJeMMFtR0kSG3PvOcci961maQYbcEpHVjfgFfFxR4KAAAA] proxy 127.0.0.1:4444

Subtickets

Change History (1)

comment:1 Changed 3 years ago by zzz

Status: newopen
Note: See TracTickets for help on using tickets.