ZABBIX BUGS AND ISSUES

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

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Blocker 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
  • Zabbix ID:
    Reviewed 2.0

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).

Issue Links

Activity

Hide
jsteckel added a comment -

Are there any plans to resolve this bug?

Show
jsteckel added a comment - Are there any plans to resolve this bug?
Hide
Alexei Vladishev added a comment -

This issue is related to ZBXNEXT-913.

Show
Alexei Vladishev added a comment - This issue is related to ZBXNEXT-913.
Hide
Alexander Vladishev added a comment -

Fixed in the development branch, rev. 23557. Backport from trunk (ZBXNEXT-913)

Show
Alexander Vladishev added a comment - Fixed in the development branch, rev. 23557. Backport from trunk (ZBXNEXT-913)
Hide
Pavels Jelisejevs added a comment -

Please review my r23716 commit. Otherwise TESTED.

Show
Pavels Jelisejevs added a comment - Please review my r23716 commit. Otherwise TESTED.
Hide
Alexander Vladishev added a comment -

Fixed in version pre-1.8.10, revision 23724

Show
Alexander Vladishev added a comment - Fixed in version pre-1.8.10, revision 23724

People

  • Assignee:
    Unassigned
    Reporter:
    jsteckel
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: