KeepJ96 / IP-Check

A Bukkit Plugin for Detecting and Controlling Multi-Accounters
BSD 3-Clause "New" or "Revised" License
1 stars 4 forks source link

MySQL Timeout #13

Open KeepJ96 opened 7 years ago

KeepJ96 commented 7 years ago

MySQL Timeout

IP-Check Version: 2.0.7 b2084

Java Version: N/A

Database Type: MySQL

Description of the problem: Need to add ?autoReconnect=true to connection string.

How to replicate: Launch IPC and wait several hours, then perform any command.


Checklist:

dutchy1001 commented 7 years ago

an error report when the connection is broken after serveral hours http://pastebin.com/ecX5Rxkw

KeepJ96 commented 7 years ago

Just to make it easier to know what the error is (instead of searching through that massive error log):

[10:38:29] [Server thread/WARN]: Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. [10:38:29] [Server thread/WARN]: at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3008) [10:38:29] [Server thread/WARN]: at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3466) [10:38:29] [Server thread/WARN]: ... 32 more [10:38:29] [Server thread/ERROR]: [IP-Check] An error occurred while attempting to generate a prepared statement for the database. [10:38:29] [Server thread/WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.

dutchy1001 commented 7 years ago

lol