Upgrade from 3.11 to 3.14 did not work

Ólavur7 years ago

After upgrading from 3.11 to 3.14 I get this error in the wrapper log. Any idea what is causing this and how to fix?

WARNING|wrapper|Service traccar|17-09-13 10:55:26|YAJSW: yajsw-stable-12.09
WARNING|wrapper|Service traccar|17-09-13 10:55:26|OS   : Linux/4.1.12-61.1.23.el6uek.x86_64/amd64
WARNING|wrapper|Service traccar|17-09-13 10:55:26|JVM  : Oracle Corporation/1.7.0_121//usr/lib/jvm/java-1.7.0-openjdk-1.7.0.121.x86_64/jre/64
INFO|wrapper|Service traccar|17-09-13 10:55:26|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=-4463198255523612904" "-Dwrapper.teeName=-4463198255523612904$1505296526109" "-Dwrapper.tmp.path=/opt/traccar/tmp" "-Djna_tmpdir=/opt/traccar/tmp" "-Dwrapper.config=/opt/traccar/conf/wrapper.conf" "-Dwrapper.visible=false" "-Dwrapper.pidfile=/var/run/wrapper.traccar.pid" "org.rzo.yajsw.app.WrapperJVMMain"
INFO|wrapper|Service traccar|17-09-13 10:55:26|posix_spawn pid 9307
INFO|wrapper|Service traccar|17-09-13 10:55:26|started process 9307
INFO|wrapper|Service traccar|17-09-13 10:55:26|started process with pid 9307
INFO|9307/0|Service traccar|17-09-13 10:55:27|[INFO] StandardFileSystemManager - Using "/tmp/vfs_cache" as temporary files store.
INFO|9307/0|Service traccar|17-09-13 10:55:27|java.lang.reflect.InvocationTargetException
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at java.lang.reflect.Method.invoke(Method.java:606)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|9307/0|Service traccar|17-09-13 10:55:27|Caused by: java.util.InvalidPropertiesFormatException: org.xml.sax.SAXParseException; lineNumber: 50; columnNumber: 14; The content of element type "properties" must match "(comment?,entry*)".
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at java.util.XMLUtils.load(XMLUtils.java:76)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at java.util.Properties.loadFromXML(Properties.java:868)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at org.traccar.Config.load(Config.java:32)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at org.traccar.Context.init(Context.java:269)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at org.traccar.Main.main(Main.java:35)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  ... 6 more
INFO|9307/0|Service traccar|17-09-13 10:55:27|Caused by: org.xml.sax.SAXParseException; lineNumber: 50; columnNumber: 14; The content of element type "properties" must match "(comment?,entry*)".
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:198)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java:134)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:396)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:327)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:284)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.handleEndElement(XMLDTDValidator.java:1994)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.endElement(XMLDTDValidator.java:879)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1776)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2964)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:606)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:504)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:848)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:243)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:338)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at java.util.XMLUtils.getLoadingDoc(XMLUtils.java:102)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  at java.util.XMLUtils.load(XMLUtils.java:74)
INFO|9307/0|Service traccar|17-09-13 10:55:27|  ... 10 more
INFO|wrapper|Service traccar|17-09-13 10:55:27|waitpid 9307 59136
INFO|wrapper|Service traccar|17-09-13 10:55:27|exit code posix process: 59136 application: 0
Anton Tananaev7 years ago

You have some problem with the config file.

Ólavur7 years ago

Strange. I installed 3.11 again and everything works fine:

The config includes these entries:

    <entry key='web.port'>80</entry>
    <entry key='web.url'>https://tolnet_test.ft.fo</entry>
    <entry key="config.default">./conf/default.xml</entry>

    <entry key='database.driver'>com.mysql.jdbc.Driver</entry>
    <entry key='database.url'>jdbc:mysql://localhost/traccar?allowMultiQueries=true&amp;autoReconnect=true&amp;useUnicode=yes&amp;characterEncoding=UTF-8&amp;sessionVariables=sql_mode=''</entry>
    <entry key='database.user'>root</entry>
    <entry key='database.password'>password</entry>

Should the config include anything else in 3.14?

Anton Tananaev7 years ago

You definitely has some problem in the config. Error message clearly indicates where the error was.

Ólavur7 years ago

I got this error when using 3.12, this points to some error in the DB. Do you have any suggestion how this can be fixed?

INFO|11304/0|Service traccar|17-09-13 11:36:50|INFO 9/13/17 11:36 AM: liquibase: Clearing database change log checksums
INFO|11304/0|Service traccar|17-09-13 11:36:50|INFO 9/13/17 11:36 AM: liquibase: Successfully acquired change log lock
INFO|11304/0|Service traccar|17-09-13 11:36:50|INFO 9/13/17 11:36 AM: liquibase: Successfully released change log lock
INFO|11304/0|Service traccar|17-09-13 11:36:50|INFO 9/13/17 11:36 AM: liquibase: Successfully acquired change log lock
INFO|11304/0|Service traccar|17-09-13 11:36:52|INFO 9/13/17 11:36 AM: liquibase: Reading from traccar.DATABASECHANGELOG
INFO|11304/0|Service traccar|17-09-13 11:36:52|INFO 9/13/17 11:36 AM: liquibase: Reading from traccar.DATABASECHANGELOG
INFO|11304/0|Service traccar|17-09-13 11:36:52|INFO 9/13/17 11:36 AM: 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|11304/0|Service traccar|17-09-13 11:36:52|SEVERE 9/13/17 11:36 AM: liquibase: ./schema/changelog-master.xml: changelog-3.12::changelog-3.12::author: Change Set changelog-3.12::changelog-3.12::author failed.  Error: Duplicate column name 'mailsent' [Failed SQL: ALTER TABLE traccar.statistics ADD mailsent INT DEFAULT 0 NOT NULL, ADD smssent INT DEFAULT 0 NOT NULL, ADD geocoderrequests INT DEFAULT 0 NOT NULL, ADD geolocationrequests INT DEFAULT 0 NOT NULL]
INFO|11304/0|Service traccar|17-09-13 11:36:52|INFO 9/13/17 11:36 AM: liquibase: changelog-3.12::changelog-3.12::author: Successfully released change log lock
INFO|11304/0|Service traccar|17-09-13 11:36:52|java.lang.reflect.InvocationTargetException
INFO|11304/0|Service traccar|17-09-13 11:36:52| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at java.lang.reflect.Method.invoke(Method.java:606)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|11304/0|Service traccar|17-09-13 11:36:52|Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set changelog-3.12::changelog-3.12::author:
INFO|11304/0|Service traccar|17-09-13 11:36:52|     Reason: liquibase.exception.DatabaseException: Duplicate column name 'mailsent' [Failed SQL: ALTER TABLE traccar.statistics ADD mailsent INT DEFAULT 0 NOT NULL, ADD smssent INT DEFAULT 0 NOT NULL, ADD geocoderrequests INT DEFAULT 0 NOT NULL, ADD geolocationrequests INT DEFAULT 0 NOT NULL]
INFO|11304/0|Service traccar|17-09-13 11:36:52| at liquibase.changelog.ChangeSet.execute(ChangeSet.java:619)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at liquibase.Liquibase.update(Liquibase.java:214)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at liquibase.Liquibase.update(Liquibase.java:192)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at liquibase.Liquibase.update(Liquibase.java:188)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:150)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at org.traccar.database.DataManager.<init>(DataManager.java:76)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at org.traccar.Context.init(Context.java:221)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at org.traccar.Main.main(Main.java:35)
INFO|11304/0|Service traccar|17-09-13 11:36:52| ... 6 more
INFO|11304/0|Service traccar|17-09-13 11:36:52|Caused by: liquibase.exception.DatabaseException: Duplicate column name 'mailsent' [Failed SQL: ALTER TABLE traccar.statistics ADD mailsent INT DEFAULT 0 NOT NULL, ADD smssent INT DEFAULT 0 NOT NULL, ADD geocoderrequests INT DEFAULT 0 NOT NULL, ADD geolocationrequests INT DEFAULT 0 NOT NULL]
INFO|11304/0|Service traccar|17-09-13 11:36:52| at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:309)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:113)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1277)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1259)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at liquibase.changelog.ChangeSet.execute(ChangeSet.java:582)
INFO|11304/0|Service traccar|17-09-13 11:36:52| ... 15 more
INFO|11304/0|Service traccar|17-09-13 11:36:52|Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'mailsent'
INFO|11304/0|Service traccar|17-09-13 11:36:52| at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at com.mysql.jdbc.Util.getInstance(Util.java:408)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
INFO|11304/0|Service traccar|17-09-13 11:36:52| at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:307)
INFO|11304/0|Service traccar|17-09-13 11:36:52| ... 20 more
INFO|wrapper|Service traccar|17-09-13 11:36:52|waitpid 11304 59136
INFO|wrapper|Service traccar|17-09-13 11:36:52|exit code posix process: 59136 application: 0
Anton Tananaev7 years ago

Now there is something broken in your database.

Please do some search before asking any questions.

Ólavur7 years ago

Ok, I have found out that something goes wrong with the installation of 3.12 (or 3.14). Again 3.11 works fine.

Has this something to do with the java version?

[root@traccar_test ~]# sudo ./traccar.run
Creating directory out
Verifying archive integrity...  100%   All good.
Uncompressing traccar  100%
chmod: cannot access `go+rX': No such file or directory
chmod: /opt/traccar: new permissions are -wxr-xr-x, not -wx--x--x
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
++++++++++ YAJSW SET ENV ++++++++++
pwd: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
chdir: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
java version "1.7.0_121"
OpenJDK Runtime Environment (rhel-2.6.8.1.0.1.el6_8-x86_64 u121-b00)
OpenJDK 64-Bit Server VM (build 24.121-b00, mixed mode)
wrapper home : /opt/traccar
configuration: /opt/traccar/conf/wrapper.conf
java version "1.7.0_121"
OpenJDK Runtime Environment (rhel-2.6.8.1.0.1.el6_8-x86_64 u121-b00)
OpenJDK 64-Bit Server VM (build 24.121-b00, mixed mode)
---------- YAJSW SET ENV ----------
++++++++++ YAJSW SET ENV ++++++++++
java version "1.7.0_121"
OpenJDK Runtime Environment (rhel-2.6.8.1.0.1.el6_8-x86_64 u121-b00)
OpenJDK 64-Bit Server VM (build 24.121-b00, mixed mode)
wrapper home : /opt/traccar
configuration: /opt/traccar/conf/wrapper.conf
java version "1.7.0_121"
OpenJDK Runtime Environment (rhel-2.6.8.1.0.1.el6_8-x86_64 u121-b00)
OpenJDK 64-Bit Server VM (build 24.121-b00, mixed mode)
---------- YAJSW SET ENV ----------
YAJSW: yajsw-stable-12.09
OS   : Linux/4.1.12-61.1.23.el6uek.x86_64/amd64
JVM  : Oracle Corporation/1.7.0_121//usr/lib/jvm/java-1.7.0-openjdk-1.7.0.121.x86_64/jre/64
Sep 13, 2017 1:53:44 PM org.apache.commons.vfs2.VfsLog info
INFO: Using "/tmp/vfs_cache" as temporary files store.
Sep 13, 2017 1:53:45 PM org.rzo.yajsw.os.posix.PosixService init
INFO: /etc/init.d/traccar already exists
************* INSTALLING traccar ***********************

Sep 13, 2017 1:53:45 PM org.rzo.yajsw.os.posix.PosixService getPid
INFO: wrapper pid file: /var/run/wrapper.traccar.pid
Sep 13, 2017 1:53:46 PM org.rzo.yajsw.os.posix.PosixService stop
INFO: Stopping traccar ...
YAJSW: yajsw-stable-12.09
OS   : Linux/4.1.12-61.1.23.el6uek.x86_64/amd64
JVM  : Oracle Corporation/1.7.0_121//usr/lib/jvm/java-1.7.0-openjdk-1.7.0.121.x86_64/jre/64
************* STOPPING traccar ***********************
Anton Tananaev7 years ago

It looks OK.