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 continuously restarting restartsrv2 mysqlconnectioncheck

Discussion in 'General Discussion' started by daWeazy, Dec 31, 2004.

  1. daWeazy

    daWeazy Member

    Joined:
    Jan 1, 2004
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    California
    This has been happening non-stop since about 4:00PST. I have upgraded kernel, rebooted, locked down /tmp, /var/tmp, verfied my.cnf for the proper .sock file location, forced updated cpanel, recompiled apache, upgrade php, rebooted, almost perfectly in that order. What the heck is going on. Mysql restarts every 30 seconds or something crazy, and I cant seem to find any errors in the log files. HELP!!

    root 28167 0.0 1.2 12812 11496 ? S 02:40 0:00 /usr/local/cpanel/whostmgr/bin/whostmgr doresetmysqlroot
    root 28195 0.0 0.0 0 0 ? Z 02:40 0:00 [whostmgr] <defunct>
    root 28222 0.0 0.2 4212 2560 ? S 02:40 0:00 /usr/bin/perl /scripts/restartsrv2 mysql
    root 28294 0.0 0.3 4792 3220 ? S 02:40 0:00 /usr/bin/perl /scripts/restartsrv_mysql --check
    root 28295 0.0 0.2 4112 2636 ? S 02:40 0:00 /usr/bin/perl /scripts/mysqlconnectioncheck
    root 28296 0.0 0.0 0 0 ? Z 02:40 0:00 [mysql] <defunct>
    root 28298 0.0 1.2 12812 11496 ? S 02:40 0:00 /usr/local/cpanel/whostmgr/bin/whostmgr doresetmysqlroot
    root 28334 0.0 0.0 0 0 ? Z 02:40 0:00 [whostmgr] <defunct>
    root 28368 0.0 0.2 4208 2556 ? S 02:41 0:00 /usr/bin/perl /scripts/restartsrv2 mysql
    root 28440 0.0 0.3 4796 3224 ? S 02:41 0:00 /usr/bin/perl /scripts/restartsrv_mysql --check
    root 28441 0.0 0.2 4112 2636 ? S 02:41 0:00 /usr/bin/perl /scripts/mysqlconnectioncheck
    root 28442 0.0 0.0 0 0 ? Z 02:41 0:00 [mysql] <defunct>
    root 28444 0.0 1.2 12812 11496 ? S 02:41 0:00 /usr/local/cpanel/whostmgr/bin/whostmgr doresetmysqlroot
    root 28474 0.0 0.0 0 0 ? Z 02:41 0:00 [whostmgr] <defunct>
    root 28498 0.0 0.2 4208 2556 ? S 02:41 0:00 /usr/bin/perl /scripts/restartsrv2 mysql
    root 28567 0.0 0.3 4796 3224 ? S 02:41 0:00 /usr/bin/perl /scripts/restartsrv_mysql --check
    root 28568 0.0 0.2 4112 2636 ? S 02:41 0:00 /usr/bin/perl /scripts/mysqlconnectioncheck
    root 28569 0.0 0.0 0 0 ? Z 02:41 0:00 [mysql] <defunct>
    root 28571 0.0 1.2 12812 11496 ? S 02:41 0:00 /usr/local/cpanel/whostmgr/bin/whostmgr doresetmysqlroot
    root 28598 0.0 0.0 0 0 ? Z 02:42 0:00 [whostmgr] <defunct>
    root 28623 0.0 0.2 4204 2552 ? S 02:42 0:00 /usr/bin/perl /scripts/restartsrv2 mysql
    root 28693 0.0 0.3 4796 3224 ? S 02:42 0:00 /usr/bin/perl /scripts/restartsrv_mysql --check
    root 28694 0.0 0.2 4112 2636 ? S 02:42 0:00 /usr/bin/perl /scripts/mysqlconnectioncheck
    root 28695 0.0 0.0 0 0 ? Z 02:42 0:00 [mysql] <defunct>
    root 28697 0.1 1.2 12812 11496 ? S 02:42 0:00 /usr/local/cpanel/whostmgr/bin/whostmgr doresetmysqlroot
    root 28724 0.0 0.0 0 0 ? Z 02:42 0:00 [whostmgr] <defunct>
    root 28748 0.1 0.2 4204 2552 ? S 02:42 0:00 /usr/bin/perl /scripts/restartsrv2 mysql
    root 28819 0.2 0.3 4796 3224 ? S 02:43 0:00 /usr/bin/perl /scripts/restartsrv_mysql --check
    root 28820 0.1 0.2 4112 2636 ? S 02:43 0:00 /usr/bin/perl /scripts/mysqlconnectioncheck
     
  2. daWeazy

    daWeazy Member

    Joined:
    Jan 1, 2004
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    California
    funny I just figured out the fix. Rebuild RPM mysql-server with the Force option fixed this issue. Very strange. Now this makes me wonder how mysql became corrupted.... Any ideas?
     
  3. daWeazy

    daWeazy Member

    Joined:
    Jan 1, 2004
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    California
    problem came back... HELP!
     
  4. Blue|Fusion

    Blue|Fusion Well-Known Member

    Joined:
    Sep 12, 2004
    Messages:
    378
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Cleveland, Ohio
    Shoot me a PM or IM and i could take a look at it.
     
  5. BenThomas

    BenThomas Well-Known Member

    Joined:
    Feb 12, 2004
    Messages:
    598
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Houston, Texas USA
    cPanel Access Level:
    Root Administrator
    chkservd calls /script/restartsrv_mysql --check, which calls /scripts/mysqlconnectioncheck. If mysql does not respond, then it is assumed that mysql is down. chkservd then call /scripts/restartsrv2 mysql. The key is to determine if mysql is up and running. Then to find out why it may not be responding. And in your case, why it would fail after a short period of time. Not much of a short answer, but maybe it'll help you sort it out.
     
  6. Blue|Fusion

    Blue|Fusion Well-Known Member

    Joined:
    Sep 12, 2004
    Messages:
    378
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Cleveland, Ohio
    try the following:
    service cpanel stop
    service mysql stop


    use ps -ax and ensure all of processes you posted above are killed, if not kill them manually

    service mysql start
    service cpanel start
     
  7. daWeazy

    daWeazy Member

    Joined:
    Jan 1, 2004
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    California
    I have performed all these solutions and nothing works. Trust me I have spent hours reading all the posts relating to mysql crashing in this forum.
     
  8. daWeazy

    daWeazy Member

    Joined:
    Jan 1, 2004
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    California

    This sure is a wierd issue. I am pretty good with sorting out problems like this, but this one is a major pain in my ass. the logs just show: mysql started ok, mysql stopped ok etc.. no real error messages. I am starting to think this chkservd might be broken is there a way to like reinstall all cpanel services? I dont know what to do all my sites are down. Then dns breaks. Its just bad.
     
  9. Blue|Fusion

    Blue|Fusion Well-Known Member

    Joined:
    Sep 12, 2004
    Messages:
    378
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Cleveland, Ohio
    /scripts/upcp --force will rebuild cPanel
     
  10. nikhilr

    nikhilr Registered

    Joined:
    Dec 24, 2004
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Same problem mysql restarting - freebsd

    Same mysql restarting problem. Server crashes.
    This happens when we try restarting mysql. But if mysql is started with --skip-grant-tables this does not happen.

    Regards
    SSR
     
  11. easyhoster1

    easyhoster1 Well-Known Member

    Joined:
    Sep 25, 2003
    Messages:
    659
    Likes Received:
    0
    Trophy Points:
    16
    We had the same problem and had to rebuild the server. Looks like the root MySQL password is corrupted and could not reset it from WHM. Can you access phpadmin from WHM?
     
  12. adtekinc

    adtekinc Registered

    Joined:
    Aug 18, 2002
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    same problem. any resolution ?

    thousands of mysql related processes running until it locks the server after 3 hours.

    :(
     
  13. Donna

    Donna BANNED

    Joined:
    Feb 15, 2003
    Messages:
    88
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Toronto, Canada
    /scripts/mysqlup --force

    reset pass via WHM then reboot.
     
  14. adtekinc

    adtekinc Registered

    Joined:
    Aug 18, 2002
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    /scripts/mysqlup --force

    so far, so good. up 30 mins and less than 100 processes.

    thanks donna - your a life saver :)
     
  15. Donna

    Donna BANNED

    Joined:
    Feb 15, 2003
    Messages:
    88
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Toronto, Canada
    Anytime.... took me a bit to sort out as I was trying to setup a server for a new client and no matter what else I did it wouldn't install mysql. Found that option fixed it rather easily :)
     
Loading...

Share This Page