HyperSQL Database Engine (HSQLDB)

I met same errors when I opened Sliderule file, converted, closed and reopened in OOo which use 2.2.9 snapshot. I tested more, created hsqldb server, copied all files from odb file /database subdirectories to server as test.script, test.data, ...etc. When I first run server all data was correct. I stopped server with CTRL+C restarted, and I get errors: "c:\Users\Zoltan\Documents\OOotest\hsqldb19\hsqldb-2.2.9_snapshot\hsqldb\bin>runS erver.bat c:\Users\Zoltan\Documents\OOotest\hsqldb19\hsqldb-2.2.9_snapshot\hsqldb\bin>cd . .\data [Server@1e57e8f]: [Thread[main,5,main]]: checkRunning(false) entered [Server@1e57e8f]: [Thread[main,5,main]]: checkRunning(false) exited [Server@1e57e8f]: Startup sequence initiated from main() method [Server@1e57e8f]: Could not load properties from file [Server@1e57e8f]: Using cli/default properties only [Server@1e57e8f]: Initiating startup sequence... [Server@1e57e8f]: Server socket opened successfully in 0 ms. 2012-07-29T17:41:22.113+0200 WARNING failed to read a byte array java.io.EOFException at org.hsqldb.persist.ScaledRAFile.read(ScaledRAFile.java:284) at org.hsqldb.persist.ScaledRAFile.readInt(ScaledRAFile.java:275) at org.hsqldb.persist.DataFileCache.readObject(DataFileCache.java:934) at org.hsqldb.persist.DataFileCache.getFromFile(DataFileCache.java:860) at org.hsqldb.persist.DataFileCache.get(DataFileCache.java:837) at org.hsqldb.persist.RowStoreAVLDisk.get(RowStoreAVLDisk.java:112) at org.hsqldb.persist.RowStoreAVLDisk.setAccessor(RowStoreAVLDisk.java:3 19) at org.hsqldb.Table.setIndexRoots(Table.java:2530) at org.hsqldb.Table.setIndexRoots(Table.java:2574) at org.hsqldb.StatementCommand.getResult(StatementCommand.java:864) at org.hsqldb.StatementCommand.execute(StatementCommand.java:212) at org.hsqldb.Session.executeCompiledStatement(Session.java:1288) at org.hsqldb.scriptio.ScriptReaderText.readDDL(ScriptReaderText.java:11 7) at org.hsqldb.scriptio.ScriptReaderBase.readAll(ScriptReaderBase.java:63 ) at org.hsqldb.persist.Log.processScript(Log.java:743) at org.hsqldb.persist.Log.open(Log.java:147) at org.hsqldb.persist.Logger.openPersistence(Logger.java:400) at org.hsqldb.Database.reopen(Database.java:231) at org.hsqldb.Database.open(Database.java:197) at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:255) at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:188) at org.hsqldb.server.Server.openDatabases(Server.java:1875) at org.hsqldb.server.Server.run(Server.java:2208) at org.hsqldb.server.Server.access$000(Server.java:243) at org.hsqldb.server.Server$ServerThread.run(Server.java:315) 2012-07-29T17:41:22.113+0200 SEVERE test.data getFromFile 160 org.hsqldb.HsqlException: java.io.EOFException at org.hsqldb.error.Error.error(Error.java:113) at org.hsqldb.persist.DataFileCache.readObject(DataFileCache.java:941) at org.hsqldb.persist.DataFileCache.getFromFile(DataFileCache.java:860) at org.hsqldb.persist.DataFileCache.get(DataFileCache.java:837) at org.hsqldb.persist.RowStoreAVLDisk.get(RowStoreAVLDisk.java:112) at org.hsqldb.persist.RowStoreAVLDisk.setAccessor(RowStoreAVLDisk.java:3 19) at org.hsqldb.Table.setIndexRoots(Table.java:2530) at org.hsqldb.Table.setIndexRoots(Table.java:2574) at org.hsqldb.StatementCommand.getResult(StatementCommand.java:864) at org.hsqldb.StatementCommand.execute(StatementCommand.java:212) at org.hsqldb.Session.executeCompiledStatement(Session.java:1288) at org.hsqldb.scriptio.ScriptReaderText.readDDL(ScriptReaderText.java:11 7) at org.hsqldb.scriptio.ScriptReaderBase.readAll(ScriptReaderBase.java:63 ) at org.hsqldb.persist.Log.processScript(Log.java:743) at org.hsqldb.persist.Log.open(Log.java:147) at org.hsqldb.persist.Logger.openPersistence(Logger.java:400) at org.hsqldb.Database.reopen(Database.java:231) at org.hsqldb.Database.open(Database.java:197) at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:255) at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:188) at org.hsqldb.server.Server.openDatabases(Server.java:1875) at org.hsqldb.server.Server.run(Server.java:2208) at org.hsqldb.server.Server.access$000(Server.java:243) at org.hsqldb.server.Server$ServerThread.run(Server.java:315) Caused by: java.io.EOFException at org.hsqldb.persist.ScaledRAFile.read(ScaledRAFile.java:284) at org.hsqldb.persist.ScaledRAFile.readInt(ScaledRAFile.java:275) at org.hsqldb.persist.DataFileCache.readObject(DataFileCache.java:934) ... 22 more 2012-07-29T17:41:22.128+0200 WARNING java.io.EOFException in statement [SET TA BLE PUBLIC."WORLD_CONTINENT" INDEX '160 0 8'] org.hsqldb.HsqlException: java.io.EOFException at org.hsqldb.error.Error.error(Error.java:113) at org.hsqldb.persist.DataFileCache.readObject(DataFileCache.java:941) at org.hsqldb.persist.DataFileCache.getFromFile(DataFileCache.java:860) at org.hsqldb.persist.DataFileCache.get(DataFileCache.java:837) at org.hsqldb.persist.RowStoreAVLDisk.get(RowStoreAVLDisk.java:112) at org.hsqldb.persist.RowStoreAVLDisk.setAccessor(RowStoreAVLDisk.java:3 19) at org.hsqldb.Table.setIndexRoots(Table.java:2530) at org.hsqldb.Table.setIndexRoots(Table.java:2574) at org.hsqldb.StatementCommand.getResult(StatementCommand.java:864) at org.hsqldb.StatementCommand.execute(StatementCommand.java:212) at org.hsqldb.Session.executeCompiledStatement(Session.java:1288) at org.hsqldb.scriptio.ScriptReaderText.readDDL(ScriptReaderText.java:11 7) at org.hsqldb.scriptio.ScriptReaderBase.readAll(ScriptReaderBase.java:63 ) at org.hsqldb.persist.Log.processScript(Log.java:743) at org.hsqldb.persist.Log.open(Log.java:147) at org.hsqldb.persist.Logger.openPersistence(Logger.java:400) at org.hsqldb.Database.reopen(Database.java:231) at org.hsqldb.Database.open(Database.java:197) at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:255) at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:188) at org.hsqldb.server.Server.openDatabases(Server.java:1875) at org.hsqldb.server.Server.run(Server.java:2208) at org.hsqldb.server.Server.access$000(Server.java:243) at org.hsqldb.server.Server$ServerThread.run(Server.java:315) Caused by: java.io.EOFException at org.hsqldb.persist.ScaledRAFile.read(ScaledRAFile.java:284) at org.hsqldb.persist.ScaledRAFile.readInt(ScaledRAFile.java:275) at org.hsqldb.persist.DataFileCache.readObject(DataFileCache.java:934) ... 22 more 2012-07-29T17:41:22.128+0200 WARNING Script processing failure org.hsqldb.HsqlException: error in script file line: 61 java.io.EOFException in statement [SET TABLE PUBLIC."WORLD_CONTINENT" INDEX '160 0 8'] at org.hsqldb.error.Error.error(Error.java:136) at org.hsqldb.scriptio.ScriptReaderText.readDDL(ScriptReaderText.java:14 8) at org.hsqldb.scriptio.ScriptReaderBase.readAll(ScriptReaderBase.java:63 ) at org.hsqldb.persist.Log.processScript(Log.java:743) at org.hsqldb.persist.Log.open(Log.java:147) at org.hsqldb.persist.Logger.openPersistence(Logger.java:400) at org.hsqldb.Database.reopen(Database.java:231) at org.hsqldb.Database.open(Database.java:197) at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:255) at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:188) at org.hsqldb.server.Server.openDatabases(Server.java:1875) at org.hsqldb.server.Server.run(Server.java:2208) at org.hsqldb.server.Server.access$000(Server.java:243) at org.hsqldb.server.Server$ServerThread.run(Server.java:315) Caused by: org.hsqldb.HsqlException: java.io.EOFException at org.hsqldb.error.Error.error(Error.java:113) at org.hsqldb.persist.DataFileCache.readObject(DataFileCache.java:941) at org.hsqldb.persist.DataFileCache.getFromFile(DataFileCache.java:860) at org.hsqldb.persist.DataFileCache.get(DataFileCache.java:837) at org.hsqldb.persist.RowStoreAVLDisk.get(RowStoreAVLDisk.java:112) at org.hsqldb.persist.RowStoreAVLDisk.setAccessor(RowStoreAVLDisk.java:3 19) at org.hsqldb.Table.setIndexRoots(Table.java:2530) at org.hsqldb.Table.setIndexRoots(Table.java:2574) at org.hsqldb.StatementCommand.getResult(StatementCommand.java:864) at org.hsqldb.StatementCommand.execute(StatementCommand.java:212) at org.hsqldb.Session.executeCompiledStatement(Session.java:1288) at org.hsqldb.scriptio.ScriptReaderText.readDDL(ScriptReaderText.java:11 7) ... 12 more Caused by: java.io.EOFException at org.hsqldb.persist.ScaledRAFile.read(ScaledRAFile.java:284) at org.hsqldb.persist.ScaledRAFile.readInt(ScaledRAFile.java:275) at org.hsqldb.persist.DataFileCache.readObject(DataFileCache.java:934) ... 22 more 2012-07-29T17:41:22.269+0200 SEVERE could not reopen database org.hsqldb.HsqlException: error in script file line: 61 java.io.EOFException in statement [SET TABLE PUBLIC."WORLD_CONTINENT" INDEX '160 0 8'] at org.hsqldb.error.Error.error(Error.java:136) at org.hsqldb.scriptio.ScriptReaderText.readDDL(ScriptReaderText.java:14 8) at org.hsqldb.scriptio.ScriptReaderBase.readAll(ScriptReaderBase.java:63 ) at org.hsqldb.persist.Log.processScript(Log.java:743) at org.hsqldb.persist.Log.open(Log.java:147) at org.hsqldb.persist.Logger.openPersistence(Logger.java:400) at org.hsqldb.Database.reopen(Database.java:231) at org.hsqldb.Database.open(Database.java:197) at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:255) at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:188) at org.hsqldb.server.Server.openDatabases(Server.java:1875) at org.hsqldb.server.Server.run(Server.java:2208) at org.hsqldb.server.Server.access$000(Server.java:243) at org.hsqldb.server.Server$ServerThread.run(Server.java:315) Caused by: org.hsqldb.HsqlException: java.io.EOFException at org.hsqldb.error.Error.error(Error.java:113) at org.hsqldb.persist.DataFileCache.readObject(DataFileCache.java:941) at org.hsqldb.persist.DataFileCache.getFromFile(DataFileCache.java:860) at org.hsqldb.persist.DataFileCache.get(DataFileCache.java:837) at org.hsqldb.persist.RowStoreAVLDisk.get(RowStoreAVLDisk.java:112) at org.hsqldb.persist.RowStoreAVLDisk.setAccessor(RowStoreAVLDisk.java:3 19) at org.hsqldb.Table.setIndexRoots(Table.java:2530) at org.hsqldb.Table.setIndexRoots(Table.java:2574) at org.hsqldb.StatementCommand.getResult(StatementCommand.java:864) at org.hsqldb.StatementCommand.execute(StatementCommand.java:212) at org.hsqldb.Session.executeCompiledStatement(Session.java:1288) at org.hsqldb.scriptio.ScriptReaderText.readDDL(ScriptReaderText.java:11 7) ... 12 more Caused by: java.io.EOFException at org.hsqldb.persist.ScaledRAFile.read(ScaledRAFile.java:284) at org.hsqldb.persist.ScaledRAFile.readInt(ScaledRAFile.java:275) at org.hsqldb.persist.DataFileCache.readObject(DataFileCache.java:934) ... 22 more [Server@1e57e8f]: [Thread[HSQLDB Server @1e57e8f,5,main]]: Database [index=0, db =file:test, alias=] did not open: org.hsqldb.HsqlException: error in script file line: 61 java.io.EOFException in statement [SET TABLE PUBLIC."WORLD_CONTINENT" INDEX '160 0 8'] [Server@1e57e8f]: [Thread[HSQLDB Server @1e57e8f,5,main]]: Shutting down because there are no open databases [Server@1e57e8f]: Initiating shutdown sequence... [Server@1e57e8f]: Shutdown sequence completed in 16 ms. [Server@1e57e8f]: 2012-07-29 17:41:22.300 SHUTDOWN : System.exit() is called next." If I use SHUTDOWN SCRIPT SQL command, than I can start server again without any problem. Same happens when in OOo I use SHUTDOWN SCRIPT in SQL command window, after reopening the odb file works.