LuckPerms

LuckPerms

41.4k Downloads

Database connection problem

xiaobao4909 opened this issue ยท 0 comments

commented

Description

The server cannot connect to the MySQL database,Unable to read data from the database

Reproduction Steps

An error occurred when the player joined the server,Or wait for a while after opening the service

Expected Behaviour

Connect to the database normally

Server Details

Paper version git-Paper-1620 (MC: 1.12.2) (Implementing API version 1.12.2-R0.1-SNAPSHOT)

LuckPerms Version

5.4.41

Logs and Configs

[14:54:20 WARN]: [me.lucko.luckperms.lib.hikari.pool.ProxyConnection] luckperms-hikari - Connection me.lucko.luckperms.lib.mysql.cj.jdbc.ConnectionImpl@52a31e82 marked as broken because of SQLSTATE(08S01), ErrorCode(0)
me.lucko.luckperms.lib.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
at me.lucko.luckperms.lib.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:637) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:418) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:370) ~[?:?]
at me.lucko.luckperms.lib.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[?:?]
at me.lucko.luckperms.lib.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[?:?]
at me.lucko.luckperms.common.messaging.sql.AbstractSqlMessenger.runHousekeeping(AbstractSqlMessenger.java:144) ~[?:?]
at java.util.concurrent.ForkJoinTask$RunnableExecuteAction.exec(ForkJoinTask.java:1395) ~[?:?]
at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:373) ~[?:?]
at java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1182) ~[?:?]
at java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1655) ~[?:?]
at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1622) ~[?:?]
at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:165) ~[?:?]
Caused by: me.lucko.luckperms.lib.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77) ~[?:?]
at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:?]
at java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) ~[?:?]
at java.lang.reflect.Constructor.newInstance(Constructor.java:480) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:546) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:710) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:649) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:136) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.NativeSession.sendCommand(NativeSession.java:311) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.ServerPreparedQuery.sendExecutePacket(ServerPreparedQuery.java:334) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.ServerPreparedQuery.serverExecute(ServerPreparedQuery.java:207) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:635) ~[?:?]
... 11 more
Caused by: java.net.SocketTimeoutException: Read timed out
at sun.nio.ch.NioSocketImpl.timedRead(NioSocketImpl.java:283) ~[?:?]
at sun.nio.ch.NioSocketImpl.implRead(NioSocketImpl.java:309) ~[?:?]
at sun.nio.ch.NioSocketImpl.read(NioSocketImpl.java:350) ~[?:?]
at sun.nio.ch.NioSocketImpl$1.read(NioSocketImpl.java:803) ~[?:?]
at java.net.Socket$SocketInputStream.read(Socket.java:966) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.protocol.ReadAheadInputStream.fill(ReadAheadInputStream.java:107) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.protocol.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:150) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.protocol.ReadAheadInputStream.read(ReadAheadInputStream.java:180) ~[?:?]
at java.io.FilterInputStream.read(FilterInputStream.java:132) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:540) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:710) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:649) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:136) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.NativeSession.sendCommand(NativeSession.java:311) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.ServerPreparedQuery.sendExecutePacket(ServerPreparedQuery.java:334) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.ServerPreparedQuery.serverExecute(ServerPreparedQuery.java:207) ~[?:?]
at me.lucko.luckperms.lib.mysql.cj.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:635) ~[?:?]
... 11 more
[14:54:20 WARN]: me.lucko.luckperms.lib.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:637)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:418)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:370)
[14:54:20 WARN]: at me.lucko.luckperms.lib.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
[14:54:20 WARN]: at me.lucko.luckperms.lib.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
[14:54:20 WARN]: at me.lucko.luckperms.common.messaging.sql.AbstractSqlMessenger.runHousekeeping(AbstractSqlMessenger.java:144)
[14:54:20 WARN]: at java.base/java.util.concurrent.ForkJoinTask$RunnableExecuteAction.exec(ForkJoinTask.java:1395)
[14:54:20 WARN]: at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:373)
[14:54:20 WARN]: at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1182)
[14:54:20 WARN]: at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1655)
[14:54:20 WARN]: at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1622)
[14:54:20 WARN]: at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:165)
[14:54:20 WARN]: Caused by: me.lucko.luckperms.lib.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
[14:54:20 WARN]: at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[14:54:20 WARN]: at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
[14:54:20 WARN]: at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[14:54:20 WARN]: at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
[14:54:20 WARN]: at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:546)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:710)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:649)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:136)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.NativeSession.sendCommand(NativeSession.java:311)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.ServerPreparedQuery.sendExecutePacket(ServerPreparedQuery.java:334)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.ServerPreparedQuery.serverExecute(ServerPreparedQuery.java:207)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:635)
[14:54:20 WARN]: ... 11 more
[14:54:20 WARN]: Caused by: java.net.SocketTimeoutException: Read timed out
[14:54:20 WARN]: at java.base/sun.nio.ch.NioSocketImpl.timedRead(NioSocketImpl.java:283)
[14:54:20 WARN]: at java.base/sun.nio.ch.NioSocketImpl.implRead(NioSocketImpl.java:309)
[14:54:20 WARN]: at java.base/sun.nio.ch.NioSocketImpl.read(NioSocketImpl.java:350)
[14:54:20 WARN]: at java.base/sun.nio.ch.NioSocketImpl$1.read(NioSocketImpl.java:803)
[14:54:20 WARN]: at java.base/java.net.Socket$SocketInputStream.read(Socket.java:966)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.protocol.ReadAheadInputStream.fill(ReadAheadInputStream.java:107)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.protocol.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:150)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.protocol.ReadAheadInputStream.read(ReadAheadInputStream.java:180)
[14:54:20 WARN]: at java.base/java.io.FilterInputStream.read(FilterInputStream.java:132)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44)
[14:54:20 WARN]: at me.lucko.luckperms.lib.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:540)
[14:54:20 WARN]: ... 18 more

Extra Details

No response