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

IT Services: Calculation of availability is incorrect when uptimes are applied

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.8.2
    • Fix Version/s: 1.8.10, 2.0.0
    • Component/s: Frontend (F)
    • Labels:
    • Environment:
      Apache/2.2.9 (Debian) PHP/5.2.6-1+lenny8 with Suhosin-Patch mod_perl/2.0.4 Perl/v5.10.0
      mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (x86_64) using readline 5.2

      Description

      The following service alarms have been recorded for service with serviceid = 3:

      mysql> SELECT servicealarmid, serviceid, clock, from_unixtime( clock ), value FROM `service_alarms` where serviceid = 3;
      --------------------------------------------------------------

      servicealarmid serviceid clock from_unixtime( clock ) value

      --------------------------------------------------------------

      5 3 1273482450 2010-05-10 11:07:30 0
      19 3 1273495024 2010-05-10 14:37:04 2
      20 3 1273495662 2010-05-10 14:47:42 0
      21 3 1273496261 2010-05-10 14:57:41 2
      84 3 1273527437 2010-05-10 23:37:17 0

      --------------------------------------------------------------
      5 rows in set (0.00 sec)

      Service with serviceid = 3 was configured according to picture 1.

      The IT services report (report3.php) with Period = Daily executed on 11 May 2010, 11:00, states results according to picture 2.

      With uptime defined only for mondays between 09:00 and 17:00 I would have expected the following results (10 May 2010 was on a monday):

      --------------------------------------------------------+

      Day OK Problems Downtime Percentage SLA

      --------------------------------------------------------+

      09 May 2010 0d 0h 0m 0d 0h 0m 1d 0h 0m N/A N/A
      10 May 2010 0d 5h 47m 0d 2h 13m 0d 16h 0m 72.29% 98.50%
      11 May 2010 0d 0h 0m 0d 0h 0m 1d 0h 0m N/A N/A

      --------------------------------------------------------+

      On 09 May and 11 May values for "OK" and "Downtime" are incorrect. On 10 May values for "OK", "Problems", "Downtime", "Percentage" as well as the font color of "SLA" are incorrect.

      If I take out any uptime or downtime configuration I get results as expected for the same report (executed on 11 May 2010, 10:42, see picture 3).

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                jsteckel jsteckel
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: