Cacti不产生流量图，Mysql 数据表修损坏修复

hb120973135

　　今日Cacti不显示流量，有如下 告警信息：
　　

0/17/2012 10:26:38 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"

10/17/2012 10:26:37 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"

10/17/2012 10:26:36 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"

Mysql中数据表修复： #用REPAIR TABLE方式修复，语法：REPAIR TABLE 表名 [选项] #进入Mysql数据库： C:\AppServ\MySQL\bin>mysql -u root -p Enter password: ************** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 87 Server version: 5.0.45-community-nt-log MySQL Community Edition (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. #显示所有数据库： mysql> show databases; +--------------------+ | Database           | +--------------------+ | information_schema | | cacti              | | mysql              | | phpmyadmin         | | test               | +--------------------+ 5 rows in set (0.00 sec) mysql> #连接损坏表所在的数据库： mysql> use cacti; Database changed #查看当前连接的数据库： mysql> select database(); +------------+ | database() | +------------+ | cacti      | +------------+ 1 row in set (0.00 sec) # REPAIR TABLE修复数据表 mysql> REPAIR TABLE poller_item; +-------------------+--------+----------+----------+ | Table             | Op     | Msg_type | Msg_text | +-------------------+--------+----------+----------+ | cacti.poller_item | repair | status   | OK       | +-------------------+--------+----------+----------+ 1 row in set (0.02 sec) mysql> 修复成功。 如果修复失败，可以尝试用USE_FRM选项，例： mysql> REPAIR TABLE poller_item USE_FRM;