Thomas, you can download my corrupt database here: http://www.trendtimer.com/db_corrupt/trendtimerdb/trendtimerdb.trace.db http://www.trendtimer.com/db_corrupt/trendtimerdb/trendtimerdb.h<http://www.trendtimer.com/db_corrupt/trendtimerdb/trendtimerdb.trace.db> 2.db
Connection string is: Constants.jdbcString="jdbc:h2:file:"+databaseFolder+databaseName; I'm running on Windows 8. I have 16gb ram and haven't seen any memory problems It's not a network drive and am running h2-1.3.171.jar I'd appreciate it if you could take a look. thanks a lot! On Wednesday, April 17, 2013 1:22:02 PM UTC-7, TrendTimer.com wrote: > > 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]> 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.
