Hi, I need help!
The traccar server worked for a year on version 4.15, the 100G database was moved to new hardware and traccar 5.7 was installed. On the new version, traccar gives an error and does not start... tell me what to do, upgrade by upgrading versions?
log:
2023-05-02 14:03:53 INFO: Update summary generated
2023-05-02 14:03:53 INFO: Successfully released change log lock
2023-05-02 14:03:53 INFO: Successfully released change log lock
2023-05-02 14:03:53 INFO: Command execution complete
2023-05-02 14:03:53 ERROR: Main method error - Unknown column 'status' in 'field list' - SQLSyntaxErrorException (... < QueryBuilder:469 < DatabaseStorage:115 < DeviceUtil:39 < ...)
2023-05-02 14:04:04 INFO: Operating system name: Linux version: 5.15.0-60-generic architecture: amd64
2023-05-02 14:04:04 INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Eclipse Adoptium version: 17.0.6+10
2023-05-02 14:04:04 INFO: Memory limit heap: 25152mb non-heap: 0mb
2023-05-02 14:04:04 INFO: Character encoding: UTF-8 charset: UTF-8
2023-05-02 14:04:04 INFO: Version: 5.7
2023-05-02 14:04:04 INFO: Starting server...
2023-05-02 14:04:05 INFO: HikariPool-1 - Starting...
2023-05-02 14:04:05 INFO: HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@503fbbc6
2023-05-02 14:04:05 INFO: HikariPool-1 - Start completed.
2023-05-02 14:04:05 INFO: Clearing database change log checksums
2023-05-02 14:04:05 INFO: Successfully acquired change log lock
2023-05-02 14:04:05 INFO: Successfully released change log lock
2023-05-02 14:04:06 INFO: Successfully acquired change log lock
2023-05-02 14:04:07 INFO: Reading from traccar.DATABASECHANGELOG
2023-05-02 14:04:07 INFO: Reading from traccar.DATABASECHANGELOG
2023-05-02 14:04:07 INFO: Reading from traccar.DATABASECHANGELOG
2023-05-02 14:04:07 INFO: UPDATE SUMMARY
2023-05-02 14:04:07 INFO: Run: 0
2023-05-02 14:04:07 INFO: Previously run: 42
2023-05-02 14:04:07 INFO: Filtered out: 0
2023-05-02 14:04:07 INFO: -------------------------------
2023-05-02 14:04:07 INFO: Total change sets: 42
It looks like the database schema is broken. Are you sure you didn't have any migration issues on the first run?
when deploying 4.15 on a new server, everything works, however, as soon as I install 5.7 it gives this... the database is not modified, the server is also
ERROR: Main method error - Unknown column 'status' in 'field list' - SQLSyntaxErrorException (... < QueryBuilder:469 < DatabaseStorage:115 < DeviceUtil:39 < ...)
may the structure of the database differ?
OK, please upload the full log somewhere with old and new version in one file.
Ok, I did everything all over again, here are the logs in zip, I deployed both assemblies on the same server, on the same database.
I apologize for the flood in the 5.7 log on the database driver below, you can see that I corrected it, but the situation has not changed, the server has not started..
https://disk.yandex.ru/d/uL9tgAySKh-4PA
It looks like you haven't restored the database to the original one.
I didn't quite understand, I made a full backup using mysqldump on the old server, deployed this database on the new one and uploaded a backup to it. What did I do wrong?
After all, the server starts working when I install the old version, even builds reports on 4.15, so the database is not damaged, or am I wrong?
Based on the logs I can see that your database is already broken. Sounds like what you have as a backup is already NOT the 4.15 database.
I understand, thank you - then it's easier to retransmit to a new server before the old one leaves us altogether...
Hi, I need help!
The traccar server worked for a year on version 4.15, the 100G database was moved to new hardware and traccar 5.7 was installed. On the new version, traccar gives an error and does not start... tell me what to do, upgrade by upgrading versions?
log: