MariageMaster - MySQL

[xflemgodax]

93.91.250.110:27370

Zdravím.

Tohle mi občas vyskočí v logu, tedy vždy když přijdu po restartu na server, ale poté to nic nedělá, nějaká chyba MySQL?
Pokud dobře vím, tak to dělá MariageMaster, ale chtěl bych vědět příčinu, pokud to není kvůli UUID?
A ještě řešení, jak se té chyby samozřejmě zabavit, pokud to není odstřihnutí od MySQL...

Spoiler: zobrazit

Kód: Vybrat vše

> [13:57:10 INFO]: Loaded player file for IIxGriimZz
> [13:57:10 WARN]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 30,576,397 milliseconds ago. The last packet sent successfully to the server was 30,576,397 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.
> [13:57:10 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> [13:57:10 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> [13:57:10 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> [13:57:10 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> [13:57:10 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
> [13:57:10 WARN]: at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
> [13:57:10 WARN]: at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3348)
> [13:57:10 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1967)
> [13:57:10 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
> [13:57:10 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
> [13:57:10 WARN]: at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
> [13:57:10 WARN]: at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273)
> [13:57:10 WARN]: at at.pcgamingfreaks.georgh.MarriageMaster.Databases.MySQL.GetPlayerID(MySQL.java:139)
> [13:57:10 WARN]: at at.pcgamingfreaks.georgh.MarriageMaster.Databases.MySQL.GetPartner(MySQL.java:302)
> [13:57:10 WARN]: at at.pcgamingfreaks.georgh.MarriageMaster.Listener.JoinLeave.PlayerLoginEvent(JoinLeave.java:47)
> [13:57:10 WARN]: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [13:57:10 WARN]: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> [13:57:10 WARN]: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> [13:57:10 WARN]: at java.lang.reflect.Method.invoke(Method.java:606)
> [13:57:10 WARN]: at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:292)
> [13:57:10 WARN]: at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
> [13:57:10 WARN]: at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredListener.java:30)
> [13:57:10 WARN]: at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:502)
> [13:57:10 WARN]: at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:487)
> [13:57:10 WARN]: at net.minecraft.server.v1_7_R3.PlayerList.c(PlayerList.java:265)
> [13:57:10 WARN]: at net.minecraft.server.v1_7_R3.PlayerList.a(PlayerList.java:152)
> [13:57:10 WARN]: at net.minecraft.server.v1_7_R3.LoginListener.c(LoginListener.java:105)
> [13:57:10 WARN]: at net.minecraft.server.v1_7_R3.LoginListener.a(LoginListener.java:43)
> [13:57:10 WARN]: at net.minecraft.server.v1_7_R3.NetworkManager.a(NetworkManager.java:183)
> [13:57:10 WARN]: at net.minecraft.server.v1_7_R3.ServerConnection.c(ServerConnection.java:81)
> [13:57:10 WARN]: at net.minecraft.server.v1_7_R3.MinecraftServer.v(MinecraftServer.java:713)
> [13:57:10 WARN]: at net.minecraft.server.v1_7_R3.DedicatedServer.v(DedicatedServer.java:283)
> [13:57:10 WARN]: at net.minecraft.server.v1_7_R3.MinecraftServer.u(MinecraftServer.java:576)
> [13:57:10 WARN]: at net.minecraft.server.v1_7_R3.MinecraftServer.run(MinecraftServer.java:482)
> [13:57:10 WARN]: at net.minecraft.server.v1_7_R3.ThreadServerApplication.run(SourceFile:628)
> [13:57:10 WARN]: Caused by: java.net.SocketException: Broken pipe
> [13:57:10 WARN]: at java.net.SocketOutputStream.socketWrite0(Native Method)
> [13:57:10 WARN]: at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
> [13:57:10 WARN]: at java.net.SocketOutputStream.write(SocketOutputStream.java:159)
> [13:57:10 WARN]: at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
> [13:57:10 WARN]: at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
> [13:57:10 WARN]: at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3329)
> [13:57:10 WARN]: ... 28 more

[vojtamaniak]

To bude podle mě problém toho pluginu, protože neuzavřel někde připojení do MySQL. Nehází to ještě nějakou chybu?

[xflemgodax]

Právě že ne, proto jsem to dost ignoroval, ale teď se snažím na testovacím serveru, abych měl log krásně čistý.
Koukám po každé chybě, ale tahle je tam jen někdy. Vždy když se přihlásím po restartu serveru. Při přihlášení bez restartu nic neobvyklého.

Dodatek hned po chybě:

Spoiler: zobrazit

Kód: Vybrat vše

> [13:57:10 INFO]: [WorldGuard] 2 regions loaded for 'Eventy'
> [13:57:10 INFO]: IIxGriimZz[/*****] logged in with entity id 260 at ([Eventy] 1355.8701913793195, 60.0, -555.3528985922883)
> [13:57:10 INFO]: Hráč IIxGriimZz se přihlásil
> [13:57:15 INFO]: [AuthMe] IIxGriimZz logged in!
> [13:58:14 INFO]: IIxGriimZz issued server command: /*****
> [13:58:16 INFO]: IIxGriimZz issued server command: /*****
> [14:00:34 INFO]: learLag] Warning Ground items will be removed in 60 seconds!
> [14:01:14 INFO]: learLag] Warning Ground items will be removed in 20 seconds!
> [14:01:34 INFO]: learLag] Removed 28 Entities!
> [14:03:05 INFO]: IIxGriimZz issued server command: /sun
> [14:08:14 INFO]: learLag] Warning Ground items will be removed in 60 seconds!
> [14:08:54 INFO]: learLag] Warning Ground items will be removed in 20 seconds!
> [14:09:14 INFO]: learLag] Removed 28 Entities!
> [14:15:54 INFO]: learLag] Warning Ground items will be removed in 60 seconds!
> [14:16:34 INFO]: learLag] Warning Ground items will be removed in 20 seconds!
> [14:16:54 INFO]: learLag] Removed 28 Entities!
> [14:23:34 INFO]: learLag] Warning Ground items will be removed in 60 seconds!
> [14:24:14 INFO]: learLag] Warning Ground items will be removed in 20 seconds!
> [14:24:35 INFO]: learLag] Removed 28 Entities!
> [14:27:55 INFO]: Hlasoval jsi dneska pro server? /vote
> [14:31:15 INFO]: learLag] Warning Ground items will be removed in 60 seconds!
> [14:31:55 INFO]: learLag] Warning Ground items will be removed in 20 seconds!
> [14:32:15 INFO]: learLag] Removed 28 Entities!
>save-all
> [14:34:55 INFO]: CONSOLE: Forcing save..
> [14:34:55 INFO]: CONSOLE: Save complete.
>save-off
> [14:35:06 INFO]: CONSOLE: Disabled level saving..
>save-on
> [14:35:13 INFO]: CONSOLE: Enabled level saving..
> [14:35:21 INFO]: IIxGriimZz lost connection: Disconnected
> [14:35:21 INFO]: Removing island config from memory.
> [14:35:21 INFO]: Player data saved!
> [14:35:21 INFO]: Removing player from memory: IIxGriimZz
> [14:35:21 INFO]: Hráč IIxGriimZz se odhlásil
> [14:35:33 INFO]: UUID of player IIxGriimZz is c8b8c74d-52aa-36ef-8ba7-da792272eb84
> [14:35:33 INFO]: [IPWhitelist] Player IIxGriimZz is connecting with IP : /93.91.250.148
> [14:35:33 INFO]: Reloading player data!
> [14:35:33 INFO]: Loaded player file for IIxGriimZz
> [14:35:33 INFO]: IIxGriimZz[/*******] logged in with entity id 989251 at ([Eventy] 1364.2319321891005, 59.0, -555.2742108916241)
> [14:35:33 INFO]: Hráč IIxGriimZz se přihlásil