Today I woke up because the Nagios used by our ISP sent me a SMS: something does not work well on one of the association servers. According to the SMS, the webserver was not responding. Ok, the webserver is never the cause of the problem, something else is going wrong.
Logged in over ssh, at least this works well. ps told me that the nightly database backup is hanging, a script which fills some tables is also waiting. MySQL shell does not really work. Disc space? Ok, enough free space.
Shutting down webserver and database, killed all scripts hanging around and restarted the db. After a while, I got an error mail:
| |
Nice …
Ok, Let’s repair the beast. myisamchk seems to work his way through the table, until I got this message:
| |
So this wannabe database just deleted 301 datasets for whatever reason. Nice to see how data integrity is not handled at all.
I’m happy at all that the new platform is coming around, betatest just started yesterday. It’s time to kick MySQL in the bin and use a real database.
Share: