[dev.icinga.com #2736] Duration in Icinga-Web 1.8 after reload Icinga

[icinga-migration]

This issue has been migrated from Redmine: https://dev.icinga.com/issues/2736

Created by sa.mueller on 2012-06-27 14:39:40 +00:00

Assignee: (none)
Status: Resolved (closed on 2012-07-23 10:45:29 +00:00)
Target Version: (none)
Last Update: 2012-07-23 10:45:29 +00:00 (in Redmine)

---

When I create new config Files for my Icinga and reload the Icinga deamon (/etc/init.d/icinga reload)to apply this configs, it sets the duration from ALL services and Hosts to Zero. This is very bad, because i dont know how long my critical Hosts are down until now. In classical Web this problem doesnt exist.

Changesets

2012-07-23 10:42:57 +00:00 by mhein 2faab91

Duration field bugfix, fixes #2736.

Thanks darkarchon for the idea, added SELECT CASE decision.

2012-07-23 10:44:28 +00:00 by mhein ae4fb8e

Duration field bugfix, fixes #2736.

Thanks darkarchon for the idea, added SELECT CASE decision.

[icinga-migration]

Updated by mhein on 2012-07-23 10:45:24 +00:00

Fixed.

Added SELECT CASE for the right value:

(CASE WHEN hs.last_state_change='0000-00-00 00:00:00' THEN ps.program_start_time ELSE hs.last_state_change END) as DURATION_START

Kind regards,
Marius.

[icinga-migration]

Updated by mhein on 2012-07-23 10:45:29 +00:00

• Status changed from New to Resolved
• Done % changed from 0 to 100

Applied in changeset ae4fb8e.