Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2003
    Location
    Southeast, USA
    Posts
    19

    MySQL hang and crash

    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 10 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. #2
    Join Date
    Dec 2003
    Location
    Brisbane, Queensland, Australia
    Posts
    547
    Try this thread out. I hope this helps

    http://www.webhostingtalk.com/showthread.php?threadid=270357

  3. #3
    Join Date
    Jan 2003
    Location
    Southeast, USA
    Posts
    19
    Originally posted by DiBellaweb
    Try this thread out. I hope this helps

    http://www.webhostingtalk.com/showthread.php?threadid=270357
    Nothing there I havent tried, thanks though.

  4. #4
    Join Date
    Dec 2003
    Location
    Brisbane, Queensland, Australia
    Posts
    547
    Can you tell us what is in your /var/log/messages in relation to mysql. This could help us why it is not starting up.

  5. #5
    Join Date
    Dec 2003
    Location
    Brisbane, Queensland, Australia
    Posts
    547
    Hi dmtnet,

    I did a bit of research and found a few suggestions. They are below:

    go to your /etc/my.cnf and change the following:

    Change your max_allowed_packet to anything over 2M

    for example max_allowed_packet=5M

    and then restart MySQL and that should be all good to go.

    You can read up more at this url

    http://bugs.mysql.com/bug.php?id=1011

  6. #6
    Join Date
    Jan 2003
    Location
    Southeast, USA
    Posts
    19
    Originally posted by DiBellaweb
    Can you tell us what is in your /var/log/messages in relation to mysql. This could help us why it is not starting up.

    My set-variable = max_allowed_packet=16M has been the same for a few months now, hasnt changed.

    Also there are no mysql messages

  7. #7
    Join Date
    Jan 2003
    Location
    Southeast, USA
    Posts
    19
    Still really need help of anyone has anything to add, it would be highly appreciated.

  8. #8
    Join Date
    Sep 2003
    Location
    New York City
    Posts
    88
    Make sure you don't run out of disk space in /tmp.
    Reliable Business E-mail Hosting
    http://www.bizintegrators.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •