CACTI 不画图 ,报错 Poller[0] ERROR: SQL Assoc Failed,解决办法!

1、CACTI 不画图 类似报错 Poller[0] ERROR: SQL Assoc Failed!, Error:’1017′

2018年4月09日 14:30:06 PM - 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) "

If you can not fix the error with poller_output table not show:

Just run mysql, use database “cacti” and 
+ mySQL>select count(*) from poller_output; 
If too much data, run query: 
+ mysql> truncate table poller_output; 
And it worked for my issue. 
Good luck, 
Manh Dung


[root@monitor ~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 97
Server version: 5.1.52 Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use "cacti" 
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select count(*) from poller_output; 
ERROR 145 (HY000): Table './cacti/poller_output' is marked as crashed and should be repaired
mysql> truncate table poller_output;
Query OK, 0 rows affected (0.02 sec)

mysql> select count(*) from poller_output; 
| count(*) |
| 0 |
1 row in set (0.00 sec)