Re: [h2] org.h2.jdbc.jdbcSQLException - unique index or primary key violation: sys_id on public.sys(id) 23505-169

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

[h2] org.h2.jdbc.jdbcSQLException - unique index or primary key violation: sys_id on public.sys(id) 23505-169

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