Thread: [HELP] Issues with Vote and Hiscores.

Results 1 to 6 of 6
  1. #1 [HELP] Issues with Vote and Hiscores. 
    Banned
    Join Date
    Sep 2012
    Posts
    1,027
    Thanks given
    193
    Thanks received
    123
    Rep Power
    0
    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.
    Reply With Quote  
     

  2. #2  
    Registered Member
    Join Date
    Aug 2010
    Posts
    640
    Thanks given
    73
    Thanks received
    47
    Rep Power
    54
    The server can't connect to the mysql database.
    Did you put the right host, user & pass?
    Reply With Quote  
     

  3. #3  
    Donator


    Join Date
    Jan 2010
    Age
    29
    Posts
    4,122
    Thanks given
    274
    Thanks received
    551
    Rep Power
    738
    Did you add your ip into the remotemysql?
    Reply With Quote  
     

  4. #4  
    Banned
    Join Date
    Sep 2012
    Posts
    1,027
    Thanks given
    193
    Thanks received
    123
    Rep Power
    0
    Quote Originally Posted by Dwyane Wade View Post
    Did you add your ip into the remotemysql?
    I'm pretty sure I did. I'm new to MySQL. this was all given to my by a friend that quit rsps. So I'm trying to make them work uno?
    Reply With Quote  
     

  5. #5  
    Banned
    Join Date
    Sep 2012
    Posts
    1,027
    Thanks given
    193
    Thanks received
    123
    Rep Power
    0
    yea my vps ip is in remotemysql
    Reply With Quote  
     

  6. #6  



    Join Date
    Dec 2010
    Posts
    833
    Thanks given
    261
    Thanks received
    121
    Rep Power
    204
    Is your webhost up then?

    It's not wise to make it to connect database when they logout, that create's so many useless connections.
    Reply With Quote  
     


Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

Similar Threads

  1. [COLOR="Red"]StaticScape 562 Fun!![/COLOR]
    By Tate Gunner in forum Advertise
    Replies: 5
    Last Post: 02-20-2012, 11:00 AM
  2. [COLOR="Black"]Interface[/COLOR]
    By King. in forum Help
    Replies: 8
    Last Post: 10-08-2009, 04:46 PM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •