you'd have to provide more information, preferably a test-case. issue 3 looks like you have multiple machines accessing the same file, and those machines do not have synchronised clocks.
Sri Sudha wrote: > Hi, > > In our project we are using H2 DB version : h2-1.1.114. We are using > h2db to store the active session information, to store the data only > for 2days and the data will be expire after that. > > We are facing multiple issues with h2DB. > > Issue 1: Sequence not found (Sequence > SYSTEM_SEQUENCE_39CBE124_6F9A_44A9_981C_7E56D83420B2 not found) > > Issue2: org.h2.jdbc.JdbcSQLException: Unique index or primary key > violation: SYS_ID ON PUBLIC.SYS(ID) > > Issue3: org.h2.jdbc.JdbcSQLException: Error opening database: Lock > file modification time is in the future; if required please delete the > file /XXX/XXXXX/XXXX/data/h2/XXXX_session.lock.db manually and retry > > From your earlier forum topics I understood that the problem might be > either DB corrupted or restarting the OS, or need to upgrade h2db to > the latest version. > > If the issue is really related to upgrade the H2DB, please suggest me > which version providing the solution for all the above issues. It > would be more helpful, if you can provide me the root cause for the > above issues for better understanding. > > Thanks, > Aruna. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
