General error: java.lang.RuntimeException: org.h2.store.PageStreamTrunk

[stolyarchukav]

Hi,
I have a database (size of mydb.h2.db file about 38MB).
When try connected in embedded mode throw exception:
Внутренняя ошибка: "java.lang.RuntimeException:
org.h2.store.PageStreamTrunk@98ce7e"
General error: "java.lang.RuntimeException:
org.h2.store.PageStreamTrunk@98ce7e" [50000-127] HY000/50000 (Помощь)
org.h2.jdbc.JdbcSQLException: Внутренняя ошибка:
"java.lang.RuntimeException: org.h2.store.PageStreamTrunk@98ce7e"
General error: "java.lang.RuntimeException:
org.h2.store.PageStreamTrunk@98ce7e" [50000-127]
at org.h2.message.Message.getSQLException(Message.java:110)
at org.h2.message.Message.convert(Message.java:287)
at org.h2.engine.Database.openDatabase(Database.java:260)
at org.h2.engine.Database.<init>(Database.java:222)
at org.h2.engine.Engine.openSession(Engine.java:58)
at org.h2.engine.Engine.openSession(Engine.java:142)
at org.h2.engine.Engine.getSession(Engine.java:122)
at
org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:
17)
at
org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:
245)
at org.h2.engine.SessionRemote.createSession(SessionRemote.java:
223)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)
at org.h2.Driver.connect(Driver.java:58)
at org.h2.server.web.WebServer.getConnection(WebServer.java:621)
at org.h2.server.web.WebThread$1LoginTask.run(WebThread.java:381)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.RuntimeException:
org.h2.store.PageStreamTrunk@98ce7e
at org.h2.message.Message.throwInternalError(Message.java:190)
at org.h2.index.PageBtreeIndex.getPage(PageBtreeIndex.java:148)
at org.h2.index.PageBtreeIndex.<init>(PageBtreeIndex.java:62)
at org.h2.table.TableData.addIndex(TableData.java:209)
at org.h2.store.PageStore.addMeta(PageStore.java:1342)
at org.h2.store.PageStore.readMetaData(PageStore.java:1245)
at org.h2.store.PageStore.recover(PageStore.java:1053)
at org.h2.store.PageStore.openExisting(PageStore.java:306)
at org.h2.store.PageStore.open(PageStore.java:264)
at org.h2.engine.Database.getPageStore(Database.java:2315)
at org.h2.engine.Database.open(Database.java:630)
at org.h2.engine.Database.openDatabase(Database.java:227)
... 13 more

Any ideas?

[Thomas Mueller]

Hi,

This looks like a serious problem. I have a few questions:

- What is your database URL?
- Did you use multiple connections?
- Do you use temporary tables?
- A workarounds is: use the tool org.h2.tools.Recover to create
the SQL script file, and then re-create the database using this script.
Does it work when you do this?
- With which version of H2 was this database created?
You can find it out using:
select * from information_schema.settings where name='CREATE_BUILD'
or have a look in the SQL script created by the recover tool.
- Did the application run out of memory (once, or multiple times)?
- Do you use any settings or special features (for example cache settings,
two phase commit, linked tables)?
- Do you use any H2-specific system properties?
- Is the application multi-threaded?
- What operating system, file system, and virtual machine
(java -version) do you use?
- How did you start the Java process (java -Xmx... and so on)?
- Is the database usually closed normally, or is process terminated
forcefully or the computer switched off?
- Is it possible to reproduce this problem using a fresh database
(sometimes, or always)?
- Are there any other exceptions (maybe in the .trace.db file)?
Could you send them please?
- Do you still have any .trace.db files, and if yes could you send them?
- Could you send the .h2.db file where this exception occurs?

Regards,
Thomas