Skocz do zawartości
  • 0

Packet Lost + Crash - MySQL


xN0MANDx
 Udostępnij

Pytanie

[18:53:47] [Server thread/INFO]: [MySQLAPI] Wystapil blad numer e4
[18:53:47] [Server thread/WARN]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
[18:53:47] [Server thread/WARN]: 
[18:53:47] [Server thread/WARN]: The last packet successfully received from the server was 2,944,431 milliseconds ago.  The last packet sent successfully to the server was 0 milliseconds ago.
[18:53:47] [Server thread/WARN]: 	at sun.reflect.GeneratedConstructorAccessor181.newInstance(Unknown Source)
[18:53:47] [Server thread/WARN]: 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[18:53:47] [Server thread/WARN]: 	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
[18:53:47] [Server thread/WARN]: 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[18:53:47] [Server thread/WARN]: 	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:989)
[18:53:47] [Server thread/WARN]: 	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3559)
[18:53:47] [Server thread/WARN]: 	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3459)
[18:53:47] [Server thread/WARN]: 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3900)
[18:53:47] [Server thread/WARN]: 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
[18:53:47] [Server thread/WARN]: 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
[18:53:47] [Server thread/WARN]: 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2483)
[18:53:47] [Server thread/WARN]: 	at com.mysql.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1552)
[18:53:47] [Server thread/WARN]: 	at com.mysql.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2607)
[18:53:47] [Server thread/WARN]: 	at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1480)
[18:53:47] [Server thread/WARN]: 	at me.xn0mandx.sql.MySQL.ExecuteCommand(MySQL.java:112)
[18:53:47] [Server thread/WARN]: 	at me.xn0mandx.sql.SQL.updateAdminTime(SQL.java:76)
[18:53:47] [Server thread/WARN]: 	at me.xn0mandx.estandard.Main.onPlayerJoinEvent(Main.java:32)
[18:53:47] [Server thread/WARN]: 	at com.destroystokyo.paper.event.executor.asm.generated.GeneratedEventExecutor197.execute(Unknown Source)
[18:53:47] [Server thread/WARN]: 	at org.bukkit.plugin.EventExecutor$2.execute(EventExecutor.java:70)
[18:53:47] [Server thread/WARN]: 	at co.aikar.timings.TimedEventExecutor.execute(TimedEventExecutor.java:78)
[18:53:47] [Server thread/WARN]: 	at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
[18:53:47] [Server thread/WARN]: 	at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:515)
[18:53:47] [Server thread/WARN]: 	at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:500)
[18:53:47] [Server thread/WARN]: 	at net.minecraft.server.v1_12_R1.PlayerList.onPlayerJoin(PlayerList.java:370)
[18:53:47] [Server thread/WARN]: 	at net.minecraft.server.v1_12_R1.PlayerList.a(PlayerList.java:183)
[18:53:47] [Server thread/WARN]: 	at protocolsupport.zplatform.impl.spigot.network.handler.SpigotLoginListenerPlay.joinGame(SpigotLoginListenerPlay.java:124)
[18:53:47] [Server thread/WARN]: 	at protocolsupport.protocol.packet.handler.AbstractLoginListenerPlay.tryJoin(AbstractLoginListenerPlay.java:131)
[18:53:47] [Server thread/WARN]: 	at protocolsupport.protocol.packet.handler.AbstractLoginListenerPlay.tick(AbstractLoginListenerPlay.java:93)
[18:53:47] [Server thread/WARN]: 	at protocolsupport.zplatform.impl.spigot.network.handler.SpigotLoginListenerPlay.e(SpigotLoginListenerPlay.java:70)
[18:53:47] [Server thread/WARN]: 	at net.minecraft.server.v1_12_R1.NetworkManager.a(NetworkManager.java:254)
[18:53:47] [Server thread/WARN]: 	at net.minecraft.server.v1_12_R1.ServerConnection.c(ServerConnection.java:150)
[18:53:47] [Server thread/WARN]: 	at net.minecraft.server.v1_12_R1.MinecraftServer.D(MinecraftServer.java:940)
[18:53:47] [Server thread/WARN]: 	at net.minecraft.server.v1_12_R1.DedicatedServer.D(DedicatedServer.java:426)
[18:53:47] [Server thread/WARN]: 	at net.minecraft.server.v1_12_R1.MinecraftServer.C(MinecraftServer.java:767)
[18:53:47] [Server thread/WARN]: 	at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:665)
[18:53:47] [Server thread/WARN]: 	at java.lang.Thread.run(Thread.java:748)
[18:53:47] [Server thread/WARN]: Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
[18:53:47] [Server thread/WARN]: 	at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3011)
[18:53:47] [Server thread/WARN]: 	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3469)
[18:53:47] [Server thread/WARN]: 	... 30 more

Podczas wysyłania polecenia do baz danych jest takie 20%, że pakiet nie dochodzi i crashuje mi serwer mc. Odbieranie rezultatów działa nie zawodnie z tego co widzę, ale to już tak średnio oraz na dodatek ten crash serwera.

	  public void ExecuteCommand(String command)
	  {
	    try
	    {
	      if (this.connection.isClosed()) {
	        Connect();
	      }
	      Statement st = this.connection.createStatement();
	      st.executeUpdate(command);
	    }
	    catch (SQLException e4)
	    {
		  System.out.println("[MySQLAPI] Wystapil blad numer e4");
	      e4.printStackTrace();
	    }
	  }

Jakieś pomysły lub sugestie dlaczego mi crashuje serwer i nie odbiera mi czasami pakietu ?

Odnośnik do komentarza
Udostępnij na innych stronach

1 odpowiedź na to pytanie

Rekomendowane odpowiedzi

Nieaktywny
Ten temat został zamknięty. Brak możliwości dodania odpowiedzi.
 Udostępnij

  • Ostatnio przeglądający   0 użytkowników

    • Brak zarejestrowanych użytkowników przeglądających tę stronę.
×
×
  • Dodaj nową pozycję...