search

nijikokun / iConomy3

Please, if you fork iConomy only do so if you are really fixing or adding something useful!
7 stars 1 forks source link

[BUG][4.1]MySQL Constant CommunicationsException #11

Open SquallSeeD31 opened 13 years ago

SquallSeeD31 commented 13 years ago

When using a MySQL database in conjunction with iConomy 4.1, I was able to get the accounts to load in successfully from the database when the server first loads, but after that point, all actions performed on the database return a CommunicationsException: Communications link failure.

Problem persists through reload, and consequently does not allow accounts to save on reload or stop. Fresh restart results in same symptopms (loads fine, then breaks).

Database: MySQL CraftBukkit: 440

2011-02-28 04:02:55 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:

* BEGIN NESTED EXCEPTION *

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException MESSAGE: Communications link failure

Last packet sent to the server was 12 ms ago.

STACKTRACE:

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 12 ms ago. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:532) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2871) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3414) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885) at com.nijiko.coelho.iConomy.net.iDatabase.resultQuery(iDatabase.java:42) at com.nijiko.coelho.iConomy.system.Account.save(Account.java:83) at com.nijiko.coelho.iConomy.iConomy.onDisable(iConomy.java:119) at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:142) at org.bukkit.plugin.java.JavaPluginLoader.disablePlugin(JavaPluginLoader.java:441) at org.bukkit.plugin.SimplePluginManager.disablePlugin(SimplePluginManager.java:199) at org.bukkit.plugin.SimplePluginManager.disablePlugins(SimplePluginManager.java:193) at org.bukkit.craftbukkit.CraftServer.disablePlugins(CraftServer.java:71) at net.minecraft.server.MinecraftServer.g(MinecraftServer.java:208) at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283) at net.minecraft.server.ThreadServerApplication.run(SourceFile:366) Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2431) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2882) ... 18 more

\ END NESTED EXCEPTION **

2011-02-28 04:02:55 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2011-02-28 04:02:55 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) 2011-02-28 04:02:55 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2011-02-28 04:02:55 [SEVERE] at java.lang.reflect.Constructor.newInstance(Constructor.java:532) 2011-02-28 04:02:55 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) 2011-02-28 04:02:55 [SEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:381) 2011-02-28 04:02:55 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984) 2011-02-28 04:02:55 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 2011-02-28 04:02:55 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 2011-02-28 04:02:55 [SEVERE] at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1098) 2011-02-28 04:02:55 [SEVERE] at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4076) 2011-02-28 04:02:55 [SEVERE] at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4042) 2011-02-28 04:02:55 [SEVERE] at com.nijiko.coelho.iConomy.net.iDatabase.resultQuery(iDatabase.java:39) 2011-02-28 04:02:55 [SEVERE] at com.nijiko.coelho.iConomy.system.Account.save(Account.java:83) 2011-02-28 04:02:55 [SEVERE] at com.nijiko.coelho.iConomy.iConomy.onDisable(iConomy.java:119) 2011-02-28 04:02:55 [SEVERE] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:142) 2011-02-28 04:02:55 [SEVERE] at org.bukkit.plugin.java.JavaPluginLoader.disablePlugin(JavaPluginLoader.java:441) 2011-02-28 04:02:55 [SEVERE] at org.bukkit.plugin.SimplePluginManager.disablePlugin(SimplePluginManager.java:199) 2011-02-28 04:02:55 [SEVERE] at org.bukkit.plugin.SimplePluginManager.disablePlugins(SimplePluginManager.java:193) 2011-02-28 04:02:55 [SEVERE] at org.bukkit.craftbukkit.CraftServer.disablePlugins(CraftServer.java:71) 2011-02-28 04:02:55 [SEVERE] at net.minecraft.server.MinecraftServer.g(MinecraftServer.java:208) 2011-02-28 04:02:55 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283) 2011-02-28 04:02:55 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:366) 2011-02-28 04:02:55 [SEVERE] java.lang.NullPointerException 2011-02-28 04:02:55 [SEVERE] at com.nijiko.coelho.iConomy.system.Account.save(Account.java:88) 2011-02-28 04:02:55 [SEVERE] at com.nijiko.coelho.iConomy.iConomy.onDisable(iConomy.java:119) 2011-02-28 04:02:55 [SEVERE] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:142) 2011-02-28 04:02:55 [SEVERE] at org.bukkit.plugin.java.JavaPluginLoader.disablePlugin(JavaPluginLoader.java:441) 2011-02-28 04:02:55 [SEVERE] at org.bukkit.plugin.SimplePluginManager.disablePlugin(SimplePluginManager.java:199) 2011-02-28 04:02:55 [SEVERE] at org.bukkit.plugin.SimplePluginManager.disablePlugins(SimplePluginManager.java:193) 2011-02-28 04:02:55 [SEVERE] at org.bukkit.craftbukkit.CraftServer.disablePlugins(CraftServer.java:71) 2011-02-28 04:02:55 [SEVERE] at net.minecraft.server.MinecraftServer.g(MinecraftServer.java:208) 2011-02-28 04:02:55 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283) 2011-02-28 04:02:55 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:366)