Historical graphs are timeshifting

[dazza1976]

We have several graphs with several datasources on them, where some are correct and then others have shifted days earlier/later.

In the attached the purple and blue areas should be roughly at the same time, however it looks the like purple data has shifted back 2 days. Then after wednesday midnight everything returns to normal. When the data was plotting on the daily (5 min average) and hourly (1 min average) graphs the 2 graphs were in sync and on top of each other.

The only thing that happened on wednesday night was that we had a network error which would have prevented new data from being captured hence the gap (of an hour) on wednesday evening.

[BSOD2600]

Not a windows specific issue, so moving to a wider forum.

rrdtool graph output would be very helpful for troubleshooting. Custom graph template you made?

[dazza1976]

Can you advise how I get the rrd graph output? These are custom graph templates

Cheers

[gandalf]

Please goto graph management and switch to debug mode.
But Cacti currently lacks the feature of SHIFTing data, so I wonder that "we" introduced that mayhem
R.

[dazza1976]

Here's the output from the debug screen, but nothing out of the usual there.

RRDTool Command:
C:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Sent Messages - Nxxxx v Platform" \
--base=1000 \
--height=120 \
--width=550 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="" \
--slope-mode \
--font TITLE:16: \
--font AXIS:10: \
--font LEGEND:10: \
--font UNIT:12: \
DEF:a="C\:/inetpub/wwwroot/cacti/rra/42/243.rrd":TotalSent:AVERAGE \
DEF:b="C\:/inetpub/wwwroot/cacti/rra/23/242.rrd":TotalSent:AVERAGE \
DEF:c="C\:/inetpub/wwwroot/cacti/rra/23/242.rrd":BluSent:AVERAGE \
DEF:d="C\:/inetpub/wwwroot/cacti/rra/23/242.rrd":RedSent:AVERAGE \
AREA:a#8D00BAFF:"Sent" \
GPRINTLAST:" Current\:%8.2lf %s" \
GPRINTAVERAGE:"Average\:%8.2lf %s" \
GPRINTMAX:"Maximum\:%8.2lf %s\n" \
AREA:b#55D6D3FF:"xxxx Sent" \
GPRINTLAST:"Current\:%8.2lf %s" \
GPRINTAVERAGE:"Average\:%8.2lf %s" \
GPRINTMAX:"Maximum\:%8.2lf %s\n" \
LINE1:c#4668E4FF:"BLU - Sent" \
GPRINT:c:LAST:" Current\:%8.2lf %s" \
GPRINT:c:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:c:MAX:"Maximum\:%8.2lf %s\n" \
LINE1:d#FF0000FF:"RED - Sent" \
GPRINT:d:LAST:" Current\:%8.2lf %s" \
GPRINT:d:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:d:MAX:"Maximum\:%8.2lf %s\n"
RRDTool Says:
OK

We definitely see that after the network interruption all the graphs are fine, but before that whilst they were fine running up to that date when we look back historically they're all over the place. This isnt the first this has happened and its happened with multiple graphs in the past.

[gandalf]

Are those rrd files updated "outside of cacti"?
R.