The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL hang and crash

Discussion in 'General Discussion' started by dmtnet, May 24, 2004.

  1. dmtnet

    dmtnet Active Member

    Joined:
    Feb 1, 2003
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    Ver: mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686)
    WHM 9.2.0 cPanel 9.3.0-C4 (CURRENT)
    RedHat 9 - WHM X v3.1.0

    Problem: I have MySQL running for about 15 mins then it crashes and chksrvd will not restart. This problem seems like it just started. When attempting restart via "service mysql restart" I get ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

    In the error log there is nothing before the crash but this is what it reads when I restart manually:

    /usr/sbin/mysqld: ready for connections.
    Version: '4.0.20-standard' socket: '/tmp/mysql.sock' port: 3306

    Number of processes running now: 1
    mysqld process hanging, pid 14861 - killed
    040524 20:36:05 mysqld restarted
    040524 20:36:05 Warning: Asked for 196608 thread stack, but got 126976
    040524 20:36:05 Can't start server: Bind on TCP/IP port: Address already in use
    040524 20:36:05 Do you already have another mysqld server running on port: 3306 ?
    040524 20:36:05 Aborting

    040524 20:36:05 /usr/sbin/mysqld: Shutdown Complete

    040524 20:36:05 mysqld ended


    Things I've tried:
    recreating the symbolic link between /tmp/mysql.sock and /var/lib/mysql
    changing the mysql config to reflect the exact mysql.sock
    upgrading/downgrading chksrvd
    upgrading/downgrading MySQL
     
  2. jsteel

    jsteel Well-Known Member

    Joined:
    Jul 4, 2002
    Messages:
    646
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Atlanta, GA
    Your error shows MysQL 4.0.20 installed and on our C4 installs (even those that just did their UPCP within the last 2 hours), the version installed is 4.0.18. Did you manually install a 4.0.20 upgrade, possibly via an RPM? If so, did you install rather than upgrade such that old 4.0.18 is still running?
     
  3. dmtnet

    dmtnet Active Member

    Joined:
    Feb 1, 2003
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    Actually did both and no result same time frame for the crashing.
     
  4. dmtnet

    dmtnet Active Member

    Joined:
    Feb 1, 2003
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    Any ideas?
     
  5. dmtnet

    dmtnet Active Member

    Joined:
    Feb 1, 2003
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    Fixed. Issue was with PRM, which I didnt know the old admin installed. MySQL was heading over its limit and being killed.

    Appreciate all the thoughts.
     
  6. Roy@ENHOST

    Roy@ENHOST Well-Known Member

    Joined:
    Mar 5, 2002
    Messages:
    495
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Los Angeles California
    This works for me:

    killall -9 mysqld
    /etc/init.d/mysql start
     
Loading...

Share This Page