I'm getting the error below in my log files. I haven't been able to quite figure this out, but it happens with all the plugins that use a connection pool. On one of my plugins, it has a setting in the config for maxLifetime value which I've adjusted to reduce and/or eliminate this problem. But I don't see that type of configuration for Statz. Any suggestions or help would be appreciated.
[19:35:03] [Craft Scheduler Thread - 64/ERROR]: [Statz] Couldn't execute MySQL statement:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 814,963 milliseconds ago. The last packet sent successfully to the server was 814,963 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.
at sun.reflect.GeneratedConstructorAccessor64.newInstance(Unknown Source) ~[?:?]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_242]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_242]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[patched_1.15.2.jar:git-Paper-98]
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[patched_1.15.2.jar:git-Paper-98]
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3706) ~[patched_1.15.2.jar:git-Paper-98]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2506) ~[patched_1.15.2.jar:git-Paper-98]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675) ~[patched_1.15.2.jar:git-Paper-98]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465) ~[patched_1.15.2.jar:git-Paper-98]
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1912) ~[patched_1.15.2.jar:git-Paper-98]
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2020) ~[patched_1.15.2.jar:git-Paper-98]
at me.staartvin.statz.database.MySQLConnector.getObjects(MySQLConnector.java:159) ~[?:?]
at me.staartvin.statz.datamanager.DataManager.getFreshPlayerInfo(DataManager.java:129) ~[?:?]
at me.staartvin.statz.tasks.UpdatePlayerCacheTask.run(UpdatePlayerCacheTask.java:36) ~[?:?]
at org.bukkit.craftbukkit.v1_15_R1.scheduler.CraftTask.run(CraftTask.java:84) ~[patched_1.15.2.jar:git-Paper-98]
at org.bukkit.craftbukkit.v1_15_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:54) ~[patched_1.15.2.jar:git-Paper-98]
at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22) ~[patched_1.15.2.jar:git-Paper-98]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_242]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_242]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_242]
Caused by: java.net.SocketException: Connection reset
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:115) ~[?:1.8.0_242]
at java.net.SocketOutputStream.write(SocketOutputStream.java:155) ~[?:1.8.0_242]
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) ~[?:1.8.0_242]
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140) ~[?:1.8.0_242]
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3688) ~[patched_1.15.2.jar:git-Paper-98]
... 14 more
I'm getting the error below in my log files. I haven't been able to quite figure this out, but it happens with all the plugins that use a connection pool. On one of my plugins, it has a setting in the config for maxLifetime value which I've adjusted to reduce and/or eliminate this problem. But I don't see that type of configuration for Statz. Any suggestions or help would be appreciated.
[19:35:03] [Craft Scheduler Thread - 64/ERROR]: [Statz] Couldn't execute MySQL statement: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 814,963 milliseconds ago. The last packet sent successfully to the server was 814,963 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. at sun.reflect.GeneratedConstructorAccessor64.newInstance(Unknown Source) ~[?:?] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_242] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_242] at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[patched_1.15.2.jar:git-Paper-98] at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[patched_1.15.2.jar:git-Paper-98] at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3706) ~[patched_1.15.2.jar:git-Paper-98] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2506) ~[patched_1.15.2.jar:git-Paper-98] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675) ~[patched_1.15.2.jar:git-Paper-98] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465) ~[patched_1.15.2.jar:git-Paper-98] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1912) ~[patched_1.15.2.jar:git-Paper-98] at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2020) ~[patched_1.15.2.jar:git-Paper-98] at me.staartvin.statz.database.MySQLConnector.getObjects(MySQLConnector.java:159) ~[?:?] at me.staartvin.statz.datamanager.DataManager.getFreshPlayerInfo(DataManager.java:129) ~[?:?] at me.staartvin.statz.tasks.UpdatePlayerCacheTask.run(UpdatePlayerCacheTask.java:36) ~[?:?] at org.bukkit.craftbukkit.v1_15_R1.scheduler.CraftTask.run(CraftTask.java:84) ~[patched_1.15.2.jar:git-Paper-98] at org.bukkit.craftbukkit.v1_15_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:54) ~[patched_1.15.2.jar:git-Paper-98] at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22) ~[patched_1.15.2.jar:git-Paper-98] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_242] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_242] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_242] Caused by: java.net.SocketException: Connection reset at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:115) ~[?:1.8.0_242] at java.net.SocketOutputStream.write(SocketOutputStream.java:155) ~[?:1.8.0_242] at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) ~[?:1.8.0_242] at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140) ~[?:1.8.0_242] at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3688) ~[patched_1.15.2.jar:git-Paper-98] ... 14 more