Poller Errors & Gaps in Graphs

[leetwanker]

First of all, I'm getting a huge amount of errors which I was able to find talked about on the forums, but the posts were over 2 years old and using a different version of cacti. These are the errors I'm getting:

It just keeps repeating this:

Code: Select all

 07/30/2008 08:09:55 PM - SYSTEM STATS: Time:292.9591 Method:cmd.php Processes:1 Threads:N/A Hosts:5 HostsPerProcess:5 DataSources:84 RRDsProcessed:42
07/30/2008 08:09:55 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
07/30/2008 08:05:04 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (89, 'traffic_in', '2008-07-30 20:05:03', '38910041')"
07/30/2008 08:05:03 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (89, 'traffic_out', '2008-07-30 20:05:03', '576373421')"

Also, I'm getting gaps in my graphs, here's a screenie:




Any help would be very appreciated!

Justin

[TheWitness]

Looks as though you have 2 crons running. That will bork your graphs to smitherenes.

TheWitness

[leetwanker]

I thought I was using the latest version but it turns out I was using 0.8.6j. I upgraded to 0.8.7b last night through suse's build service.

All the errors in the above post went away, YAY!

but.....

I've got new ones:

Code: Select all

 07/31/2008 04:25:20 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (89, 'traffic_out', '2008-07-31 16:25:20', '584966439')'
07/31/2008 04:25:20 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (89, 'traffic_in', '2008-07-31 16:25:20', '38914703')' 

There's one of these errors for all my data sources. Devices 48 to 89.

Code: Select all

07/31/2008 04:29:01 PM - POLLER: Poller[0] WARNING: Poller[0] Host[1] SNMP Time was not numeric

I'm also getting this once every round. If I run 'php cmd.php' from a user account or the root account, I get the same error.

[leetwanker]

I think I tracked down the cause of this error:

Code: Select all

POLLER: Poller[0] WARNING: Poller[0] Host[1] SNMP Time was not numeric

SNMP was turned on on localhost, once I turned snmp off on the localhost under Devices, the error went away. SNMP isn't supposed to be on for the local machine, right?

[arevelo]

I found the problem but I don't know how to resolve it. When I create a new graph in cacti on debug mode the last line of rrdtool's commands comes with an extra slash "\" that's the reason why when cacti tries to search rdd file it doesnt find it. If i run the same comands without this "\" from CLI the file is created and cacti shows me the graph.

#rrdtool create \
/opt/lampp/htdocs/cacti/rra/test.rrd \
-s 300 \
DS:escritorio:GAUGE:600:-10:60 \
DS:exterior:GAUGE:600:-10:60 \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MIN:0.5:1:600 \
RRA:MIN:0.5:6:700 \
RRA:MIN:0.5:24:775 \
RRA:MIN:0.5:288:797 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \ this is extra slash that don't let to create .rrd file
I dont want to create this file manually forever
now the question is : how can i remove this slash from cacti ?

The second questions is
how can I check if my poller.php is working? 'cause i run poller from cli and I don't have any answer It only shows me this:
[root@localhost cacti]# php poller.php
Content-type: text/html
X-Powered-By: PHP/4.3.9

I think this is the reason why my graph doesn't show me any data

[leetwanker]

I think there's at least three different modes you can put the poller reporting into. Errors only, Notifications?, and Debug?

Try turning some of these on in settings. Should give you what you're looking for.

FYI: my copy of cacti creates it's own .rrd files, upgrading to 0.8.7b fixed a lot of bugs for me.

Justin