[09:13:37] INFO: Starting Traccar server...
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
2020-11-09 09:13:39 INFO: HikariPool-1 - Starting...
2020-11-09 09:13:39 WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2020-11-09 09:13:40 INFO: HikariPool-1 - Start completed.
2020-11-09 09:13:42 INFO: Clearing database change log checksums
2020-11-09 09:13:43 INFO: Successfully acquired change log lock
2020-11-09 09:13:44 INFO: Successfully released change log lock
2020-11-09 09:13:44 INFO: Successfully acquired change log lock
2020-11-09 09:13:44 INFO: Can not use class liquibase.parser.core.yaml.YamlChangeLogParser as a Liquibase service because org.yaml.snakeyaml.constructor.BaseConstructor is not in the classpath
2020-11-09 09:13:44 INFO: Can not use class liquibase.parser.core.json.JsonChangeLogParser as a Liquibase service because org.yaml.snakeyaml.constructor.BaseConstructor is not in the classpath
2020-11-09 09:13:46 INFO: Reading from traccar.DATABASECHANGELOG
2020-11-09 09:13:48 ERROR: Change Set changelog-4.0-clean::changelog-4.0-clean::author failed. Error: Table 'tc_attributes' already exists [Failed SQL: (1050) CREATE TABLE traccar.tc_attributes (id INT AUTO_INCREMENT NOT NULL, `description` VARCHAR(4000) NOT NULL, type VARCHAR(128) NOT NULL, attribute VARCHAR(128) NOT NULL, expression VARCHAR(4000) NOT NULL, CONSTRAINT PK_TC_ATTRIBUTES PRIMARY KEY (id))]
2020-11-09 09:13:48 INFO: Successfully released change log lock
2020-11-09 09:13:48 ERROR: Main method error - Table 'tc_attributes' already exists - SQLSyntaxErrorException (... < DataManager:312 < *:90 < Context:299 < Main:137 < ...)
Exception in thread "main" java.lang.RuntimeException: liquibase.exception.MigrationFailedException: Migration failed for change set changelog-4.0-clean::changelog-4.0-clean::author:
Reason: liquibase.exception.DatabaseException: Table 'tc_attributes' already exists [Failed SQL: (1050) CREATE TABLE traccar.tc_attributes (id INT AUTO_INCREMENT NOT NULL, `description` VARCHAR(4000) NOT NULL, type VARCHAR(128) NOT NULL, attribute VARCHAR(128) NOT NULL, expression VARCHAR(4000) NOT NULL, CONSTRAINT PK_TC_ATTRIBUTES PRIMARY KEY (id))]
at org.traccar.Main.run(Main.java:165)
at org.traccar.Main.main(Main.java:110)
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set changelog-4.0-clean::changelog-4.0-clean::author:
Reason: liquibase.exception.DatabaseException: Table 'tc_attributes' already exists [Failed SQL: (1050) CREATE TABLE traccar.tc_attributes (id INT AUTO_INCREMENT NOT NULL, `description` VARCHAR(4000) NOT NULL, type VARCHAR(128) NOT NULL, attribute VARCHAR(128) NOT NULL, expression VARCHAR(4000) NOT NULL, CONSTRAINT PK_TC_ATTRIBUTES PRIMARY KEY (id))]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:659)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:97)
at liquibase.Liquibase.update(Liquibase.java:201)
at liquibase.Liquibase.update(Liquibase.java:178)
at liquibase.Liquibase.update(Liquibase.java:174)
at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:312)
at org.traccar.database.DataManager.<init>(DataManager.java:90)
at org.traccar.Context.init(Context.java:299)
at org.traccar.Main.run(Main.java:137)
... 1 more
Caused by: liquibase.exception.DatabaseException: Table 'tc_attributes' already exists [Failed SQL: (1050) CREATE TABLE traccar.tc_attributes (id INT AUTO_INCREMENT NOT NULL, `description` VARCHAR(4000) NOT NULL, type VARCHAR(128) NOT NULL, attribute VARCHAR(128) NOT NULL, expression VARCHAR(4000) NOT NULL, CONSTRAINT PK_TC_ATTRIBUTES PRIMARY KEY (id))]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:430)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:87)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:159)
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1276)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1258)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:622)
... 10 more
Caused by: java.sql.SQLSyntaxErrorException: Table 'tc_attributes' already exists
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)
at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:426)
... 15 more
[09:13:37] INFO: Starting Traccar server...Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.2020-11-09 09:13:39 INFO: HikariPool-1 - Starting...2020-11-09 09:13:39 WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.2020-11-09 09:13:40 INFO: HikariPool-1 - Start completed.2020-11-09 09:13:42 INFO: Clearing database change log checksums2020-11-09 09:13:43 INFO: Successfully acquired change log lock2020-11-09 09:13:44 INFO: Successfully released change log lock2020-11-09 09:13:44 INFO: Successfully acquired change log lock2020-11-09 09:13:44 INFO: Can not use class liquibase.parser.core.yaml.YamlChangeLogParser as a Liquibase service because org.yaml.snakeyaml.constructor.BaseConstructor is not in the classpath2020-11-09 09:13:44 INFO: Can not use class liquibase.parser.core.json.JsonChangeLogParser as a Liquibase service because org.yaml.snakeyaml.constructor.BaseConstructor is not in the classpath2020-11-09 09:13:46 INFO: Reading from traccar.DATABASECHANGELOG2020-11-09 09:13:48 ERROR: Change Set changelog-4.0-clean::changelog-4.0-clean::author failed. Error: Table 'tc_attributes' already exists [Failed SQL: (1050) CREATE TABLE traccar.tc_attributes (id INT AUTO_INCREMENT NOT NULL, `description` VARCHAR(4000) NOT NULL, type VARCHAR(128) NOT NULL, attribute VARCHAR(128) NOT NULL, expression VARCHAR(4000) NOT NULL, CONSTRAINT PK_TC_ATTRIBUTES PRIMARY KEY (id))]2020-11-09 09:13:48 INFO: Successfully released change log lock2020-11-09 09:13:48 ERROR: Main method error - Table 'tc_attributes' already exists - SQLSyntaxErrorException (... < DataManager:312 < *:90 < Context:299 < Main:137 < ...)Exception in thread "main" java.lang.RuntimeException: liquibase.exception.MigrationFailedException: Migration failed for change set changelog-4.0-clean::changelog-4.0-clean::author: Reason: liquibase.exception.DatabaseException: Table 'tc_attributes' already exists [Failed SQL: (1050) CREATE TABLE traccar.tc_attributes (id INT AUTO_INCREMENT NOT NULL, `description` VARCHAR(4000) NOT NULL, type VARCHAR(128) NOT NULL, attribute VARCHAR(128) NOT NULL, expression VARCHAR(4000) NOT NULL, CONSTRAINT PK_TC_ATTRIBUTES PRIMARY KEY (id))] at org.traccar.Main.run(Main.java:165) at org.traccar.Main.main(Main.java:110)Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set changelog-4.0-clean::changelog-4.0-clean::author: Reason: liquibase.exception.DatabaseException: Table 'tc_attributes' already exists [Failed SQL: (1050) CREATE TABLE traccar.tc_attributes (id INT AUTO_INCREMENT NOT NULL, `description` VARCHAR(4000) NOT NULL, type VARCHAR(128) NOT NULL, attribute VARCHAR(128) NOT NULL, expression VARCHAR(4000) NOT NULL, CONSTRAINT PK_TC_ATTRIBUTES PRIMARY KEY (id))] at liquibase.changelog.ChangeSet.execute(ChangeSet.java:659) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:97) at liquibase.Liquibase.update(Liquibase.java:201) at liquibase.Liquibase.update(Liquibase.java:178) at liquibase.Liquibase.update(Liquibase.java:174) at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:312) at org.traccar.database.DataManager.<init>(DataManager.java:90) at org.traccar.Context.init(Context.java:299) at org.traccar.Main.run(Main.java:137) ... 1 moreCaused by: liquibase.exception.DatabaseException: Table 'tc_attributes' already exists [Failed SQL: (1050) CREATE TABLE traccar.tc_attributes (id INT AUTO_INCREMENT NOT NULL, `description` VARCHAR(4000) NOT NULL, type VARCHAR(128) NOT NULL, attribute VARCHAR(128) NOT NULL, expression VARCHAR(4000) NOT NULL, CONSTRAINT PK_TC_ATTRIBUTES PRIMARY KEY (id))] at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:430) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:87) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:159) at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1276) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1258) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:622) ... 10 moreCaused by: java.sql.SQLSyntaxErrorException: Table 'tc_attributes' already exists at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:426) ... 15 more
发表于 2020-11-9 09:49:07
楼主