Upgrade from 3.11 to 3.14 did not work

Ólavur 8 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 Tananaev 8 years ago

You have some problem with the config file.

Ólavur 8 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 Tananaev 8 years ago

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

Ólavur 8 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 Tananaev 8 years ago

Now there is something broken in your database.

Please do some search before asking any questions.

Ólavur 8 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 Tananaev 8 years ago

It looks OK.