El error:
Opciones / SQL-ERR ‘Table ‘Logs’ is marked as crashed and should be repaired’, statement was ‘select Level, count(Level) as LevelCount from Logs where Level < 0 and from_unixtime(TimeKey) + interval 900 second > now() group by Level order by Level asc’
zmfix -a
myisamchk –force –update-state /var/lib/mysql/zm/*.MYI
Desde el CLI de MySQL:
CHECK TABLE Logs;
REPAIR TABLE Logs;
https://dev.mysql.com/doc/refman/5.0/en/myisam-repair.html
Can’t write log entry ‘insert into Logs ( TimeKey, Component, Pid, Level, Code, Message, File, Line ) values ( 1377274084.174016, ‘web_php’, 13130, -3, ‘FAT’, ‘SQL-ERR \’Table \’./zm/Logs\’ is marked as crashed and last (automatic?) repair failed\’, statement was \’select Level, count(Level) as LevelCount from Logs where Level < 0 and from_unixtime(TimeKey) + interval 900 second > now() group by Level order by Level asc\”, ‘/usr/share/zoneminder/includes/database.php’, 78 )’: Table ‘./zm/Logs’ is marked as crashed and last (automatic?) repair failed
¿Cúal es la recomendación para poder limpiar el sistema de esta falla?
Recomiendo hacer esto:
service zoneminder stop
service mysql stopmysql -u root -p -D zm
# myisamchk –force –update-state /var/lib/mysql/zm/*.MYIservice zoneminder start
service mysql start