[14:54:04 ERROR]: [PlayerPoints] Could not create getter statement.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 511,596 milliseconds ago.  The last packet sent successfully to the server was 511,631 milliseconds ago.
        at sun.reflect.GeneratedConstructorAccessor166.newInstance(Unknown Source) ~[?:?]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_261]
        at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_261]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[spigot.jar:git-Spigot-642f6d2-6103339]
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[spigot.jar:git-Spigot-642f6d2-6103339]
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3746) ~[spigot.jar:git-Spigot-642f6d2-6103339]
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2509) ~[spigot.jar:git-Spigot-642f6d2-6103339]
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) ~[spigot.jar:git-Spigot-642f6d2-6103339]
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484) ~[spigot.jar:git-Spigot-642f6d2-6103339]
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) ~[spigot.jar:git-Spigot-642f6d2-6103339]
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197) ~[spigot.jar:git-Spigot-642f6d2-6103339]
        at lib.PatPeter.SQLibrary.Database.query(Database.java:261) ~[?:?]
        at lib.PatPeter.SQLibrary.Database.query(Database.java:278) ~[?:?]
        at org.black_ixx.playerpoints.storage.models.MySQLStorage.getPoints(MySQLStorage.java:87) ~[?:?]
        at org.black_ixx.playerpoints.storage.StorageHandler.getPoints(StorageHandler.java:39) ~[?:?]
        at org.black_ixx.playerpoints.PlayerPointsAPI.look(PlayerPointsAPI.java:102) ~[?:?]
        at com.extendedclip.papi.expansion.playerpoints.PlayerPointsExpansion.getPoints(PlayerPointsExpansion.java:73) ~[?:?]
        at com.extendedclip.papi.expansion.playerpoints.PlayerPointsExpansion.onPlaceholderRequest(PlayerPointsExpansion.java:65) ~[?:?]
        at me.clip.placeholderapi.PlaceholderHook.onRequest(PlaceholderHook.java:38) ~[?:?]
        at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:234) ~[?:?]
        at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:374) ~[?:?]
        at dear.i.love.you.dont.crack.please!.O00000OOO00O00OOOOOO00O0O0O0.ALLATORIxDEMO(lb:215) ~[?:?]
        at java.util.concurrent.CompletableFuture$AsyncRun.run(Unknown Source) [?:1.8.0_261]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_261]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_261]
        at java.lang.Thread.run(Unknown Source) [?:1.8.0_261]
Caused by: java.net.SocketException: Connection reset by peer: socket write error
        at java.net.SocketOutputStream.socketWrite0(Native Method) ~[?:1.8.0_261]
        at java.net.SocketOutputStream.socketWrite(Unknown Source) ~[?:1.8.0_261]
        at java.net.SocketOutputStream.write(Unknown Source) ~[?:1.8.0_261]
        at java.io.BufferedOutputStream.flushBuffer(Unknown Source) ~[?:1.8.0_261]
        at java.io.BufferedOutputStream.flush(Unknown Source) ~[?:1.8.0_261]
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3728) ~[spigot.jar:git-Spigot-642f6d2-6103339]
        ... 20 more

求问大佬这个报错的问题在哪里？

检查下数据库的端口和 ip 是否填写正确，数据库有没有开启之类的。

使用5.几以上的mysql 就会刷这个东西
请设置ssl

关于服务端连接MySQL警告SSL连接问题的解决方法
https://www.mcbbs.net/thread-1021722-1-1.html
(出处: Minecraft(我的世界)中文论坛)

database的参数我设置是，表参数?useSSL=false&serverTimezone=UTC，是不是这个serverTimezone=UTC导致的报错

你这数据库都压根没连上。

?useSSL=true&serverTimezone=UTC

试一下

连上了啊，用的好好的，数据同步没有问题

我现在把UTC关闭了，如果稍后还报错就试试把SSL改为true看看吧，因为报错中的这句话The last packet successfully received from the server was 511,596 milliseconds ago.  The last packet sent successfully to the server was 511,631 milliseconds ago.感觉是时间问题？

The last packet successfully received from the server was 511,596 milliseconds ago.  The last packet sent successfully to the server was 511,631 milliseconds ago.

5511596毫秒，也就是五百多秒都没响应，这也能正常使用吗。或者只是这一个查询出了问题，所以数据库是放在哪里的。

总之绝对和 ssl 没任何关系。

有points连接数据库的前置插件吗

我也不清楚，但是用起来正常，两个端之间的数据正常同步指令扣除增加也能马上刷新

本帖最后由 もぺもぺ 于 2021-2-17 15:37 编辑

那么你可以在观察下，如果数据库没有部署在和 mc 服务端一个服务器上，那可能就是网络波动了。

可以参照 https://my.oschina.net/xsh1208/blog/493443

我现在还没迁移到本地，用的是远程库，那应该是网络或者是库设置问题吧

有前置，不过这前置之前也刷过一个报错，当时没处理，现在没刷出来偶尔很久刷一次

似乎是插件数据写入错误，但具体我也不知道是哪里问题

所以会有网络延迟的问题。最好是部署到局域网内，或者本机上。

那么影响不是很大的话，可以忽略掉的。