It may be a bug of Delta value of interface DCI

[x199x]

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!

[victor]

Hi!

Do you set data type of DCI to unsigned integer?

Best regards,
Victor

[x199x]

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.