I was helping out http://www.pmi-sfbac.org whose web site was down.
The server was being unresponsive, and Larry Van Cantfort (the Director of Operations for PMI SFBAC) sent me this clue:
It appears that httpd has a lot of running processes and when I try to kill them I am unable to. THis is causing the server to sloooow way down. There are also error messages from mysqld with a corrupt table:

I couldn’t even get into the control panel to get things going, so the cleanest approach was to simply rebuild the server.
So I shut down the database and started to try and get it backed up so we’d at least save all the hard work of the volunteers.
So I tried to run the dump, with the following command that I got from the Parallels support site:

But that gave me the same error:

A quick Google search and I found the “fix” for this is to run a repair on the tables: http://www.daveperrett.com/articles/2009/06/18/mysql-table-is-marked-as-crashed/

That fixed the issue, and I was able to create the “dumpall.sql”.

Once I had ALL of the tables fixed, I simply rebuilt the server and migrated it into a new database as described in the Parallels KB article mentioned above (a lot more steps to make sure the backup was good, but once it was the newly imaged server was able to run without incident).

Enhanced by Zemanta

Recently after an upgrade of my Plesk panel, my web site was down.

In fact ALL of the domains I host on that particular cloud server were not working. A quick call to 1and1’s server guys and it appeared that there was some step in the upgrade process that failed.

They had it fixed in a moment, and then went the extra step to send me the command to fix this myself in the future:

/usr/local/psa/admin/bin/httpdmng –reconfigure-all

That simple command reset all the server config files and got all of the domains working again.

A huge thanks to the 1and1 Server Support guys and Khristian Byrd specifically !!!

Enhanced by Zemanta