Fe - Economy

59k Downloads

MySQL issue

rcl2748 opened this issue ยท 0 comments

commented

I have this error every time someone logs in:

[09:36:26 WARN]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Commun
ications link failure

The last packet successfully received from the server was 167,373 milliseconds a
go. The last packet sent successfully to the server was 5 milliseconds ago.
[09:36:26 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance
0(Native Method)
[09:36:26 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance
(Unknown Source)
[09:36:26 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInst
ance(Unknown Source)
[09:36:26 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Sou
rce)
[09:36:26 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
[09:36:26 WARN]: at com.mysql.jdbc.SQLError.createCommunicationsException
(SQLError.java:1116)
[09:36:26 WARN]: at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.jav
a:3082)
[09:36:26 WARN]: at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.jav
a:2968)
[09:36:26 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
3516)
[09:36:26 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)

[09:36:26 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:21
40)
[09:36:26 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
java:2626)
[09:36:26 WARN]: at com.mysql.jdbc.PreparedStatement.executeInternal(Prep
aredStatement.java:2111)
[09:36:26 WARN]: at com.mysql.jdbc.PreparedStatement.executeQuery(Prepare
dStatement.java:2273)
[09:36:26 WARN]: at com.niccholaspage.nSQL.query.SelectQuery.execute(Sele
ctQuery.java:55)
[09:36:26 WARN]: at org.melonbrew.fe.database.databases.SQLDB.loadAccount
Money(SQLDB.java:161)
[09:36:26 WARN]: at org.melonbrew.fe.database.Database.getAccount(Databas
e.java:44)
[09:36:26 WARN]: at org.melonbrew.fe.database.Database.createAccount(Data
base.java:58)
[09:36:26 WARN]: at org.melonbrew.fe.API.createAccount(API.java:69)
[09:36:26 WARN]: at org.melonbrew.fe.listeners.FePlayerListener.onPlayerL
ogin(FePlayerListener.java:24)
[09:36:26 WARN]: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native M
ethod)
[09:36:26 WARN]: at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown S
ource)
[09:36:26 WARN]: at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unkno
wn Source)
[09:36:26 WARN]: at java.lang.reflect.Method.invoke(Unknown Source)
[09:36:26 WARN]: at org.bukkit.plugin.java.JavaPluginLoader$1.execute(Jav
aPluginLoader.java:318)
[09:36:26 WARN]: at org.bukkit.plugin.RegisteredListener.callEvent(Regist
eredListener.java:62)
[09:36:26 WARN]: at org.bukkit.plugin.TimedRegisteredListener.callEvent(T
imedRegisteredListener.java:30)
[09:36:26 WARN]: at org.bukkit.plugin.SimplePluginManager.fireEvent(Simpl
ePluginManager.java:487)
[09:36:26 WARN]: at org.bukkit.plugin.SimplePluginManager.callEvent(Simpl
ePluginManager.java:472)
[09:36:26 WARN]: at net.minecraft.server.v1_7_R1.PlayerList.attemptLogin(
PlayerList.java:362)
[09:36:26 WARN]: at net.minecraft.server.v1_7_R1.LoginListener.c(LoginLis
tener.java:79)
[09:36:26 WARN]: at net.minecraft.server.v1_7_R1.LoginListener.a(LoginLis
tener.java:42)
[09:36:26 WARN]: at net.minecraft.server.v1_7_R1.NetworkManager.a(Network
Manager.java:150)
[09:36:26 WARN]: at net.minecraft.server.v1_7_R1.ServerConnection.c(Serve
rConnection.java:77)
[09:36:26 WARN]: at net.minecraft.server.v1_7_R1.MinecraftServer.u(Minecr
aftServer.java:700)
[09:36:26 WARN]: at net.minecraft.server.v1_7_R1.DedicatedServer.u(Dedica
tedServer.java:273)
[09:36:26 WARN]: at net.minecraft.server.v1_7_R1.MinecraftServer.t(Minecr
aftServer.java:562)
[09:36:26 WARN]: at net.minecraft.server.v1_7_R1.MinecraftServer.run(Mine
craftServer.java:469)
[09:36:26 WARN]: at net.minecraft.server.v1_7_R1.ThreadServerApplication.
run(SourceFile:617)
[09:36:26 WARN]: Caused by: java.io.EOFException: Can not read response from ser
ver. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly l
ost.
[09:36:26 WARN]: at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2529)
[09:36:26 WARN]: at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.jav
a:2979)
[09:36:26 WARN]: ... 32 more
[09:36:26 ERROR]: Could not pass event PlayerLoginEvent to Fe v0.7-SNAPSHOT
org.bukkit.event.EventException
at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.ja
va:320) ~[server.jar:git-Spigot-1331]
at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.jav
a:62) ~[server.jar:git-Spigot-1331]
at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredLi
stener.java:30) ~[server.jar:git-Spigot-1331]
at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.j
ava:487) [server.jar:git-Spigot-1331]
at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.j
ava:472) [server.jar:git-Spigot-1331]
at net.minecraft.server.v1_7_R1.PlayerList.attemptLogin(PlayerList.java:
362) [server.jar:git-Spigot-1331]
at net.minecraft.server.v1_7_R1.LoginListener.c(LoginListener.java:79) [
server.jar:git-Spigot-1331]
at net.minecraft.server.v1_7_R1.LoginListener.a(LoginListener.java:42) [
server.jar:git-Spigot-1331]
at net.minecraft.server.v1_7_R1.NetworkManager.a(NetworkManager.java:150
) [server.jar:git-Spigot-1331]
at net.minecraft.server.v1_7_R1.ServerConnection.c(ServerConnection.java
:77) [server.jar:git-Spigot-1331]
at net.minecraft.server.v1_7_R1.MinecraftServer.u(MinecraftServer.java:7
00) [server.jar:git-Spigot-1331]
at net.minecraft.server.v1_7_R1.DedicatedServer.u(DedicatedServer.java:2
73) [server.jar:git-Spigot-1331]
at net.minecraft.server.v1_7_R1.MinecraftServer.t(MinecraftServer.java:5
62) [server.jar:git-Spigot-1331]
at net.minecraft.server.v1_7_R1.MinecraftServer.run(MinecraftServer.java
:469) [server.jar:git-Spigot-1331]
at net.minecraft.server.v1_7_R1.ThreadServerApplication.run(SourceFile:6
17) [server.jar:git-Spigot-1331]
Caused by: java.lang.NullPointerException
at org.melonbrew.fe.database.databases.SQLDB.loadAccountMoney(SQLDB.java
:163) ~[?:?]
at org.melonbrew.fe.database.Database.getAccount(Database.java:44) ~[?:?
]
at org.melonbrew.fe.database.Database.createAccount(Database.java:58) ~[
?:?]
at org.melonbrew.fe.API.createAccount(API.java:69) ~[?:?]
at org.melonbrew.fe.listeners.FePlayerListener.onPlayerLogin(FePlayerLis
tener.java:24) ~[?:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0
_07]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.7.0
_07]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1
.7.0_07]
at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.7.0_07]
at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.ja
va:318) ~[server.jar:git-Spigot-1331]
... 14 more

P.S: and you are calling this a Rock Solid plugin that wont let you down? xD