[icinga-checkins] icinga.org: icinga-reports/fix/avail-query-4152: fix empty variable for mysql sla procedure

git at icinga.org git at icinga.org
Wed May 29 14:46:11 CEST 2013


Module: icinga-reports
Branch: fix/avail-query-4152
Commit: b119991c0f0aea4af5bc4f21ef16c0f0e258a5b1
URL:    https://git.icinga.org/?p=icinga-reports.git;a=commit;h=b119991c0f0aea4af5bc4f21ef16c0f0e258a5b1

Author: Michael Friedrich <michael.friedrich at netways.de>
Date:   Wed May 29 14:47:33 2013 +0200

fix empty variable for mysql sla procedure

fixes #4152

---

 db/icinga/mysql/availability.sql |    2 ++
 1 files changed, 2 insertions(+), 0 deletions(-)

diff --git a/db/icinga/mysql/availability.sql b/db/icinga/mysql/availability.sql
index f9bf252..e4ad7eb 100644
--- a/db/icinga/mysql/availability.sql
+++ b/db/icinga/mysql/availability.sql
@@ -32,6 +32,8 @@ BEGIN
              @id := id, @start := start, @end := end FROM DUAL
   ) dummy;
 
+  SELECT (@last_state := @last_ts := @cnt_dt := @add_duration := NULL) + 1 FROM DUAL INTO dummy;
+
   SELECT
     -- Let's pick up the first valid value...
     COALESCE(





More information about the icinga-checkins mailing list