server not start

Suny Niazi8 years ago

hi
my traccar service not work today.
i think my db have problem. because when i do stop service and replace with oldest databases after run service, server work correctly.
how i can repair my database ?
thank you

Anton Tananaev8 years ago

Without any details about the problem, it would be impossible to help you.

Suny Niazi8 years ago

with newer (today) .db files system not run and when go localhost:8082 shown ERR_CONNECTION_REFUSED in explorer.
but when i use oldest .db files (backup 3 days ago) system work correctly.
my problem is in .db file and i need a way to repair it.
if you want i can upload my .db files to you for check ?
thanks.

Anton Tananaev8 years ago

You should check the logs and find out what the problem is.

Suny Niazi8 years ago

WARNING|wrapper|Service traccar|17-02-21 07:27:51|YAJSW: yajsw-stable-12.08
WARNING|wrapper|Service traccar|17-02-21 07:27:51|OS   : Windows XP/5.1/x86
WARNING|wrapper|Service traccar|17-02-21 07:27:51|JVM  : Oracle Corporation/1.7.0_80/D:\Program Files\Java\jre7/32
INFO|wrapper|Service traccar|17-02-21 07:27:52|start delay: 0
INFO|wrapper|Service traccar|17-02-21 07:27:55|started process with pid 1000
INFO|1000/0|Service traccar|17-02-21 07:28:01|[INFO] StandardFileSystemManager - Using "D:\WINDOWS\TEMP\vfs_cache" as temporary files store.
INFO|1000/0|Service traccar|17-02-21 07:28:01|!! WARNING !! Windows JDK7 should set -Djava.net.preferIPv4Stack=true (see java bug 7179799 )
INFO|1000/0|Service traccar|17-02-21 07:28:09|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
INFO|1000/0|Service traccar|17-02-21 07:28:12|[main] ERROR com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization.
INFO|1000/0|Service traccar|17-02-21 07:28:12|org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: File corrupted in chunk 367111, expected page length 4..96, got 825373230 [1.4.193/6]" [50000-193]
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.message.DbException.get(DbException.java:168)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.message.DbException.convert(DbException.java:295)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.engine.Database.openDatabase(Database.java:304)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.engine.Database.<init>(Database.java:267)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.engine.Engine.openSession(Engine.java:64)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.engine.Engine.openSession(Engine.java:176)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.engine.Engine.createSession(Engine.java:137)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.engine.Engine.createSession(Engine.java:27)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:115)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:99)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.Driver.connect(Driver.java:69)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:428)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:499)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.traccar.database.DataManager.initDatabase(DataManager.java:115)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.traccar.database.DataManager.<init>(DataManager.java:70)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.traccar.Context.init(Context.java:198)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.traccar.Main.main(Main.java:35)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at java.lang.reflect.Method.invoke(Unknown Source)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|1000/0|Service traccar|17-02-21 07:28:12|Caused by: java.lang.IllegalStateException: File corrupted in chunk 367111, expected page length 4..96, got 825373230 [1.4.193/6]
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:765)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.Page.read(Page.java:649)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.Page.read(Page.java:195)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.MVStore.readPage(MVStore.java:1954)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.MVMap.readPage(MVMap.java:736)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.Page.getChildPage(Page.java:217)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.Cursor.fetchNext(Cursor.java:150)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.Cursor.next(Cursor.java:50)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.db.TransactionStore$TransactionMap$1.fetchNext(TransactionStore.java:1391)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.db.TransactionStore$TransactionMap$1.next(TransactionStore.java:1430)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.db.MVSecondaryIndex$MVStoreCursor.next(MVSecondaryIndex.java:507)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.engine.Database.open(Database.java:753)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.engine.Database.openDatabase(Database.java:273)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	... 28 more
INFO|1000/0|Service traccar|17-02-21 07:28:12|java.lang.reflect.InvocationTargetException
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at java.lang.reflect.Method.invoke(Unknown Source)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|1000/0|Service traccar|17-02-21 07:28:12|Caused by: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: General error: "java.lang.IllegalStateException: File corrupted in chunk 367111, expected page length 4..96, got 825373230 [1.4.193/6]" [50000-193]
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:528)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:520)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.traccar.database.DataManager.initDatabase(DataManager.java:115)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.traccar.database.DataManager.<init>(DataManager.java:70)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.traccar.Context.init(Context.java:198)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.traccar.Main.main(Main.java:35)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	... 6 more
INFO|1000/0|Service traccar|17-02-21 07:28:12|Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: File corrupted in chunk 367111, expected page length 4..96, got 825373230 [1.4.193/6]" [50000-193]
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.message.DbException.get(DbException.java:168)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.message.DbException.convert(DbException.java:295)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.engine.Database.openDatabase(Database.java:304)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.engine.Database.<init>(Database.java:267)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.engine.Engine.openSession(Engine.java:64)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.engine.Engine.openSession(Engine.java:176)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.engine.Engine.createSession(Engine.java:137)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.engine.Engine.createSession(Engine.java:27)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:115)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:99)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.Driver.connect(Driver.java:69)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:428)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:499)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	... 12 more
INFO|1000/0|Service traccar|17-02-21 07:28:12|Caused by: java.lang.IllegalStateException: File corrupted in chunk 367111, expected page length 4..96, got 825373230 [1.4.193/6]
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:765)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.Page.read(Page.java:649)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.Page.read(Page.java:195)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.MVStore.readPage(MVStore.java:1954)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.MVMap.readPage(MVMap.java:736)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.Page.getChildPage(Page.java:217)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.Cursor.fetchNext(Cursor.java:150)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.Cursor.next(Cursor.java:50)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.db.TransactionStore$TransactionMap$1.fetchNext(TransactionStore.java:1391)
INFO|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.db.TransactionStore$TransactionMap$1.next(TransactionStore.java:1430)
FINEST|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.mvstore.db.MVSecondaryIndex$MVStoreCursor.next(MVSecondaryIndex.java:507)
FINEST|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.engine.Database.open(Database.java:753)
FINEST|1000/0|Service traccar|17-02-21 07:28:12|	at org.h2.engine.Database.openDatabase(Database.java:273)
FINEST|1000/0|Service traccar|17-02-21 07:28:12|	... 28 more
INFO|wrapper|Service traccar|17-02-21 07:28:12|calling onStop
INFO|wrapper|Service traccar|17-02-21 07:28:12|Win service stop - timeout: 30000
INFO|wrapper|Service traccar|17-02-21 07:28:12|Win service wrapper.control -> stopping application
INFO|wrapper|Service traccar|17-02-21 07:28:12|Win service stop - after shutdown
INFO|wrapper|Service traccar|17-02-21 07:28:12|Win service stop - before notify

thanks

Anton Tananaev8 years ago

Looks like your database is corrupted. Most likely it's lost, but you can try H2 Recover tool:

http://www.h2database.com/html/advanced.html#using_recover_tool