Poller error with PHP Script Server

[rxhz]

I notice that Thold is not updating its information, and the "Last Poll: " time reported is not correct. Also, when I get to any of the devices, the graphs are empty.

I went to cacti.log and I saw these messages:

02/14/2008 10:32:10 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'2002', 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"
02/14/2008 10:47:44 AM - POLLER: Poller[0] WARNING: Cron is out of sync with the Poller Interval! The Poller Interval is '300' seconds, with a maximum of a '300' second Cron, but 963 seconds have passed since the last poll!
02/14/2008 10:48:49 AM - CACTID: Poller[0] WARNING: SS[0] The PHP Script Server did not respond in time and will therefore be restarted
02/14/2008 10:49:14 AM - CACTID: Poller[0] WARNING: SS[0] The PHP Script Server did not respond in time and will therefore be restarted
02/14/2008 10:49:39 AM - CACTID: Poller[0] WARNING: SS[0] The PHP Script Server did not respond in time and will therefore be restarted
02/14/2008 10:50:05 AM - CACTID: Poller[0] WARNING: SS[0] The PHP Script Server did not respond in time and will therefore be restarted
02/14/2008 10:50:30 AM - CACTID: Poller[0] WARNING: SS[0] The PHP Script Server did not respond in time and will therefore be restarted
02/14/2008 10:50:55 AM - CACTID: Poller[0] WARNING: SS[0] The PHP Script Server did not respond in time and will therefore be restarted
02/14/2008 10:51:20 AM - CACTID: Poller[0] WARNING: SS[0] The PHP Script Server did not respond in time and will therefore be restarted
02/14/2008 10:51:45 AM - CACTID: Poller[0] WARNING: SS[0] The PHP Script Server did not respond in time and will therefore be restarted
02/14/2008 10:52:10 AM - CACTID: Poller[0] WARNING: SS[0] The PHP Script Server did not respond in time and will therefore be restarted
02/14/2008 10:52:35 AM - CACTID: Poller[0] WARNING: SS[0] The PHP Script Server did not respond in time and will therefore be restarted
02/14/2008 10:52:43 AM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.


Any ideas?

I am using Cacti version 0.8.7a.

[CyrilP]

Hey rxhz,

Do you resolved your problem ? Because I had the same this morning :-/
After a reboot, the problem has disapear but what are its causes and what can I do to fix the problem permanently?

My version of cacti is the 0.8.7b, the latest one.

Thx for yours replies,

Cyril

[CyrilP]

My problem are now recurring and no data is collected

Somebody can help me or give me some ideas ?

Thx

[rchu]

All you need to do is to increase the max concurrent processes in the poller settings from 1 to 5 or higher. You could also increase the other performance parameters on this page such as threads per process to see if it makes the problem disappear. It works for me.