Hi, I don't know what the problem is, but quite many bugs have been fixed since version 1.3.169 (see the change log).
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. What database URL do you use? Did you re-create the database when upgrading to version 1.3.169? Does your application backup the database file? Regards, Thomas On Saturday, July 26, 2014, lingamoorthy bheeman balan < [email protected]> wrote: > Hi All, > > Can anyone help us in resolving the below issue. > > The H2 Database file was created with the version 1.3.160 and it is copied > and being used in around 1500 local systems. But this db file is being > accessed by the Java application with the h2 jar version 1.3.169. There was > no problem at all in accessing this db since April'14. But suddenly few > days > back, it has thrown the exception saying "org.h2.jdbc.jdbcSQLException - > unique index or primary key violation: "sys_id on public.sys(id)" > 23505-169" > thus not able to open and insert the data. Surprise, this problem is > occurred only in around 400 systems and not in all. > > So, kindly give us your ideas, suggestions and solutions to resolve this > without causing any problem to the Client's data stored in this db. > > Your ideas, views, suggestions and solutions on this will be more helpful > to > us. > > > > > -- > View this message in context: > http://h2-database.66688.n3.nabble.com/org-h2-jdbc-jdbcSQLException-unique-index-or-primary-key-violation-sys-id-on-public-sys-id-23505-169-tp4029704.html > Sent from the H2 Database mailing list archive at Nabble.com. > > -- > 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. > 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.
