Upgrade Traccar 3.5 to 3.9 MySQL problem

Доброго времени суток. Обновил Traccar с версии 3.5 до версии 3.9. В конфиге traccar.xml вместо стандартной базы прописал параметры бд mysql.

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

Вобщем, не стартует. Подскажите пожалуйста.


WARNING|wrapper|Service traccar|17-01-16 20:32:47|YAJSW: yajsw-beta-12.07
WARNING|wrapper|Service traccar|17-01-16 20:32:47|OS   : Linux/3.10.0-327.18.2.el7.x86_64/amd64
WARNING|wrapper|Service traccar|17-01-16 20:32:47|JVM  : Oracle Corporation/1.8.0_60//usr/java/jre1.8.0_60/64
INFO|wrapper|Service traccar|17-01-16 20:32:47|exec:"/bin/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=-6660251273218093343" "-Dwrapper.teeName=-6660251273218093343$1484587967752" "-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-01-16 20:32:47|posix_spawn pid 2695
INFO|wrapper|Service traccar|17-01-16 20:32:47|started process 2695
INFO|wrapper|Service traccar|17-01-16 20:32:47|started process with pid 2695
INFO|2695/0|Service traccar|17-01-16 20:32:48|[INFO] StandardFileSystemManager - Using "/tmp/vfs_cache" as temporary files store.
INFO|2695/0|Service traccar|17-01-16 20:32:49|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Started.
INFO|2695/0|Service traccar|17-01-16 20:32:49|INFO 1/16/17 8:32 PM: liquibase: Clearing database change log checksums
INFO|2695/0|Service traccar|17-01-16 20:32:49|INFO 1/16/17 8:32 PM: liquibase: Successfully acquired change log lock
INFO|2695/0|Service traccar|17-01-16 20:32:49|INFO 1/16/17 8:32 PM: liquibase: Successfully released change log lock
INFO|2695/0|Service traccar|17-01-16 20:32:50|INFO 1/16/17 8:32 PM: liquibase: Successfully acquired change log lock
INFO|2695/0|Service traccar|17-01-16 20:32:50|INFO 1/16/17 8:32 PM: liquibase: Reading from traccar.DATABASECHANGELOG
INFO|2695/0|Service traccar|17-01-16 20:32:51|INFO 1/16/17 8:32 PM: liquibase: Reading from traccar.DATABASECHANGELOG
INFO|2695/0|Service traccar|17-01-16 20:32:51|SEVERE 1/16/17 8:32 PM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Change Set changelog-3.8::changelog-3.8::author failed.  Error: Table 'attribute_aliases' already exists [Failed SQL: CREATE TABLE traccar.attribute_aliases (id INT AUTO_INCREMENT NOT NULL, deviceid INT NOT NULL, attribute VARCHAR(128) NOT NULL, alias VARCHAR(128) NOT NULL, CONSTRAINT PK_ATTRIBUTE_ALIASES PRIMARY KEY (id))]
INFO|2695/0|Service traccar|17-01-16 20:32:51|INFO 1/16/17 8:32 PM: liquibase: changelog-3.8::changelog-3.8::author: Successfully released change log lock
INFO|2695/0|Service traccar|17-01-16 20:32:51|java.lang.reflect.InvocationTargetException
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at java.lang.reflect.Method.invoke(Unknown Source)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|2695/0|Service traccar|17-01-16 20:32:51|Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set changelog-3.8::changelog-3.8::author:
INFO|2695/0|Service traccar|17-01-16 20:32:51|     Reason: liquibase.exception.DatabaseException: Table 'attribute_aliases' already exists [Failed SQL: CREATE TABLE traccar.attribute_aliases (id INT AUTO_INCREMENT NOT NULL, deviceid INT NOT NULL, attribute VARCHAR(128) NOT NULL, alias VARCHAR(128) NOT NULL, CONSTRAINT PK_ATTRIBUTE_ALIASES PRIMARY KEY (id))]
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:619)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at liquibase.Liquibase.update(Liquibase.java:214)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at liquibase.Liquibase.update(Liquibase.java:192)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at liquibase.Liquibase.update(Liquibase.java:188)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:142)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at org.traccar.database.DataManager.<init>(DataManager.java:68)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at org.traccar.Context.init(Context.java:176)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at org.traccar.Main.main(Main.java:35)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	... 6 more
INFO|2695/0|Service traccar|17-01-16 20:32:51|Caused by: liquibase.exception.DatabaseException: Table 'attribute_aliases' already exists [Failed SQL: CREATE TABLE traccar.attribute_aliases (id INT AUTO_INCREMENT NOT NULL, deviceid INT NOT NULL, attribute VARCHAR(128) NOT NULL, alias VARCHAR(128) NOT NULL, CONSTRAINT PK_ATTRIBUTE_ALIASES PRIMARY KEY (id))]
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:309)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:113)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1277)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1259)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:582)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	... 15 more
INFO|2695/0|Service traccar|17-01-16 20:32:51|Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'attribute_aliases' already exists
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at java.lang.reflect.Constructor.newInstance(Unknown Source)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at com.mysql.jdbc.Util.getInstance(Util.java:408)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:739)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:307)
INFO|2695/0|Service traccar|17-01-16 20:32:51|	... 20 more
INFO|wrapper|Service traccar|17-01-16 20:32:51|waitpid 2695 59136
INFO|wrapper|Service traccar|17-01-16 20:32:51|exit code posix process: 59136 application: 0

Правильно ли я понимаю что сервер сам должен создать/обновить необходимые таблицы в БД?

Anton Tananaev7 years ago

Должен сам обновить, но у вас какая-то проблема с базой данных. У вас по какой-то причине уже создана таблица "attribute_aliases". Такой таблицы не должно быть в версии 3.5. Вы точно только официальными релизами пользовались?

Malkit Singh7 years ago

просто падение таблицу "attribute_aliases" вручную из базы данных и повторите попытку, все должно работать после этого.

Latenight7 years ago

Спасибо за ответы. Да, у меня был установлен официальный релиз 3.5. Скорее всего эта таблица создалась в результате предыдущих неудачных попыток запустить сервер. Я пробовал дропать эту таблицу, но в итоге все равно ругался на следующую и т.д. по чейнджлогу). Потом я создал новую DATABASE, развернул в нее бэкап бд версии 3.5, убедился в отсутствии "лишних" таблиц, указал в конфиге новую бд. Теперь ругается что не может модифицировать..


WARNING|wrapper|Service traccar|17-01-17 08:53:34|YAJSW: yajsw-beta-12.07
WARNING|wrapper|Service traccar|17-01-17 08:53:34|OS   : Linux/3.10.0-327.18.2.el7.x86_64/amd64
WARNING|wrapper|Service traccar|17-01-17 08:53:34|JVM  : Oracle Corporation/1.8.0_60//usr/java/jre1.8.0_60/64
INFO|wrapper|Service traccar|17-01-17 08:53:34|exec:"/bin/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=-5357079629209505661" "-Dwrapper.teeName=-5357079629209505661$1484632414792" "-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-01-17 08:53:34|posix_spawn pid 6607
INFO|wrapper|Service traccar|17-01-17 08:53:35|started process 6607
INFO|wrapper|Service traccar|17-01-17 08:53:35|started process with pid 6607
INFO|6607/0|Service traccar|17-01-17 08:53:36|[INFO] StandardFileSystemManager - Using "/tmp/vfs_cache" as temporary files store.
INFO|6607/0|Service traccar|17-01-17 08:53:36|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Started.
INFO|6607/0|Service traccar|17-01-17 08:53:36|INFO 1/17/17 8:53 AM: liquibase: Clearing database change log checksums
INFO|6607/0|Service traccar|17-01-17 08:53:37|INFO 1/17/17 8:53 AM: liquibase: Successfully acquired change log lock
INFO|6607/0|Service traccar|17-01-17 08:53:38|INFO 1/17/17 8:53 AM: liquibase: Successfully released change log lock
INFO|6607/0|Service traccar|17-01-17 08:53:38|INFO 1/17/17 8:53 AM: liquibase: Successfully acquired change log lock
INFO|6607/0|Service traccar|17-01-17 08:53:39|INFO 1/17/17 8:53 AM: liquibase: Reading from trac.DATABASECHANGELOG
INFO|6607/0|Service traccar|17-01-17 08:53:39|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.3::changelog-3.3::author: Marking ChangeSet: changelog-3.3::changelog-3.3::author ran despite precondition failure due to onFail='MARK_RAN': 
INFO|6607/0|Service traccar|17-01-17 08:53:39|          ./schema/changelog-master.xml : Not precondition failed
INFO|6607/0|Service traccar|17-01-17 08:53:39|
INFO|6607/0|Service traccar|17-01-17 08:53:39|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.5::changelog-3.5::author: Marking ChangeSet: changelog-3.5::changelog-3.5::author ran despite precondition failure due to onFail='MARK_RAN': 
INFO|6607/0|Service traccar|17-01-17 08:53:39|          ./schema/changelog-master.xml : Not precondition failed
INFO|6607/0|Service traccar|17-01-17 08:53:39|
INFO|6607/0|Service traccar|17-01-17 08:53:40|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.6::changelog-3.6::author: Table events created
INFO|6607/0|Service traccar|17-01-17 08:53:41|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.6::changelog-3.6::author: Foreign key constraint added to events (deviceid)
INFO|6607/0|Service traccar|17-01-17 08:53:42|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.6::changelog-3.6::author: Columns motion(VARCHAR(128)) added to devices
INFO|6607/0|Service traccar|17-01-17 08:53:42|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.6::changelog-3.6::author: Table geofences created
INFO|6607/0|Service traccar|17-01-17 08:53:42|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.6::changelog-3.6::author: Table user_geofence created
INFO|6607/0|Service traccar|17-01-17 08:53:44|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.6::changelog-3.6::author: Foreign key constraint added to user_geofence (userid)
INFO|6607/0|Service traccar|17-01-17 08:53:45|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.6::changelog-3.6::author: Foreign key constraint added to user_geofence (geofenceid)
INFO|6607/0|Service traccar|17-01-17 08:53:45|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.6::changelog-3.6::author: Table group_geofence created
INFO|6607/0|Service traccar|17-01-17 08:53:46|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.6::changelog-3.6::author: Foreign key constraint added to group_geofence (groupid)
INFO|6607/0|Service traccar|17-01-17 08:53:47|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.6::changelog-3.6::author: Foreign key constraint added to group_geofence (geofenceid)
INFO|6607/0|Service traccar|17-01-17 08:53:48|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.6::changelog-3.6::author: Table device_geofence created
INFO|6607/0|Service traccar|17-01-17 08:53:49|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.6::changelog-3.6::author: Foreign key constraint added to device_geofence (deviceid)
INFO|6607/0|Service traccar|17-01-17 08:53:50|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.6::changelog-3.6::author: Foreign key constraint added to device_geofence (geofenceid)
INFO|6607/0|Service traccar|17-01-17 08:53:51|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.6::changelog-3.6::author: Table notifications created
INFO|6607/0|Service traccar|17-01-17 08:53:52|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.6::changelog-3.6::author: Foreign key constraint added to notifications (userid)
INFO|6607/0|Service traccar|17-01-17 08:53:52|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.6::changelog-3.6::author: Columns attributes(VARCHAR(4096)) added to users
INFO|6607/0|Service traccar|17-01-17 08:53:52|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.6::changelog-3.6::author: ChangeSet changelog-3.6::changelog-3.6::author ran successfully in 13184ms
INFO|6607/0|Service traccar|17-01-17 08:53:53|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.7::changelog-3.7::author: Data updated in devices
INFO|6607/0|Service traccar|17-01-17 08:53:54|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.7::changelog-3.7::author: Foreign key constraint added to devices (groupid)
INFO|6607/0|Service traccar|17-01-17 08:53:54|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.7::changelog-3.7::author: Data updated in groups
INFO|6607/0|Service traccar|17-01-17 08:53:55|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.7::changelog-3.7::author: Columns attributes(VARCHAR(4096)) added to devices
INFO|6607/0|Service traccar|17-01-17 08:53:56|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.7::changelog-3.7::author: Column devices.motion dropped
INFO|6607/0|Service traccar|17-01-17 08:53:57|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.7::changelog-3.7::author: Column devices.status dropped
INFO|6607/0|Service traccar|17-01-17 08:53:58|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.7::changelog-3.7::author: Columns attributes(VARCHAR(4096)) added to groups
INFO|6607/0|Service traccar|17-01-17 08:53:59|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.7::changelog-3.7::author: Columns attributes(VARCHAR(4096)) added to server
INFO|6607/0|Service traccar|17-01-17 08:53:59|INFO 1/17/17 8:53 AM: liquibase: ./schema/changelog-master.xml: changelog-3.7::changelog-3.7::author: ChangeSet changelog-3.7::changelog-3.7::author ran successfully in 6351ms
INFO|6607/0|Service traccar|17-01-17 08:54:00|INFO 1/17/17 8:54 AM: liquibase: ./schema/changelog-master.xml: changelog-3.7::changelog-3.7-notmssql::author: Foreign key constraint added to groups (groupid)
INFO|6607/0|Service traccar|17-01-17 08:54:00|INFO 1/17/17 8:54 AM: liquibase: ./schema/changelog-master.xml: changelog-3.7::changelog-3.7-notmssql::author: ChangeSet changelog-3.7::changelog-3.7-notmssql::author ran successfully in 1383ms
INFO|6607/0|Service traccar|17-01-17 08:54:01|INFO 1/17/17 8:54 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Table attribute_aliases created
INFO|6607/0|Service traccar|17-01-17 08:54:02|INFO 1/17/17 8:54 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Foreign key constraint added to attribute_aliases (deviceid)
INFO|6607/0|Service traccar|17-01-17 08:54:02|INFO 1/17/17 8:54 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Unique constraint added to attribute_aliases(deviceid, attribute)
INFO|6607/0|Service traccar|17-01-17 08:54:02|INFO 1/17/17 8:54 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Data updated in users
INFO|6607/0|Service traccar|17-01-17 08:54:02|INFO 1/17/17 8:54 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Data updated in users
INFO|6607/0|Service traccar|17-01-17 08:54:02|INFO 1/17/17 8:54 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Data updated in users
INFO|6607/0|Service traccar|17-01-17 08:54:03|INFO 1/17/17 8:54 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Table statistics created
INFO|6607/0|Service traccar|17-01-17 08:54:04|INFO 1/17/17 8:54 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: server.mapurl datatype was changed to VARCHAR(512)
INFO|6607/0|Service traccar|17-01-17 08:54:05|INFO 1/17/17 8:54 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Columns forcesettings(BOOLEAN) added to server
INFO|6607/0|Service traccar|17-01-17 08:54:05|INFO 1/17/17 8:54 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Columns coordinateformat(VARCHAR(128)) added to users
INFO|6607/0|Service traccar|17-01-17 08:54:06|INFO 1/17/17 8:54 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Columns coordinateformat(VARCHAR(128)) added to server
INFO|6607/0|Service traccar|17-01-17 09:06:13|SEVERE 1/17/17 9:06 AM: liquibase: ./schema/changelog-master.xml: changelog-3.8::changelog-3.8::author: Change Set changelog-3.8::changelog-3.8::author failed.  Error: Temporary file write failure. [Failed SQL: ALTER TABLE trac.positions MODIFY attributes VARCHAR(4096) NULL]
INFO|6607/0|Service traccar|17-01-17 09:06:13|INFO 1/17/17 9:06 AM: liquibase: changelog-3.8::changelog-3.8::author: Successfully released change log lock
INFO|6607/0|Service traccar|17-01-17 09:06:13|java.lang.reflect.InvocationTargetException
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at java.lang.reflect.Method.invoke(Unknown Source)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|6607/0|Service traccar|17-01-17 09:06:13|Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set changelog-3.8::changelog-3.8::author:
INFO|6607/0|Service traccar|17-01-17 09:06:13|     Reason: liquibase.exception.DatabaseException: Temporary file write failure. [Failed SQL: ALTER TABLE trac.positions MODIFY attributes VARCHAR(4096) NULL]
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:619)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at liquibase.Liquibase.update(Liquibase.java:214)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at liquibase.Liquibase.update(Liquibase.java:192)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at liquibase.Liquibase.update(Liquibase.java:188)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:142)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at org.traccar.database.DataManager.<init>(DataManager.java:68)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at org.traccar.Context.init(Context.java:176)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at org.traccar.Main.main(Main.java:35)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	... 6 more
INFO|6607/0|Service traccar|17-01-17 09:06:13|Caused by: liquibase.exception.DatabaseException: Temporary file write failure. [Failed SQL: ALTER TABLE trac.positions MODIFY attributes VARCHAR(4096) NULL]
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:309)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:113)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1277)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1259)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:582)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	... 15 more
INFO|6607/0|Service traccar|17-01-17 09:06:13|Caused by: java.sql.SQLException: Temporary file write failure.
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:739)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:307)
INFO|6607/0|Service traccar|17-01-17 09:06:13|	... 20 more
INFO|wrapper|Service traccar|17-01-17 09:06:13|waitpid 6607 59136
INFO|wrapper|Service traccar|17-01-17 09:06:13|exit code posix process: 59136 application: 0

Можно ли однозначно сказать что проблема в моей БД ?

Anton Tananaev7 years ago

Теперь у вас проблема с временным файлом. Скорее всего недостаточно места на диске.

Latenight7 years ago

Разобрался. Все проблемы возникли в результате того что при первом запуске сервера - я его остановил, подумав что он не запускается. Ему надо было достаточное время просто чтобы создать/обновить таблицы в базе. Некоторые таблицы он успел создать, поэтому и ругался при последующих попытках что они уже есть. В итоге развернул новую базу из дампа, запустил сервер и все прекрасно.

Места должно быть как минимум на размер существующей базы, т.к. при миграции, насколько я понял - делается копия базы.

Большое спасибо.

Anton Tananaev7 years ago

Traccar добавляет поля в таблицы. MySQL при изменении схемы создает копию таблицы, соответственно нужно достаточно места для хотя-бы 2 таблиц positions.