Version 4.15 error replace old database

I have server unreachable after database restore with mysql -u root -p traccar <traccar.sql Are there any unknown changes in version 4.15? By restoring the primary installation database, everything works fine.

Have you checked logs? What was the error?

HikariPool-1 - Starting...
2022-01-25 22:06:17  WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2022-01-25 22:06:18  INFO: HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@403f0a22
2022-01-25 22:06:18  INFO: HikariPool-1 - Start completed.
2022-01-25 22:06:18  INFO: Clearing database change log checksums
2022-01-25 22:06:19  INFO: Successfully acquired change log lock
2022-01-25 22:06:19  INFO: Successfully released change log lock
2022-01-25 22:06:19  INFO: Successfully acquired change log lock
2022-01-25 22:06:19  INFO: Cannot load service: liquibase.parser.ChangeLogParser: liquibase.parser.core.json.JsonChangeLogParser Unable to get public no-arg constructor
2022-01-25 22:06:20  INFO: Cannot load service: liquibase.parser.ChangeLogParser: liquibase.parser.core.yaml.YamlChangeLogParser Unable to get public no-arg constructor
2022-01-25 22:06:22  INFO: Reading from traccar.DATABASECHANGELOG
2022-01-25 22:06:23  INFO: Reading from traccar.DATABASECHANGELOG
2022-01-25 22:06:24  INFO: Cannot load service: liquibase.hub.HubService: Provider liquibase.hub.core.StandardHubService could not be instantiated
2022-01-25 22:06:24  INFO: Successfully released change log lock
2022-01-25 22:06:24 ERROR: Main method error - Table 'tc_orders' already exists - SQLSyntaxErrorException (... < DataManager:298 < *:91 < Context:298 < Main:120 < ...)
2022-01-25 22:06:35  INFO: HikariPool-1 - Starting...
2022-01-25 22:06:36  WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2022-01-25 22:06:37  INFO: HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@403f0a22
2022-01-25 22:06:37  INFO: HikariPool-1 - Start completed.
2022-01-25 22:06:37  INFO: Clearing database change log checksums
2022-01-25 22:06:38  INFO: Successfully acquired change log lock
2022-01-25 22:06:38  INFO: Successfully released change log lock
2022-01-25 22:06:38  INFO: Successfully acquired change log lock
2022-01-25 22:06:38  INFO: Cannot load service: liquibase.parser.ChangeLogParser: liquibase.parser.core.json.JsonChangeLogParser Unable to get public no-arg constructor
2022-01-25 22:06:38  INFO: Cannot load service: liquibase.parser.ChangeLogParser: liquibase.parser.core.yaml.YamlChangeLogParser Unable to get public no-arg constructor
2022-01-25 22:06:41  INFO: Reading from traccar.DATABASECHANGELOG
2022-01-25 22:06:42  INFO: Reading from traccar.DATABASECHANGELOG
2022-01-25 22:06:42  INFO: Cannot load service: liquibase.hub.HubService: Provider liquibase.hub.core.StandardHubService could not be instantiated
2022-01-25 22:06:42  INFO: Successfully released change log lock
2022-01-25 22:06:42 ERROR: Main method error - Table 'tc_orders' already exists - SQLSyntaxErrorException (... < DataManager:298 < *:91 < Context:298 < Main:120 < ...)
2022-01-25 22:06:54  INFO: HikariPool-1 - Starting...
2022-01-25 22:06:54  WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2022-01-25 22:06:55  INFO: HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@403f0a22
2022-01-25 22:06:56  INFO: HikariPool-1 - Start completed.
2022-01-25 22:06:56  INFO: Clearing database change log checksums
2022-01-25 22:06:57  INFO: Successfully acquired change log lock
2022-01-25 22:06:57  INFO: Successfully released change log lock
2022-01-25 22:06:57  INFO: Successfully acquired change log lock
2022-01-25 22:06:57  INFO: Cannot load service: liquibase.parser.ChangeLogParser: liquibase.parser.core.json.JsonChangeLogParser Unable to get public no-arg constructor
2022-01-25 22:06:57  INFO: Cannot load service: liquibase.parser.ChangeLogParser: liquibase.parser.core.yaml.YamlChangeLogParser Unable to get public no-arg constructor
2022-01-25 22:07:00  INFO: Reading from traccar.DATABASECHANGELOG
2022-01-25 22:07:01  INFO: Reading from traccar.DATABASECHANGELOG
2022-01-25 22:07:01  INFO: Cannot load service: liquibase.hub.HubService: Provider liquibase.hub.core.StandardHubService could not be instantiated
2022-01-25 22:07:01  INFO: Successfully released change log lock
2022-01-25 22:07:01 ERROR: Main method error - Table 'tc_orders' already exists - SQLSyntaxErrorException (... < DataManager:298 < *:91 < Context:298 < Main:120 < ...)
2022-01-25 22:07:13  INFO: HikariPool-1 - Starting...
2022-01-25 22:07:13  WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2022-01-25 22:07:14  INFO: HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@403f0a22
2022-01-25 22:07:14  INFO: HikariPool-1 - Start completed.
2022-01-25 22:07:14  INFO: Clearing database change log checksums
2022-01-25 22:07:15  INFO: Successfully acquired change log lock
2022-01-25 22:07:15  INFO: Successfully released change log lock
2022-01-25 22:07:15  INFO: Successfully acquired change log lock
2022-01-25 22:07:15  INFO: Cannot load service: liquibase.parser.ChangeLogParser: liquibase.parser.core.json.JsonChangeLogParser Unable to get public no-arg constructor
2022-01-25 22:07:16  INFO: Cannot load service: liquibase.parser.ChangeLogParser: liquibase.parser.core.yaml.YamlChangeLogParser Unable to get public no-arg constructor
2022-01-25 22:07:19  INFO: Reading from traccar.DATABASECHANGELOG
2022-01-25 22:07:19  INFO: Reading from traccar.DATABASECHANGELOG
2022-01-25 22:07:19  INFO: Cannot load service: liquibase.hub.HubService: Provider liquibase.hub.core.StandardHubService could not be instantiated
2022-01-25 22:07:19  INFO: Successfully released change log lock
2022-01-25 22:07:21  INFO: Your platform does not provide complete low-level API for accessing direct buffers reliably. Unless explicitly requested, heap buffer will always be preferred to avoid potential system instability.

This is the problem:

Table 'tc_orders' already exists

It probably means that you are not upgrading from the official 4.14.

Exactly I installed the 4.15 from a new installation, and I wanted to restore the devices and the traccar configurations from version 4.13. There is a solution?

My point is that what you are trying to restore is not an official release.

I don't know anyway I installed from wget with this string:
wget https://github.com/traccar/traccar/releases/download/v4.15/traccar-linux-64-4.15.zip

I'm talking about your database.

Ok I understand, but in these cases how do I save devices, users and configurations and restore them to a new version without updating from the previous version?

If you upgrade between official releases you won't have this problem.

ok, thank you

you restored a db with a command quoted mysql -u root -p traccar <traccar.sql .
you need to leave a space before traccar.sql

The command is right, it was just a copy paste error, I understood the problem and only in the different tables of the database from version 4.13 to version 4.15. How do I save the database of devices and configurations only without the tables? I think the problem is the tables. Someone help me with the command or how did it solve? in essence the mysqldump command must result without saving the tables. thanks in advance

how do i fix for this error?

Main method error - Table 'tc_orders' already exists - SQLSyntaxErrorException (... < DataManager:298 < *:91 < Context:298 < Main:120 < ...)

How do open for reading table and data file old database traccar version. 4.13 for migrate on version 4.15?

Hi @Mark,

Did you fix this issue yet?