database error

[YnsanitY16]

Plugin Version

2.8.1

Server Version

universespigot (paper fork) 1.21.8

Issue description

error on login
[18:35:54 WARN]: com.mysql.cj.jdbc.exceptions.CommunicationsException: The last packet successfully received from the server was 45,274,808 milliseconds ago. The last packet sent successfully to the server was 45,274,808 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.
[18:35:54 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:165)
[18:35:54 WARN]: at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:55)
[18:35:54 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:990)
[18:35:54 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1058)
[18:35:54 WARN]: at HMCCosmeticsRemapped-2.8.1.jar//com.hibiscusmc.hmccosmetics.database.types.SQLData.lambda$get$0(SQLData.java:27)
[18:35:54 WARN]: at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
[18:35:54 WARN]: at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.exec(CompletableFuture.java:1760)
[18:35:54 WARN]: at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
[18:35:54 WARN]: at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
[18:35:54 WARN]: at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
[18:35:54 WARN]: at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
[18:35:54 WARN]: at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)
[18:35:54 WARN]: Caused by: com.mysql.cj.exceptions.CJCommunicationsException: The last packet successfully received from the server was 45,274,808 milliseconds ago. The last packet sent successfully to the server was 45,274,808 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.
[18:35:54 WARN]: at java.base/jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance(DirectConstructorHandleAccessor.java:62)
[18:35:54 WARN]: at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:502)
[18:35:54 WARN]: at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:486)
[18:35:54 WARN]: at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:52)
[18:35:54 WARN]: at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:95)
[18:35:54 WARN]: at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:140)
[18:35:54 WARN]: at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:156)
[18:35:54 WARN]: at com.mysql.cj.protocol.a.NativeProtocol.send(NativeProtocol.java:637)
[18:35:54 WARN]: at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:691)
[18:35:54 WARN]: at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:940)
[18:35:54 WARN]: at com.mysql.cj.NativeSession.execSQL(NativeSession.java:817)
[18:35:54 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:965)
[18:35:54 WARN]: ... 9 more
[18:35:54 WARN]: Caused by: java.net.SocketException: Connection reset by peer
[18:35:54 WARN]: at java.base/sun.nio.ch.SocketDispatcher.write0(Native Method)
[18:35:54 WARN]: at java.base/sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:62)
[18:35:54 WARN]: at java.base/sun.nio.ch.NioSocketImpl.tryWrite(NioSocketImpl.java:394)
[18:35:54 WARN]: at java.base/sun.nio.ch.NioSocketImpl.implWrite(NioSocketImpl.java:410)
[18:35:54 WARN]: at java.base/sun.nio.ch.NioSocketImpl.write(NioSocketImpl.java:440)
[18:35:54 WARN]: at java.base/sun.nio.ch.NioSocketImpl$2.write(NioSocketImpl.java:819)
[18:35:54 WARN]: at java.base/java.net.Socket$SocketOutputStream.write(Socket.java:1195)
[18:35:54 WARN]: at java.base/java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:125)
[18:35:54 WARN]: at java.base/java.io.BufferedOutputStream.implFlush(BufferedOutputStream.java:252)
[18:35:54 WARN]: at java.base/java.io.BufferedOutputStream.flush(BufferedOutputStream.java:240)
[18:35:54 WARN]: at com.mysql.cj.protocol.a.SimplePacketSender.send(SimplePacketSender.java:48)
[18:35:54 WARN]: at com.mysql.cj.protocol.a.TimeTrackingPacketSender.send(TimeTrackingPacketSender.java:43)
[18:35:54 WARN]: at com.mysql.cj.protocol.a.NativeProtocol.send(NativeProtocol.java:630)
[18:35:54 WARN]: ... 13 more

Steps to reproduce

connect after server is on for 8 hours

Issue priority

Low (slightly annoying)

Other Versions

No response

[LoJoSho]

This is because of how we handle MySQL connections in that we check if a connection is alive on the server side, but in the case of this error, it's the server basically saying "This connection is not actually alive like you thought it was".

There are ways to fix this in HMCC that I'll implement next chance I get around to working on the plugin.

[YnsanitY16]

@LoJoSho yeah thanks, it's not something problematic. i was using the testserver and i left it open with 0 connection for more than 8 hours. usually a server has not 0 player for so long so it was just a report to make the pl better than ever

[YnsanitY16]

fix it when you got time man thanks again