Setting Max Value in Data Templates - resulting NaN values

[calvin419]

Hello, and thanks in advance for any help somebody can offer.

Cacti is not setting the DS max values appropriately to the value specified in my Data Template. I'm aware and understand how to change these values after the fact with rrdtool, however I'd like to understand why and how to enforce Cacti to set the correct value when new RRD files are created.

Cacti version: 0.8.7g
OS: CentOS 5.6 64-bit
Net-snmp: 5.3.2.2-9
Rrdtool: 1.4.4-1

Data Template name: Interface Traffic

* traffic_in
- Maximum Value: 100000000000
- Use Per-Data Source Value: not selected
* traffic_out
- Maximum Value: 100000000000
- Use Per-Data Source Value: not selected

I have made some custom changes to my associated Data Queries I am using "In/Out Bits with 95th Percentile". I am also using 64-bit counters.

Associated Data Templates
Data Template - Interface - Traffic
Data Source - traffic_in: ifHCInOctets
Data Source - traffic_out: ifHCOutOctets

Suggested Values
Data Template - Interface - Traffic
name |host_description| - Traffic - |query_ifName|
name |host_description| - Traffic - |query_ifDescr|
rrd_maximum ||query_ifHighSpeed|*10000000|
rrd_maximum |query_ifSpeed|

For my testing purposes, I am creating graphs for a GigabitEthernet interface and a TenGigabitEthernet interface.

Here is the associated cacti log with debugging enabled:

08/09/2011 02:25:02 PM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '301', Max Runtime '298', Poller Runs: '1'
08/09/2011 02:25:02 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/local/spine/spine, ARGS: 0 28]
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The path_php variable is /usr/bin/php
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The availability_method variable is 2
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The ping_recovery_count variable is 3
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The ping_failure_count variable is 2
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The ping_method variable is 2
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The ping_retries variable is 1
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The ping_timeout variable is 400
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The snmp_retries variable is 3
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The log_perror variable is 1
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The log_pwarn variable is 1
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The boost_redirect variable is 0
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The log_pstats variable is 1
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The threads variable is 15
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The polling interval is 300 seconds
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The number of concurrent processes is 1
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The script timeout is 15
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The number of php script servers to run is 2
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: StartHost='0', EndHost='28', TotalPHPScripts='0'
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The PHP Script Server is Not Required
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The Maximum SNMP OID Get Size is 1
08/09/2011 02:25:02 PM - SPINE: Poller[0] Version 0.8.7g starting
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: MySQL is Thread Safe!
08/09/2011 02:25:02 PM - SPINE: Poller[0] WARNING: Spine NOT running asroot. This is require if using ICMP. Please run "chmod +s;chown root:root spine" to resolve.
08/09/2011 02:25:02 PM - SPINE: Poller[0] SPINE: Initializing Net-SNMP API
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: Issues with SNMP Header Version information, assuming old version of Net-SNMP.
08/09/2011 02:25:02 PM - SPINE: Poller[0] SPINE: Initializing PHP Script Server(s)
08/09/2011 02:25:02 PM - SPINE: Poller[0] NOTE: Spine did not detect multithreaded device polling.
08/09/2011 02:25:02 PM - SPINE: Poller[0] NOTE: Spine is behaving in a 0.8.7g manner
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: Initial Value of Active Threads is 0
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 2
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 3
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[0] TH[1] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 2
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[1] DEBUG: UDP Host Alive, Try Count:1, Time:0.0348 ms
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[1] PING: Result UDP: Host is Alive
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[1] TH[1] Host has no information for recache.
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[1] TH[1] NOTE: There are '5' Polling Items for this Host
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[1] DEBUG: The NIFTY POPEN returned the following File Descriptor 7
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[28] SNMP Result: Host responded to SNMP
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[28] TH[1] RECACHE: Processing 1 items in the auto reindex cache for '10.1.1.1'
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[28] TH[1] NOTE: There are '4' Polling Items for this Host
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[1] TH[1] DS[3] SCRIPT: perl /usr/local/cacti/scripts/linux_memory.pl MemFree:, output: 2640132
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[1] DEBUG: The NIFTY POPEN returned the following File Descriptor 7
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[1] TH[1] DS[4] SCRIPT: perl /usr/local/cacti/scripts/linux_memory.pl SwapFree:, output: 8388600
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[1] DEBUG: The NIFTY POPEN returned the following File Descriptor 7
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[1] TH[1] DS[5] SCRIPT: perl /usr/local/cacti/scripts/loadavg_multi.pl, output: 1min:0.00 5min:0.00 10min:0.00
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[1] DEBUG: The NIFTY POPEN returned the following File Descriptor 7
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[1] TH[1] DS[6] SCRIPT: perl /usr/local/cacti/scripts/unix_users.pl , output: 2
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[1] DEBUG: The NIFTY POPEN returned the following File Descriptor 7
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[28] TH[1] DS[703] SNMP: v2: 10.1.1.1, dsname: traffic_in, oid: .1.3.6.1.2.1.31.1.1.1.6.13, value: 35512256060
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[1] TH[1] DS[7] SCRIPT: perl /usr/local/cacti/scripts/unix_processes.pl, output: 142
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[1] TH[1] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[28] TH[1] DS[702] SNMP: v2: 10.1.1.1, dsname: traffic_out, oid: .1.3.6.1.2.1.31.1.1.1.10.5, value: 39898594197
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[28] TH[1] DS[703] SNMP: v2: 10.1.1.1, dsname: traffic_out, oid: .1.3.6.1.2.1.31.1.1.1.10.13, value: 1541018018
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[28] TH[1] DS[702] SNMP: v2: 10.1.1.1, dsname: traffic_in, oid: .1.3.6.1.2.1.31.1.1.1.6.5, value: 59916844596
08/09/2011 02:25:02 PM - SPINE: Poller[0] Host[28] TH[1] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 0
08/09/2011 02:25:02 PM - POLLER: Poller[0] Parsed MULTI output field '1min:0.00' [map 1min->load_1min]
08/09/2011 02:25:02 PM - POLLER: Poller[0] Parsed MULTI output field '5min:0.00' [map 5min->load_5min]
08/09/2011 02:25:02 PM - POLLER: Poller[0] Parsed MULTI output field '10min:0.00' [map 10min->load_15min]
08/09/2011 02:25:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool create /usr/local/cacti/rra/28/702.rrd --step 60 DS:traffic_in:COUNTER:120:0:4294967295 DS:traffic_out:COUNTER:120:0:4294967295 RRA:AVERAGE:0.5:1:8760 RRA:AVERAGE:0.5:24:2160 RRA:AVERAGE:0.5:6:8736 RRA:AVERAGE:0.5:1:105120 RRA:AVERAGE:0.5:288:797 RRA:MAX:0.5:1:8760 RRA:MAX:0.5:24:2160 RRA:MAX:0.5:6:8736 RRA:MAX:0.5:1:105120 RRA:MAX:0.5:288:797
08/09/2011 02:25:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/local/cacti/rra/28/702.rrd --template traffic_in:traffic_out N:59916844596:39898594197
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: Thread Cleanup Complete
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: PHP Script Server Pipes Closed
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: Allocated Variable Memory Freed
08/09/2011 02:25:02 PM - SPINE: Poller[0] DEBUG: MYSQL Free & Close Completed
08/09/2011 02:25:02 PM - SPINE: Poller[0] Time: 0.1075 s, Threads: 15, Hosts: 3
08/09/2011 02:25:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool create /usr/local/cacti/rra/28/703.rrd --step 60 DS:traffic_in:COUNTER:120:0:1000000000 DS:traffic_out:COUNTER:120:0:1000000000 RRA:AVERAGE:0.5:1:8760 RRA:AVERAGE:0.5:24:2160 RRA:AVERAGE:0.5:6:8736 RRA:AVERAGE:0.5:1:105120 RRA:AVERAGE:0.5:288:797 RRA:MAX:0.5:1:8760 RRA:MAX:0.5:24:2160 RRA:MAX:0.5:6:8736 RRA:MAX:0.5:1:105120 RRA:MAX:0.5:288:797
08/09/2011 02:25:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/local/cacti/rra/28/703.rrd --template traffic_out:traffic_in N:1541018018:35512256060
08/09/2011 02:25:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/local/cacti/rra/localhost_proc_7.rrd --template proc 1312914302:142
08/09/2011 02:25:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/local/cacti/rra/localhost_users_6.rrd --template users 1312914302:2
08/09/2011 02:25:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/local/cacti/rra/localhost_load_1min_5.rrd --template load_1min:load_5min:load_15min 1312914302:0.00:0.00:0.00
08/09/2011 02:25:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/local/cacti/rra/localhost_mem_swap_4.rrd --template mem_swap 1312914302:8388600
08/09/2011 02:25:02 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/local/cacti/rra/localhost_mem_buffers_3.rrd --template mem_buffers 1312914302:2640132
08/09/2011 02:25:02 PM - SYSTEM STATS: Time:0.1195 Method:spine Processes:1 Threads:15 Hosts:3 HostsPerProcess:3 DataSources:9 RRDsProcessed:7


Here is output from rrdtool commands:

[root@cacti 28]# rrdtool info 700.rrd
filename = "700.rrd"
rrd_version = "0003"
step = 60
last_update = 1312914001
header_size = 3496
ds[traffic_in].index = 0
ds[traffic_in].type = "COUNTER"
ds[traffic_in].minimal_heartbeat = 120
ds[traffic_in].min = 0.0000000000e+00
ds[traffic_in].max = 4.2949672950e+09
ds[traffic_in].last_ds = "59818974766"
ds[traffic_in].value = NaN
ds[traffic_in].unknown_sec = 1
ds[traffic_out].index = 1
ds[traffic_out].type = "COUNTER"
ds[traffic_out].minimal_heartbeat = 120
ds[traffic_out].min = 0.0000000000e+00
ds[traffic_out].max = 4.2949672950e+09
ds[traffic_out].last_ds = "39897450337"
ds[traffic_out].value = NaN
ds[traffic_out].unknown_sec = 1

Is this enough appropriate information to help steer me in the right direction?

TIA

[noname]

[root@cacti 28]# rrdtool info 700.rrd
filename = "700.rrd"
rrd_version = "0003"
step = 60
last_update = 1312914001
header_size = 3496
ds[traffic_in].index = 0
ds[traffic_in].type = "COUNTER"
ds[traffic_in].minimal_heartbeat = 120
ds[traffic_in].min = 0.0000000000e+00
ds[traffic_in].max = 4.2949672950e+09
ds[traffic_in].last_ds = "59818974766"
ds[traffic_in].value = NaN
ds[traffic_in].unknown_sec = 1
ds[traffic_out].index = 1
ds[traffic_out].type = "COUNTER"
ds[traffic_out].minimal_heartbeat = 120
ds[traffic_out].min = 0.0000000000e+00
ds[traffic_out].max = 4.2949672950e+09
ds[traffic_out].last_ds = "39897450337"
ds[traffic_out].value = NaN
ds[traffic_out].unknown_sec = 1

I don't know why the maximum is set such a value (4.2949672950e+09), but..

4.2949672950e+09 = 4,294,967,295 < 39,897,450,337 < 59,818,974,766

Try:
1) Remove 'rrd_maximum' from "Suggested Values"
2) Set '0' for "Maximum Value" in data template
3) Re-create datasource (and graph) or perform rrdtune against existing RRD file as follows
% rrdtool tune xxxx.rrd --maximum traffic_in:U --maximum traffic_out:U

[calvin419]

I will give that a whirl and let you know.

Thanks!