I posted another message awhile back about a corrupted H2 database. It happened again for me tonight. I get the following exception.
Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "page[2255] data leaf table:49 TRE_FUNDINFO entries:6 parent:291 keys:[307394, 307395, 307396, 307397, 307398, 307399] offsets:[1831, 1595, 1325, 1065, 830, 581]". Possible solution: use the recovery tool; SQL statement: DELETE FROM `tre_fundinfo` WHERE `id` = ? [90030-171] at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) at org.h2.message.DbException.get(DbException.java:169) at org.h2.message.DbException.get(DbException.java:146) ... I'm not sure what I might have done to cause this. I do routinely shut down my application at different moments. I don't think the application was writing data at the moment of shutdown, but it's possible. Even if it was, I don't think this should corrupt the database. Basically any time this happens my application is completely broken. Given that it has happened to me twice in the last month, I'm concerned that this might be a frequent occurrence. As we all know, data stored in databases can be important, so it is important that it doesn't get lost. I understand there is a database recovery tool of some sort, but end users shouldn't be expected to run this kind of thing. when I select from the table in the H2 Console I get: General error: "java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement: select * from tre_fundinfo [50000-171]<http://192.168.1.9:8082/query.do?jsessionid=2d594820d37f9586827884be52b7bb80#> HY000/50000 (Help)<http://h2database.com/javadoc/org/h2/constant/ErrorCode.html#c50000> Thomas, I have saved a copy of the corrupted database. It's about 150MB (before zipping). If you're interested, I could place this somewhere you could download it from. Thanks! -- 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 http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
