Error migrating trailing 3.17 to 4.0

br2e 7 years ago

INFO|5555/0|Service traccar|19-02-01 02:33:56|Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set changelog-3.17::changelog-3.17::author:
INFO|5555/0|Service traccar|19-02-01 02:33:56|     Reason: liquibase.exception.DatabaseException: Duplicate column name 'maintenanceid' [Failed SQL: ALTER TABLE rastreamento.events ADD maintenanceid INT NULL]
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at liquibase.changelog.ChangeSet.execute(ChangeSet.java:637)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:78)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at liquibase.Liquibase.update(Liquibase.java:202)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at liquibase.Liquibase.update(Liquibase.java:179)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at liquibase.Liquibase.update(Liquibase.java:175)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:307)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at org.traccar.database.DataManager.<init>(DataManager.java:88)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at org.traccar.Context.init(Context.java:361)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at org.traccar.Main.main(Main.java:35)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  ... 6 more
INFO|5555/0|Service traccar|19-02-01 02:33:56|Caused by: liquibase.exception.DatabaseException: Duplicate column name 'maintenanceid' [Failed SQL: ALTER TABLE rastreamento.events ADD maintenanceid INT NULL]
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1229)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1211)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at liquibase.changelog.ChangeSet.execute(ChangeSet.java:600)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  ... 15 more
INFO|5555/0|Service traccar|19-02-01 02:33:56|Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'maintenanceid'
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at com.mysql.jdbc.Util.getInstance(Util.java:408)
INFO|5555/0|Service traccar|19-02-01 02:33:56|  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
FINEST|5555/0|Service traccar|19-02-01 02:33:56|        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
FINEST|5555/0|Service traccar|19-02-01 02:33:56|        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
FINEST|5555/0|Service traccar|19-02-01 02:33:56|        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
FINEST|5555/0|Service traccar|19-02-01 02:33:56|        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
FINEST|5555/0|Service traccar|19-02-01 02:33:56|        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2482)
FINEST|5555/0|Service traccar|19-02-01 02:33:56|        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2440)
FINEST|5555/0|Service traccar|19-02-01 02:33:56|        at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
FINEST|5555/0|Service traccar|19-02-01 02:33:56|        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
FINEST|5555/0|Service traccar|19-02-01 02:33:56|        at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352)
FINEST|5555/0|Service traccar|19-02-01 02:33:56|        ... 20 more
INFO|wrapper|Service traccar|19-02-01 02:33:57|waitpid 5555 59136
INFO|wrapper|Service traccar|19-02-01 02:33:57|exit code posix process: 59136 application(status/signal): 231/0

Anton Tananaev 7 years ago

Something went wrong with database migration. You would probably have to do it manually or start over if you have a database backup.

br2e 7 years ago

My God is a 2gb database

Anton Tananaev 7 years ago

Have you made a backup?

br2e 7 years ago

yes I have more see well once I did an upgrade with it to 3.17 I did not like the version that at the time had some bugs I did a downgrade the tables maintenance I left as I noticed that in the users table only the admin field was renamed to administrator made manual the change and is up to now working fine now I made the up direct to the version 4.2 generated these error beginning where what it recommends to me before doing it manually

br2e 7 years ago

Forgive me for version 4.0

Anton Tananaev 7 years ago

OK, so you manually tweaked the database? That's the problem. You would need to manually fix it now.

br2e 7 years ago

after daily occurrence but before

br2e 7 years ago

3.17 for the 3.16 download grid what tables should I change out users admin field?

Ernesto Vallejo 7 years ago

Check schema folder for changes along versions.