I think it should be fine, as long as everything else is working.
Thank you Anton. Sudden errors always make me twitchy, but I will take your advice and ignore for the time being.
It might cause problems on upgrading, so that's something to keep in mind.
Looking at the logs - I transitioned to the new OS yesterday and started getting the error at that point. (but didn't notice it then - my bad)
This afternoon I upgraded traccar to 6.11.1 (from 6.10.0) and the upgrade seemed to work OK, with the database changes being applied with no other reported errors. I first noticed the error at this point.
If you want to know mariadb version numbers then I'm happy to supply.
It sounds like it should be fine if database was updated.
I have a fix. Change the jdbc connector to the mariadb connector (instead of the mysql connector) and the error goes away.
Instead of
<entry key='database.driver'>com.mysql.cj.jdbc.Driver</entry>
<entry key='database.url'>jdbc:mysql://localhost/traccar_db?zeroDateTimeBehavior=round&serverTimezone=Europe/London&allowPublicKeyRetrieval=true&useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>
Use this
<entry key='database.driver'>org.mariadb.jdbc.Driver</entry>
<entry key='database.url'>jdbc:mariadb://localhost/traccar_db?zeroDateTimeBehavior=round&serverTimezone=Europe/London&allowPublicKeyRetrieval=true&useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>
I am pretty certain that Anton is correct and the error is is nothing to worry about, but the above fix seems to be a good workaround (for those that follow later.)
Hi,
I recently upgraded my traccar server from Raspbian bookworm to trixie and after the upgrade I'm getting the following error in the traccar log files when starting the server
Traccar seems to be working OK though. Should I be worried or can I safely ignore the error?
Supplementary information :-
I'm using a MySQL (MariaDB) database as the back end with the following in my config file
<entry key='database.driver'>com.mysql.cj.jdbc.Driver</entry> <entry key='database.url'>jdbc:mysql://localhost/traccar_db?zeroDateTimeBehavior=round&serverTimezone=Europe/London&allowPublicKeyRetrieval=true&useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>DB migration method
I migrated the traccar database to the new server by dumping to flat file using mysqldump, and then importing that into the new database that I manually created on the new machine as follows
CREATE DATABASE traccar_db; CREATE USER 'traccar'@'localhost' IDENTIFIED BY 'redacted'; GRANT ALL PRIVILEGES ON traccar_db.* TO 'traccar'@'localhost'; FLUSH PRIVILEGES; QUITThanks in advance for any advice
Jon.