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]> 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]. > 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. > > > > > -- > 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. > > > -- 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.
