Monday, October 19, 2009

Zabbix mysql innodb backend shits itself on power outage

We had a power outage, and the mysql database that backs our zabbix install shat itself. The innodb tables couldn't recover themselves. I had to force an innodb recovery, which got me a running server, but I couldn't successfully do a mysqldump or select * into outfile because it failed on one table. I dumped everything else and tried a drop table on the corrupted table. The drop table didn't work, the mysql connection died after I hit enter and the table was still there. Eventually tried drop database with the same result. Yay.

Killed mysql and installed postgres.

No comments: