I am a Java developer working with H2 database. I have encountered a situation in our Production Environment where the connection to H2 database closed abruptly.
>From the trace.db file I learnt the following: *org.h2.message.DbException: The connection was not closed by the application and is garbage collected [90018-174]* * at org.h2.message.DbException.get(DbException.java:172)* *Caused by: org.h2.jdbc.JdbcSQLException: The connection was not closed by the application and is garbage collected [90018-174]* * at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)* * ... 40 more* *06-19 23:59:58 database: close* *java.lang.ClassCastException: org.h2.index.PageDataLeaf cannot be cast to org.h2.store.PageStreamTrunk* *06-20 00:00:19 jdbc[1404]: exception* *org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "[41656] stream data key:8741 pos:11 remaining:0". Possible solution: use the recovery tool; SQL statement:* *select tran0_.TRAN_NO as TRAN1_229_, tran0_.ENTRY_DATE as ENTRY2_229_, tran0_.BUSINESS_DAY as BUSINESS3_229_, tran0_.POS_NO as POS4_229_, tran0_.RECEIPT_NO as RECEIPT5_229_, tran0_.RETURNED as RETURNED229_, tran0_.SERIES_FLAG as SERIES7_229_, tran0_.STAFF_NO as STAFF8_229_, tran0_.TRAN_DATA as TRAN9_229_, tran0_.TRAN_DATE as TRAN10_229_, tran0_.TRAN_DAY as TRAN11_229_, tran0_.TRAN_ID as TRAN12_229_, tran0_.TRAN_SEND_FLAG as TRAN13_229_, tran0_.TRAN_TIME as TRAN14_229_, tran0_.TRAN_VERSION as TRAN15_229_ from T_TRAN tran0_ where tran0_.TRAN_SEND_FLAG=0 [90030-174]* Could you please throw some light on what could possibly cause a *database: close* event. H2 version: *h2-1.3.174.jar* JRE version: *jdk1.6.0_25* If you need more details, please let us know. -- 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 post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
