error upgrading

jesusle4 years ago

Hi can help me please, have next error

2021-03-04 15:14:23  INFO: Successfully released change log lock
2021-03-04 15:14:23 ERROR: Main method error - Error during testing for MySQL/MariaDB JDBC driver bug: could not retrieve JDBC metadata information for temporary table 'TMP_ATQNDEWDUGYKVQXA' - UnexpectedLiquibaseException (... < DataManager:293 < *:86 < Context:289 < Main:120 < ...)
2021-03-04 15:14:49  INFO: HikariPool-1 - Starting...
2021-03-04 15:14:53  WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2021-03-04 15:14:59  INFO: HikariPool-1 - Start completed.
2021-03-04 15:15:09  INFO: Clearing database change log checksums
2021-03-04 15:15:10  INFO: Successfully acquired change log lock
2021-03-04 15:15:10  INFO: Successfully released change log lock
2021-03-04 15:15:10  INFO: Successfully acquired change log lock
2021-03-04 15:15:10  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
2021-03-04 15:15:10  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
2021-03-04 15:15:12  INFO: Reading from topsatgp_topsat.DATABASECHANGELOG
2021-03-04 15:15:13  INFO: Reading from topsatgp_topsat.DATABASECHANGELOG
2021-03-04 15:15:14 ERROR: Change Set changelog-4.7::changelog-4.7::author failed.  Error: Migration failed for change set changelog-4.7::changelog-4.7::author:
     Reason: 

./schema/changelog-master.xml : Index Exists Precondition: user_device_user_id : Error during testing for MySQL/MariaDB JDBC driver bug: could not retrieve JDBC metadata information for temporary table 'TMP_TTNIEAQQCNNUUQTJ'
Anton Tananaev4 years ago

Are you using MyISAM?

jesusle4 years ago

I have mysql 8 default innodb

Anton Tananaev4 years ago

What version of Traccar are you using?

jesusle4 years ago

I upgrade from 3.16 to 4.11

Anton Tananaev4 years ago

OK. Then I'm not sure what the issue is. It looks like liquibase is returning the error.

jesusle4 years ago

befor error

2021-03-04 13:05:33  INFO: Marking ChangeSet: changelog-4.1::changelog-4.1-mssql::author ran despite precondition failure due to onFail='MARK_RAN': 
          ./schema/changelog-master.xml : DBMS Precondition failed: expected mssql, got mysql
Anton Tananaev4 years ago

That's not an error. That's expected.

jesusle4 years ago

sorry server is using MyISAM

Anton Tananaev4 years ago

That's exactly the problem then.

jesusle4 years ago

why, can help me for understand? regards

Anton Tananaev4 years ago
jesusle4 years ago

solved, thanks so much!