Problems with update 3.16 to 3.17 problem and in the database where I should move to repair the database if someone can help me

br2e6 years ago
WARNING|wrapper|Service traccar|19-03-13 01:28:49|YAJSW: yajsw-stable-12.12
...
INFO|4359/0|Service traccar|19-03-13 01:28:56|[main] INFO liquibase.executor.jvm.JdbcExecutor - SELECT * FROM rastreamento.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
INFO|4359/0|Service traccar|19-03-13 01:28:56|[main] INFO liquibase.executor.jvm.JdbcExecutor - CREATE TABLE rastreamento.users (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(128) NOT NULL, email VARCHAR(128) NOT NULL, hashedpassword VARCHAR(128) NOT NULL, salt VARCHAR(128) NOT NULL, readonly BIT(1) DEFAULT 0 NOT NULL, administrator BIT(1) DEFAULT 0 NOT NULL, map VARCHAR(128) DEFAULT 'osm' NOT NULL, language VARCHAR(128) DEFAULT 'en' NOT NULL, distanceunit VARCHAR(128) DEFAULT 'km' NOT NULL, speedunit VARCHAR(128) DEFAULT 'kmh' NOT NULL, latitude DOUBLE DEFAULT 0 NOT NULL, longitude DOUBLE DEFAULT 0 NOT NULL, zoom INT DEFAULT 0 NOT NULL, CONSTRAINT PK_USERS PRIMARY KEY (id))
INFO|4359/0|Service traccar|19-03-13 01:28:56|[main] ERROR liquibase.changelog.ChangeSet - Change Set changelog-3.3::changelog-3.3::author failed.  Error: Table 'users' already exists [Failed SQL: CREATE TABLE rastreamento.users (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(128) NOT NULL, email VARCHAR(128) NOT NULL, hashedpassword VARCHAR(128) NOT NULL, salt VARCHAR(128) NOT NULL, readonly BIT(1) DEFAULT 0 NOT NULL, administrator BIT(1) DEFAULT 0 NOT NULL, map VARCHAR(128) DEFAULT 'osm' NOT NULL, language VARCHAR(128) DEFAULT 'en' NOT NULL, distanceunit VARCHAR(128) DEFAULT 'km' NOT NULL, speedunit VARCHAR(128) DEFAULT 'kmh' NOT NULL, latitude DOUBLE DEFAULT 0 NOT NULL, longitude DOUBLE DEFAULT 0 NOT NULL, zoom INT DEFAULT 0 NOT NULL, CONSTRAINT PK_USERS PRIMARY KEY (id))]
INFO|4359/0|Service traccar|19-03-13 01:28:56|[main] INFO liquibase.lockservice.StandardLockService - Successfully released change log lock
INFO|4359/0|Service traccar|19-03-13 01:28:56|java.lang.reflect.InvocationTargetException
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at java.lang.reflect.Method.invoke(Method.java:498)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|4359/0|Service traccar|19-03-13 01:28:56|Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set changelog-3.3::changelog-3.3::author:
INFO|4359/0|Service traccar|19-03-13 01:28:56|     Reason: liquibase.exception.DatabaseException: Table 'users' already exists [Failed SQL: CREATE TABLE rastreamento.users (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(128) NOT NULL, email VARCHAR(128) NOT NULL, hashedpassword VARCHAR(128) NOT NULL, salt VARCHAR(128) NOT NULL, readonly BIT(1) DEFAULT 0 NOT NULL, administrator BIT(1) DEFAULT 0 NOT NULL, map VARCHAR(128) DEFAULT 'osm' NOT NULL, language VARCHAR(128) DEFAULT 'en' NOT NULL, distanceunit VARCHAR(128) DEFAULT 'km' NOT NULL, speedunit VARCHAR(128) DEFAULT 'kmh' NOT NULL, latitude DOUBLE DEFAULT 0 NOT NULL, longitude DOUBLE DEFAULT 0 NOT NULL, zoom INT DEFAULT 0 NOT NULL, CONSTRAINT PK_USERS PRIMARY KEY (id))]
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:637)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:78)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at liquibase.Liquibase.update(Liquibase.java:202)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at liquibase.Liquibase.update(Liquibase.java:179)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at liquibase.Liquibase.update(Liquibase.java:175)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:306)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at org.traccar.database.DataManager.<init>(DataManager.java:88)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at org.traccar.Context.init(Context.java:353)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at org.traccar.Main.main(Main.java:35)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	... 6 more
INFO|4359/0|Service traccar|19-03-13 01:28:56|Caused by: liquibase.exception.DatabaseException: Table 'users' already exists [Failed SQL: CREATE TABLE rastreamento.users (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(128) NOT NULL, email VARCHAR(128) NOT NULL, hashedpassword VARCHAR(128) NOT NULL, salt VARCHAR(128) NOT NULL, readonly BIT(1) DEFAULT 0 NOT NULL, administrator BIT(1) DEFAULT 0 NOT NULL, map VARCHAR(128) DEFAULT 'osm' NOT NULL, language VARCHAR(128) DEFAULT 'en' NOT NULL, distanceunit VARCHAR(128) DEFAULT 'km' NOT NULL, speedunit VARCHAR(128) DEFAULT 'kmh' NOT NULL, latitude DOUBLE DEFAULT 0 NOT NULL, longitude DOUBLE DEFAULT 0 NOT NULL, zoom INT DEFAULT 0 NOT NULL, CONSTRAINT PK_USERS PRIMARY KEY (id))]
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1229)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1211)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:600)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	... 15 more
INFO|4359/0|Service traccar|19-03-13 01:28:56|Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'users' already exists
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at com.mysql.jdbc.Util.getInstance(Util.java:408)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2482)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2440)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352)
INFO|4359/0|Service traccar|19-03-13 01:28:56|	... 20 more
INFO|wrapper|Service traccar|19-03-13 01:28:56|waitpid 4359 59136
INFO|wrapper|Service traccar|19-03-13 01:28:56|exit code posix process: 59136 application(status/signal): 231/0
Ernesto Vallejo6 years ago

Did you customize your database?