Join Log in
Score:0
Christoforos avatar Server

Traccar with h2 databse stops and does not restart with systemctl

cn flag
Christoforos

I am using traccar o Centos 7 machine with nginx and h2 database.

My tracacar service start when I reboot the machine but when I am trying to access it stops. By issuing sudo systemctl start traccar no error appears on the console but the service has not started. Bellow is an part of my journalctl that shows the error:

 developer : TTY=pts/0 ; PWD=/etc/nginx/conf.d ; USER=root ; COMMAND=/bin/systemctl --no-ask-password restart traccar
Dec 19 18:10:09 medisys3 sudo[1791]: pam_unix(sudo:session): session opened for user root by developer(uid=0)
Dec 19 18:10:09 medisys3 systemd[1]: Started traccar.
Dec 19 18:10:09 medisys3 sudo[1791]: pam_unix(sudo:session): session closed for user root
Dec 19 18:10:11 medisys3 traccar[1793]: Exception in thread "main" java.lang.RuntimeException: liquibase.exception.LockException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: org.h2.jdbc.JdbcSQLNonTransientException: General error: "General error: "
Dec 19 18:10:11 medisys3 traccar[1793]: ROLLBACK [50000-200]
Dec 19 18:10:11 medisys3 traccar[1793]: at org.traccar.Main.run(Main.java:152)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.traccar.Main.main(Main.java:104)
Dec 19 18:10:11 medisys3 traccar[1793]: Caused by: liquibase.exception.LockException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: org.h2.jdbc.JdbcSQLNonTransientException: General error: "General error: ""java.lang.ArrayIndexOutOfBoundsException: I
Dec 19 18:10:11 medisys3 traccar[1793]: ROLLBACK [50000-200]
Dec 19 18:10:11 medisys3 traccar[1793]: at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:295)
Dec 19 18:10:11 medisys3 traccar[1793]: at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:213)
Dec 19 18:10:11 medisys3 traccar[1793]: at liquibase.Liquibase.clearCheckSums(Liquibase.java:1455)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:310)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.traccar.database.DataManager.<init>(DataManager.java:90)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.traccar.Context.init(Context.java:292)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.traccar.Main.run(Main.java:110)
Dec 19 18:10:11 medisys3 traccar[1793]: ... 1 more
Dec 19 18:10:11 medisys3 traccar[1793]: Caused by: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: org.h2.jdbc.JdbcSQLNonTransientException: General error: "General error: ""java.lang.ArrayIndexOutOfBoundsException: Index 0 out of bounds for length 0""
Dec 19 18:10:11 medisys3 traccar[1793]: ROLLBACK [50000-200]
Dec 19 18:10:11 medisys3 traccar[1793]: at liquibase.database.AbstractJdbcDatabase.rollback(AbstractJdbcDatabase.java:1163)
Dec 19 18:10:11 medisys3 traccar[1793]: at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:251)
Dec 19 18:10:11 medisys3 traccar[1793]: ... 7 more
Dec 19 18:10:11 medisys3 traccar[1793]: Caused by: liquibase.exception.DatabaseException: org.h2.jdbc.JdbcSQLNonTransientException: General error: "General error: ""java.lang.ArrayIndexOutOfBoundsException: Index 0 out of bounds for length 0"" [50000-200]"; SQL statement:
Dec 19 18:10:11 medisys3 traccar[1793]: ROLLBACK [50000-200]
Dec 19 18:10:11 medisys3 traccar[1793]: at liquibase.database.jvm.JdbcConnection.rollback(JdbcConnection.java:339)
Dec 19 18:10:11 medisys3 traccar[1793]: at liquibase.database.AbstractJdbcDatabase.rollback(AbstractJdbcDatabase.java:1161)
Dec 19 18:10:11 medisys3 traccar[1793]: ... 8 more
Dec 19 18:10:11 medisys3 traccar[1793]: Caused by: org.h2.jdbc.JdbcSQLNonTransientException: General error: "General error: ""java.lang.ArrayIndexOutOfBoundsException: Index 0 out of bounds for length 0"" [50000-200]"; SQL statement:
Dec 19 18:10:11 medisys3 traccar[1793]: ROLLBACK [50000-200]
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.message.DbException.getJdbcSQLException(DbException.java:505)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.message.DbException.get(DbException.java:194)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.engine.Database.throwLastBackgroundException(Database.java:2221)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.engine.Database.commit(Database.java:2202)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.engine.Session.rollback(Session.java:846)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.command.dml.TransactionCommand.update(TransactionCommand.java:49)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.command.CommandContainer.update(CommandContainer.java:198)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.command.Command.executeUpdate(Command.java:251)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.jdbc.JdbcConnection.rollbackInternal(JdbcConnection.java:1530)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.jdbc.JdbcConnection.rollback(JdbcConnection.java:561)
Dec 19 18:10:11 medisys3 traccar[1793]: at liquibase.database.jvm.JdbcConnection.rollback(JdbcConnection.java:336)
Dec 19 18:10:11 medisys3 traccar[1793]: ... 9 more
Dec 19 18:10:11 medisys3 traccar[1793]: Caused by: org.h2.message.DbException: General error: "java.lang.ArrayIndexOutOfBoundsException: Index 0 out of bounds for length 0" [50000-200]
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.message.DbException.get(DbException.java:194)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.message.DbException.convert(DbException.java:347)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.mvstore.db.MVTableEngine$1.uncaughtException(MVTableEngine.java:93)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.mvstore.MVStore.handleException(MVStore.java:2877)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.mvstore.MVStore.writeInBackground(MVStore.java:2813)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.mvstore.MVStore$BackgroundWriterThread.run(MVStore.java:3290)
Dec 19 18:10:11 medisys3 traccar[1793]: Caused by: org.h2.jdbc.JdbcSQLNonTransientException: General error: "java.lang.ArrayIndexOutOfBoundsException: Index 0 out of bounds for length 0" [50000-200]
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.message.DbException.getJdbcSQLException(DbException.java:505)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
Dec 19 18:10:11 medisys3 traccar[1793]: ... 6 more
Dec 19 18:10:11 medisys3 traccar[1793]: Caused by: java.lang.ArrayIndexOutOfBoundsException: Index 0 out of bounds for length 0
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.mvstore.Page.getKey(Page.java:270)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.mvstore.MVMap.rewritePage(MVMap.java:773)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.mvstore.MVMap.rewrite(MVMap.java:734)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.mvstore.MVMap.rewrite(MVMap.java:710)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.mvstore.MVStore.compactRewrite(MVStore.java:2137)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.mvstore.MVStore.rewriteChunks(MVStore.java:2026)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.mvstore.MVStore.doMaintenance(MVStore.java:2844)
Dec 19 18:10:11 medisys3 traccar[1793]: at org.h2.mvstore.MVStore.writeInBackground(MVStore.java:2788)
Dec 19 18:10:11 medisys3 traccar[1793]: ... 1 more
Dec 19 18:10:11 medisys3 systemd[1]: traccar.service: main process exited, code=exited, status=1/FAILURE
Dec 19 18:10:11 medisys3 systemd[1]: Unit traccar.service entered failed state.
Dec 19 18:10:11 medisys3 systemd[1]: traccar.service failed.
Dec 19 18:10:15 medisys3 sudo[1825]: developer : TTY=pts/0 ; PWD=/etc/nginx/conf.d ; USER=root ; COMMAND=/bin/systemctl status traccar
Dec 19 18:10:15 medisys3 sudo[1825]: pam_unix(sudo:session): session opened for user root by developer(uid=0)
Dec 19 18:10:15 medisys3 sudo[1825]: pam_unix(sudo:session): session closed for user root
Dec 19 18:10:32 medisys3 sudo[1827]: developer : TTY=pts/0 ; PWD=/etc/nginx/conf.d ; USER=root ; COMMAND=/bin/journalctl
Dec 19 18:10:32 medisys3 sudo[1827]: pam_unix(sudo:session): session opened for user root by developer(uid=0)

Can anyone help ?

61
0 + 0
ธงชาติไทย
Elon Musk
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.