Thanks Thomas. I'll post a download link for these tonight. I appreciate your help! I've really been impressed with H2 except for these corruption issues. The start-up time could be improved, but the overall performance is great.
On Wednesday, April 17, 2013 12:26:46 AM UTC-7, Thomas Mueller wrote: > > Hi, > > I would be interested in the database files (*.db, including the trace > file if there is one). It would be great if you could send them to me. > > Regards, > Thomas > > > > On Wed, Apr 17, 2013 at 6:17 AM, Ryan How <[email protected]<javascript:> > > wrote: > >> Sorry, you might have said in another post, but what connection string >> are you using? >> >> Are you using it over a network drive? >> >> OS? >> >> Any Out of Memory errors on this database? >> >> >> Thanks, Ryan >> >> >> >> On 17/04/2013 12:13 PM, TrendTimer.com wrote: >> >> 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] <javascript:>. >> To post to this group, send email to [email protected]<javascript:> >> . >> Visit this group at http://groups.google.com/group/h2-database?hl=en. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> >> >> -- >> 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] <javascript:>. >> To post to this group, send email to [email protected]<javascript:> >> . >> Visit this group at http://groups.google.com/group/h2-database?hl=en. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- 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.
