MySQL Crashed on several servers???

[WebHostPro]

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

 

[kris1351]

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.

 

[mickalo]

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

what version are you running or where running prior to the update ??

Mickalo

 

[tekdns]

+1

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

 

[mickalo]

did you restart MySQL ?

 

[WebHostPro]

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.

 

[mickalo]

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

 

[WebHostPro]

Cool no worries at all.

Thank you,

 

[kris1351]

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.

 

[mickalo]

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.

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

 

[adapter]

sorry but how can i upgrade mysql to 4.0.20 ?

thx