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 < b.b.lingamoor...@gmail.com> 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 h2-database+unsubscr...@googlegroups.com <javascript:;>. > To post to this group, send email to h2-database@googlegroups.com > <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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
