[Maia-users] web pages hang on maia, forced to reboot server. ..

[Robert LeBlanc]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Kurt Buff wrote:

> OK - I've looked at the log (/var/db/mysql/zmx1.zetron.com.err), and find
> the follwing from the most recent two reboots. I'm not seeing anything that
> tells me what happened, but that may be due to my inexperience. Prior to the
> 24th, the last message in the error log is from the 18th. Are the logs below
> indicating any particular kind of corruption? Is the error logging in MySQL
> set high enough to tell, and if not, how do I set it higher?

The log excerpts you posted look essentially fine.  They show that your
server (or at least mysqld) shut down uncleanly on a couple of occasions
and had some cleanup to do at startup, but from the look of it the
cleanup was straightforward and successful both times.  This doesn't
look like a corruption problem--in a corruption scenario you'd see the
server try the cleanup at startup and fail, shut down and restart
itself, try the cleanup at startup and fail, shut down and restart
itself, and so on, filling your error log with such messages until you
eventually run out of disk space in /var/log and that would finally get
your attention ;)

On the other hand, if you don't know what caused mysqld to improperly
shut itself down on those two occasions, that's probably the next thing
to investigate.  Was the server powered off without a clean shutdown?
Power failure?  Did someone do a "kill -9" on the mysqld process for
some reason?  You might want to check some of your other system logs for
events that occurred around the same time as these two incidents, to see
if they might have been a side-effect of something else going on in
another application.

- --
Robert LeBlanc <rjl at renaissoft.com>
Renaissoft, Inc.
Maia Mailguard <http://www.maiamailguard.com/>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)

iD8DBQFGrqWmGmqOER2NHewRAi6BAKCjqoqluSva48SfbGnE6JHA07DU3QCfRY3q
HsN/Bw/FmnN17WMWaGpbQkk=
=N6xW
-----END PGP SIGNATURE-----