Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

MySQL Database Error on TimeOut #15

Closed
MarcHagen opened this issue Nov 2, 2012 · 0 comments
Closed

MySQL Database Error on TimeOut #15

MarcHagen opened this issue Nov 2, 2012 · 0 comments

Comments

@MarcHagen
Copy link

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)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@MarcHagen