error upgrading

jesusle 5 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 Tananaev 5 years ago

Are you using MyISAM?

jesusle 5 years ago

I have mysql 8 default innodb

Anton Tananaev 5 years ago

What version of Traccar are you using?

jesusle 5 years ago

I upgrade from 3.16 to 4.11

Anton Tananaev 5 years ago

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

jesusle 5 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 Tananaev 5 years ago

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

jesusle 5 years ago

sorry server is using MyISAM

Anton Tananaev 5 years ago

That's exactly the problem then.

jesusle 5 years ago

why, can help me for understand? regards

Anton Tananaev 5 years ago
jesusle 5 years ago

solved, thanks so much!