[ZBX-2419] IT Services: Calculation of availability is incorrect when uptimes are applied Created: 2010 May 11  Updated: 2017 May 30  Resolved: 2011 Nov 27

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.8.2
Fix Version/s: 1.8.10, 2.0.0

Type: Incident report Priority: Blocker
Reporter: jsteckel Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: itservices
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
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

Attachments: JPEG File screenshot-1.jpg     JPEG File screenshot-2.jpg     JPEG File screenshot-3.jpg    
Issue Links:
Duplicate
duplicates ZBX-2177 sla seems to be calculated incorrectly Closed

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

 Comments   
Comment by jsteckel [ 2010 Sep 20 ]

Are there any plans to resolve this bug?

Comment by Alexei Vladishev [ 2011 Nov 16 ]

This issue is related to ZBXNEXT-913.

Comment by Alexander Vladishev [ 2011 Nov 27 ]

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

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 02 ]

Please review my r23716 commit. Otherwise TESTED.

Comment by Alexander Vladishev [ 2011 Dec 02 ]

Fixed in version pre-1.8.10, revision 23724

Generated at Sat Apr 20 03:24:09 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.