Thread: Mysql crashes server when site is down?

Results 1 to 10 of 10
  1. #1 Mysql crashes server when site is down? 
    Registered Member
    Zivik's Avatar
    Join Date
    Oct 2007
    Age
    28
    Posts
    4,421
    Thanks given
    891
    Thanks received
    1,527
    Rep Power
    3285
    Ok, for my vote system, hiscores, and donation system. Whenever i type something such as ::voted, or :onated, or re-log to save hiscores it will crash the server if my website is down that the server is connected to. Does anyone know how to fix this so that if the website is down, and i type the command, it will not disconnect the server?

    This is the error i get on the run.bat when this error happens:

    Code:
    The last packet successfully received from the server was 1,324,336,532,044 mill
    iseconds ago.  The last packet sent successfully to the server was 0 millisecond
    s ago.
    [12/19/11 3:15 PM]:     at sun.reflect.GeneratedConstructorAccessor9.newInstance
    (Unknown Source)
    [12/19/11 3:15 PM]:     at sun.reflect.DelegatingConstructorAccessorImpl.newInst
    ance(Unknown Source)
    [12/19/11 3:15 PM]:     at java.lang.reflect.Constructor.newInstance(Unknown Sou
    rce)
    [12/19/11 3:15 PM]:     at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    [12/19/11 3:15 PM]:     at com.mysql.jdbc.SQLError.createCommunicationsException
    (SQLError.java:1074)
    [12/19/11 3:15 PM]:     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
    [12/19/11 3:15 PM]:     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionI
    mpl.java:2137)
    [12/19/11 3:15 PM]:     ... 25 more
    [12/19/11 3:15 PM]: Caused by: java.net.ConnectException: Connection timed out:
    connect
    [12/19/11 3:15 PM]:     at java.net.PlainSocketImpl.socketConnect(Native Method)
    
    [12/19/11 3:15 PM]:     at java.net.PlainSocketImpl.doConnect(Unknown Source)
    [12/19/11 3:15 PM]:     at java.net.PlainSocketImpl.connectToAddress(Unknown Sou
    rce)
    [12/19/11 3:15 PM]:     at java.net.PlainSocketImpl.connect(Unknown Source)
    [12/19/11 3:15 PM]:     at java.net.SocksSocketImpl.connect(Unknown Source)
    [12/19/11 3:15 PM]:     at java.net.Socket.connect(Unknown Source)
    [12/19/11 3:15 PM]:     at java.net.Socket.connect(Unknown Source)
    [12/19/11 3:15 PM]:     at java.net.Socket.<init>(Unknown Source)
    [12/19/11 3:15 PM]:     at java.net.Socket.<init>(Unknown Source)
    [12/19/11 3:15 PM]:     at com.mysql.jdbc.StandardSocketFactory.connect(Standard
    SocketFactory.java:253)
    [12/19/11 3:15 PM]:     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:290)
    [12/19/11 3:15 PM]:     ... 26 more
    Thanks.
    Reply With Quote  
     

  2. #2  
    Member Mysql crashes server when site is down? Market Banned

    Robin Spud's Avatar
    Join Date
    Aug 2008
    Age
    31
    Posts
    2,338
    Thanks given
    46
    Thanks received
    73
    Rep Power
    1068
    Yeh, create a connection, if the connection doesn't proceed, cancle the command.
    ILY Stewie.
    Reply With Quote  
     

  3. #3  
    Registered Member
    Zivik's Avatar
    Join Date
    Oct 2007
    Age
    28
    Posts
    4,421
    Thanks given
    891
    Thanks received
    1,527
    Rep Power
    3285
    Quote Originally Posted by Robin Spud View Post
    Yeh, create a connection, if the connection doesn't proceed, cancle the command.
    Lol? I need these commands up the whole time. My site is rarely down, but when it is for just 1 second this error can mess up the server.
    Reply With Quote  
     

  4. #4  
    Registered Member
    Zivik's Avatar
    Join Date
    Oct 2007
    Age
    28
    Posts
    4,421
    Thanks given
    891
    Thanks received
    1,527
    Rep Power
    3285
    Bumppp
    Reply With Quote  
     

  5. #5  
    Registered Member
    Zivik's Avatar
    Join Date
    Oct 2007
    Age
    28
    Posts
    4,421
    Thanks given
    891
    Thanks received
    1,527
    Rep Power
    3285
    Bumppp
    Reply With Quote  
     

  6. #6  
    Boom Boom

    Kakapo's Avatar
    Join Date
    Aug 2010
    Posts
    1,030
    Thanks given
    358
    Thanks received
    218
    Rep Power
    365
    Get a better host? Derp


    Reply With Quote  
     

  7. #7  
    Registered Member
    Join Date
    Sep 2008
    Posts
    7
    Thanks given
    0
    Thanks received
    0
    Rep Power
    0
    Why would you site be down in the first place?
    Reply With Quote  
     

  8. #8  
    Registered Member
    Zivik's Avatar
    Join Date
    Oct 2007
    Age
    28
    Posts
    4,421
    Thanks given
    891
    Thanks received
    1,527
    Rep Power
    3285
    Quote Originally Posted by Butternotch View Post
    Get a better host? Derp
    DDoS attacks.


    Quote Originally Posted by IAmSaad View Post
    In the vote , hiscores, and donation methods add:
    Code:
    if(con == null)
         con.createConnection();
    in the beginning

    1776 helped me fix a similiar error in my g.e
    I'll try that out
    Reply With Quote  
     

  9. #9  
    Registered Member
    Zivik's Avatar
    Join Date
    Oct 2007
    Age
    28
    Posts
    4,421
    Thanks given
    891
    Thanks received
    1,527
    Rep Power
    3285
    Bump
    Reply With Quote  
     

  10. #10  
    Banned
    Join Date
    Dec 2011
    Posts
    8
    Thanks given
    0
    Thanks received
    17
    Rep Power
    0
    Did u try adding a recconnect after the server tries to creatConnection?

    Eg:
    if(con == null)
    con.createConnection();
    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. [PI]Server Crashes
    By Nutella in forum Help
    Replies: 13
    Last Post: 04-08-2012, 08:56 PM
  2. Server Crashes
    By Sir Lethal in forum Help
    Replies: 5
    Last Post: 12-20-2011, 12:39 AM
  3. Mysql site
    By rkcjeffrey in forum Website Development
    Replies: 3
    Last Post: 07-09-2011, 05:27 AM
  4. [525] Server Crashes Help rep++
    By White. in forum Help
    Replies: 7
    Last Post: 04-14-2009, 02:26 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
  •