server upgrade traccar wont start anymore.

Chris2 years ago

Hi all,

I upgraded my traccar server to the latest version. Now when i am trying to start traccar i am getting these errors? Any advise on this problem?

Exception in thread "main" java.lang.RuntimeException: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: General error: "The write format 1 is smaller than the supported format 2 [2.0.206/5]" [50000-206]
        at org.traccar.Main.run(Main.java:147)
        at org.traccar.Main.main(Main.java:106)
Caused by: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: General error: "The write format 1 is smaller than the supported format 2 [2.0.206/5]" [50000-206]
        at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:596)
        at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:582)
        at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
        at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81)
        at org.traccar.database.DataManager.initDatabase(DataManager.java:131)
        at org.traccar.database.DataManager.<init>(DataManager.java:90)
        at org.traccar.Context.init(Context.java:298)
        at org.traccar.Main.run(Main.java:120)
        ... 1 more
Caused by: org.h2.jdbc.JdbcSQLNonTransientException: General error: "The write format 1 is smaller than the supported format 2 [2.0.206/5]" [50000-206]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:573)
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:496)
        at org.h2.message.DbException.get(DbException.java:216)
        at org.h2.mvstore.db.Store.convertMVStoreException(Store.java:166)
        at org.h2.mvstore.db.Store.<init>(Store.java:140)
        at org.h2.engine.Database.<init>(Database.java:324)
        at org.h2.engine.Engine.openSession(Engine.java:92)
        at org.h2.engine.Engine.openSession(Engine.java:222)
        at org.h2.engine.Engine.createSession(Engine.java:201)
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:117)
        at org.h2.Driver.connect(Driver.java:59)
        at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
        at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
        at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
        at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
        at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
Anton Tananaev2 years ago

The database is not compatible.

Anton Tananaev2 years ago

You can try migration instructions from here:

https://www.h2database.com/html/migration-to-v2.html

Chris2 years ago

Thank you,

However i am no db expert. i have no idea how to upgrade the database now. is it a simple command or is it hard to do?

Jan2 years ago

Here is the same problem after updating the Docker container. The h2 database does not start and throws the same error.

Any tips on how to solve this?

Anton Tananaev2 years ago

You need to migrate the database. See the link.

Jan2 years ago

Hello Anton,
unfortunately, I feel the same way as Chris. I do not understand the instructions in the link. Can you maybe give us tips how to update to the new h2 version.

Thanks a lot

Anton Tananaev2 years ago
Matyi Szabolcs2 years ago

Hello,

These instructions mean nothing to me either. I didn't know what to do with it. Thank you it went very well. According to them, this cannot be based on this either.

+1