Hi, I suggest to upgrade to a newer version of H2. If needed, you can use the Recover tool to recover data from the database.
The attached file contains some error messages / error codes that show the database was created with version 1.3.160 (error code 90121-160). The error you wrote about is from version 1.3.169. Those old versions had the following known problems (see also the change log) that can cause corruption: With version 1.3.171 and older: when using local temporary tables and not dropping them manually before closing the session, and then killing the process could result in a database that couldn't be opened. With version 1.3.162 and older: on out of disk space, the database can get corrupt sometimes, if later write operations succeed. The same problem happens on other kinds of I/O exceptions (where one or some of the writes fail, but subsequent writes succeed). Now the file is closed on the first unsuccessful write operation, so that later requests fail consistently. Regards, Thomas On Tuesday, September 16, 2014, Sanchand <[email protected] <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > trace file related to the H2 file is attached, after this the h2 file > becomes corrupt and keeps throwing the error when tried to get connection > "Internal Exception: org.h2.jdbc.JdbcSQLException: Unique index or primary > key violation: "SYS_ID ON PUBLIC.SYS(ID)" [23505-169]" > > > On Wednesday, September 10, 2014 11:51:33 AM UTC+8, Sanchand wrote: >> >> In our project we execute sql files using Runscript.execute method of H2, >> during one such execution, there was large number of delete statement for a >> particular table in one of the sql file, the java utility handling the >> execution exited in during execution of that file. The utility ran >> successfully in few laptops but failed in failed in many exactly at the >> execution of that file. Please advice. >> > -- > 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. > For more options, visit https://groups.google.com/d/optout. > -- 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. For more options, visit https://groups.google.com/d/optout.
