May I know if some organization gives support for H2 database related issues. We are facing major problem due to h2 db corruption issue in production.
Following is the log from trace.db *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]* -- 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.
