Also, I'm using version h2-1.3.171.jar On Tuesday, April 16, 2013 9:05:41 PM UTC-7, TrendTimer.com wrote: > > > 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.
