MySQL connection error after server restart

Nitin Joshi5 years ago

It's a Windows Server with MySQL CE. Was working fine until a server auto restart. Now it does not connect and also I'm not able to stop the Traccar service once started. Here's the error log

2018-12-04 22:55:27  INFO: HikariPool-1 - Starting...
2018-12-04 22:55:34 ERROR: HikariPool-1 - Exception during pool initialization. - Could not create connection to database server. Attempted reconnect 3 times. Giving up. - MySQLNonTransientConnectionException (... < DataManager:133 < *:90 < Context:382 < Main:110 < ...)
2018-12-04 22:55:34 ERROR: Main method error - Failed to initialize pool: Could not create connection to database server. Attempted reconnect 3 times. Giving up. - PoolInitializationException (... < DataManager:133 < *:90 < Context:382 < Main:110 < ...)

The traccaar.config has this:

    <entry key='database.driver'>com.mysql.jdbc.Driver</entry>
    <entry key='database.url'>jdbc:mysql://localhost:3306/trackmenow?useSSL=false&amp;allowMultiQueries=true&amp;autoReconnect=true&amp;useUnicode=yes&amp;characterEncoding=UTF-8&amp;sessionVariables=sql_mode=''
</entry>
    <entry key='database.user'>root</entry>
    <entry key='database.password'>Tmn@2546</entry>
Anton Tananaev5 years ago

Seems like a problem with MySQL.

Medveczki Zoltán5 years ago

The mistake follows from MYSQL later departure. Try it TRACAR timed a server with a launch to fill. MYSQL will work perfectly already with approximately 5 seconds of timing after his departure.