SimpleClans

SimpleClans

467k Downloads

MySQL error

Rocologo opened this issue ยท 2 comments

commented

I get this bug in the console

ERROR Query: UPDATE sc_players SET name = 'jehako' WHERE uuid = '850c7057-05b9-4562-9f67-834ad7e6260c'; 20.01 12:03:10 [Server] ERROR Error at SQL UPDATE Query: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 59,028,486 milliseconds ago. The last packet sent successfully to the server was 59,028,486 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

Im a dev my self and I know what this means. You need to close ALL connections to the database, if you dont do this the MySQL server will drop the connection after some time. And then you get this error.

So after doing the query / update, close the connection.

commented

What version are you using?

commented

Sorry, you need of cause that
V 2.7.10
build 68
Downloaded from your jenkins server