broken graphs and sql errors

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
jbl22
Posts: 9
Joined: Tue Sep 27, 2005 10:44 pm

broken graphs and sql errors

Post by jbl22 »

I installed rrdtool-1.0.50-1.2, cacti-0.8.6h, php-snmp-5.04-10.5, mysql-4.1.16-1, httpd-2.0.54-10.3, php-5.04-10.5, net-snmp-5.2.1.2 on FC4. I have 1 crontab entry for poller.php. When I look at my graphs, there are several breaks in the graph at random times throughout the day. I ran debug mode in cacti and found these entries in the log....

02/22/2006 01:15:05 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
02/22/2006 01:15:07 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (4,'mem_swap','2006-02-22 01:15:05','1310712')"
02/22/2006 01:15:07 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (5,'','2006-02-22 01:15:05','1min:0.19 5min:0.09 10min:0.02')"
02/22/2006 01:15:07 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (6,'users','2006-02-22 01:15:05','1')"
02/22/2006 01:15:07 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (8,'5min_cpu','2006-02-22 01:15:06','6')"
02/22/2006 01:15:07 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (7,'proc','2006-02-22 01:15:05','110')"
02/22/2006 01:15:07 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (9,'traffic_out','2006-02-22 01:15:06','508851891')"
02/22/2006 01:15:07 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (10,'traffic_out','2006-02-22 01:15:06','4040386989')"
02/22/2006 01:15:08 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (11,'traffic_out','2006-02-22 01:15:06','4122315709')"
02/22/2006 01:15:08 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (12,'traffic_out','2006-02-22 01:15:06','1137509765')"
02/22/2006 01:15:08 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (10,'traffic_in','2006-02-22 01:15:06','3343239143')"
02/22/2006 01:15:08 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (11,'traffic_in','2006-02-22 01:15:06','974089592')"
02/22/2006 01:15:08 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (12,'traffic_in','2006-02-22 01:15:06','2792534615')"
02/22/2006 01:19:56 AM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
02/22/2006 01:19:56 AM - SYSTEM STATS: Time:292.4433 Method:cmd.php Processes:3 Threads:N/A Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:1
02/22/2006 01:20:04 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
02/22/2006 01:20:07 AM - SYSTEM STATS: Time:4.1491 Method:cmd.php Processes:3 Threads:N/A Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:7
02/22/2006 01:25:05 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
02/22/2006 01:29:56 AM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
02/22/2006 01:29:56 AM - SYSTEM STATS: Time:292.7428 Method:cmd.php Processes:3 Threads:N/A Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:11
02/22/2006 01:30:05 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
02/22/2006 01:30:07 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (8,'5min_cpu','2006-02-22 01:30:06','7')"
02/22/2006 01:30:07 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (9,'traffic_out','2006-02-22 01:30:06','516248297')"
02/22/2006 01:30:07 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (9,'traffic_in','2006-02-22 01:30:06','186659770')"
02/22/2006 01:30:07 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (10,'traffic_out','2006-02-22 01:30:06','4048271653')"
02/22/2006 01:30:07 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (11,'traffic_out','2006-02-22 01:30:06','4269291451')"
02/22/2006 01:30:07 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (12,'traffic_out','2006-02-22 01:30:06','1143598855')"
02/22/2006 01:30:07 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (10,'traffic_in','2006-02-22 01:30:06','3360056185')"
02/22/2006 01:30:07 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (11,'traffic_in','2006-02-22 01:30:06','997227054')"
02/22/2006 01:30:07 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (12,'traffic_in','2006-02-22 01:30:06','2802528482')"
02/22/2006 01:34:56 AM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
02/22/2006 01:34:56 AM - SYSTEM STATS: Time:293.4164 Method:cmd.php Processes:3 Threads:N/A Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:1

any help offered would be greatly appreciated.

JBL
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

Perhaps upping of MySql Connection limit needed?
Reinhard
Top
jbl22
Posts: 9
Joined: Tue Sep 27, 2005 10:44 pm

Post by jbl22 »

are you speaking of max_connections in mysql?

JBL
Top
jbl22
Posts: 9
Joined: Tue Sep 27, 2005 10:44 pm

Post by jbl22 »

also have this entry in the mail folder:

/bin/bash: line 1: 21159 Segmentation fault php /var/www/html/cacti/poller.php >/dev/null 2>&1
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

This is no good. Please try to run poller.php as cactiuser from cli

Code: Select all

php poller.php
. Actually, you're using cmd.php. If possible, please try cactid instead and tell us your findings
Reinhard
Top
jbl22
Posts: 9
Joined: Tue Sep 27, 2005 10:44 pm

Post by jbl22 »

Thanks for your help lvm..

I installed cactid tonight but I still have the issue of the graphs breaking up.

this is the output after 1 polling ...

02/27/2006 08:25:05 PM - CACTID: Poller[0] Host[1] ERROR: Empty result [127.0.0.1]: 'perl /var/www/html/cacti/scripts/linux_memory.pl MemFree:'
02/27/2006 08:25:05 PM - CACTID: Poller[0] Host[1] DS[3] WARNING: Result from SCRIPT not valid. Partial Result: ...
02/27/2006 08:25:05 PM - CACTID: Poller[0] Host[1] ERROR: Empty result [127.0.0.1]: 'perl /var/www/html/cacti/scripts/linux_memory.pl SwapFree:'
02/27/2006 08:25:05 PM - CACTID: Poller[0] Host[1] DS[4] WARNING: Result from SCRIPT not valid. Partial Result: ...
02/27/2006 08:25:05 PM - CACTID: Poller[0] Host[1] ERROR: Empty result [127.0.0.1]: 'perl /var/www/html/cacti/scripts/loadavg_multi.pl'
02/27/2006 08:25:05 PM - CACTID: Poller[0] Host[1] DS[5] WARNING: Result from SCRIPT not valid. Partial Result: ...
02/27/2006 08:25:05 PM - CACTID: Poller[0] Host[1] ERROR: Empty result [127.0.0.1]: 'perl /var/www/html/cacti/scripts/unix_processes.pl'
02/27/2006 08:25:05 PM - CACTID: Poller[0] Host[1] DS[7] WARNING: Result from SCRIPT not valid. Partial Result: ...
02/27/2006 08:25:05 PM - CACTID: Poller[0] Host[1] ERROR: Empty result [127.0.0.1]: 'perl /var/www/html/cacti/scripts/unix_users.pl'
02/27/2006 08:25:05 PM - CACTID: Poller[0] Host[1] DS[6] WARNING: Result from SCRIPT not valid. Partial Result: ...
02/27/2006 08:25:05 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Duplicate entry '3-mem_buffers-2006-02-27 20:25:04' for key 1'

any ideas?
Top
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

You must use the full path for programs cactid runs. i.e. /usr/bin/perl instead of perl. As stated on the Cactid download page: http://www.cacti.net/cactid_download.php
Top
jbl22
Posts: 9
Joined: Tue Sep 27, 2005 10:44 pm

Post by jbl22 »

Made the changes for the paths to the binaries. I stiil have broken graphs.

03/01/2006 10:00:05 AM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Duplicate entry '3-mem_buffers-2006-03-01 10:00:04' for key 1'
03/01/2006 09:59:55 AM - SYSTEM STATS: Time:292.3279 Method:cactid Processes:3 Threads:1 Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:10
03/01/2006 09:59:55 AM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/01/2006 09:54:56 AM - SYSTEM STATS: Time:293.2281 Method:cactid Processes:3 Threads:1 Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:0
03/01/2006 09:54:56 AM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/01/2006 09:50:05 AM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Duplicate entry '3-mem_buffers-2006-03-01 09:50:04' for key 1'
03/01/2006 09:49:56 AM - SYSTEM STATS: Time:292.5827 Method:cactid Processes:3 Threads:1 Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:5
03/01/2006 09:49:56 AM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/01/2006 09:45:05 AM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Duplicate entry '3-mem_buffers-2006-03-01 09:45:04' for key 1'
03/01/2006 09:44:59 AM - SYSTEM STATS: Time:292.7244 Method:cactid Processes:3 Threads:1 Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:0
03/01/2006 09:44:59 AM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/01/2006 09:40:09 AM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Duplicate entry '9-traffic_in-2006-03-01 09:40:08' for key 1'
03/01/2006 09:39:56 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"
03/01/2006 09:39:56 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:293.0108 Method:cactid Processes:3 Threads:1 Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:0')"
03/01/2006 09:39:56 AM - SYSTEM STATS: Time:293.0108 Method:cactid Processes:3 Threads:1 Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:0
03/01/2006 09:39:56 AM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/01/2006 09:39:56 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)"
03/01/2006 09:39:56 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39: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)"
03/01/2006 09:39:55 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39: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)"
03/01/2006 09:39:54 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:53 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)"
03/01/2006 09:39:53 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:52 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)"
03/01/2006 09:39:52 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:51 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)"
03/01/2006 09:39:51 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:50 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)"
03/01/2006 09:39:50 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:49 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)"
03/01/2006 09:39:49 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:48 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)"
03/01/2006 09:39:48 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:47 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)"
03/01/2006 09:39:47 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:46 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)"
03/01/2006 09:39:46 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:45 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)"
03/01/2006 09:39:45 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:44 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)"
03/01/2006 09:39:44 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:43 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)"
03/01/2006 09:39:43 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:42 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)"
03/01/2006 09:39:42 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:41 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)"
03/01/2006 09:39:41 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:40 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)"
03/01/2006 09:39:40 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:39 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)"
03/01/2006 09:39:39 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:38 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)"
03/01/2006 09:39:38 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:37 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)"
03/01/2006 09:39:37 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:36 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)"
03/01/2006 09:39:36 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:35 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)"
03/01/2006 09:39:35 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:34 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)"
03/01/2006 09:39:34 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:33 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)"
03/01/2006 09:39:33 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:32 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)"
03/01/2006 09:39:32 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:31 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)"
03/01/2006 09:39:31 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:30 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)"
03/01/2006 09:39:30 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:29 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)"
03/01/2006 09:39:29 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:28 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)"
03/01/2006 09:39:28 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:27 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)"
03/01/2006 09:39:27 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:26 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)"
03/01/2006 09:39:26 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:25 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)"
03/01/2006 09:39:25 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:24 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)"
03/01/2006 09:39:24 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:23 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)"
03/01/2006 09:39:23 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:22 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)"
03/01/2006 09:39:22 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:21 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)"
03/01/2006 09:39:21 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:20 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)"
03/01/2006 09:39:20 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:19 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)"
03/01/2006 09:39:19 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:18 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)"
03/01/2006 09:39:18 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:17 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)"
03/01/2006 09:39:17 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:16 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)"
03/01/2006 09:39:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:15 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)"
03/01/2006 09:39:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:14 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)"
03/01/2006 09:39:14 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:13 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)"
03/01/2006 09:39:13 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:11 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)"
03/01/2006 09:39:11 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:10 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)"
03/01/2006 09:39:10 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:09 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)"
03/01/2006 09:39:09 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:08 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)"
03/01/2006 09:39:08 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:07 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)"
03/01/2006 09:39:07 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:06 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)"
03/01/2006 09:39:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:05 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)"
03/01/2006 09:39:05 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:04 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)"
03/01/2006 09:39:04 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:03 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)"
03/01/2006 09:39:03 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
03/01/2006 09:39:02 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)"
[/img]
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

The first few messages are often seen in installation that run 2 different crontabs with a cronjob for cacti in each of them. RPM installation often installs /etc/cron.d/cacti and if you put the poller in /etc/crontab or into crontab of user root or cactiuser you'll have two of them. This will not work well. So please search for this issue.
Reinhard
Top
jbl22
Posts: 9
Joined: Tue Sep 27, 2005 10:44 pm

Post by jbl22 »

removed the cronjob entry from etc/cron.d and graphing did ok for a while. The graphs are still broken. I checked the log and it is showing a duplicate entry again. Is there anywhere else I should look for a cronjob entry? What else would cause duplicate entries?

Latest log..

03/01/2006 09:54:56 PM - SYSTEM STATS: Time:292.7712 Method:cactid Processes:3 Threads:1 Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:1
03/01/2006 09:54:56 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/01/2006 09:50:05 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Duplicate entry '3-mem_buffers-2006-03-01 21:50:04' for key 1'
03/01/2006 09:49:56 PM - SYSTEM STATS: Time:293.5080 Method:cactid Processes:3 Threads:1 Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:5
03/01/2006 09:49:56 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/01/2006 09:44:56 PM - SYSTEM STATS: Time:292.7570 Method:cactid Processes:3 Threads:1 Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:15
03/01/2006 09:44:56 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/01/2006 09:39:56 PM - SYSTEM STATS: Time:293.5136 Method:cactid Processes:3 Threads:1 Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:10
03/01/2006 09:39:56 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/01/2006 09:34:56 PM - SYSTEM STATS: Time:292.3700 Method:cactid Processes:3 Threads:1 Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:5
03/01/2006 09:34:56 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/01/2006 09:30:06 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Duplicate entry '9-traffic_in-2006-03-01 21:30:05' for key 1'
03/01/2006 09:30:05 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Duplicate entry '3-mem_buffers-2006-03-01 21:30:04' for key 1'
03/01/2006 09:29:55 PM - SYSTEM STATS: Time:292.3376 Method:cactid Processes:3 Threads:1 Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:15
03/01/2006 09:29:55 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/01/2006 09:24:56 PM - SYSTEM STATS: Time:293.4504 Method:cactid Processes:3 Threads:1 Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:1
03/01/2006 09:24:56 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/01/2006 09:19:56 PM - SYSTEM STATS: Time:292.3721 Method:cactid Processes:3 Threads:1 Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:0
03/01/2006 09:19:56 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/01/2006 09:15:05 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Duplicate entry '3-mem_buffers-2006-03-01 21:15:04' for key 1'
03/01/2006 09:14:56 PM - SYSTEM STATS: Time:293.3680 Method:cactid Processes:3 Threads:1 Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:5
03/01/2006 09:14:56 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/01/2006 09:09:55 PM - SYSTEM STATS: Time:292.3537 Method:cactid Processes:3 Threads:1 Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:15
03/01/2006 09:09:55 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/01/2006 09:04:56 PM - SYSTEM STATS: Time:293.3076 Method:cactid Processes:3 Threads:1 Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:10
03/01/2006 09:04:56 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/01/2006 08:59:56 PM - SYSTEM STATS: Time:293.3027 Method:cactid Processes:3 Threads:1 Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:5
03/01/2006 08:59:56 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/01/2006 08:54:55 PM - SYSTEM STATS: Time:292.3524 Method:cactid Processes:3 Threads:1 Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:10
03/01/2006 08:54:55 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
Attachments
Lan graph
Lan graph
lan2.JPG (38.35 KiB) Viewed 2060 times
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

Please change Settings -> Logging Level to DEBUG for some polling intervals and check log/cacti.log for more errors. Do not forget to reset logging to standard
Reinhard
Top
jbl22
Posts: 9
Joined: Tue Sep 27, 2005 10:44 pm

Post by jbl22 »

Inconsistent today with the graphs. Worked fine for as long as 3 hours and as short as 15 min. Ran fine from 4:05 - 6:35(see log 1).

stopped graphing from 6:35 - 6:50 (see log 2).

started graphing again at 6:50 (see log 3)
Attachments
cactilog1.txt
(43.07 KiB) Downloaded 105 times
cactilog3.txt
(101.66 KiB) Downloaded 87 times
cactilog2.txt
(92.12 KiB) Downloaded 81 times
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

Please try upgrading to latest cactid. cactid-0.8.6f is know to be buggy
Reinhard
Top
jbl22
Posts: 9
Joined: Tue Sep 27, 2005 10:44 pm

Post by jbl22 »

I am running cactid-0.8.6g-1
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

jbl22 wrote:I am running cactid-0.8.6g-1
Sh... cactid-0.8.6g had a "bug" with the version number so it shows 0.8.6f (see logs). So I'm sorry but I am at a loss. Would need TheWitness (=author of cactid)
Reinhard
Top
Post Reply

Return to “Help: General”

Who is online

Users browsing this forum: No registered users and 1 guest