Opened 6 years ago

Closed 5 years ago

#1129 closed defect (wontfix)

Syndie: UTFDataFormatException upgrading from HSQLDB1 to HSQLDB2

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

Description

I'm pretty sure I was running 1.104b-1 with HSQLDB1 at the time of the upgrade to 1.104b-6-rc.

Starting with the new version yielded:

HTTP archive server listening on 8997
* Command execution complete. 
* Status: 0
* Location: 
* Next command: * Command execution complete. 
* Status: 0
* Location: 
* Next command: 2013-11-12T23:32:10.165+0000  SEVERE  ./db/syndie.data getFromFile 573545032
org.hsqldb.HsqlException: java.io.UTFDataFormatException
        at org.hsqldb.error.Error.error(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.persist.RowStoreAVLDisk.setAccessor(Unknown Source)                                                                                                                                    
        at org.hsqldb.Table.setIndexRoots(Unknown Source)
        at org.hsqldb.Table.setIndexRoots(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.scriptio.ScriptReaderText.readDDL(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.openPersistence(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:233)
        at syndie.db.DBClient.connect(DBClient.java:172)
        at syndie.db.DBClient.connect(DBClient.java:396)
        at syndie.db.TextEngine.processLogin(TextEngine.java:425)
        at syndie.db.TextEngine.access$100(TextEngine.java:33)
        at syndie.db.TextEngine$StartMenu.processCommands(TextEngine.java:1133)
        at syndie.db.TextEngine.processMenu(TextEngine.java:599)
        at syndie.db.TextEngine.doRunStep(TextEngine.java:179)
        at syndie.db.TextEngine.runStep(TextEngine.java:159)
        at syndie.db.TextEngine.run(TextEngine.java:148)
        at syndie.db.TextUI.run(TextUI.java:295)
        at syndie.db.TextUI.main(TextUI.java:236)
Caused by: java.io.UTFDataFormatException
        at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
        at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readString(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readChar(Unknown Source)
        at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
        at org.hsqldb.RowAVLDisk.<init>(Unknown Source)
        ... 35 more

2013-11-12T23:32:10.167+0000  WARNING  java.io.UTFDataFormatException in statement [SET TABLE NYMARCHIVE INDEX'573545032 0']
org.hsqldb.HsqlException: java.io.UTFDataFormatException
        at org.hsqldb.error.Error.error(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.persist.RowStoreAVLDisk.setAccessor(Unknown Source)
        at org.hsqldb.Table.setIndexRoots(Unknown Source)
        at org.hsqldb.Table.setIndexRoots(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.scriptio.ScriptReaderText.readDDL(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.openPersistence(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:233)
        at syndie.db.DBClient.connect(DBClient.java:172)
        at syndie.db.DBClient.connect(DBClient.java:396)
        at syndie.db.TextEngine.processLogin(TextEngine.java:425)
        at syndie.db.TextEngine.access$100(TextEngine.java:33)
        at syndie.db.TextEngine$StartMenu.processCommands(TextEngine.java:1133)
        at syndie.db.TextEngine.processMenu(TextEngine.java:599)
        at syndie.db.TextEngine.doRunStep(TextEngine.java:179)
        at syndie.db.TextEngine.runStep(TextEngine.java:159)
        at syndie.db.TextEngine.run(TextEngine.java:148)
        at syndie.db.TextUI.run(TextUI.java:295)
        at syndie.db.TextUI.main(TextUI.java:236)
Caused by: java.io.UTFDataFormatException
        at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
        at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readString(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readChar(Unknown Source)
        at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
        at org.hsqldb.RowAVLDisk.<init>(Unknown Source)
        ... 35 more

2013-11-12T23:32:10.169+0000  WARNING  Script processing failure
org.hsqldb.HsqlException: error in script file line: 81 java.io.UTFDataFormatException in statement [SET TABLE NYMARCHIVE INDEX'573545032 0']
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.scriptio.ScriptReaderText.readDDL(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.openPersistence(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:233)
        at syndie.db.DBClient.connect(DBClient.java:172)
        at syndie.db.DBClient.connect(DBClient.java:396)
        at syndie.db.TextEngine.processLogin(TextEngine.java:425)
        at syndie.db.TextEngine.access$100(TextEngine.java:33)
        at syndie.db.TextEngine$StartMenu.processCommands(TextEngine.java:1133)
        at syndie.db.TextEngine.processMenu(TextEngine.java:599)
        at syndie.db.TextEngine.doRunStep(TextEngine.java:179)
        at syndie.db.TextEngine.runStep(TextEngine.java:159)
        at syndie.db.TextEngine.run(TextEngine.java:148)
        at syndie.db.TextUI.run(TextUI.java:295)
        at syndie.db.TextUI.main(TextUI.java:236)
Caused by: org.hsqldb.HsqlException: java.io.UTFDataFormatException
        at org.hsqldb.error.Error.error(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.persist.RowStoreAVLDisk.setAccessor(Unknown Source)
        at org.hsqldb.Table.setIndexRoots(Unknown Source)
        at org.hsqldb.Table.setIndexRoots(Unknown Source)
        at org.hsqldb.StatementCommand.getResult(Unknown Source)
        at org.hsqldb.StatementCommand.execute(Unknown Source)
        at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
        ... 25 more
Caused by: java.io.UTFDataFormatException
        at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
        at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readString(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readChar(Unknown Source)
        at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
        at org.hsqldb.RowAVLDisk.<init>(Unknown Source)
        ... 35 more

2013-11-12T23:32:10.275+0000  SEVERE  could not reopen database
org.hsqldb.HsqlException: error in script file line: 81 java.io.UTFDataFormatException in statement [SET TABLE NYMARCHIVE INDEX'573545032 0']
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.scriptio.ScriptReaderText.readDDL(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.openPersistence(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:233)
        at syndie.db.DBClient.connect(DBClient.java:172)
        at syndie.db.DBClient.connect(DBClient.java:396)
        at syndie.db.TextEngine.processLogin(TextEngine.java:425)
        at syndie.db.TextEngine.access$100(TextEngine.java:33)
        at syndie.db.TextEngine$StartMenu.processCommands(TextEngine.java:1133)
        at syndie.db.TextEngine.processMenu(TextEngine.java:599)
        at syndie.db.TextEngine.doRunStep(TextEngine.java:179)
        at syndie.db.TextEngine.runStep(TextEngine.java:159)
        at syndie.db.TextEngine.run(TextEngine.java:148)
        at syndie.db.TextUI.run(TextUI.java:295)
        at syndie.db.TextUI.main(TextUI.java:236)
Caused by: org.hsqldb.HsqlException: java.io.UTFDataFormatException
        at org.hsqldb.error.Error.error(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.persist.RowStoreAVLDisk.setAccessor(Unknown Source)
        at org.hsqldb.Table.setIndexRoots(Unknown Source)
        at org.hsqldb.Table.setIndexRoots(Unknown Source)
        at org.hsqldb.StatementCommand.getResult(Unknown Source)
        at org.hsqldb.StatementCommand.execute(Unknown Source)
        at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
        ... 25 more
Caused by: java.io.UTFDataFormatException
        at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
        at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readString(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readChar(Unknown Source)
        at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
        at org.hsqldb.RowAVLDisk.<init>(Unknown Source)
        ... 35 more

2013-11-12T23:32:10.767+0000  SEVERE  ./db/syndie.data getFromFile 573545032
org.hsqldb.HsqlException: java.io.UTFDataFormatException
        at org.hsqldb.error.Error.error(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.persist.RowStoreAVLDisk.setAccessor(Unknown Source)
        at org.hsqldb.Table.setIndexRoots(Unknown Source)
        at org.hsqldb.Table.setIndexRoots(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.scriptio.ScriptReaderText.readDDL(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.openPersistence(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:249)
        at syndie.db.DBClient.connect(DBClient.java:396)
        at syndie.db.TextEngine.processLogin(TextEngine.java:425)
        at syndie.db.TextEngine.access$100(TextEngine.java:33)
        at syndie.db.TextEngine$StartMenu.processCommands(TextEngine.java:1133)
        at syndie.db.TextEngine.processMenu(TextEngine.java:599)
        at syndie.db.TextEngine.doRunStep(TextEngine.java:179)
        at syndie.db.TextEngine.runStep(TextEngine.java:159)
        at syndie.db.TextEngine.run(TextEngine.java:148)
        at syndie.db.TextUI.run(TextUI.java:295)
        at syndie.db.TextUI.main(TextUI.java:236)
Caused by: java.io.UTFDataFormatException
        at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
        at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readString(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readChar(Unknown Source)
        at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
        at org.hsqldb.RowAVLDisk.<init>(Unknown Source)
        ... 35 more

2013-11-12T23:32:10.768+0000  WARNING  java.io.UTFDataFormatException in statement [SET TABLE NYMARCHIVE INDEX'573545032 0']
org.hsqldb.HsqlException: java.io.UTFDataFormatException
        at org.hsqldb.error.Error.error(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.persist.RowStoreAVLDisk.setAccessor(Unknown Source)
        at org.hsqldb.Table.setIndexRoots(Unknown Source)
        at org.hsqldb.Table.setIndexRoots(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.scriptio.ScriptReaderText.readDDL(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.openPersistence(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:249)
        at syndie.db.DBClient.connect(DBClient.java:396)
        at syndie.db.TextEngine.processLogin(TextEngine.java:425)
        at syndie.db.TextEngine.access$100(TextEngine.java:33)
        at syndie.db.TextEngine$StartMenu.processCommands(TextEngine.java:1133)
        at syndie.db.TextEngine.processMenu(TextEngine.java:599)
        at syndie.db.TextEngine.doRunStep(TextEngine.java:179)
        at syndie.db.TextEngine.runStep(TextEngine.java:159)
        at syndie.db.TextEngine.run(TextEngine.java:148)
        at syndie.db.TextUI.run(TextUI.java:295)
        at syndie.db.TextUI.main(TextUI.java:236)
Caused by: java.io.UTFDataFormatException
        at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
        at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readString(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readChar(Unknown Source)
        at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
        at org.hsqldb.RowAVLDisk.<init>(Unknown Source)
        ... 35 more

2013-11-12T23:32:10.769+0000  WARNING  Script processing failure
org.hsqldb.HsqlException: error in script file line: 81 java.io.UTFDataFormatException in statement [SET TABLE NYMARCHIVE INDEX'573545032 0']
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.scriptio.ScriptReaderText.readDDL(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.openPersistence(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:249)
        at syndie.db.DBClient.connect(DBClient.java:396)
        at syndie.db.TextEngine.processLogin(TextEngine.java:425)
        at syndie.db.TextEngine.access$100(TextEngine.java:33)
        at syndie.db.TextEngine$StartMenu.processCommands(TextEngine.java:1133)
        at syndie.db.TextEngine.processMenu(TextEngine.java:599)
        at syndie.db.TextEngine.doRunStep(TextEngine.java:179)
        at syndie.db.TextEngine.runStep(TextEngine.java:159)
        at syndie.db.TextEngine.run(TextEngine.java:148)
        at syndie.db.TextUI.run(TextUI.java:295)
        at syndie.db.TextUI.main(TextUI.java:236)
Caused by: org.hsqldb.HsqlException: java.io.UTFDataFormatException
        at org.hsqldb.error.Error.error(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.persist.RowStoreAVLDisk.setAccessor(Unknown Source)
        at org.hsqldb.Table.setIndexRoots(Unknown Source)
        at org.hsqldb.Table.setIndexRoots(Unknown Source)
        at org.hsqldb.StatementCommand.getResult(Unknown Source)
        at org.hsqldb.StatementCommand.execute(Unknown Source)
        at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
        ... 25 more
Caused by: java.io.UTFDataFormatException
        at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
        at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readString(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readChar(Unknown Source)
        at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
        at org.hsqldb.RowAVLDisk.<init>(Unknown Source)
        ... 35 more

2013-11-12T23:32:10.872+0000  SEVERE  could not reopen database
org.hsqldb.HsqlException: error in script file line: 81 java.io.UTFDataFormatException in statement [SET TABLE NYMARCHIVE INDEX'573545032 0']
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.scriptio.ScriptReaderText.readDDL(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.openPersistence(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:249)
        at syndie.db.DBClient.connect(DBClient.java:396)
        at syndie.db.TextEngine.processLogin(TextEngine.java:425)
        at syndie.db.TextEngine.access$100(TextEngine.java:33)
        at syndie.db.TextEngine$StartMenu.processCommands(TextEngine.java:1133)
        at syndie.db.TextEngine.processMenu(TextEngine.java:599)
        at syndie.db.TextEngine.doRunStep(TextEngine.java:179)
        at syndie.db.TextEngine.runStep(TextEngine.java:159)
        at syndie.db.TextEngine.run(TextEngine.java:148)
        at syndie.db.TextUI.run(TextUI.java:295)
        at syndie.db.TextUI.main(TextUI.java:236)
Caused by: org.hsqldb.HsqlException: java.io.UTFDataFormatException
        at org.hsqldb.error.Error.error(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.persist.RowStoreAVLDisk.setAccessor(Unknown Source)
        at org.hsqldb.Table.setIndexRoots(Unknown Source)
        at org.hsqldb.Table.setIndexRoots(Unknown Source)
        at org.hsqldb.StatementCommand.getResult(Unknown Source)
        at org.hsqldb.StatementCommand.execute(Unknown Source)
        at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
        ... 25 more
Caused by: java.io.UTFDataFormatException
        at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
        at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readString(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readChar(Unknown Source)
        at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
        at org.hsqldb.RowAVLDisk.<init>(Unknown Source)
        ... 35 more

Error trying to login
java.sql.SQLException: error in script file line: 81 java.io.UTFDataFormatException in statement [SET TABLE NYMARCHIVE INDEX'573545032 0']
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.Util.sqlException(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:249)
        at syndie.db.DBClient.connect(DBClient.java:396)
        at syndie.db.TextEngine.processLogin(TextEngine.java:425)
        at syndie.db.TextEngine.access$100(TextEngine.java:33)
        at syndie.db.TextEngine$StartMenu.processCommands(TextEngine.java:1133)
        at syndie.db.TextEngine.processMenu(TextEngine.java:599)
        at syndie.db.TextEngine.doRunStep(TextEngine.java:179)
        at syndie.db.TextEngine.runStep(TextEngine.java:159)
        at syndie.db.TextEngine.run(TextEngine.java:148)
        at syndie.db.TextUI.run(TextUI.java:295)
        at syndie.db.TextUI.main(TextUI.java:236)
Caused by: org.hsqldb.HsqlException: error in script file line: 81 java.io.UTFDataFormatException in statement [SET TABLE NYMARCHIVE INDEX'573545032 0']
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.scriptio.ScriptReaderText.readDDL(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.openPersistence(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)
        ... 16 more
Caused by: org.hsqldb.HsqlException: java.io.UTFDataFormatException
        at org.hsqldb.error.Error.error(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.persist.RowStoreAVLDisk.setAccessor(Unknown Source)
        at org.hsqldb.Table.setIndexRoots(Unknown Source)
        at org.hsqldb.Table.setIndexRoots(Unknown Source)
        at org.hsqldb.StatementCommand.getResult(Unknown Source)
        at org.hsqldb.StatementCommand.execute(Unknown Source)
        at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
        ... 25 more
Caused by: java.io.UTFDataFormatException
        at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
        at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readString(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readChar(Unknown Source)
        at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
        at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
        at org.hsqldb.RowAVLDisk.<init>(Unknown Source)
        ... 35 more
* Command execution complete. 
* Status: 0
* Location: 
* Next command: * Next command: 

I restored the 1.8 DB and started the GUI version and got the same errors.

Subtickets

Change History (2)

comment:1 Changed 6 years ago by zzz

I doubt we can fix this.

Some guidance here says we should reduce our use of cached tables:

http://osdir.com/ml/java.hsqldb.user/2002-12/msg00004.html

comment:2 Changed 5 years ago by zzz

  • Resolution set to wontfix
  • Status changed from new to closed
Note: See TracTickets for help on using tickets.