Dear All, unfortunately I am able to corrupt a perfectly valid database with a very simple sequence of DML/DDLs and Queries:
1) CREATE TABLE ... AS SELECT .. FROM ... 2) on that table create a few indexes 3) on that table, run a few SELECT ... FROM ... All these steps above succeed and I see the results of Step 3, but then, when closing and opening that database again it fails with the exception below. I have tried that 5 times already starting with the same clean database and were able to repeat that corruption. Also it will not corrupt, when we skip steps 1) and 2) and run 3) as SELECT ... FROM (SELECT ... FROM ...) instead, using the SELECT statement of step 1 as sub query. Further information: a) the H2 is 1.4.200 b) connection url is: jdbc:h2:tcp://localhost/~/.manticore/ifrsbox;PAGE_SIZE=8192;CACHE_SIZE=20000 d) the select of 1) pulls less than 700 records in total (only) c) total size of the H2 database is 250 MByte Please let me know what we should do from our end in order to help solving that error. We are fully committed. Thank you already and best regards Andreas org.h2.jdbc.JdbcSQLNonTransientException: General error: "java.lang.IllegalStateException: Unable to read the page at position 136339454691093 [1.4.200/6]" [50000-200] at org.h2.message.DbException.getJdbcSQLException(DbException.java:505) at org.h2.message.DbException.getJdbcSQLException(DbException.java:429) at org.h2.message.DbException.get(DbException.java:194) at org.h2.message.DbException.convert(DbException.java:347) at org.h2.engine.Database.openDatabase(Database.java:333) at org.h2.engine.Database.<init>(Database.java:301) at org.h2.engine.Engine.openSession(Engine.java:74) at org.h2.engine.Engine.openSession(Engine.java:192) at org.h2.engine.Engine.createSessionAndValidate(Engine.java:171) at org.h2.engine.Engine.createSession(Engine.java:166) at org.h2.server.TcpServerThread.run(TcpServerThread.java:168) at java.lang.Thread.run(Thread.java:748) Caused by: java.lang.IllegalStateException: Unable to read the page at position 136339454691093 [1.4.200/6] at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:950) at org.h2.mvstore.MVStore.readPage(MVStore.java:2213) at org.h2.mvstore.MVMap.readPage(MVMap.java:672) at org.h2.mvstore.MVMap.readOrCreateRootPage(MVMap.java:688) at org.h2.mvstore.MVMap.setRootPos(MVMap.java:682) at org.h2.mvstore.MVStore.openMap(MVStore.java:576) at org.h2.mvstore.MVStore.openMap(MVStore.java:535) at org.h2.mvstore.MVStore.openMap(MVStore.java:516) at org.h2.mvstore.MVStore.removeMap(MVStore.java:2742) at org.h2.mvstore.db.MVTableEngine$Store.removeTemporaryMaps(MVTableEngine.java:302) at org.h2.engine.Database.open(Database.java:765) at org.h2.engine.Database.openDatabase(Database.java:307) ... 7 more *Caused by: java.lang.IllegalStateException: Unsupported type 17 [1.4.200/3]* at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:950) at org.h2.mvstore.type.ObjectDataType.newType(ObjectDataType.java:165) at org.h2.mvstore.type.ObjectDataType.read(ObjectDataType.java:229) at org.h2.mvstore.type.ObjectDataType.read(ObjectDataType.java:114) at org.h2.mvstore.Page.read(Page.java:605) at org.h2.mvstore.Page.read(Page.java:239) at org.h2.mvstore.MVStore.readPage(MVStore.java:2211) ... 17 more -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/869273df-2944-47bb-a559-33e922e1d138%40googlegroups.com.
