点券插件papi使用时报错 - 联机问答

Cheris

[20:01:00 ERROR]: [PlayerPoints] Could not create getter statement. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 1,273,628 milliseconds ago. The last packet sent successfully to the server was 1,273,629 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.GeneratedConstructorAccessor408.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) ~[patched_1.15.2.jar:git-Paper-384] at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[patched_1.15.2.jar:git-Paper-384] at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3706) ~[patched_1.15.2.jar:git-Paper-384] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2506) ~[patched_1.15.2.jar:git-Paper-384] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675) ~[patched_1.15.2.jar:git-Paper-384] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465) ~[patched_1.15.2.jar:git-Paper-384] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1912) ~[patched_1.15.2.jar:git-Paper-384] at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1251) ~[patched_1.15.2.jar:git-Paper-384] 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:69) ~[?:?] at com.extendedclip.papi.expansion.playerpoints.PlayerPointsExpansion.onRequest(PlayerPointsExpansion.java:61) ~[?:?] at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:326) ~[?:?] at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:525) ~[?:?] at me.arasple.mc.trmenu.utils.Vars.setPlaceholders(Vars.java:32) ~[?:?] at me.arasple.mc.trmenu.utils.Vars.replace(Vars.java:22) ~[?:?] at me.arasple.mc.trmenu.utils.Vars.lambda$replace$0(Vars.java:27) ~[?:?] at java.util.ArrayList.forEach(Unknown Source) ~[?:1.8.0_261] at me.arasple.mc.trmenu.utils.Vars.replace(Vars.java:27) ~[?:?] at me.arasple.mc.trmenu.display.Item.createItemStack(Item.java:84) ~[?:?] at me.arasple.mc.trmenu.menu.Menu.setButton(Menu.java:267) ~[?:?] at me.arasple.mc.trmenu.menu.Menu.newUpdateTask(Menu.java:247) ~[?:?] at me.arasple.mc.trmenu.menu.Menu.lambda$open$0(Menu.java:139) ~[?:?] at java.util.HashMap.forEach(Unknown Source) ~[?:1.8.0_261] at me.arasple.mc.trmenu.menu.Menu.open(Menu.java:136) ~[?:?] at me.arasple.mc.trmenu.menu.Menu.open(Menu.java:107) ~[?:?] at me.arasple.mc.trmenu.listeners.ListenerMenuOpenCommands.onCommand(ListenerMenuOpenCommands.java:41) ~[?:?] at com.destroystokyo.paper.event.executor.asm.generated.GeneratedEventExecutor4684.execute(Unknown Source) ~[?:?] at org.bukkit.plugin.EventExecutor.lambda$create$1(EventExecutor.java:69) ~[patched_1.15.2.jar:git-Paper-384] at co.aikar.timings.TimedEventExecutor.execute(TimedEventExecutor.java:80) ~[patched_1.15.2.jar:git-Paper-384] at pw.yumc.Yum.inject.ListenerInjector.execute(ListenerInjector.java:88) ~[?:?] at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:70) ~[patched_1.15.2.jar:git-Paper-384] at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:607) ~[patched_1.15.2.jar:git-Paper-384] at net.minecraft.server.v1_15_R1.PlayerConnection.handleCommand(PlayerConnection.java:1861) ~[patched_1.15.2.jar:git-Paper-384] at net.minecraft.server.v1_15_R1.PlayerConnection.a(PlayerConnection.java:1677) ~[patched_1.15.2.jar:git-Paper-384] at net.minecraft.server.v1_15_R1.PacketPlayInChat.a(PacketPlayInChat.java:47) ~[patched_1.15.2.jar:git-Paper-384] at net.minecraft.server.v1_15_R1.PacketPlayInChat.a(PacketPlayInChat.java:5) ~[patched_1.15.2.jar:git-Paper-384] at net.minecraft.server.v1_15_R1.PlayerConnectionUtils.lambda$ensureMainThread$1(PlayerConnectionUtils.java:23) ~[patched_1.15.2.jar:git-Paper-384] at net.minecraft.server.v1_15_R1.TickTask.run(SourceFile:18) ~[patched_1.15.2.jar:git-Paper-384] at net.minecraft.server.v1_15_R1.IAsyncTaskHandler.executeTask(IAsyncTaskHandler.java:136) ~[patched_1.15.2.jar:git-Paper-384] at net.minecraft.server.v1_15_R1.IAsyncTaskHandlerReentrant.executeTask(SourceFile:23) ~[patched_1.15.2.jar:git-Paper-384] at net.minecraft.server.v1_15_R1.IAsyncTaskHandler.executeNext(IAsyncTaskHandler.java:109) ~[patched_1.15.2.jar:git-Paper-384] at net.minecraft.server.v1_15_R1.MinecraftServer.ba(MinecraftServer.java:1106) ~[patched_1.15.2.jar:git-Paper-384] at net.minecraft.server.v1_15_R1.MinecraftServer.executeNext(MinecraftServer.java:1099) ~[patched_1.15.2.jar:git-Paper-384] at net.minecraft.server.v1_15_R1.IAsyncTaskHandler.awaitTasks(IAsyncTaskHandler.java:119) ~[patched_1.15.2.jar:git-Paper-384] at net.minecraft.server.v1_15_R1.MinecraftServer.sleepForTick(MinecraftServer.java:1060) ~[patched_1.15.2.jar:git-Paper-384] at net.minecraft.server.v1_15_R1.MinecraftServer.run(MinecraftServer.java:975) ~[patched_1.15.2.jar:git-Paper-384] at java.lang.Thread.run(Unknown Source) [?:1.8.0_261] Caused by: java.net.SocketException: Software caused connection abort: 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:3688) ~[patched_1.15.2.jar:git-Paper-384] ... 48 more [20:01:00 WARN]: Fri Aug 28 20:01:00 CST 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

trmenu菜单里面有papi下载,使用的%playerpoints-points%变量并且能正常显示
但是玩家打开菜单时就会刷一下上面的报错，似乎并没造成什么影响
求解

蟹蒙老鸽

这个是日常,点券一直都有这个bug，如果觉得在后台看着难受可以用
[管理|修正] Console Spam Fix —— (兼容1.7.2)屏蔽掉那些烦人的报错信息[1.8-1.10]
https://www.mcbbs.net/thread-598149-1-1.html
(出处: Minecraft(我的世界)中文论坛)
来屏蔽报错信息,该插件在1.12也可以使用

Mikoto。

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

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