Graphs are not populating, appears to be errors in polling

[blacksnow]

Hi guys,

So we updated PHP on the box we run Cacti to 5.3.28 (old still, I know). This is on Centos 5.10

In any case, once that was done it appears there are a bunch of errors with polling. Here's from the TS page:

Code: Select all

Poller Information
Interval	300
Type	cmd.php
Items	Action[0]: 448
Total: 448
Concurrent Processes	1
Max Threads	1
PHP Servers	1
Script Timeout	25
Max OID	10
Last Run Statistics	Time:42.7205 Method:cmd.php Processes:1 Threads:N/A Hosts:8 HostsPerProcess:8 DataSources:448 RRDsProcessed:0

And here's a snippet from the error log. This repeats for each port I belive.

Code: Select all

7/07/2014 10:48:52 AM - SYSTEM STATS: Time:20.7301 Method:cmd.php Processes:1 Threads:N/A Hosts:8 HostsPerProcess:8 DataSources:448 RRDsProcessed:0
07/07/2014 10:48:52 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select poller_output.output, poller_output.time, UNIX_TIMESTAMP(poller_output.time) as unix_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) "
07/07/2014 10:48:52 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select poller_output.output, poller_output.time, UNIX_TIMESTAMP(poller_output.time) as unix_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"
07/07/2014 10:48:52 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'145', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (312, 'traffic_in', '2014-07-07 10:48:50', '428527401')'
07/07/2014 10:48:52 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select poller_output.output, poller_output.time, UNIX_TIMESTAMP(poller_output.time) as unix_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"
07/07/2014 10:48:52 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select poller_output.output, poller_output.time, UNIX_TIMESTAMP(poller_output.time) as unix_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"
07/07/2014 10:48:52 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select poller_output.output, poller_output.time, UNIX_TIMESTAMP(poller_output.time) as unix_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"
07/07/2014 10:48:52 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select poller_output.output, poller_output.time, UNIX_TIMESTAMP(poller_output.time) as unix_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"
07/07/2014 10:48:52 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select poller_output.output, poller_output.time, UNIX_TIMESTAMP(poller_output.time) as unix_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"
07/07/2014 10:48:52 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select poller_output.output, poller_output.time, UNIX_TIMESTAMP(poller_output.time) as unix_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"

Any thoughts on the matter? Thanks in advance!

[cigamit]

I would first grab one of those SQL queries and run it yourself from the mysql command line. For that to fail, it would seem like one of the tables has gotten corrupted.

[Piratos]

I had the same problem and I fixed it by repairing the MySQL tables (see also http://www.thegeekstuff.com/2011/12/mysqlcheck/):

Check a Specific Table (poller_output) in a Database:

Code: Select all

mysqlcheck -c cacti poller_output -u root -p

Check All Tables in a Database:

Code: Select all

mysqlcheck -c cacti -u root -p

Repair Table (poller_output) using Mysqlcheck:

Code: Select all

mysqlcheck -r cacti poller_output -u root -p

Hope this will help anyone.

[lufecoma]

Thank you very much !!
It helped me a lot in my business...

[Hemanth]

Hey Thanks its worked, its helped me a lot in my work.