Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-23536

Decimal precision inconsistency in Top hosts widget (PostgreSQL)

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Won't fix
    • Icon: Major Major
    • None
    • 6.0.23rc1, 6.4.8rc1, 7.0.0alpha7
    • Frontend (F)
    • None
    • Sprint 105 (Oct 2023), Sprint 106 (Nov 2023), Sprint 107 (Dec 2023)

      Decimal place inconsistency occurs in the Top Hosts widget when using the 'avg' aggregation.

      When using MySQL DB, 4 digits after comma are displayed, but with PostgreSQL, a lot more digits are displayed after comma. 

      Steps to reproduce:

      Conditions : PostgreSQL database.

      1. create a host;
      2. add Zabbix trapper item to this host, item type - Numeric(unsigned);
      3. send any value to the item;
      4. create a top hosts widget;
      5. add a column with created item;
      6. add aggregation function 'avg' to this column;
      7. save the widget and observe that when you hover over the result in the top hosts widget, approximately 20 digits are shown after the decimal point in the hintbox:

      Note: This issue cannot be reproduced, if MySQL database is used

            zabbix.dev Zabbix Development Team
            esekace Eliza Sekace
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: