Alright so every time someone log's out of the game, it disconnects the entire server for about a minute or two, and a shit ton of CMD errors (server sided) pop up. When somene does an auth code, it does the same thing.
I think I did something wrong making the databases, but I'm at a complete loss due to the fact, I don't know shit when it comes to mySQL. If anyone knows how to fix this, I'll greatly appreciate the help and I'll +Rep.
Thanks in advanced for reading this thread.
Nick.
P.S. I'll get the CMD errors once it starts doing it again. Happens every now and then, but too often and it crashes the entire server until the errors spam into the cmd.
Trying to log out:
Code:
[9/29/12 12:39 PM]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Com
munications link failure
The last packet successfully received from the server was 251,312 milliseconds a
go. The last packet sent successfully to the server was 42,625 milliseconds ago
.
[9/29/12 12:39 PM]: at sun.reflect.NativeConstructorAccessorImpl.newInstance
0(Native Method)
[9/29/12 12:39 PM]: at sun.reflect.NativeConstructorAccessorImpl.newInstance
(NativeConstructorAccessorImpl.java:39)
[9/29/12 12:39 PM]: at sun.reflect.DelegatingConstructorAccessorImpl.newInst
ance(DelegatingConstructorAccessorImpl.java:27)
[9/29/12 12:39 PM]: at java.lang.reflect.Constructor.newInstance(Constructor
.java:513)
[9/29/12 12:39 PM]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
[9/29/12 12:39 PM]: at com.mysql.jdbc.SQLError.createCommunicationsException
(SQLError.java:1074)
[9/29/12 12:39 PM]: at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.jav
a:3030)
[9/29/12 12:39 PM]: at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.jav
a:2916)
[9/29/12 12:39 PM]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
3459)
[9/29/12 12:39 PM]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
[9/29/12 12:39 PM]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:21
07)
[9/29/12 12:39 PM]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
java:2642)
[9/29/12 12:39 PM]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
java:2571)
[9/29/12 12:39 PM]: at com.mysql.jdbc.StatementImpl.execute(StatementImpl.ja
va:769)
[9/29/12 12:39 PM]: at com.mysql.jdbc.StatementImpl.execute(StatementImpl.ja
va:612)
[9/29/12 12:39 PM]: at server.util.HiscoresHandler.deleteHiscores(HiscoresHa
ndler.java:109)
[9/29/12 12:39 PM]: at server.util.HiscoresHandler.hiscoresHandler(HiscoresH
andler.java:68)
[9/29/12 12:39 PM]: at server.model.players.Client.logout(Client.java:459)
[9/29/12 12:39 PM]: at server.model.players.packets.ClickingButtons.processP
acket(ClickingButtons.java:1194)
[9/29/12 12:39 PM]: at server.model.players.PacketHandler.processPacket(Pack
etHandler.java:175)
[9/29/12 12:39 PM]: at server.model.players.Client.processQueuedPackets(Clie
nt.java:999)
[9/29/12 12:39 PM]: at server.model.players.PlayerHandler.process(PlayerHand
ler.java:151)
[9/29/12 12:39 PM]: at server.Server$2.execute(Server.java:180)
[9/29/12 12:39 PM]: at server.event.Task.tick(Task.java:103)
[9/29/12 12:39 PM]: at server.event.TaskScheduler.run(TaskScheduler.java:98)
[9/29/12 12:39 PM]: at java.util.concurrent.Executors$RunnableAdapter.call(E
xecutors.java:441)
[9/29/12 12:39 PM]: at java.util.concurrent.FutureTask$Sync.innerRunAndReset
(FutureTask.java:317)
[9/29/12 12:39 PM]: at java.util.concurrent.FutureTask.runAndReset(FutureTas
k.java:150)
[9/29/12 12:39 PM]: at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
duledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)
[9/29/12 12:39 PM]: at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
duledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180)
[9/29/12 12:39 PM]: at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
duledFutureTask.run(ScheduledThreadPoolExecutor.java:204)
[9/29/12 12:39 PM]: at java.util.concurrent.ThreadPoolExecutor$Worker.runTas
k(ThreadPoolExecutor.java:886)
[9/29/12 12:39 PM]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Th
readPoolExecutor.java:908)
[9/29/12 12:39 PM]: at java.lang.Thread.run(Thread.java:662)
[9/29/12 12:39 PM]: Caused by: java.net.SocketException: Connection reset
[9/29/12 12:39 PM]: at java.net.SocketInputStream.read(SocketInputStream.jav
a:168)
[9/29/12 12:39 PM]: at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAhe
adInputStream.java:113)
[9/29/12 12:39 PM]: at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnde
rlyingStreamIfNecessary(ReadAheadInputStream.java:160)
[9/29/12 12:39 PM]: at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAhe
adInputStream.java:188)
[9/29/12 12:39 PM]: at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2472)
[9/29/12 12:39 PM]: at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.jav
a:2927)
[9/29/12 12:39 PM]: ... 27 more
[9/29/12 12:39 PM]: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViol
ationException: Duplicate entry 'Nick' for key 'PRIMARY'
[9/29/12 12:39 PM]: at sun.reflect.NativeConstructorAccessorImpl.newInstance
0(Native Method)
[9/29/12 12:39 PM]: at sun.reflect.NativeConstructorAccessorImpl.newInstance
(NativeConstructorAccessorImpl.java:39)
[9/29/12 12:39 PM]: at sun.reflect.DelegatingConstructorAccessorImpl.newInst
ance(DelegatingConstructorAccessorImpl.java:27)
[9/29/12 12:39 PM]: at java.lang.reflect.Constructor.newInstance(Constructor
.java:513)
[9/29/12 12:39 PM]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
[9/29/12 12:39 PM]: at com.mysql.jdbc.Util.getInstance(Util.java:381)
[9/29/12 12:39 PM]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
ava:1015)
[9/29/12 12:39 PM]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
ava:956)
[9/29/12 12:39 PM]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
3536)
[9/29/12 12:39 PM]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
3468)
[9/29/12 12:39 PM]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
[9/29/12 12:39 PM]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:21
07)
[9/29/12 12:39 PM]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
java:2642)
[9/29/12 12:39 PM]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
java:2571)
[9/29/12 12:39 PM]: at com.mysql.jdbc.StatementImpl.execute(StatementImpl.ja
va:769)
[9/29/12 12:39 PM]: at com.mysql.jdbc.StatementImpl.execute(StatementImpl.ja
va:612)
[9/29/12 12:39 PM]: at server.util.HiscoresHandler.saveHiscores(HiscoresHand
ler.java:84)
[9/29/12 12:39 PM]: at server.util.HiscoresHandler.hiscoresHandler(HiscoresH
andler.java:69)
[9/29/12 12:39 PM]: at server.model.players.Client.logout(Client.java:459)
[9/29/12 12:39 PM]: at server.model.players.packets.ClickingButtons.processP
acket(ClickingButtons.java:1194)
[9/29/12 12:39 PM]: at server.model.players.PacketHandler.processPacket(Pack
etHandler.java:175)
[9/29/12 12:39 PM]: at server.model.players.Client.processQueuedPackets(Clie
nt.java:999)
[9/29/12 12:39 PM]: at server.model.players.PlayerHandler.process(PlayerHand
ler.java:151)
[9/29/12 12:39 PM]: at server.Server$2.execute(Server.java:180)
[9/29/12 12:39 PM]: at server.event.Task.tick(Task.java:103)
[9/29/12 12:39 PM]: at server.event.TaskScheduler.run(TaskScheduler.java:98)
[9/29/12 12:39 PM]: at java.util.concurrent.Executors$RunnableAdapter.call(E
xecutors.java:441)
[9/29/12 12:39 PM]: at java.util.concurrent.FutureTask$Sync.innerRunAndReset
(FutureTask.java:317)
[9/29/12 12:39 PM]: at java.util.concurrent.FutureTask.runAndReset(FutureTas
k.java:150)
[9/29/12 12:39 PM]: at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
duledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)
[9/29/12 12:39 PM]: at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
duledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180)
[9/29/12 12:39 PM]: at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
duledFutureTask.run(ScheduledThreadPoolExecutor.java:204)
[9/29/12 12:39 PM]: at java.util.concurrent.ThreadPoolExecutor$Worker.runTas
k(ThreadPoolExecutor.java:886)
[9/29/12 12:39 PM]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Th
readPoolExecutor.java:908)
[9/29/12 12:39 PM]: at java.lang.Thread.run(Thread.java:662)
[9/29/12 12:39 PM]: Game saved for player Nick
[9/29/12 12:39 PM]: LOGGED OUT: Nick
[9/29/12 12:39 PM]: Average Cycle Time: 322ms
[9/29/12 12:39 PM]: Players online: 1, engine load: 53.67%
the auth code does the same thing pretty much.
Code:
[9/29/12 12:44 PM]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Com
munications link failure
The last packet successfully received from the server was 676,515 milliseconds a
go. The last packet sent successfully to the server was 49,703 milliseconds ago
.
[9/29/12 12:44 PM]: at sun.reflect.NativeConstructorAccessorImpl.newInstance
0(Native Method)
[9/29/12 12:44 PM]: at sun.reflect.NativeConstructorAccessorImpl.newInstance
(NativeConstructorAccessorImpl.java:39)
[9/29/12 12:44 PM]: at sun.reflect.DelegatingConstructorAccessorImpl.newInst
ance(DelegatingConstructorAccessorImpl.java:27)
[9/29/12 12:44 PM]: at java.lang.reflect.Constructor.newInstance(Constructor
.java:513)
[9/29/12 12:44 PM]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
[9/29/12 12:44 PM]: at com.mysql.jdbc.SQLError.createCommunicationsException
(SQLError.java:1074)
[9/29/12 12:44 PM]: at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.jav
a:3030)
[9/29/12 12:44 PM]: at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.jav
a:2916)
[9/29/12 12:44 PM]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
3459)
[9/29/12 12:44 PM]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
[9/29/12 12:44 PM]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:21
07)
[9/29/12 12:44 PM]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
java:2642)
[9/29/12 12:44 PM]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
java:2571)
[9/29/12 12:44 PM]: at com.mysql.jdbc.StatementImpl.executeQuery(StatementIm
pl.java:1451)
[9/29/12 12:44 PM]: at server.util.VoteHandler.checkVote(VoteHandler.java:88
)
[9/29/12 12:44 PM]: at server.model.players.packets.Commands.processPacket(C
ommands.java:372)
[9/29/12 12:44 PM]: at server.model.players.PacketHandler.processPacket(Pack
etHandler.java:175)
[9/29/12 12:44 PM]: at server.model.players.Client.processQueuedPackets(Clie
nt.java:999)
[9/29/12 12:44 PM]: at server.model.players.PlayerHandler.process(PlayerHand
ler.java:151)
[9/29/12 12:44 PM]: at server.Server$2.execute(Server.java:180)
[9/29/12 12:44 PM]: at server.event.Task.tick(Task.java:103)
[9/29/12 12:44 PM]: at server.event.TaskScheduler.run(TaskScheduler.java:98)
[9/29/12 12:44 PM]: at java.util.concurrent.Executors$RunnableAdapter.call(E
xecutors.java:441)
[9/29/12 12:44 PM]: at java.util.concurrent.FutureTask$Sync.innerRunAndReset
(FutureTask.java:317)
[9/29/12 12:44 PM]: at java.util.concurrent.FutureTask.runAndReset(FutureTas
k.java:150)
[9/29/12 12:44 PM]: at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
duledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)
[9/29/12 12:44 PM]: at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
duledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180)
[9/29/12 12:44 PM]: at java.util.concurrent.ScheduledThreadPoolExecutor$Sche
duledFutureTask.run(ScheduledThreadPoolExecutor.java:204)
[9/29/12 12:44 PM]: at java.util.concurrent.ThreadPoolExecutor$Worker.runTas
k(ThreadPoolExecutor.java:886)
[9/29/12 12:44 PM]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Th
readPoolExecutor.java:908)
[9/29/12 12:44 PM]: at java.lang.Thread.run(Thread.java:662)
[9/29/12 12:44 PM]: Caused by: java.net.SocketException: Connection reset
[9/29/12 12:44 PM]: at java.net.SocketInputStream.read(SocketInputStream.jav
a:168)
[9/29/12 12:44 PM]: at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAhe
adInputStream.java:113)
[9/29/12 12:44 PM]: at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnde
rlyingStreamIfNecessary(ReadAheadInputStream.java:160)
[9/29/12 12:44 PM]: at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAhe
adInputStream.java:188)
[9/29/12 12:44 PM]: at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2472)
[9/29/12 12:44 PM]: at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.jav
a:2927)
[9/29/12 12:44 PM]: ... 24 more
[9/29/12 12:44 PM]: Game saved for player Nick
[9/29/12 12:44 PM]: LOGGED OUT: Nick
mind you when it doesn't make the player connect it works perfectly... but as i said. it's been happening A LOT.