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 Crashed on several servers???

Discussion in 'General Discussion' started by DWHS.net, Jul 14, 2004.

  1. DWHS.net

    DWHS.net Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,569
    Likes Received:
    6
    Trophy Points:
    38
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    We had MySQL crash on several servers this morning, anyone know what caused this was there a update or something?

    Anyone else have MySQL crash this morning?

    Thanks, Charles
     
  2. kris1351

    kris1351 Well-Known Member

    Joined:
    Apr 18, 2003
    Messages:
    963
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Lewisville, Tx
    Interesting you posted that. We had one server hang to the point we had to console boot it around 3:40am this morning (cst). It was definately in the updates, but all services were shut down completely and mySQL was off the chart.
     
  3. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    765
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    N.W. Iowa
    what version are you running or where running prior to the update ??

    Mickalo
     
  4. tekdns

    tekdns Well-Known Member

    Joined:
    Jun 9, 2002
    Messages:
    100
    Likes Received:
    0
    Trophy Points:
    16
    +1

    Yes, my a servers MYSQL down.WHY?
    How to fix also.?
     
  5. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    765
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    N.W. Iowa
    did you restart MySQL ?
     
  6. DWHS.net

    DWHS.net Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,569
    Likes Received:
    6
    Trophy Points:
    38
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    That's how I fixed it, simple reboot fixed it up.

    This is listed in resourses usage:

    Top Process %CPU 2.1 /usr/bin/perl /scripts/realperlinstaller Net::AIM Net::SSLeay Archive::Tar Tree::MultiNode Tie::IxHash HTML::Entities Bundle::DBD::mysql CGI MD5 Digest::MD5 Mail::SpamAssassin Net::DNS Bundle::Interchange
    Top Process %CPU 1.5 /usr/bin/perl /scripts/ensurerpm2 --safe pine gd gd-devel gd-progs expect freetype freetype-devel gnupg lynx ucd-snmp ucd-snmp-devel ucd-snmp-utils wget sharutils bind bind-devel bind-utils openssl openssl-devel openssl-misc openssh openssh-server openssh-clients XFree86-devel XFree86-libs libgd1 libgd1-devel gd-utils perl-CPAN gcc libmysqlclient10-dev


    I havn't seen this before and it's on all servers so it must be connected.

    I was running 4.0.20-standard I believe.

    It doesn't seem to have a new version on the server.

    I just want to mak sure it's not a hacker messing around.
     
  7. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    765
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    N.W. Iowa
    from UPCP udates.

    there was some MySQL 4.0.20 rpm updates last nite, but shouldn't have caused any problems. It appears you had some rpm/perl module updates also. Unless problem persist, I wouldn't worry too much, but worth monitoring :)

    Mickalo
     
  8. DWHS.net

    DWHS.net Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,569
    Likes Received:
    6
    Trophy Points:
    38
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    Cool no worries at all.

    Thank you,
     
  9. kris1351

    kris1351 Well-Known Member

    Joined:
    Apr 18, 2003
    Messages:
    963
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Lewisville, Tx
    Yea, our one had to be rebooted. Couldn't do anything else otherwise. We do not do auto updates on Cpanel, but it does do all the dep checks each night as usual.
     
  10. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    765
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    N.W. Iowa
    Yea, that it does. If you don't want the upcp to run nitely, then simply remove it from the crontab file for root, or disable the upcp script, then when you want to run it manually, simply execute it from the command line. This does give you more control and able to trouble shoot faster.

    We setup our cronjob to run at 8pm each nite so I can monitor any problems that may arise, instead of the 4am it normally runs, or about that time :)

    Mickalo
     
  11. adapter

    adapter Well-Known Member
    PartnerNOC

    Joined:
    Sep 17, 2003
    Messages:
    391
    Likes Received:
    0
    Trophy Points:
    16
    sorry but how can i upgrade mysql to 4.0.20 ?

    thx
     
Loading...

Share This Page