Negative Then Positive Then Negative Values

[ChaosSystems]

Hi

I am having the same problem described in the thread False Positives but sadly no solution was posted.

I checked the database and I am not using any DERIVED datasource types.

Using Cacti 0.8.7e and Thold 0.4.8 and High/Low values using data type Exact Value and getting e-mails sent because negative values are been generated.

The datasource type is a Counter.

Any ideas?

[zakki]

Hi,

I was facing the same problem with you but so far my value is always negative. If you believe it is always negative, you can choose RPN Expression in the Data Type. And use ABS(|ds:traffic_in|)

was:
And then multiply the data source with -1. Like -1*|ds:traffic_in|

[TheWitness]

That's weird. Can you do an rrdtool info and post the head of the file?

[zakki]

Hi sorry for late reply. I just updated my thold to latest version. I don't know if it is what you mean of rrd info:


/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=1323330543 \
--end=1323416943 \
--title=' BGP Router - Ext - Traffic - Gi0/0 - (Link#1)' \
--rigid \
--base=1000 \
--height=120 \
--width=600 \
--alt-autoscale-max \
--lower-limit=0 \
COMMENT:"From 2011/12/08 09\:49\:03 To 2011/12/09 09\:49\:03\c" \
COMMENT:" \n" \
--vertical-label='bits per second' \
--slope-mode \
--font TITLE:10: \
--font AXIS:7: \
--font LEGEND:8: \
--font UNIT:7: \
DEF:a="/var/www/nms/rra/bgp_router_-_ext_traffic_in_575.rrd":traffic_in:AVERAGE \
DEF:b="/var/www/nms/rra/bgp_router_-_ext_traffic_in_575.rrd":traffic_out:AVERAGE \
DEF:c="/var/www/nms/rra/bgp_router_-_ext_traffic_in_575.rrd":traffic_out:MAX \
CDEF:cdefa=a,8,* \
CDEF:cdeff=b,8,* \
CDEF:cdefbb=a,UN,INF,UNKN,IF \
--watermark "xxx"
AREA:cdefa#00CF00FF:"Inbound" \
GPRINT:cdefa:LAST:" Last\:%8.2lf %s" \
GPRINT:cdefa:AVERAGE:"Avg\:%8.2lf %s" \
GPRINT:cdefa:MAX:"Max\:%8.2lf %s" \
COMMENT:"Total In\: 201.4 GB\n" \
LINE1:cdeff#002A97FF:"Outbound" \
GPRINT:cdeff:LAST:"Last\:%8.2lf %s" \
GPRINT:cdeff:AVERAGE:"Avg\:%8.2lf %s" \
GPRINT:cdeff:MAX:"Max\:%8.2lf %s" \
COMMENT:"Total Out\: 26.41 GB\n" \
COMMENT:"Graph Last Updated\:Fri 09 Dec 09\:45\:05 CAT 2011\n" \
AREA:cdefbb#8F9286FF:""


That is from one of the graph that thold detects the value is negative. Below is screenshot from thold:

[TheWitness]

What Data Manipulation are you using in the told? What Data Types are the Data Sources (counter, guage, derive, absolute)?

[dlalaina]

Please, someone help me with this, the attached image has informations about the problem.

[MarioCesar]

Hello.
I was in the same situation, and it had an offset graphs so I solved the folowing form:
Verifying local times in both my team and the php.ini, had a difference of 1 hour, which modify my php.ini file for adding my time zone and time was corrected and in turn disappeared in negative values​​, providing the correct value.

Hope this helps.

[dlalaina]

Hello.
I was in the same situation, and it had an offset graphs so I solved the folowing form:
Verifying local times in both my team and the php.ini, had a difference of 1 hour, which modify my php.ini file for adding my time zone and time was corrected and in turn disappeared in negative values​​, providing the correct value.

Hope this helps.

THANK YOU VERY MUCH !!!!
This information has gold value There are a lot of people in the world with this problem, and google didn't have the answer until now

I had to correct the date and timezone for system(linux), php, mysql, etc.

[mpmserrao]

dlalaina,

Do these solve the issue/problem? Or just the "negative" values?
My question is if after the local times correction, the "current" value of thold is now ok?
Can you please post what are the correction do you have made?

Thx in advance.

Best regards,
/mserrao

[dlalaina]

dlalaina,

Do these solve the issue/problem? Or just the "negative" values?
My question is if after the local times correction, the "current" value of thold is now ok?
Can you please post what are the correction do you have made?

Thx in advance.

Best regards,
/mserrao

Yes, this solved the negative problem, now the data source is right, the current and last values are right, and I just just have to use CDEF to manipulate the data, like:

Special Data Source: CURRENT_DATA_SOURCE
Item #2 Custom String: 8
Item #3 Operator: *
Item #4 Custom String: 1024
Item #5 Operator: /
Item #6 Custom String: 1024
Item #7 Operator: /

or

Special Data Source: CURRENT_DATA_SOURCE
Item #2 Custom String: 8
Item #3 Operator: *
Item #4 Custom String: 1024
Item #5 Operator: /

[alejo0102]

Thaaaannnnkkkk I have this problem today and fix in a few minutes, thanks so much!!