Hello,
I could not start up my traccar server anymore:
2024-03-29 10:11:33 INFO: Update summary generated
2024-03-29 10:11:33 INFO: Update command completed successfully.
2024-03-29 10:11:33 INFO: Successfully released change log lock
2024-03-29 10:11:33 INFO: Command execution complete
2024-03-29 10:11:36 WARN: HikariPool-1 - Connection conn1: url=jdbc:h2:./data/database user=SA marked as broken because of SQLSTATE(HYT00), ErrorCode(50200) - Row not found when trying to delete from index "PUBLIC.IDX_DEVICES_UNIQUEID: 43" [90112-224] - JdbcSQLTransientException (... < QueryBuilder:469 < DatabaseStorage:115 < DeviceUtil:39 < ...)
2024-03-29 10:11:36 ERROR: Main method error - Row not found when trying to delete from index "PUBLIC.IDX_DEVICES_UNIQUEID: 43" [90112-224] - JdbcSQLTransientException (... < QueryBuilder:469 < DatabaseStorage:115 < DeviceUtil:39 < ...)`
I could fix it with the same procedure as database upgrade:
from https://github.com/h2database/h2database/releases
I took:
wget https://github.com/h2database/h2database/releases/download/version-2.2.224/h2-2023-09-17.zip
unzip ./h2-2023-09-17.zip
java -cp h2/bin/h2-2.2.224.jar org.h2.tools.Script -url jdbc:h2:./database -user sa -script test.zip -options compression zip
java -cp h2/bin/h2-2.2.224.jar org.h2.tools.RunScript -url jdbc:h2:./database_new -user sa -script test.zip -options compression zip
mv database.mv.db database.mv.db.org
mv database_new.mv.db database.mv.db
Just in case some has a simular issue.
Regards, Tomte
Hello,
I could not start up my traccar server anymore:
I could fix it with the same procedure as database upgrade:
from https://github.com/h2database/h2database/releases
I took:
Just in case some has a simular issue.
Regards, Tomte