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

Sequential order in SERVICEALARMS table can generate wrongs SLA values.

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 2.2.16
    • Frontend (F), Server (S)
    • Zabbix 2.4.5 / database Postgres 9.3 / Ubuntu 14.04 LTS

      We started to follow SLA values, day by day, and I found decrease in many IT services.

      So, I started to try understand what were responsible were for this problem.

      After some queries in the database, I noticed strange things in the SERVICEALARM table when checking servicealarmid and clock.fields (IT Service Detail SLA - Pool mdbotmdb018-otmdb2 instance otmdb2.png)

      Look at that, sequentially servicealarmid 70849, happened on 2016-11-06 03:31-03-03, with value 4 (down) ....

      E servicealarmid 70851 (greater than 70849), happened on 2016-11-06 03:30:59-03 (before 2016-11-06 03:31:00-03) with a value of 0 (UP).

      I fixed this order just updating these two lines (Detail SLA IT Service - update command.png)

      Now, the lines are following chronological ordem(Detalhe SLA IT Service - After update.jpg)

      After these updates, SLA showed correctly.

        1. Detalhe SLA IT Service - After update.png
          14 kB
          Airton Wagner Pinheiro Bezerra
        2. Detalhe SLA IT Service - Fixed - Pool mdbotmdb018-otmdb2 instância otmdb2 .png
          33 kB
          Airton Wagner Pinheiro Bezerra
        3. Detalhe SLA IT Service - Pool mdbotmdb018-otmdb2 instância otmdb2.png
          6 kB
          Airton Wagner Pinheiro Bezerra
        4. Detalhe SLA IT Service - Service Alarms Pool mdbotmdb018-otmdb2 instância otmdb2.png
          21 kB
          Airton Wagner Pinheiro Bezerra
        5. Detalhe SLA IT Service - update command.png
          7 kB
          Airton Wagner Pinheiro Bezerra

            Unassigned Unassigned
            wagner.pinheiro@4dados.com Airton Wagner Pinheiro Bezerra
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: