错误描述&＃xff1a;打开cacti监控&＃xff0c;发现已经运行的转码机不产生流量&＃xff0c;即cacti监控所显示已经运行的转码机为宕机&＃xff0c;查看cacti日志发现error&＃xff0c;查资料解决此问题、

cacit监控无数据了&＃xff0c;查看日志&＃xff1a;

2014年05月03日 09:05:51 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:&＃39;145&＃39;, SQL:"INSERT INTO &＃96;cacti&＃96;.&＃96;syslog_hosts&＃96; (host) (SELECT DISTINCT host FROM &＃96;cacti&＃96;.&＃96;syslog_incoming&＃96;) ON DUPLICATE KEY UPDATE host&＃61;VALUES(host), last_updated&＃61;NOW()&＃39;
2014年05月03日 09:05:51 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:&＃39;145&＃39;, SQL:"DELETE FROM &＃96;cacti&＃96;.&＃96;syslog_incoming&＃96; WHERE status&＃61;90&＃39;
2014年05月03日 09:05:51 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:&＃39;145&＃39;, SQL:"INSERT INTO &＃96;cacti&＃96;.&＃96;syslog&＃96; (logtime, priority_id, facility_id, host_id, message) SELECT TIMESTAMP(&＃96;date&＃96;, &＃96;time&＃96;), priority_id, facility_id, host_id, message FROM (SELECT date, time, priority_id, facility_id, host_id, message FROM syslog_incoming AS si INNER JOIN syslog_facilities AS sf ON sf.facility&＃61;si.facility INNER JOIN syslog_priorities AS sp ON sp.priority&＃61;si.priority INNER JOIN syslog_hosts AS sh ON sh.host&＃61;si.host WHERE status&＃61;90) AS merge&＃39;

查mysql日志&＃xff1a;

140504 12:20:45 [ERROR] /usr/libexec/mysqld: Table &＃39;./cacti/syslog_incoming&＃39; is marked as crashed and should be repaired
140504 12:20:45 [ERROR] /usr/libexec/mysqld: Table &＃39;./cacti/syslog_incoming&＃39; is marked as crashed and should be repaired
140504 12:22:00 [ERROR] /usr/libexec/mysqld: Table &＃39;./cacti/syslog_incoming&＃39; is marked as crashed and should be repaired
140504 12:22:00 [ERROR] /usr/libexec/mysqld: Table &＃39;./cacti/syslog_incoming&＃39; is marked as crashed and should be repaired


#连接损坏表所在的数据库&＃xff1a;

mysql> use cacti;
Database changed
# REPAIR TABLE修复数据表
mysql> REPAIR TABLE poller_item;
&＃43;——————-&＃43;——–&＃43;———-&＃43;———-&＃43;
| Table             | Op     | Msg_type | Msg_text |
&＃43;——————-&＃43;——–&＃43;———-&＃43;———-&＃43;
| cacti.poller_item | repair | status   | OK
|
&＃43;——————-&＃43;——–&＃43;———-&＃43;———-&＃43;
1 row in set (0.02 sec)
mysql>
修复成功。
如果修复失败&＃xff0c;可以尝试用USE_FRM选项&＃xff0c;例&＃xff1a;
mysql> REPAIR TABLE poller_item USE_FRM;
由于表数量比较多&＃xff0c;使用脚本进行检查和修复



#!/bin/bash

#This script used by repair tables
mysql_host&＃61;localhost
mysql_user&＃61;root

database&＃61;cacti
tables&＃61;$(mysql -h$mysql_host -u$mysql_user $database -A -Bse "show tables")
for arg in $tables
do
check_status&＃61;$(mysql -h$mysql_host -u$mysql_user $database -A -Bse "check table $arg" | awk &＃39;{ print $4 }&＃39;)
if [ "$check_status" &＃61; "OK" ]
then
echo "$arg is ok"
else
echo $(mysql -h$mysql_host -u$mysql_user $database -A -Bse "repair table $arg")
fi
echo $(mysql -h$mysql_host -u$mysql_user $database -A -Bse "optimize table $arg")
done