rrdtool - RRD acceptance criteria

Im using an RRD to monitor a data source. We are seeing many occasions where the RRD stores a NaN result despite the fact that we know data was received as we are also appending the received data to a file for testing. When we examine the difference we see the following:I tried to paste the data as two columns but it hasnt structured properly but in essence what we see below is two columns of a spreadsheet. The left column is the rrd dump and the right column is the actual data that arrived at that time." <!-- 2017-09-28 06:00:00 U...Read more

rrdtool fetch command always returns -nan value

I have an rrd file whose output from rrdtool info is as follows:$rrdtool info ifInOctets.rrd filename = "ifInOctets.rrd"rrd_version = "0003"step = 300last_update = 1497312000header_size = 1416ds[ifInOctets].index = 0ds[ifInOctets].type = "COUNTER"ds[ifInOctets].minimal_heartbeat = 900ds[ifInOctets].min = 0.0000000000e+00ds[ifInOctets].max = 9.9999999990e+09ds[ifInOctets].last_ds = "3.4019552910E+09"ds[ifInOctets].value = 8.1322780295e+08ds[ifInOctets].unknown_sec = 0rra[0].cf = "AVERAGE"rra[0].rows = 2016rra[0].cur_row = 1544rra[0].pdp_per_row ...Read more

rrdtool - Updating values in an existing RRD file

I have an rrd file working fine under cacti, drawing a graph for me for more than a year from one data source. Today, I discovered that the data in the rrd file is not correct. I have corrected the data source and fixed problem for the future. However, I need to divide the previous data by 2 to correct it historically as well. Is it possible to update the values of an rrd file? If yes, how can I achieve this?...Read more

rrdtool - How to create a rrd file with a specific time?

I had created a rrd file with a specific time. But when i convert it into xml, i find the start time is inconsitent with the specified time.The version of rrdtool is 1.5.5.And the code is > rrdtool create abc.rrd \ > step 15 --start 1554122342 \ DS:sum:GAUGE:120:U:U \ RRA:AVERAGE:0.5:1:5856 \ RRA:AVERAGE:0.5:4:20160 \ > RRA:AVERAGE:0.5:40:52704The first few lines is like > <!-- 2019-03-31 20:15:15 CST / 1554034515 --> <row><v>NaN</v></row>> <!-- 2019-03-31 20:15:30 CST / 1554034530 --...Read more

Is the rrdtool RRA XFF value useless if RRA step is 1?

According to rrdcreate manual, the RRA definition has the following syntax:RRA:{AVERAGE | MIN | MAX | LAST}:xff:steps:rowsXFF(xfiles factor) defines what part of a consolidation interval may be made up from UNKNOWN data while the consolidated value is still regarded as known. Am I correct, that if the step is 1, then XFF value doesn't matter because single PDP is used to build the RRA entry, i.e this single PDP is either present or not? For example, both RRA:AVERAGE:0:1:12 and RRA:AVERAGE:0.9999:1:12 are equal?...Read more

Differences of using the rrdtool RRD PDP or RRA consolidation function to calculate the average reading?

I'm updating a rrdtool round-robin database with 1 minute intervals. I want to store the average value of five updates as one RRA entry in rrdtool RRD. One way to do this is like this:$ rrdtool create foo.rrd --start 1000000500 --step 60 \> DS:ping:GAUGE:120:0:1000 RRA:AVERAGE:0.5:5:12; \> rrdtool update foo.rrd 1000000560:10 1000000620:20 \> 1000000680:30 1000000740:40 1000000800:50It accumulates five readings and stores the average of those as an entry in RRA. However, one could achieve the same with this:$ rrdtool create bar.rrd --s...Read more

How is rrdtool PDP value calculated?

When I create a RRD database and update it with a GAUGE value 100, then value of the PDP value is set to 26.877900000. When I create a RRD database roughly a second later, then PDP value is 17.477500000:usr@PC:~$ rm foo.rrd; rrdtool create foo.rrd --start 'N' --step '300' 'DS:RTT:GAUGE:600:0:1000000' 'RRA:AVERAGE:0.5:1:1440'; rrdtool update foo.rrd N:100; rrdtool dump foo.rrd | grep --color -E '<value>[0-9]+|<unknown_sec>|<lastupdate>' <lastupdate>1551973741</lastupdate> <!-- 2019-03-07 17:49:01 EET -->...Read more

rrdtool - Convert rrd files from 32 bit ARM to x86_64

I have a lot of rrd files which got generated on a 1st Gen Cubieboard (1 GHz CPU, 1 Core, 1 GB RAM), and about a year ago, when I migrated the data loggers to an x86_64 machine, I noticed that I can no longer read those old files. I didn't know they were platform specific.I know that there is a workflow where I export the data from the files into XML files and then import them on the other architecture, but this is not my first choice as the old board is painfully slow and has other important work to do, like be a DNS server. The rrdtool versi...Read more

How could I print the time of a max value in a rrdtool graph?

I've searched so many times that I'm tired to.I've a rrdtool database, with which I'm used to print the MAX, Min, Average value.Now, I would like to print the time of the max value stored in the rrd db.Here is the definition of my rrd (CPU monitoring) :rrdtool create CPU.rrd --start $Date \ DS:CPU_ALL:GAUGE:600:U:U \ DS:User:GAUGE:600:U:U \ DS:Sys:GAUGE:600:U:U \ DS:Wait:GAUGE:600:U:U \ DS:Idle:GAUGE:600:U:U \ RRA:AVERAGE:0.5:1:20000 \ RRA:AVERAGE:0.5:1:20000 \ RRA:AVERAGE:0.5:1:20000 \ RRA:AVERAGE:0.5:1:20000 \ RRA:AVERAGE:...Read more

rrdtool - Adding values from multiple .rrd file

Problem =====>Basically there are three .rrd which are generated for three departments.From that we fetch three values (MIN, MAX, CURRENT) and print ins 3x3 format. There is a python script which does that.eg - Dept1: Min=10 Max=20 Cur=15Dept2: Min=0 Max=10 Cur=5Dept3: Min=10 Max=30 Cur=25 Now I want to add the values together (Min, Max, Cur) and print in one line.eg -Dept: Min=20 Max=60 Cur=45Issue I am facing =====>No matter what CDEF i write, I am breaking the graph. :(This is the part I hate as i do not get any error message.As far as I und...Read more

rrdtool - Unexpected (wrong?) values

I want to store the value of two solar inverters in a rrd. I get the values over modbus as absolute values (increasing counters). I created my rrd like this:rrdtool create -s 60 /data/solar.rrd --no-overwrite \ DS:WR1:COUNTER:300:0:U \ DS:WR2:COUNTER:300:0:U \ RRA:AVERAGE:0.5:1:43200 \ RRA:AVERAGE:0.5:5:25920 \ RRA:AVERAGE:0.5:60:8784 \ RRA:AVERAGE:0.5:1440:18993 \ RRA:MAX:0.5:1440:18993Using a bit of Python, I insert values into this rrd with (with debug output):rrdtool.update("/data/solar.rrd","-t","WR1:WR2","N:%i:%i" % (d1.inverter.WH...Read more

how can i extract the start time and end time from an rrdtool acrchive?

I have been given several rrd filed containing cpu load for about a year. using rrdtool info I do see a last_update. would that be the last data point added? If so, awesome, but I don't see anything that tells me the time of the first entry. I am looking to graph the entire year but looking for the start time via fetch is not practical on multiple files. I'd like to do it programmatically if possible. thanks for your time, J...Read more

collectd - RRDtool force the step parameter when xporting data

I'm using a javascript library to visualize rrdtool data and using rrdtool xport to retreive the data from the rrd files.Today I noticed the following:When viewing the data from now-1day: there is a datapoint of 100but when viewing the data from now-31day, the datapoint of 100 is nowhere to be seen...How can I make sure I get all datapoints within the specified time when using xport?I'm using --step 10, but it didn't make a difference. No matter what --step I set it doesn't get used. I read this is because it is ignored if it's less than 1 pixe...Read more