Opened 3 years ago

Last modified 3 years ago

#1808 new defect

Syndie 1.106b-1 : errors when first start : "SEVERE readExistingData" and more

Reported by: hummingbird Owned by: zzz
Priority: major Milestone: n/a
Component: apps/syndie Version: 0.9.26
Keywords: Cc:
Parent Tickets:

Description

I tried to launch Syndie from terminal because it did not create icons in the Cinnamon GUI. Note: Syndie 1.105b was properly uninstalled before the installation of 'syndie-installer-1.106b-1.bin.linux64.jar '.

cd syndie/bin
sh syndie.sh

2016-06-18T17:41:18.162+0200  SEVERE  readExistingData failed 31774
org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_CT_10097 table: CHANNEL
	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.Table.insertData(Unknown Source)
	at org.hsqldb.Table.insertFromScript(Unknown Source)
	at org.hsqldb.scriptio.ScriptReaderText.readExistingData(Unknown Source)
	at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source)
	at org.hsqldb.persist.Log.processScript(Unknown Source)
	at org.hsqldb.persist.Log.open(Unknown Source)
	at org.hsqldb.persist.Logger.open(Unknown Source)
	at org.hsqldb.Database.reopen(Unknown Source)
	at org.hsqldb.Database.close(Unknown Source)
	at org.hsqldb.StatementCommand.getResult(Unknown Source)
	at org.hsqldb.StatementCommand.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.execute(Unknown Source)
	at syndie.db.DBClient.connect(DBClient.java:284)
	at syndie.db.DBClient.connect(DBClient.java:396)
	at syndie.db.TextEngine.processLogin(TextEngine.java:426)
	at syndie.db.TextEngine.access$100(TextEngine.java:33)
	at syndie.db.TextEngine$StartMenu.processCommands(TextEngine.java:1134)
	at syndie.db.TextEngine.processMenu(TextEngine.java:600)
	at syndie.db.TextEngine.doRunStep(TextEngine.java:180)
	at syndie.db.TextEngine.runStep(TextEngine.java:160)
	at syndie.db.TextEngine.run(TextEngine.java:149)
	at syndie.gui.SWTUI$1.run(SWTUI.java:123)
	at java.lang.Thread.run(Thread.java:745)

2016-06-18T17:41:18.166+0200  WARNING  Script processing failure
org.hsqldb.HsqlException: error in script file line: 31774 org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_CT_10097 table: CHANNEL
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.scriptio.ScriptReaderText.readExistingData(Unknown Source)
	at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source)
	at org.hsqldb.persist.Log.processScript(Unknown Source)
	at org.hsqldb.persist.Log.open(Unknown Source)
	at org.hsqldb.persist.Logger.open(Unknown Source)
	at org.hsqldb.Database.reopen(Unknown Source)
	at org.hsqldb.Database.close(Unknown Source)
	at org.hsqldb.StatementCommand.getResult(Unknown Source)
	at org.hsqldb.StatementCommand.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.execute(Unknown Source)
	at syndie.db.DBClient.connect(DBClient.java:284)
	at syndie.db.DBClient.connect(DBClient.java:396)
	at syndie.db.TextEngine.processLogin(TextEngine.java:426)
	at syndie.db.TextEngine.access$100(TextEngine.java:33)
	at syndie.db.TextEngine$StartMenu.processCommands(TextEngine.java:1134)
	at syndie.db.TextEngine.processMenu(TextEngine.java:600)
	at syndie.db.TextEngine.doRunStep(TextEngine.java:180)
	at syndie.db.TextEngine.runStep(TextEngine.java:160)
	at syndie.db.TextEngine.run(TextEngine.java:149)
	at syndie.gui.SWTUI$1.run(SWTUI.java:123)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_CT_10097 table: CHANNEL
	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.Table.insertData(Unknown Source)
	at org.hsqldb.Table.insertFromScript(Unknown Source)
	... 24 more

2016-06-18T17:41:18.277+0200  SEVERE  could not reopen database
org.hsqldb.HsqlException: error in script file line: 31774 org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_CT_10097 table: CHANNEL
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.scriptio.ScriptReaderText.readExistingData(Unknown Source)
	at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source)
	at org.hsqldb.persist.Log.processScript(Unknown Source)
	at org.hsqldb.persist.Log.open(Unknown Source)
	at org.hsqldb.persist.Logger.open(Unknown Source)
	at org.hsqldb.Database.reopen(Unknown Source)
	at org.hsqldb.Database.close(Unknown Source)
	at org.hsqldb.StatementCommand.getResult(Unknown Source)
	at org.hsqldb.StatementCommand.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.execute(Unknown Source)
	at syndie.db.DBClient.connect(DBClient.java:284)
	at syndie.db.DBClient.connect(DBClient.java:396)
	at syndie.db.TextEngine.processLogin(TextEngine.java:426)
	at syndie.db.TextEngine.access$100(TextEngine.java:33)
	at syndie.db.TextEngine$StartMenu.processCommands(TextEngine.java:1134)
	at syndie.db.TextEngine.processMenu(TextEngine.java:600)
	at syndie.db.TextEngine.doRunStep(TextEngine.java:180)
	at syndie.db.TextEngine.runStep(TextEngine.java:160)
	at syndie.db.TextEngine.run(TextEngine.java:149)
	at syndie.gui.SWTUI$1.run(SWTUI.java:123)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_CT_10097 table: CHANNEL
	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.Table.insertData(Unknown Source)
	at org.hsqldb.Table.insertFromScript(Unknown Source)
	... 24 more

2016-06-18T17:41:19.215+0200  SEVERE  readExistingData failed 31774
org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_CT_10097 table: CHANNEL
	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.Table.insertData(Unknown Source)
	at org.hsqldb.Table.insertFromScript(Unknown Source)
	at org.hsqldb.scriptio.ScriptReaderText.readExistingData(Unknown Source)
	at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source)
	at org.hsqldb.persist.Log.processScript(Unknown Source)
	at org.hsqldb.persist.Log.open(Unknown Source)
	at org.hsqldb.persist.Logger.open(Unknown Source)
	at org.hsqldb.Database.reopen(Unknown Source)
	at org.hsqldb.Database.open(Unknown Source)
	at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)
	at org.hsqldb.DatabaseManager.newSession(Unknown Source)
	at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
	at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
	at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
	at java.sql.DriverManager.getConnection(DriverManager.java:571)
	at java.sql.DriverManager.getConnection(DriverManager.java:215)
	at syndie.db.DBClient.connect(DBClient.java:302)
	at syndie.db.DBClient.connect(DBClient.java:396)
	at syndie.db.TextEngine.processLogin(TextEngine.java:426)
	at syndie.db.TextEngine.access$100(TextEngine.java:33)
	at syndie.db.TextEngine$StartMenu.processCommands(TextEngine.java:1134)
	at syndie.db.TextEngine.processMenu(TextEngine.java:600)
	at syndie.db.TextEngine.doRunStep(TextEngine.java:180)
	at syndie.db.TextEngine.runStep(TextEngine.java:160)
	at syndie.db.TextEngine.run(TextEngine.java:149)
	at syndie.gui.SWTUI$1.run(SWTUI.java:123)
	at java.lang.Thread.run(Thread.java:745)

2016-06-18T17:41:19.216+0200  WARNING  Script processing failure
org.hsqldb.HsqlException: error in script file line: 31774 org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_CT_10097 table: CHANNEL
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.scriptio.ScriptReaderText.readExistingData(Unknown Source)
	at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source)
	at org.hsqldb.persist.Log.processScript(Unknown Source)
	at org.hsqldb.persist.Log.open(Unknown Source)
	at org.hsqldb.persist.Logger.open(Unknown Source)
	at org.hsqldb.Database.reopen(Unknown Source)
	at org.hsqldb.Database.open(Unknown Source)
	at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)
	at org.hsqldb.DatabaseManager.newSession(Unknown Source)
	at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
	at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
	at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
	at java.sql.DriverManager.getConnection(DriverManager.java:571)
	at java.sql.DriverManager.getConnection(DriverManager.java:215)
	at syndie.db.DBClient.connect(DBClient.java:302)
	at syndie.db.DBClient.connect(DBClient.java:396)
	at syndie.db.TextEngine.processLogin(TextEngine.java:426)
	at syndie.db.TextEngine.access$100(TextEngine.java:33)
	at syndie.db.TextEngine$StartMenu.processCommands(TextEngine.java:1134)
	at syndie.db.TextEngine.processMenu(TextEngine.java:600)
	at syndie.db.TextEngine.doRunStep(TextEngine.java:180)
	at syndie.db.TextEngine.runStep(TextEngine.java:160)
	at syndie.db.TextEngine.run(TextEngine.java:149)
	at syndie.gui.SWTUI$1.run(SWTUI.java:123)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_CT_10097 table: CHANNEL
	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.Table.insertData(Unknown Source)
	at org.hsqldb.Table.insertFromScript(Unknown Source)
	... 25 more

2016-06-18T17:41:19.326+0200  SEVERE  could not reopen database
org.hsqldb.HsqlException: error in script file line: 31774 org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_CT_10097 table: CHANNEL
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.scriptio.ScriptReaderText.readExistingData(Unknown Source)
	at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source)
	at org.hsqldb.persist.Log.processScript(Unknown Source)
	at org.hsqldb.persist.Log.open(Unknown Source)
	at org.hsqldb.persist.Logger.open(Unknown Source)
	at org.hsqldb.Database.reopen(Unknown Source)
	at org.hsqldb.Database.open(Unknown Source)
	at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)
	at org.hsqldb.DatabaseManager.newSession(Unknown Source)
	at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
	at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
	at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
	at java.sql.DriverManager.getConnection(DriverManager.java:571)
	at java.sql.DriverManager.getConnection(DriverManager.java:215)
	at syndie.db.DBClient.connect(DBClient.java:302)
	at syndie.db.DBClient.connect(DBClient.java:396)
	at syndie.db.TextEngine.processLogin(TextEngine.java:426)
	at syndie.db.TextEngine.access$100(TextEngine.java:33)
	at syndie.db.TextEngine$StartMenu.processCommands(TextEngine.java:1134)
	at syndie.db.TextEngine.processMenu(TextEngine.java:600)
	at syndie.db.TextEngine.doRunStep(TextEngine.java:180)
	at syndie.db.TextEngine.runStep(TextEngine.java:160)
	at syndie.db.TextEngine.run(TextEngine.java:149)
	at syndie.gui.SWTUI$1.run(SWTUI.java:123)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_CT_10097 table: CHANNEL
	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.Table.insertData(Unknown Source)
	at org.hsqldb.Table.insertFromScript(Unknown Source)
	... 25 more

Note: I have a backup of my old Syndie profile.

Subtickets (add)

Change History (3)

comment:1 Changed 3 years ago by hummingbird

Note: after uninstalling then reinstalling the old v1.105b-0, the log is the same as above, and the error message inside the splash window is the same: "Error in script file line:31774 org.hsqldb.HsqlException?: integrity constraint violation: unique constraint or index violation; SYS_CT_10097 table: CHANNEL"

comment:2 Changed 3 years ago by hummingbird

Test: Install Syndie v1.106b-1, replace '/lib/hsqldb.jar' with the one of the v1.105b-0, run Syndie once, shut down, replace '/lib/hsqldb.jar' with the new one, run Syndie.

Log after exiting from the launch # 3 (GUI crashed after I did something) :

(Syndie:9173): GLib-CRITICAL **: Source ID 1079 was not found when attempting to remove it
(Syndie:9173): GLib-CRITICAL **: Source ID 1253 was not found when attempting to remove it
(Syndie:9173): GLib-CRITICAL **: Source ID 1355 was not found when attempting to remove it
(Syndie:9173): GLib-CRITICAL **: Source ID 3852 was not found when attempting to remove it
(Syndie:9173): GLib-CRITICAL **: Source ID 4442 was not found when attempting to remove it
(Syndie:9173): GLib-CRITICAL **: Source ID 4560 was not found when attempting to remove it
(Syndie:9173): GLib-CRITICAL **: Source ID 8082 was not found when attempting to remove it
(Syndie:9173): Gdk-ERROR **: The program 'Syndie' received an X Window System error.
This probably reflects a bug in the program.
The error was 'BadMatch (invalid parameter attributes)'.
  (Details: serial 49556 error_code 8 request_code 62 (core protocol) minor_code 0)
  (Note to programmers: normally, X errors are reported asynchronously;
   that is, you will receive the error a while after causing it.
   To debug your program, run it with the GDK_SYNCHRONIZE environment
   variable to change this behavior. You can then get a meaningful
   backtrace from your debugger if you break on the gdk_x_error() function.)
Trace/breakpoint trap

Note: The GUI crash occurs as soon as I open the forum 'Syndie chat'.

Log after exiting from the launch # 2 :

(Syndie:10425): GLib-CRITICAL **: Source ID 505 was not found when attempting to remove it
(Syndie:10425): GLib-CRITICAL **: Source ID 1698 was not found when attempting to remove it
(Syndie:10425): Gtk-CRITICAL **: gtk_widget_set_size_request: assertion 'GTK_IS_WIDGET (widget)' failed

Log after exiting from the launch # 3 :

(Syndie:10425): GLib-CRITICAL **: Source ID 505 was not found when attempting to remove it
(Syndie:10425): GLib-CRITICAL **: Source ID 1698 was not found when attempting to remove it
(Syndie:10425): Gtk-CRITICAL **: gtk_widget_set_size_request: assertion 'GTK_IS_WIDGET (widget)' failed

comment:3 Changed 3 years ago by aargh

  • Component changed from www/syndie to apps/syndie
Note: See TracTickets for help on using tickets.