[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
求问大佬这个报错的问题在哪里?
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(我的世界)中文论坛)
The_jimeng 发表于 2021-2-17 15:08
使用5.几以上的mysql 就会刷这个东西
请设置ssl
database的参数我设置是,表参数?useSSL=false&serverTimezone=UTC,是不是这个serverTimezone=UTC导致的报错