MultiInv

359k Downloads

MySQL Database Error on TimeOut

MarcHagen opened this issue ยท 0 comments

commented

Windows Server 2008 R2
Craftbukkit 1.3.2-R2.0

I get this after a night and some one joins.

2012-11-02 13:49:19 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 35,342,699 milliseconds ago. The last packet sent succe
ssfully to the server was 35,342,699 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use i
n your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
2012-11-02 13:49:19 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
2012-11-02 13:49:19 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2012-11-02 13:49:19 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
2012-11-02 13:49:19 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source)
2012-11-02 13:49:19 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
2012-11-02 13:49:19 [SEVERE] at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
2012-11-02 13:49:19 [SEVERE] at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3348)
2012-11-02 13:49:19 [SEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1967)
2012-11-02 13:49:19 [SEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
2012-11-02 13:49:19 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
2012-11-02 13:49:19 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
2012-11-02 13:49:19 [SEVERE] at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
2012-11-02 13:49:19 [SEVERE] at uk.co.tggl.pluckerpluck.multiinv.mysql.SqlConnector.tableExists(SqlConnector.java:26)
2012-11-02 13:49:19 [SEVERE] at uk.co.tggl.pluckerpluck.multiinv.mysql.SqlConnector.createRecord(SqlConnector.java:93)
2012-11-02 13:49:19 [SEVERE] at uk.co.tggl.pluckerpluck.multiinv.mysql.SqlConnector.saveInventory(SqlConnector.java:83)
2012-11-02 13:49:19 [SEVERE] at uk.co.tggl.pluckerpluck.multiinv.player.MIPlayer.saveInventory(MIPlayer.java:61)
2012-11-02 13:49:19 [SEVERE] at uk.co.tggl.pluckerpluck.multiinv.listener.MIPlayerListener.savePlayerState(MIPlayerListener.java:116)
2012-11-02 13:49:19 [SEVERE] at uk.co.tggl.pluckerpluck.multiinv.player.DeferredWorldCheck.run(DeferredWorldCheck.java:27)
2012-11-02 13:49:19 [SEVERE] at org.bukkit.craftbukkit.scheduler.CraftTask.run(CraftTask.java:53)
2012-11-02 13:49:19 [SEVERE] at org.bukkit.craftbukkit.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:345)
2012-11-02 13:49:19 [SEVERE] at net.minecraft.server.MinecraftServer.q(MinecraftServer.java:510)
2012-11-02 13:49:19 [SEVERE] at net.minecraft.server.DedicatedServer.q(DedicatedServer.java:213)
2012-11-02 13:49:19 [SEVERE] at net.minecraft.server.MinecraftServer.p(MinecraftServer.java:474)
2012-11-02 13:49:19 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:406)
2012-11-02 13:49:19 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:539)
2012-11-02 13:49:19 [SEVERE] Caused by: java.net.SocketException: Software caused connection abort: socket write error
2012-11-02 13:49:19 [SEVERE] at java.net.SocketOutputStream.socketWrite0(Native Method)
2012-11-02 13:49:19 [SEVERE] at java.net.SocketOutputStream.socketWrite(Unknown Source)
2012-11-02 13:49:19 [SEVERE] at java.net.SocketOutputStream.write(Unknown Source)
2012-11-02 13:49:19 [SEVERE] at java.io.BufferedOutputStream.flushBuffer(Unknown Source)
2012-11-02 13:49:19 [SEVERE] at java.io.BufferedOutputStream.flush(Unknown Source)
2012-11-02 13:49:19 [SEVERE] at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3329)
2012-11-02 13:49:19 [SEVERE] ... 18 more
2012-11-02 13:49:19 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'server0_multiinv' already exists
2012-11-02 13:49:19 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2012-11-02 13:49:19 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
2012-11-02 13:49:19 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
2012-11-02 13:49:19 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source)
2012-11-02 13:49:19 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
2012-11-02 13:49:19 [SEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:382)
2012-11-02 13:49:19 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
2012-11-02 13:49:19 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
2012-11-02 13:49:19 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
2012-11-02 13:49:19 [SEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
2012-11-02 13:49:19 [SEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
2012-11-02 13:49:19 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
2012-11-02 13:49:19 [SEVERE] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
2012-11-02 13:49:19 [SEVERE] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
2012-11-02 13:49:19 [SEVERE] at uk.co.tggl.pluckerpluck.multiinv.mysql.SqlConnector.createTable(SqlConnector.java:42)
2012-11-02 13:49:19 [SEVERE] at uk.co.tggl.pluckerpluck.multiinv.mysql.SqlConnector.createRecord(SqlConnector.java:94)
2012-11-02 13:49:19 [SEVERE] at uk.co.tggl.pluckerpluck.multiinv.mysql.SqlConnector.saveInventory(SqlConnector.java:83)
2012-11-02 13:49:19 [SEVERE] at uk.co.tggl.pluckerpluck.multiinv.player.MIPlayer.saveInventory(MIPlayer.java:61)
2012-11-02 13:49:19 [SEVERE] at uk.co.tggl.pluckerpluck.multiinv.listener.MIPlayerListener.savePlayerState(MIPlayerListener.java:116)
2012-11-02 13:49:19 [SEVERE] at uk.co.tggl.pluckerpluck.multiinv.player.DeferredWorldCheck.run(DeferredWorldCheck.java:27)
2012-11-02 13:49:19 [SEVERE] at org.bukkit.craftbukkit.scheduler.CraftTask.run(CraftTask.java:53)
2012-11-02 13:49:19 [SEVERE] at org.bukkit.craftbukkit.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:345)
2012-11-02 13:49:19 [SEVERE] at net.minecraft.server.MinecraftServer.q(MinecraftServer.java:510)
2012-11-02 13:49:19 [SEVERE] at net.minecraft.server.DedicatedServer.q(DedicatedServer.java:213)
2012-11-02 13:49:19 [SEVERE] at net.minecraft.server.MinecraftServer.p(MinecraftServer.java:474)
2012-11-02 13:49:19 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:406)
2012-11-02 13:49:19 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:539)