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

jsteckel made changes -
Field Original Value New Value
Attachment screenshot-1.jpg [ 12935 ]
jsteckel made changes -
Attachment screenshot-2.jpg [ 12936 ]
jsteckel made changes -
Attachment screenshot-3.jpg [ 12937 ]
jsteckel made changes -
Comment [ Picture 1 ]
jsteckel made changes -
Comment [ Picture 2 ]
jsteckel made changes -
Comment [ Picture 3 ]
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?
jsteckel made changes -
Status Open [ 1 ] Need info [ 10001 ]
Alexei Vladishev made changes -
Labels itservices
Fix Version/s 2.0 [ 10402 ]
Priority Major [ 3 ] Blocker [ 1 ]
Zabbix ID NA Reviewed 2.0
Alexei Vladishev made changes -
Link This issue duplicates ZBX-2177 [ ZBX-2177 ]
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.
Alexander Vladishev made changes -
Assignee Alexander Vladishev [ sasha ]
Alexander Vladishev made changes -
Status Need info [ 10001 ] In Progress [ 3 ]
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)
Alexander Vladishev made changes -
Status In Progress [ 3 ] Resolved [ 5 ]
Assignee Alexander Vladishev [ sasha ]
Resolution Fixed [ 1 ]
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.
Pavels Jelisejevs made changes -
Status Resolved [ 5 ] Tested [ 10002 ]
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
Alexander Vladishev made changes -
Status Tested [ 10002 ] Closed [ 6 ]
Fix Version/s 1.8.10 [ 10506 ]

People

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

Dates

  • Created:
    Updated:
    Resolved: