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.
