HQY 一个和谐有爱的空间

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

2013年10月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)

2、常见不出图或有图无数据解决办法之二：登录CactiEZ中文版V10，点击“工具”菜单中的“系统工具”，然后点击“重建采集器缓存”。几分钟之后再查看是否正常，该办法能解决大多数问题。