net.if.out[] on 64bit systems

[ProTON]

Hello,

I have net.if.out[eth0] item configured as Delta (speed per second), and it always shows the same 50Gbps traffic. It was working on the 32bit system before the upgrade.

P.S. Zabbix is recompiled after upgrade to 64bit libraries.

[vrtareg]

Hi

I have the same problem on 64 bit systems.

See this thread for more details.

Areg

[ProTON]

I think I solved it -> http://www.zabbix.com/forum/showthread.php?p=17554

[quekky]

i had the same problem suddenly happening last night, and just managed to found the same solution this morning

[kevinappel]

I am experiencing the same issue on 64 bit servers.
How do you have the item configured, i.e. numeric float, or numeric integer 64 bit, units, multiplier, custom multiplier,store value?

What steps did you take to have values start working? If you modified the type of a value stored in the DB, but it mess with your current values?

[ProTON]

Numeric (float)
Units: bits
Custom multiplier by 8
Delta (speed per second)

Database modification doesn't affect current values stored, because my patch only tells MySQL to use more bytes for all future values.

[kevinappel]

Thanks for that info, one more question. From the patch it looks like you modify the value field inside the history table and prevorgvalue inside the items table. What SQL commands do I need to run to make this happen?

[ProTON]

ALTER TABLE history MODIFY value DOUBLE(24,4) DEFAULT '0.0000' NOT NULL;
ALTER TABLE items MODIFY prevorgvalue DOUBLE(24,4) DEFAULT NULL;

[djinn_fr22]

Works for me.

Thank you for the patch.

[kevinappel]

Thanks, so far it looks like the numbers are good

[vrtareg]

Hi

I use "Numeric (integer 64bit)" for the net.if.in/out items.
Is this not correct?
the data type for this items is uint.

Now i change data type to float and graphs corrected.
I also alert database.

Thanks
Areg

[ProTON]

It doesn't matter which type you use. The problem is with prevorgvalue field in items table. 64bit items simply does not have enough space to fill this MySQL field.

[vrtareg]

Thanks for explaining situation.

Areg

[kevinappel]

One more question, this currently reports in bits , what do I need to change to have bytes?

[vrtareg]

Hi

The net.if.in/out items return result in bytes.
What multiplier and units do you use?

I set Units to Bps and set multiplier to "Do not use" and i see my results in Bps, KBps, Mbps ....

Areg