H2 Database corruption : java.lang.RuntimeException: old!=record pos:196012 old:page[196012] data leaf overflow parent:196011 next:0 new:page[196012] data leaf table:10 T10 entries:0 parent:194682 keys:null offsets:null

[Lingamoorthy Bheeman Balan]

Hi Team,

We are getting lot of H2 database corruption cases from clients. Kindly help us to provide some information to address this issue. 

We tried the Recovery of corrupted DB but we could not recover.

Please find below the details of our system.

H2 version	:	1.3.169
Java version	:	1.6.0_21
H2 DB connection URL	:	jdbc:h2:<H2 DB file path>;CIPHER=AES;MVCC=TRUE;AUTO_SERVER=TRUE
H2 DB file size	:	289 MB
OS	:	Windows 7,8.1 & 10

Exceptions:

1. org.hibernate.exception.GenericJDBCException: Cannot open connection

2. org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (General error: "java.lang.RuntimeException: old!=record pos:196012 old:page[196012] data leaf overflow parent:196011 next:0 new:page[196012] data leaf table:10 T10 entries:0 parent:194682 keys:null offsets:null" [50000-169])

3. org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException: old!=record pos:196012 old:page[196012] data leaf overflow parent:196011 next:0 new:page[196012] data leaf table:10 T10 entries:0 parent:194682 keys:null offsets:null" [50000-169]

4. java.lang.RuntimeException: old!=record pos:196012 old:page[196012] data leaf overflow parent:196011 next:0 new:page[196012] data leaf table:10 T10 entries:0 parent:194682 keys:null offsets:null

Awaiting for your valuable feedback.

[Kerry Sainsbury]

I thought the current wisdom was that MCC and 1.3 aren't recommended:

http://www.h2database.com/html/advanced.html#mvcc states

"The MVCC feature is not fully tested yet" and "the complete undo log (the list of uncommitted changes) must fit in memory"

[Lingamoorthy Bheeman Balan]

Hi Kerry,

Thanks for the update.

Could you please help to update us the root cause behind the MVCC that lead to H2 DB corruption, because number of users affected (80+ users for now) are being increased daily ?

Also, what may be the alternate solution to resolve this issue ?

Awaiting for your valuable reply.

Regards,

Lingamoorthy.

[Noel Grandin]

The answer is "don't use MVCC with version 1.3 because it's experimental and you might lose data"​