Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Doughnut chart shows certain closed outages as "current"

Description

There are no current outages, however the doughnut chart does show an outage.

Acceptance / Success Criteria

None

Lucidchart Diagrams

Activity

Show:

Christian Pape August 8, 2018 at 1:11 PM

Please review and merge:

 

Jesse White July 30, 2018 at 8:33 PM
Edited

The problem appears to be in the SQL for the node_outage_status view: it is possible for outages to be closed, but not be associated with a svcregainedeventid.

Instead, an outage should be considered "open" if ifregainedservice IS NULL.

Jesse White July 30, 2018 at 8:31 PM
Edited

Doughnut charts make a call to:

Which issues an SQL statement like:

The view is defined as follows:

The queries currently return:

Fixed

Details

Assignee

Reporter

Components

Sprint

Fix versions

Affects versions

Priority

PagerDuty

Created July 30, 2018 at 8:31 PM
Updated August 10, 2018 at 12:32 AM
Resolved August 10, 2018 at 12:32 AM