search

haffo / hit-base-tool

This is the base tool, template of all the others tools. The packages included are domain independent.
0 stars 6 forks source link

App crashes during the weekend (SQL error) #4

Closed ncrouzier-nist closed 7 years ago

ncrouzier-nist commented 9 years ago

Hard to tell what or when the app crashes (maybe when the machine restarts, or some of the services restarts like Mysql or Tomcat..)

The web app crashes and I am unable to retart it. I must create a new app with a different jdbc.url to make it work...

Error I get:

Caused by: org.h2.jdbc.JdbcSQLException: Table "VOCABULARYLIBRARY" already exists; SQL statement: CREATE CACHED TABLE PUBLIC.VOCABULARYLIBRARY( ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_1DAB2AC0_02B8_4445_891D_33329F49D40E) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_1DAB2AC0_02B8_4445_891D_33329F49D40E, DESCRIPTION VARCHAR(255), JSON LONGTEXT, KEY VARCHAR(255), NAME VARCHAR(255), SOURCEID VARCHAR(255) NOT NULL, XML LONGTEXT ) [42101-187]

see attached complete log appcrash.txt

ncrouzier-nist commented 9 years ago

This happens when app crashes for a reason during startup. To fix, just delete databasename.mv.db and databasename.trace.db. Should probably have a way for the tool to delete those files at each startup to avoid this probelm