Function does not exist - runaway error

[neteru]

I'll run it again tonight, or early morning tomorrow.

[neteru]

LOW Logging level... including previous iteration.

[neteru]

LOW Logging level... including previous iteration....

... and again since I missed the error about the .log extension...

[TheWitness]

Looks like the warnings are gone. Can you confirm? Why are you running for 292 seconds? Is something crashing?

TheWitness

[neteru]

These warnings?

10/18/2006 08:00:32 AM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Duplicate entry '74-traffic_in-2006-10-18 08:00:22' for key 1'
10/18/2006 08:00:35 AM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Duplicate entry '256-traffic_in-2006-10-18 08:00:28' for key 1'
10/18/2006 08:00:37 AM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Duplicate entry '297-traffic_in-2006-10-18 08:00:33' for key 1'
10/18/2006 08:00:37 AM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Duplicate entry '285-traffic_in-2006-10-18 08:00:33' for key 1'

.... no, they are still there. Or were you talking about somethign else this whole time?

As for exceeding the max runtime I don't see anything at low log levels, but get this in the logs at debug (the two sql queries are repeated ad naseum until the script is killed):
======================
<snipped many many more sql assoc queries>
10/19/2006 08:34:54 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
10/19/2006 08:34:54 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "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/19/2006 08:34:54 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
10/19/2006 08:34:54 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "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/19/2006 08:34:55 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
10/19/2006 08:34:55 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "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/19/2006 08:34:55 AM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
10/19/2006 08:34:55 AM - SYSTEM STATS: Time:292.9340 Method:cactid Processes:2 Threads:10 Hosts:112 HostsPerProcess:56 DataSources:995 RRDsProcessed:1289
10/19/2006 08:34:55 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:292.9340 Method:cactid Processes:2 Threads:10 Hosts:112 HostsPerProcess:56 DataSources:995 RRDsProcessed:1289')"
10/19/2006 08:34:55 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
10/19/2006 08:34:55 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"
10/19/2006 08:34:55 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "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"
===========================================

[TheWitness]

When you goto Cactid 0.8.6i those messages will go away.

TheWitness

[neteru]

Alright, maybe this was in the release notes, maybe not....

I recalled when I was looking at the list of files from the i rpm that it inserted a cron file in /etc/cron.d. I also had the 5 min polling entry in my /etc/crontab file.

Removed the /etc/crontab entry and not the duplicate mysql notifications are gone. Also, performance in much enhanced. Your sporadic appearances of the mysql errors may be common to those running the rhel rpms, or perhaps some of the rpm builds in general.

It just hit me as I was thinking about all this... I was noticing large performance differences in command line execution of the poller/cactid and what I was seeing when cacti actually polled the elements.

About 7s with cactid -R
About 25s with cactid from the command line.
About 1.5 min or so running php poller.php from the command line, building all the graphs.
Exceeding the 5 minutes of allowed time when running through cacti...

I think we can close this "ticket". Thanks for all the help.

[TheWitness]

Double Cron's have been more prevelent in the last year or so. Many RPM's are doing all the setup now and therefore, when new users follow the instructions, they double work.

TheWitness

[gandalf]

I'm on the run adding this to my "NaN" thingy
Reinhard

[y-watanabe]

Hi !

If possible, I would like to know the root cause of this issue.

10/12/2006 10:30:10 AM - CACTID: Poller[0] MYSQL: Connection Failed: Too many connections
(fork)10/12/2006 10:30:10 AM - PHPSVR: Poller[0] WARNING: PHP Script File to be included, does not exist
10/12/2006 10:30:10 AM - PHPSVR: Poller[0] WARNING: Function does not exist
10/12/2006 10:30:10 AM - PHPSVR: Poller[0] WARNING: PHP Script File to be included, does not exist

My guess is when php_close is called after "Too many connections" occured ,
it seems that the quit signal to the child process ,"script_server.php", is not behaving as expected.
The parent process , cactid, is throws a invalid signal, which is " " or "\r\n", and the script_server.php
is looping forever.

I would appreciate if people in this forum can take time to confirm my thought.

Thanks,
Yu

[gandalf]

Please increase connections in /etc/my.ini and restart mysql
R.