How making backup from vhicles data
I suspect that you have some invalid references in the database.
Hi,Anton
how i can solve the problem
we running traccar for test, if we had so much data what !
is there any way for solving the problem?
TNX
First of all, you should never use H2 database for production. You should use a fully-featured database like MySQL.
As for the problem, I don't think it should happen. Most likely you either have a corrupted database, or some config issue.
Hi, Dear
Many thanks
i was try with mysql but here is the errors and warnings in both of log files:
2017-08-02 16:52:31 INFO: Operating system name: Linux version: 3.4.113-sun8i architecture: arm 2017-08-02 16:52:31 INFO: Java runtime name: Java HotSpot(TM) Client VM vendor: Oracle Corporation version: 25.131-b11 2017-08-02 16:52:31 INFO: Memory limit heap: 119mb non-heap: 0mb 2017-08-02 16:52:31 INFO: Character encoding: UTF-8 charset: UTF-8 2017-08-02 16:52:31 INFO: Version: 3.9-SNAPSHOT 2017-08-02 16:52:33 WARN: Table 'microlinoTracker.groups' doesn't exist - MySQLSyntaxErrorException (... < QueryBuilder:388 < DataManager:240 < DeviceManager:244 < ...) 2017-08-02 16:52:34 WARN: Table 'microlinoTracker.application_settings' doesn't exist - MySQLSyntaxErrorException (... < QueryBuilder:388 < *:284 < DataManager:319 < PermissionsManager:88 < ...)
WARNING|wrapper|Service traccar|17-08-02 16:52:22|YAJSW: yajsw-beta-12.07 WARNING|wrapper|Service traccar|17-08-02 16:52:22|OS : Linux/3.4.113-sun8i/arm WARNING|wrapper|Service traccar|17-08-02 16:52:22|JVM : Oracle Corporation/1.8.0_131//opt/jdk/jdk1.8.0_131/jre/32 INFO|wrapper|Service traccar|17-08-02 16:52:23|exec:"java" "-classpath" "/opt/traccar/wrapperApp.jar:/opt/traccar/tracker-server.jar:/opt/traccar/lib/log4j-1.2.17.jar:/opt/traccar/lib/joda-time-2.9.6.jar:/opt/traccar/lib/h2-1.4.193.jar:/opt/traccar/lib/mysql-connector-java-5.1.40.jar:/opt/traccar/lib/postgresql-9.4.1212.jre7.jar:/opt/traccar/lib/mssql-jdbc-6.1.0.jre7.jar:/opt/traccar/lib/HikariCP-java7-2.4.9.jar:/opt/traccar/lib/slf4j-api-1.7.21.jar:/opt/traccar/lib/netty-3.10.6.Final.jar:/opt/traccar/lib/async-http-client-1.9.40.jar:/opt/traccar/lib/slf4j-simple-1.7.21.jar:/opt/traccar/lib/javax.json-1.0.4.jar:/opt/traccar/lib/jetty-server-9.2.19.v20160908.jar:/opt/traccar/lib/javax.servlet-api-3.1.0.jar:/opt/traccar/lib/jetty-http-9.2.19.v20160908.jar:/opt/traccar/lib/jetty-io-9.2.19.v20160908.jar:/opt/traccar/lib/jetty-servlet-9.2.19.v20160908.jar:/opt/traccar/lib/jetty-security-9.2.19.v20160908.jar:/opt/traccar/lib/jetty-webapp-9.2.19.v20160908.jar:/opt/traccar/lib/jetty-xml-9.2.19.v20160908.jar:/opt/traccar/lib/jetty-jndi-9.2.19.v20160908.jar:/opt/traccar/lib/jetty-util-9.2.19.v20160908.jar:/opt/traccar/lib/websocket-server-9.2.19.v20160908.jar:/opt/traccar/lib/websocket-common-9.2.19.v20160908.jar:/opt/traccar/lib/websocket-api-9.2.19.v20160908.jar:/opt/traccar/lib/websocket-client-9.2.19.v20160908.jar:/opt/traccar/lib/websocket-servlet-9.2.19.v20160908.jar:/opt/traccar/lib/jersey-container-servlet-2.24.jar:/opt/traccar/lib/jersey-container-servlet-core-2.24.jar:/opt/traccar/lib/javax.inject-2.5.0-b05.jar:/opt/traccar/lib/jersey-common-2.24.jar:/opt/traccar/lib/javax.annotation-api-1.2.jar:/opt/traccar/lib/jersey-guava-2.24.jar:/opt/traccar/lib/hk2-api-2.5.0-b05.jar:/opt/traccar/lib/hk2-utils-2.5.0-b05.jar:/opt/traccar/lib/aopalliance-repackaged-2.5.0-b05.jar:/opt/traccar/lib/hk2-locator-2.5.0-b05.jar:/opt/traccar/lib/javassist-3.20.0-GA.jar:/opt/traccar/lib/osgi-resource-locator-1.0.1.jar:/opt/traccar/lib/jersey-server-2.24.jar:/opt/traccar/lib/jersey-client-2.24.jar:/opt/traccar/lib/jersey-media-jaxb-2.24.jar:/opt/traccar/lib/validation-api-1.1.0.Final.jar:/opt/traccar/lib/javax.ws.rs-api-2.0.1.jar:/opt/traccar/lib/jersey-media-json-jackson-2.24.jar:/opt/traccar/lib/jersey-entity-filtering-2.24.jar:/opt/traccar/lib/jackson-jaxrs-base-2.5.4.jar:/opt/traccar/lib/jackson-core-2.5.4.jar:/opt/traccar/lib/jackson-databind-2.5.4.jar:/opt/traccar/lib/jackson-jaxrs-json-provider-2.5.4.jar:/opt/traccar/lib/jackson-module-jaxb-annotations-2.5.4.jar:/opt/traccar/lib/jackson-annotations-2.5.4.jar:/opt/traccar/lib/liquibase-core-3.5.3.jar:/opt/traccar/lib/snakeyaml-1.17.jar:/opt/traccar/lib/mail-1.4.7.jar:/opt/traccar/lib/activation-1.1.jar:/opt/traccar/lib/jxls-2.3.0.jar:/opt/traccar/lib/commons-jexl-2.1.1.jar:/opt/traccar/lib/commons-logging-1.1.1.jar:/opt/traccar/lib/commons-beanutils-1.9.2.jar:/opt/traccar/lib/jcl-over-slf4j-1.7.12.jar:/opt/traccar/lib/logback-core-1.1.3.jar:/opt/traccar/lib/jxls-poi-1.0.11.jar:/opt/traccar/lib/poi-3.14.jar:/opt/traccar/lib/commons-codec-1.10.jar:/opt/traccar/lib/poi-ooxml-3.14.jar:/opt/traccar/lib/poi-ooxml-schemas-3.14.jar:/opt/traccar/lib/xmlbeans-2.6.0.jar:/opt/traccar/lib/stax-api-1.0.1.jar:/opt/traccar/lib/curvesapi-1.03.jar:/opt/traccar/lib/velocity-1.7.jar:/opt/traccar/lib/commons-collections-3.2.1.jar:/opt/traccar/lib/commons-lang-2.4.jar" "-Dfile.encoding=UTF-8" "-Xrs" "-Dwrapper.service=true" "-Dwrapper.console.visible=false" "-Dwrapper.port=15003" "-Dwrapper.key=-2729931028803961484" "-Dwrapper.teeName=-2729931028803961484$1501692742815" "-Dwrapper.tmp.path=/opt/traccar/tmp" "-Djna_tmpdir=/opt/traccar/tmp" "-Dwrapper.config=/opt/traccar/conf/wrapper.conf" "-Dwrapper.visible=false" "-Dwrapper.pidfile=/run/wrapper.traccar.pid" "org.rzo.yajsw.app.WrapperJVMMain" INFO|wrapper|Service traccar|17-08-02 16:52:23|posix_spawn pid 3313 INFO|wrapper|Service traccar|17-08-02 16:52:23|started process 3313 INFO|wrapper|Service traccar|17-08-02 16:52:23|started process with pid 3313 INFO|3313/0|Service traccar|17-08-02 16:52:28|[INFO] StandardFileSystemManager - Using "/tmp/vfs_cache" as temporary files store. INFO|3313/0|Service traccar|17-08-02 16:52:31|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Started. INFO|3313/0|Service traccar|17-08-02 16:52:33|[main] INFO org.eclipse.jetty.util.log - Logging initialized @7900ms INFO|3313/0|Service traccar|17-08-02 16:52:34|java.lang.reflect.InvocationTargetException INFO|3313/0|Service traccar|17-08-02 16:52:34| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) INFO|3313/0|Service traccar|17-08-02 16:52:34| at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) INFO|3313/0|Service traccar|17-08-02 16:52:34| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) INFO|3313/0|Service traccar|17-08-02 16:52:34| at java.lang.reflect.Method.invoke(Method.java:498) INFO|3313/0|Service traccar|17-08-02 16:52:34| at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60) INFO|3313/0|Service traccar|17-08-02 16:52:34| at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43) INFO|3313/0|Service traccar|17-08-02 16:52:34|Caused by: java.lang.NullPointerException INFO|3313/0|Service traccar|17-08-02 16:52:34| at org.traccar.database.DeviceManager.getAllGroups(DeviceManager.java:273) INFO|3313/0|Service traccar|17-08-02 16:52:34| at org.traccar.database.PermissionsManager.refreshPermissions(PermissionsManager.java:104) INFO|3313/0|Service traccar|17-08-02 16:52:34| at org.traccar.database.PermissionsManager.<init>(PermissionsManager.java:81) INFO|3313/0|Service traccar|17-08-02 16:52:34| at org.traccar.Context.init(Context.java:244) INFO|3313/0|Service traccar|17-08-02 16:52:34| at org.traccar.Main.main(Main.java:35) INFO|3313/0|Service traccar|17-08-02 16:52:34| ... 6 more INFO|wrapper|Service traccar|17-08-02 16:52:34|waitpid 3313 59136 INFO|wrapper|Service traccar|17-08-02 16:52:34|exit code posix process: 59136 application: 0
Hi,Anton
it Solveddddddddddddddddddddddddddddddddddddddddddddddddd
thanks
Hi
1- i have an image from a linux with installed traccar with different UI.
2- i have a backup database.mv.db .
when im trying to replace the previous image everything working fine.
but when im stopping the service and replace the database file and startDaemon again , then traccar dont working .