[ZBX-13539] Wrong values after Zabbix upgrade (3.4.5 -> 3.4.6) Created: 2018 Feb 26  Updated: 2018 Jul 16  Resolved: 2018 Apr 17

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 3.4.6
Fix Version/s: 3.0.17rc1, 3.4.9rc1, 4.0.0alpha6, 4.0 (plan)

Type: Incident report Priority: Major
Reporter: Mikhail Markov Assignee: Alexander Vladishev
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: JPEG File 123.jpg     PNG File Capture.PNG     JPEG File Screenshot_1.jpg     JPEG File Screenshot_2.jpg     PNG File bugreport.PNG     JPEG File scree.jpg    
Issue Links:
Causes
caused by ZBX-11607 Truncation of large numbers in latest... Closed
Sub-task
depends on ZBX-12935 Incorrect displaying(rounding) of Num... Closed
Team: Team B
Sprint: Sprint 30, Sprint 31, Sprint 32
Story Points: 1

 Description   

We a getting strange values as Zabbix was updated from 3.4.5 to 3.4.6
Strage values in the Latest data tab (see attachment)



 Comments   
Comment by mzhuravlev [ 2018 Feb 27 ]

after upgrade to 3.4.7 problem not resolved.

Comment by Kaspars Mednis [ 2018 Feb 27 ]

Hi,

Can you show item configuration of some of the affected items ? Item tab and pre-processing tab.
What kind of database back-end are you using ?

Regards,
Kaspars

Comment by mzhuravlev [ 2018 Feb 28 ]

default zabbix template

Comment by mzhuravlev [ 2018 Feb 28 ]

"Can you show item configuration of some of the affected items ? Item tab and pre-processing tab."
default settings on all items. On default template "Template Zabbix server" situation is similar

"What kind of database back-end are you using ?"
Oracle12

Comment by Kaspars Mednis [ 2018 Feb 28 ]

Thanks for information, it can be Oracle related
We will check this

Regards,
Kaspars

Comment by Kaspars Mednis [ 2018 Mar 01 ]

Confirmed, all versions affected after 3.4.1.

Only very small float values are affected.
Another issue even in 3.4.1, float item type with units % is rounded to 2 digits, float item type with custom unit is rounded to 4 digits (see screenshot).

Environment:
Red Hat Enterprise Linux Server release 7.4 (Maipo)
Oracle Database 12c Standard Edition Release 12.2.0.1.0

SQL> select parameter,value from v$nls_parameters where parameter='NLS_CHARACTERSET' or parameter='NLS_NCHAR_CHARACTERSET';

PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_CHARACTERSET
AL32UTF8

NLS_NCHAR_CHARACTERSET
UTF8

Comment by mzhuravlev [ 2018 Mar 15 ]

If used for backend elasticsearch, problem is not detected.

Comment by Alexander Vladishev [ 2018 Apr 11 ]

Both issues (ZBX-13539 and ZBX-12935) are resolved in svn://svn.zabbix.com/branches/dev/ZBX-13539.

Comment by mzhuravlev [ 2018 Jul 16 ]

Hi! 

In zabbix api problem actual. See attach.

Comment by Alexander Vladishev [ 2018 Jul 16 ]

mzhuravlev, please add more details. The problem is not clear from the screenshots.

Comment by mzhuravlev [ 2018 Jul 16 ]

after upgrade to 3.4.9 in web interface problem has resolved, but geting information using API, recieved values is incorrect. see new attach.

I use next python scrypt:

#!/usr/bin/python3.6
from pyzabbix import ZabbixAPI
Z = ZabbixAPI('LINK', user='zabbixAPI', password='password')
typeserver = Z.item.get(hostids=12237, output=['itemid','name','lastvalue'],filter={'name': 'CPU util'})
print(typeserver)

Received:

zabbix@server dbsync]$ ./api.pl
{'itemid': '1953481', 'name': 'CPU util', 'lastvalue': '.06'}]

+ screenshot 

Generated at Thu Mar 28 22:47:52 EET 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.