Friday, June 12, 2015

Cacti " ./syslog/syslog_incoming' is marked as crashed and should be repaired

Error:
[ERROR] /usr/libexec/mysqld: Table './syslog/syslog_incoming' is marked as crashed and should be repaired

Solution:
mysqlcheck --auto-repair --databases syslog
mysqlcheck --auto-repair --databases cacti

#mysqlcheck --auto-repair --databases syslog -u root -p
syslog.syslog
warning : 2 clients are using or haven't closed the table properly
status : OK
syslog.syslog_alert OK
syslog.syslog_incoming
warning : Table is marked as crashed
warning : 2 clients are using or haven't closed the table properly
error : Record at pos: 1062960 is not remove-marked
error : record delete-link-chain corrupted
error : Corrupt
syslog.syslog_remove OK

Repairing tables

source

Related Posts:

0 comments:

Post a Comment