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.
