Problem 3.14 - Not start & port closed

rzjl7 years ago

Hi, I install server and after a day of test, shut down:
What can I do? Please help me.

This log:

2017-09-14 13:45:06  INFO: Operating system name: Linux version: 4.4.0-93-generic architecture: amd64
2017-09-14 13:45:06  INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Oracle Corporation version: 25.131-b11
2017-09-14 13:45:06  INFO: Memory limit heap: 446mb non-heap: 0mb
2017-09-14 13:45:06  INFO: Character encoding: UTF-8 charset: UTF-8
2017-09-14 13:45:06  INFO: Version: 3.14-SNAPSHOT
repeat 
repeat

I try check port and 8082 is closed, I restart traccar service, restart mysql

# netstat -lt
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State
tcp        0      0 localhost:mysql         *:*                     LISTEN
tcp        0      0 *:ssh                   *:*                     LISTEN
tcp6       0      0 [::]:ssh                [::]:*                  LISTEN

Thanks.

rzjl7 years ago

Hi, I created a new databse MYSQL and all right, the problem is with first database, I can not do backup and restore because then second database make interface do not show and close ports. If I create a database n#3 anew all correct, but if I restore backup then all closed ports. I install server test since 0 to only 3.14(not upgrade since other version) for test and after do same with my server. But what can I do bad?

Anton Tananaev7 years ago

You are looking at the wrong log file.

rzjl7 years ago

Hi, I see opt/traccar/logs/tracker-server.log, this correct?

Anton Tananaev7 years ago

As I said, it's not. If server doesn't start, you should look into wrapper log file.

rzjl7 years ago

I checked log mysql

2017-09-14T21:07:09.737496Z 240 [Note] Aborted connection 240 to db: 'traccar' user: 'root' host: 'localhost' (Got an error reading communication packets)
2017-09-14T21:09:39.539275Z 251 [Note] Aborted connection 251 to db: 'traccar' user: 'root' host: 'localhost' (Got an error reading communication packets)
2017-09-14T21:09:40.061660Z 250 [Note] Aborted connection 250 to db: 'traccar' user: 'root' host: 'localhost' (Got an error reading communication packets)
2017-09-14T21:09:40.061936Z 249 [Note] Aborted connection 249 to db: 'traccar' user: 'root' host: 'localhost' (Got an error reading communication packets)
2017-09-14T21:09:40.062118Z 248 [Note] Aborted connection 248 to db: 'traccar' user: 'root' host: 'localhost' (Got an error reading communication packets)
2017-09-14T21:09:40.062297Z 247 [Note] Aborted connection 247 to db: 'traccar' user: 'root' host: 'localhost' (Got an error reading communication packets)
2017-09-14T21:09:40.062455Z 246 [Note] Aborted connection 246 to db: 'traccar' user: 'root' host: 'localhost' (Got an error reading communication packets)
2017-09-14T21:09:40.062617Z 244 [Note] Aborted connection 244 to db: 'traccar' user: 'root' host: 'localhost' (Got an error reading communication packets)
2017-09-14T21:09:40.062652Z 245 [Note] Aborted connection 245 to db: 'traccar' user: 'root' host: 'localhost' (Got an error reading communication packets)
2017-09-14T21:09:40.062801Z 243 [Note] Aborted connection 243 to db: 'traccar' user: 'root' host: 'localhost' (Got an error reading communication packets)
2017-09-14T21:09:40.063239Z 242 [Note] Aborted connection 242 to db: 'traccar' user: 'root' host: 'localhost' (Got an error reading communication packets)
2017-09-14T21:09:40.063609Z 241 [Note] Aborted connection 241 to db: 'traccar' user: 'root' host: 'localhost' (Got an error reading communication packets)

rzjl7 years ago

Wrapper log.

INFO|wrapper|Service traccar|17-09-14 21:07:09|waitpid 4285 59136
INFO|wrapper|Service traccar|17-09-14 21:07:09|exit code posix process: 59136 application: 0
WARNING|wrapper|Service traccar|17-09-14 21:09:34|YAJSW: yajsw-stable-12.09
WARNING|wrapper|Service traccar|17-09-14 21:09:34|OS   : Linux/4.4.0-93-generic/amd64
WARNING|wrapper|Service traccar|17-09-14 21:09:34|JVM  : Oracle Corporation/1.8.0_131//usr/lib/jvm/java-8-openjdk-amd64/jre/64
INFO|wrapper|Service traccar|17-09-14 21:09:35|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.9.jar:/opt/traccar/lib/h2-1.4.196.jar:/opt/traccar/lib/mysql-connector-java-5.1.44.jar:/opt/traccar/lib/postgresql-42.1.4.jre7.jar:/opt/traccar/lib/mssql-jdbc-6.2.1.jre7.jar:/opt/traccar/lib/HikariCP-java7-2.4.12.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.25.jar:/opt/traccar/lib/javax.json-1.0.4.jar:/opt/traccar/lib/jetty-server-9.2.22.v20170606.jar:/opt/traccar/lib/javax.servlet-api-3.1.0.jar:/opt/traccar/lib/jetty-http-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-io-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-servlet-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-security-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-webapp-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-xml-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-jndi-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-util-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-proxy-9.2.22.v20170606.jar:/opt/traccar/lib/jetty-client-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-server-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-common-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-api-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-client-9.2.22.v20170606.jar:/opt/traccar/lib/websocket-servlet-9.2.22.v20170606.jar:/opt/traccar/lib/jersey-container-servlet-2.25.1.jar:/opt/traccar/lib/jersey-container-servlet-core-2.25.1.jar:/opt/traccar/lib/javax.inject-2.5.0-b32.jar:/opt/traccar/lib/jersey-common-2.25.1.jar:/opt/traccar/lib/javax.annotation-api-1.2.jar:/opt/traccar/lib/jersey-guava-2.25.1.jar:/opt/traccar/lib/hk2-api-2.5.0-b32.jar:/opt/traccar/lib/hk2-utils-2.5.0-b32.jar:/opt/traccar/lib/aopalliance-repackaged-2.5.0-b32.jar:/opt/traccar/lib/hk2-locator-2.5.0-b32.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.25.1.jar:/opt/traccar/lib/jersey-client-2.25.1.jar:/opt/traccar/lib/jersey-media-jaxb-2.25.1.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.25.1.jar:/opt/traccar/lib/jersey-entity-filtering-2.25.1.jar:/opt/traccar/lib/jackson-jaxrs-base-2.8.4.jar:/opt/traccar/lib/jackson-core-2.8.4.jar:/opt/traccar/lib/jackson-databind-2.8.4.jar:/opt/traccar/lib/jackson-jaxrs-json-provider-2.8.4.jar:/opt/traccar/lib/jackson-module-jaxb-annotations-2.8.4.jar:/opt/traccar/lib/jackson-annotations-2.8.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.4.2.jar:/opt/traccar/lib/commons-jexl-2.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.13.jar:/opt/traccar/lib/poi-3.16.jar:/opt/traccar/lib/poi-ooxml-3.16.jar:/opt/traccar/lib/poi-ooxml-schemas-3.16.jar:/opt/traccar/lib/xmlbeans-2.6.0.jar:/opt/traccar/lib/stax-api-1.0.1.jar:/opt/traccar/lib/curvesapi-1.04.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:/opt/traccar/lib/velocity-tools-2.0.jar:/opt/traccar/lib/commons-digester-1.8.jar:/opt/traccar/lib/commons-chain-1.1.jar:/opt/traccar/lib/commons-logging-1.1.jar:/opt/traccar/lib/servlet-api-2.3.jar:/opt/traccar/lib/commons-validator-1.3.1.jar:/opt/traccar/lib/dom4j-1.1.jar:/opt/traccar/lib/oro-2.0.8.jar:/opt/traccar/lib/sslext-1.2-0.jar:/opt/traccar/lib/struts-core-1.3.8.jar:/opt/traccar/lib/antlr-2.7.2.jar:/opt/traccar/lib/struts-taglib-1.3.8.jar:/opt/traccar/lib/struts-tiles-1.3.8.jar:/opt/traccar/lib/commons-collections4-4.1.jar:/opt/traccar/lib/ical4j-2.0.4.jar:/opt/traccar/lib/commons-codec-1.9.jar:/opt/traccar/lib/commons-lang3-3.3.2.jar:/opt/traccar/lib/threetenbp-1.3.3.jar:/opt/traccar/lib/ch-smpp-5.0.9.jar:/opt/traccar/lib/ch-commons-util-6.0.2.jar:/opt/traccar/lib/ch-commons-charset-3.0.2.jar" "-Dfile.encoding=UTF-8" "-Xrs" "-Dwrapper.service=true" "-Dwrapper.console.visible=false" "-Dwrapper.port=15003" "-Dwrapper.key=-77501093653407396" "-Dwrapper.teeName=-77501093653407396$1505423374776" "-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-09-14 21:09:35|posix_spawn pid 4387
INFO|wrapper|Service traccar|17-09-14 21:09:35|started process 4387
INFO|wrapper|Service traccar|17-09-14 21:09:35|started process with pid 4387
INFO|4387/0|Service traccar|17-09-14 21:09:36|[INFO] StandardFileSystemManager - Using "/tmp/vfs_cache" as temporary files store.
INFO|4387/0|Service traccar|17-09-14 21:09:37|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
INFO|4387/0|Service traccar|17-09-14 21:09:37|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.
INFO|4387/0|Service traccar|17-09-14 21:09:37|INFO 9/14/17 9:09 PM: liquibase: Clearing database change log checksums
INFO|4387/0|Service traccar|17-09-14 21:09:37|INFO 9/14/17 9:09 PM: liquibase: Successfully acquired change log lock
INFO|4387/0|Service traccar|17-09-14 21:09:37|INFO 9/14/17 9:09 PM: liquibase: Successfully released change log lock
INFO|4387/0|Service traccar|17-09-14 21:09:37|INFO 9/14/17 9:09 PM: liquibase: Successfully acquired change log lock
INFO|4387/0|Service traccar|17-09-14 21:09:39|INFO 9/14/17 9:09 PM: liquibase: Reading from traccar.DATABASECHANGELOG
INFO|4387/0|Service traccar|17-09-14 21:09:39|INFO 9/14/17 9:09 PM: liquibase: Reading from traccar.DATABASECHANGELOG
INFO|4387/0|Service traccar|17-09-14 21:09:39|INFO 9/14/17 9:09 PM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8-dropuniquetoken::author: Change set changelog-3.8::changelog-3.8-dropuniquetoken::author failed, but failOnError was false.  Error: Can't DROP 'uk_user_token'; check that column/key exists [Failed SQL: ALTER TABLE traccar.users DROP KEY uk_user_token]
INFO|4387/0|Service traccar|17-09-14 21:09:39|INFO 9/14/17 9:09 PM: liquibase: Successfully released change log lock
INFO|4387/0|Service traccar|17-09-14 21:09:39|[main] INFO org.eclipse.jetty.util.log - Logging initialized @4180ms
INFO|4387/0|Service traccar|17-09-14 21:09:39|java.lang.reflect.InvocationTargetException
INFO|4387/0|Service traccar|17-09-14 21:09:39|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|4387/0|Service traccar|17-09-14 21:09:39|	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
INFO|4387/0|Service traccar|17-09-14 21:09:39|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|4387/0|Service traccar|17-09-14 21:09:39|	at java.lang.reflect.Method.invoke(Method.java:498)
INFO|4387/0|Service traccar|17-09-14 21:09:39|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|4387/0|Service traccar|17-09-14 21:09:39|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|4387/0|Service traccar|17-09-14 21:09:39|Caused by: java.lang.StackOverflowError
INFO|4387/0|Service traccar|17-09-14 21:09:39|	at java.util.HashMap$KeyIterator.<init>(HashMap.java:1459)
INFO|4387/0|Service traccar|17-09-14 21:09:39|	at java.util.HashMap$KeySet.iterator(HashMap.java:916)
INFO|4387/0|Service traccar|17-09-14 21:09:39|	at java.util.HashSet.iterator(HashSet.java:172)
INFO|4387/0|Service traccar|17-09-14 21:09:39|	at org.traccar.database.GroupTree.getNodes(GroupTree.java:144)
INFO|4387/0|Service traccar|17-09-14 21:09:39|	at org.traccar.database.GroupTree.getNodes(GroupTree.java:146)
INFO|4387/0|Service traccar|17-09-14 21:09:39|	at org.traccar.database.GroupTree.getNodes(GroupTree.java:146)
INFO|4387/0|Service traccar|17-09-14 21:09:39|	at org.traccar.database.GroupTree.getNodes(GroupTree.java:146)
INFO|4387/0|Service traccar|17-09-14 21:09:39|	at org.traccar.database.GroupTree.getNodes(GroupTree.java:146)

Anton Tananaev7 years ago

You have a cycle in groups. Usually it means that you set group as it's own parent. You need to fix it or clear the database.

Alvaro Escobar Hernandez7 years ago

Gracias, tenia el mismo problema, lo solucione en la tabla grupos de la base de datos, el groupid hacia un ciclo. !