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

insufficient precision may result in incorrect data

    Details

      Description

      our current database schema is limited to 4 decimal places for decimal values ("float" type). in some cases this can result in incorrect data.
      for example, icmppingsec documentation says "If host is not available (timeout reached), the item will return 0."

      if we ping a low latency host (localhost being the easiest example), results from fping might be :

      127.0.0.1 : [0], 84 bytes, 0.04 ms (0.04 avg, 0% loss)
      127.0.0.1 : [1], 84 bytes, 0.04 ms (0.04 avg, 0% loss)
      127.0.0.1 : [2], 84 bytes, 0.04 ms (0.04 avg, 0% loss)

      127.0.0.1 : [0], 84 bytes, 0.04 ms (0.04 avg, 0% loss)
      127.0.0.1 : [1], 84 bytes, 0.03 ms (0.03 avg, 0% loss)
      127.0.0.1 : [2], 84 bytes, 0.06 ms (0.04 avg, 0% loss)

      in both cases average would be below 0.05.

      zabbix stores these values as seconds, and with decimal places limited to 4... we get all zeroes - which was supposed to indicate connection problems.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                richlv richlv
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: