adding new datasources to existing graphs = weird

[mshannon]

Hi,

I set up cacto to graph total established tcp connections for 13 servers in a web farm, and that worked great, but when we added 4 new servers to the web farm it looks like rrd is making up values for connections when the servers weren't in the farm. You can see that for servers 14,15,16,17 there are values being graphed for the whole week even though the servers weren't added until Tuesday. Coincidently, the servers were added where the gap was, I happened to have cacti down while someone else was adding the servers, but it illustrates nicely what I'm explaining, there shouldn't be any data for the servers before the gap, I didnt even start monitoring until a few hours after that gap appears.

Thanks,

-m

[BSOD2600]

I don't see how you've come to that conclusion since servers 14, 15, 16 all use the same colors as severs 1, 2, 4. How can you be sure you're not looking at those instead? Tried changing the colors of the newer servers to something not currently present it the graph?

[mshannon]

subject says it all

[mshannon]

when I do an rrdtool dump on the rra file, there are no values for dates before I started monitoring (as expected) and when I just create an individual graph the data appears to be correct, its just when I stack the graphs on top of older data....

[gandalf]

Please click on the graph and select one of the wrenches to get the rrdtool graph statements. Please post them.
Reinhard

[mshannon]

Thanks for that tip! That wrench is awfully helpful!

/usr/local/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="TCP connections" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--units-exponent=0 \
--vertical-label="Established Connections" \
--slope-mode \
DEF:a="/usr/local/cacti-0.8.6g/rra/www1_tcp_conn_377.rrd":tcp_conn:AVERAGE \
DEF:b="/usr/local/cacti-0.8.6g/rra/www16_tcp_conn_579.rrd":tcp_conn:AVERAGE \
DEF:c="/usr/local/cacti-0.8.6g/rra/www15_tcp_conn_567.rrd":tcp_conn:AVERAGE \
DEF:d="/usr/local/cacti-0.8.6g/rra/www14_tcp_conn_555.rrd":tcp_conn:AVERAGE \
DEF:e="/usr/local/cacti-0.8.6g/rra/www13_tcp_conn_523.rrd":tcp_conn:AVERAGE \
DEF:f="/usr/local/cacti-0.8.6g/rra/www12_tcp_conn_511.rrd":tcp_conn:AVERAGE \
DEF:g="/usr/local/cacti-0.8.6g/rra/www11_tcp_conn_497.rrd":tcp_conn:AVERAGE \
DEF:h="/usr/local/cacti-0.8.6g/rra/www10_tcp_conn_485.rrd":tcp_conn:AVERAGE \
DEF:i="/usr/local/cacti-0.8.6g/rra/www9_tcp_conn_473.rrd":tcp_conn:AVERAGE \
DEF:j="/usr/local/cacti-0.8.6g/rra/www8_tcp_conn_461.rrd":tcp_conn:AVERAGE \
DEF:ba="/usr/local/cacti-0.8.6g/rra/www7_tcp_conn_449.rrd":tcp_conn:AVERAGE \
DEF:bb="/usr/local/cacti-0.8.6g/rra/www6_tcp_conn_437.rrd":tcp_conn:AVERAGE \
DEF:bc="/usr/local/cacti-0.8.6g/rra/www5_tcp_conn_425.rrd":tcp_conn:AVERAGE \
DEF:bd="/usr/local/cacti-0.8.6g/rra/www4_tcp_conn_413.rrd":tcp_conn:AVERAGE \
DEF:be="/usr/local/cacti-0.8.6g/rra/www3_tcp_conn_401.rrd":tcp_conn:AVERAGE \
DEF:bf="/usr/local/cacti-0.8.6g/rra/www2_tcp_conn_389.rrd":tcp_conn:AVERAGE \
DEF:bg="/usr/local/cacti-0.8.6g/rra/www17_tcp_conn_591.rrd":tcp_conn:AVERAGE \
AREA:a#FFFFFF:"www1" \
AREA:b#FFFFFF:"www2":STACK \
AREA:c#FFFFFF:"www3":STACK \
AREA:d#FFFFFF:"www4":STACK \
AREA:e#FFFFFF:"www5":STACK \
AREA:f#FFFFFF:"www6":STACK \
AREA:g#FFFFFF:"www7":STACK \
AREA:h#FFFFFF:"www8":STACK \
AREA:i#FFFFFF:"www9":STACK \
AREA:j#FFFFFF:"www10":STACK \
AREA:ba#FFFFFF:"www11":STACK \
AREA:bb#FFFFFF:"www12":STACK \
AREA:bc#FFFFFF:"www13":STACK \
AREA:bd#FF0000:"www14":STACK \
AREA:be#EA8F00:"www15":STACK \
AREA:bf#00FF00:"www16":STACK \
AREA:bg#000000:"www17":STACK

I see the problem, and I thought I had that addressed. In the graph template I was careful to make sure that, for instance, Graph Template Items #16 corrisponded to the 16th item listed in Graph Item Inputs - but apparently I wasnt diligant enough.

Whats the fix for this? Is there a way to edit that command line so everything is correct?

[mshannon]

got it figured out - there's some weirdness to it, but I just ended up deleting my old graph template and was very methodical about how I added inputs.

Thanks for all the pointers.

[mshannon]

is there a way to manually edit the associations between DEFS and AREA? the gui is driving me bonkers.

[mshannon]

figured out how to export the template via xml and played around with it a bit - still seems like a lot of work to just associate the DEFS with the graphs... so I guess I ask again - is there an easy way of doing that?

I monkeyed around in the database for a while and decided that seems like a little out of bounds, the XML stuff is doable, but seems like a pain, is there a way to fix these mess ups through the gui that I'm just not seeing?

[mshannon]

problem solved - was using default names for Graph Item Inputs and they would get reordered every time something changed - added an index to the name and it added sanity to the process.

-m