Hi In the meantime, I received the device with the corrupt db for analysis. The complete stacktrace is given below. The interesting thing is, that the device has been rebooted just before the data corruption occurred. After that reboot, the operating system's clock (SuSE linux) shifted back for 10 minutes for no obvious reasons. Could there be a connection between time shift and data corruption? Does H2 need a continuous clock to be consistent?
The db is accessed by the following url: jdbc:h2:tcp://<host ip>:9092/ dbName;IFEXISTS=TRUE;LOCK_TIMEOUT=5000 Regards, Remo 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 001 org.h2.jdbc.JdbcSQLException: Row not found when trying to delete from index """"".I365: ( /* key:3896 */ 0, 1679, 85564, NULL, 24864, 108079, 161864, NULL, 'Printer Model: SEIKO Precesion SP-2400', 'Continuous Paper for Maneuvering Log Printer', '', '', 'Continuous Paper', '', 'Paper', 'Stationary', '*', 0, 20655)" [90112-147] 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 002 at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 003 at org.h2.message.DbException.get(DbException.java:167) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 004 at org.h2.message.DbException.get(DbException.java:144) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 005 at org.h2.index.PageBtreeLeaf.remove(PageBtreeLeaf.java:222) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 006 at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 007 at org.h2.index.PageBtreeIndex.remove(PageBtreeIndex.java:234) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 008 at org.h2.table.RegularTable.removeRow(RegularTable.java:360) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 009 at org.h2.store.PageStore.redo(PageStore.java:1501) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 010 at org.h2.store.PageStore.redoDelete(PageStore.java:1474) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 011 at org.h2.store.PageLog.recover(PageLog.java:332) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 012 at org.h2.store.PageStore.recover(PageStore.java:1347) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 013 at org.h2.store.PageStore.openExisting(PageStore.java:346) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 014 at org.h2.store.PageStore.open(PageStore.java:275) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 015 at org.h2.engine.Database.getPageStore(Database.java:2040) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 016 at org.h2.engine.Database.open(Database.java:547) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 017 at org.h2.engine.Database.openDatabase(Database.java:218) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 018 at org.h2.engine.Database.<init>(Database.java:213) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 019 at org.h2.engine.Engine.openSession(Engine.java:55) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 020 at org.h2.engine.Engine.openSession(Engine.java:158) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 021 at org.h2.engine.Engine.createSessionAndValidate(Engine.java:137) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 022 at org.h2.engine.Engine.createSession(Engine.java:120) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 023 at org.h2.server.TcpServerThread.run(TcpServerThread.java:124) 2011-10-31 14:28:47,444 ERROR [OffshoreServer - SYS - Mespas - 0003] | 024 at java.lang.Thread.run(Thread.java:619) On 7 Nov., 19:53, Thomas Mueller <[email protected]> wrote: > Hi, > > There were quite a few changes since version 1.2.147, see > alsohttp://www.h2database.com/html/changelog.html > > But without more details it's hard to say if the problem is already > fixed. What database URL do you use, what is the complete stack trace? > > Regards, > Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
