Недавно перестал работать zabbix. Оказалось, что не поднимается база после перезагрузки сервера.
Проблема, как я понял в файле ibdata1, а конкретнее в таблице zabbix.history.
База поднимается только с параметром innodb_force_recovery, при этом пишет в лог:
140510 23:59:24 InnoDB: Page checksum 1056052232, prior-to-4.0.14-form checksum 2556165064
InnoDB: stored checksum 1056052232, prior-to-4.0.14-form stored checksum 2855696032
InnoDB: Page lsn 25 1497914638, low 4 bytes of lsn at page end 1494816398
InnoDB: Page number (if stored to page already) 4659,
InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0
InnoDB: Page may be a system page
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 4659.
InnoDB: You may have to recover from a backup.
InnoDB: It is also possible that your operating
InnoDB: system has corrupted its own file cache
InnoDB: and rebooting your computer removes the
InnoDB: error.
InnoDB: If the corrupt page is an index page
InnoDB: you can also try to fix the corruption
InnoDB: by dumping, dropping, and reimporting
InnoDB: the corrupt table. You can use CHECK
InnoDB: TABLE to scan your table for corruption.
InnoDB: See also http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
