I just switched over from using cmp.php to cactid for faster polling. The speed and reduced CPU load of cactid are great!! However, I am getting drop-outs during the course of the day. Here is my enviroment:
OS: Solaris 8
Cacti: cacti-0.8.6h
PHP: PHP 4.3.0
MySQL: 4.0.21
RRDTool: RRDtool 1.2.11
Apache: apache_1.3.27
Cactid: cacti-cactid-0.8.6g
Here is a screen-shot of the drop-outs:
I turned on debuging for the Poller and here is the context when I see the drop-outs. They can be matched up to drop-outs on the graphs above:
09/17/2006 10:20:04 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.loca
l_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_outpu
t.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)"
09/17/2006 10:20:04 AM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
09/17/2006 10:20:04 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NO
W(), NOW())"
9/17/2006 10:45:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '22': 'SELECT action,hostname,snmp_community,snmp_version,snmp_user
name,snmp_password,rrd_name,rrd_path,arg1,arg2,arg3,local_data_id,rrd_num,snmp_port,snmp_timeout FROM poller_item WHERE host_id=0 OR
DER BY arg1'
09/17/2006 10:45:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '22': OK
09/17/2006 10:45:02 AM - CACTID: Poller[0] Host[0] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
09/17/2006 10:45:02 AM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
09/17/2006 10:45:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NO
W(), NOW())"
09/17/2006 10:45:03 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
09/17/2006 11:00:02 AM - CACTID: Poller[0] CACTID: Initializing PHP Script Server
09/17/2006 11:00:02 AM - CACTID: Poller[0] DEBUG: SS[0] PHP Script Server Routine Starting
09/17/2006 11:00:02 AM - CACTID: Poller[0] DEBUG: SS[0] PHP Script Server About to FORK Child Process
09/17/2006 11:00:02 AM - CACTID: Poller[0] DEBUG: SS[0] PHP Script Server Child FORK Success
09/17/2006 11:00:02 AM - PHPSVR: Poller[0] DEBUG: SERVER: cactid
09/17/2006 11:00:02 AM - PHPSVR: Poller[0] DEBUG: GETCWD: /usr/local/cacti-cactid-0.8.6g
09/17/2006 11:00:02 AM - PHPSVR: Poller[0] DEBUG: DIRNAM: /usr/local/cacti-0.8.6h
09/17/2006 11:00:02 AM - PHPSVR: Poller[0] DEBUG: FILENM: /usr/local/cacti-0.8.6h/script_server.php
09/17/2006 11:00:02 AM - PHPSVR: Poller[0] PHP Script Server has Started - Parent is cactid
09/17/2006 11:00:02 AM - CACTID: Poller[0] DEBUG: SS[0] Confirmed PHP Script Server running
09/17/2006 11:00:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '21': 'SELECT id FROM host WHERE disabled='' AND id BETWEEN 0 AND 2
5 ORDER BY id'
09/17/2006 11:00:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '21': OK
09/17/2006 11:00:02 AM - CACTID: Poller[0] DEBUG: Initial Value of Active Threads is 0
09/17/2006 11:00:02 AM - CACTID: Poller[0] DEBUG: In Poller, About to Start Polling of Host
09/17/2006 11:00:02 AM - CACTID: Poller[0] MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
09/17/2006 11:00:02 AM - CACTID: Poller[0] MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
09/17/2006 11:00:02 AM - CACTID: Poller[0] DEBUG: Valid Thread to be Created
09/17/2006 11:00:02 AM - CACTID: Poller[0] DEBUG: The Value of Active Threads is 1
09/17/2006 11:00:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '22': 'SELECT action,hostname,snmp_community,snmp_version,snmp_user
name,snmp_password,rrd_name,rrd_path,arg1,arg2,arg3,local_data_id,rrd_num,snmp_port,snmp_timeout FROM poller_item WHERE host_id=0 OR
DER BY arg1'
09/17/2006 11:00:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '22': OK
09/17/2006 11:00:02 AM - CACTID: Poller[0] Host[0] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
09/17/2006 11:00:02 AM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
09/17/2006 11:00:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NO
W(), NOW())"
09/17/2006 11:00:03 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
Any ideas on this?
NetGeek
