search

Zrips / Jobs

Jobs
Apache License 2.0
187 stars 215 forks source link

Server freezing due to MYSQL on MultiServer #1517

Open LuluxClient opened 2 years ago

LuluxClient commented 2 years ago

Detailed description of the issue: Sometimes the server freezes and we will always see this error: https://pastebin.com/BUhMVtNk

ERROR (DELETE IF YOU HAVE NO ERROR): <-- Try to use pastebin.com server if you have long error. -->

[####################
## PASTE ERROR HERE ##
####################](https://pastebin.com/BUhMVtNk)

CONFIG SECTION (DELETE IF NOT RELEVANT):

#####################################
## PASTE RELEVANT CONFIG SECTION HERE ##
#####################################

Jobs version: 5.1.0.1 Server Type (Spigot/Paper/etc): Puffer+ Server Version (using /ver): This server is running Pufferfish+ version git-PufferfishPlus-29 (MC: 1.19.2) (Implementing API version 1.19.2-R0.1-SNAPSHOT) (Git: cb76ba2 on HEAD) You are on the latest version! Previous version: git-Paper-201 (MC: 1.19.2)

Floxiik commented 2 years ago

Same for me https://pastebin.com/y35awyHK

Dweezy750 commented 1 year ago

17.10 22:02:09 [Server] ERROR --- DO NOT REPORT THIS TO PURPUR - THIS IS NOT A BUG OR A CRASH - git-Purpur-2058 (MC: 1.20.1) --- 17.10 22:02:09 [Server] ERROR The server has not responded for 35 seconds! Creating thread dump 17.10 22:02:09 [Server] ERROR ------------------------------ 17.10 22:02:09 [Server] ERROR Server thread dump (Look for plugins here before reporting to Purpur!): 17.10 22:02:09 [Server] ERROR ------------------------------ 17.10 22:02:09 [Server] ERROR Current Thread: Server thread 17.10 22:02:09 [Server] ERROR PID: 60 | Suspended: false | Native: true | State: RUNNABLE 17.10 22:02:09 [Server] ERROR Stack: 17.10 22:02:09 [Server] ERROR java.base@21/sun.nio.ch.Net.poll(Native Method) 17.10 22:02:09 [Server] ERROR java.base@21/sun.nio.ch.NioSocketImpl.park(NioSocketImpl.java:191) 17.10 22:02:09 [Server] ERROR java.base@21/sun.nio.ch.NioSocketImpl.park(NioSocketImpl.java:201) 17.10 22:02:09 [Server] ERROR java.base@21/sun.nio.ch.NioSocketImpl.implRead(NioSocketImpl.java:309) 17.10 22:02:09 [Server] ERROR java.base@21/sun.nio.ch.NioSocketImpl.read(NioSocketImpl.java:346) 17.10 22:02:09 [Server] ERROR java.base@21/sun.nio.ch.NioSocketImpl$1.read(NioSocketImpl.java:796) 17.10 22:02:09 [Server] ERROR java.base@21/java.net.Socket$SocketInputStream.read(Socket.java:1099) 17.10 22:02:09 [Server] ERROR com.mysql.cj.protocol.ReadAheadInputStream.fill(ReadAheadInputStream.java:107) 17.10 22:02:09 [Server] ERROR com.mysql.cj.protocol.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:150) 17.10 22:02:09 [Server] ERROR com.mysql.cj.protocol.ReadAheadInputStream.read(ReadAheadInputStream.java:180) 17.10 22:02:09 [Server] ERROR java.base@21/java.io.FilterInputStream.read(FilterInputStream.java:119) 17.10 22:02:09 [Server] ERROR com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64) 17.10 22:02:09 [Server] ERROR com.mysql.cj.protocol.a.SimplePacketReader.readHeaderLocal(SimplePacketReader.java:81) 17.10 22:02:09 [Server] ERROR com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) 17.10 22:02:09 [Server] ERROR com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) 17.10 22:02:09 [Server] ERROR com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) 17.10 22:02:09 [Server] ERROR com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) 17.10 22:02:09 [Server] ERROR com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) 17.10 22:02:09 [Server] ERROR com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) 17.10 22:02:09 [Server] ERROR com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:576) 17.10 22:02:09 [Server] ERROR com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:762) 17.10 22:02:09 [Server] ERROR com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:701) 17.10 22:02:09 [Server] ERROR com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:1052) 17.10 22:02:09 [Server] ERROR com.mysql.cj.NativeSession.execSQL(NativeSession.java:657) 17.10 22:02:09 [Server] ERROR com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:893) 17.10 22:02:09 [Server] ERROR com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354) 17.10 22:02:09 [Server] ERROR Jobs5.2.1.2.jar//com.gamingmesh.jobs.dao.JobsDAO.savePoints(JobsDAO.java:2167) 17.10 22:02:09 [Server] ERROR Jobs5.2.1.2.jar//com.gamingmesh.jobs.container.JobsPlayer.save(JobsPlayer.java:917) 17.10 22:02:09 [Server] ERROR Jobs5.2.1.2.jar//com.gamingmesh.jobs.container.JobsPlayer.save(JobsPlayer.java:900) 17.10 22:02:09 [Server] ERROR Jobs5.2.1.2.jar//com.gamingmesh.jobs.PlayerManager.playerQuit(PlayerManager.java:276) 17.10 22:02:09 [Server] ERROR Jobs5.2.1.2.jar//com.gamingmesh.jobs.listeners.JobsListener.onPlayerQuit(JobsListener.java:192) 17.10 22:02:09 [Server] ERROR com.destroystokyo.paper.event.executor.asm.generated.GeneratedEventExecutor940.execute(Unknown Source) 17.10 22:02:09 [Server] ERROR org.bukkit.plugin.EventExecutor$2.execute(EventExecutor.java:77) 17.10 22:02:09 [Server] ERROR co.aikar.timings.TimedEventExecutor.execute(TimedEventExecutor.java:77) 17.10 22:02:09 [Server] ERROR org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:70) 17.10 22:02:09 [Server] ERROR io.papermc.paper.plugin.manager.PaperEventManager.callEvent(PaperEventManager.java:54) 17.10 22:02:09 [Server] ERROR io.papermc.paper.plugin.manager.PaperPluginManagerImpl.callEvent(PaperPluginManagerImpl.java:126) 17.10 22:02:09 [Server] ERROR org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:617) 17.10 22:02:09 [Server] ERROR net.minecraft.server.players.PlayerList.remove(PlayerList.java:609) 17.10 22:02:09 [Server] ERROR net.minecraft.server.players.PlayerList.remove(PlayerList.java:593)