hi,victor
In netxms-1.1.6 I set the DCI of my interface "Net.Interface.BytesIn(eth0)"(kb/s) and set it to Delta value(average per second)
There is two problem I meet:
1)In linux/window,the counter of the inflow of interface can increase until it reach an bottleneck(maximum value),and then it become to zero again,It is a cycle. But if the netxms get two values near the bottleneck left and right, and the second value minus the first one,it will come up a negative number. It will cause a bug,isn't it?
2)I ergodic the database(mysql) of a agent(idata_103) file:idata_value and try to find the DCI "Net.Interface.BytesIn(eth0)"(kb/s) and I found that the is 11634 records but there is 151 records is negative number(from -1813 to -33059395).This is a bug become of the negative number. It may not cause by the above problem. Because of some of the negative number is samll.
there is my sql command:
SELECT
idata_value
FROM idata_103
WHERE item_id = 84
AND idata_value < 0;
If it is a bug,how I can slove it? Thanks!
Hi!
Do you set data type of DCI to unsigned integer?
Best regards,
Victor
Oh I cause that bug. It is not relate to the unsigned integer problem. Because the counter of the inflow will be zero when the agent restart. for example, the agent network infolw now is 1000000000,and it save to the DB and the agent machine reatart. the network infolw will set to zero. When the server get the "Net.Interface.BytesIn(eth0)" from the same agent again. 0 mimus 1000 is a negative number.
So That bug cause:
1)when the agent machine restart
2)the first point I have said above.