[dev.icinga.com #2089] Timestamps for icinga_slahistory table

[icinga-migration]

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

Created by gbeutner on 2011-11-18 12:36:56 +00:00

Assignee: mfriedrich
Status: Closed (closed on 2012-04-30 16:11:58 +00:00)
Target Version: (none)
Last Update: 2014-12-08 14:35:58 +00:00 (in Redmine)

Icinga Version: 1.10.0
OS Version: any

---

Hi,

commit 3a56389 (in the gbeutner/sla-test branch) fixes the default values for the start/end/ack timestamps for the slahistory table.

Regards,
Gunnar

---

Relations:

• relates #2089
• relates #2203

[icinga-migration]

Updated by mfriedrich on 2011-11-21 09:29:27 +00:00

• Status changed from New to Feedback

and how about pgsql and oracle? their default is not NULL, but still the same value.

[icinga-migration]

Updated by mfriedrich on 2011-11-23 14:10:37 +00:00

• Assigned to changed from mfriedrich to gbeutner
• Target Version changed from 1.6 to 1.7

[icinga-migration]

Updated by jmosshammer on 2011-11-23 14:20:50 +00:00

• Status changed from Feedback to Assigned

PostgreSQL Queries now throw errors in sla (because it requires casts after the tamestamp change.

So in 1.6.0. SLA won't be a final feature for all Databases (which isn't that bad, because only the tackle view in ciinga-web currently uses SLA)

[icinga-migration]

Updated by gbeutner on 2011-11-25 07:54:22 +00:00

Michael: Can you please mention this in the release notes for 1.6?

[icinga-migration]

Updated by mfriedrich on 2012-02-18 17:23:14 +00:00

• Priority changed from Normal to High

please have a look into the postgresql queries and sla.

current dev/ido, e586b34
debian sid x64, postgresql 9.1

2012-02-18 18:20:05 CET ANWEISUNG:  SELECT slahistory_id, UNIX_TIMESTAMP(start_time) AS start_time, UNIX_TIMESTAMP(end_time) AS end_time, UNIX_TIMESTAMP(acknowledgement_time) AS acknowledgement_time, state, state_type, scheduled_downtime FROM icinga_slahistory WHERE instance_id = '1' AND object_id = '1039' AND ((start_time > FROM_UNIXTIME(1329585603) AND start_time < FROM_UNIXTIME(1329585603)) OR  (end_time > FROM_UNIXTIME(1329585603) AND end_time < FROM_UNIXTIME(1329585603)) OR  (start_time < FROM_UNIXTIME(1329585603) AND end_time > FROM_UNIXTIME(1329585603)) OR  (end_time IS NULL))
2012-02-18 18:20:05 CET FEHLER:  Funktion unix_timestamp(timestamp with time zone) existiert nicht bei Zeichen 23
2012-02-18 18:20:05 CET TIPP:  Keine Funktion stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen.
2012-02-18 18:20:05 CET ANWEISUNG:  SELECT slahistory_id, UNIX_TIMESTAMP(start_time) AS start_time, UNIX_TIMESTAMP(end_time) AS end_time, UNIX_TIMESTAMP(acknowledgement_time) AS acknowledgement_time, state, state_type, scheduled_downtime FROM icinga_slahistory WHERE instance_id = '1' AND object_id = '1049' AND ((start_time > FROM_UNIXTIME(1329585603) AND start_time < FROM_UNIXTIME(1329585603)) OR  (end_time > FROM_UNIXTIME(1329585603) AND end_time < FROM_UNIXTIME(1329585603)) OR  (start_time < FROM_UNIXTIME(1329585603) AND end_time > FROM_UNIXTIME(1329585603)) OR  (end_time IS NULL))
2012-02-18 18:20:05 CET FEHLER:  Funktion unix_timestamp(timestamp with time zone) existiert nicht bei Zeichen 23
2012-02-18 18:20:05 CET TIPP:  Keine Funktion stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen.
2012-02-18 18:20:05 CET ANWEISUNG:  SELECT slahistory_id, UNIX_TIMESTAMP(start_time) AS start_time, UNIX_TIMESTAMP(end_time) AS end_time, UNIX_TIMESTAMP(acknowledgement_time) AS acknowledgement_time, state, state_type, scheduled_downtime FROM icinga_slahistory WHERE instance_id = '1' AND object_id = '1029' AND ((start_time > FROM_UNIXTIME(1329585603) AND start_time < FROM_UNIXTIME(1329585603)) OR  (end_time > FROM_UNIXTIME(1329585603) AND end_time < FROM_UNIXTIME(1329585603)) OR  (start_time < FROM_UNIXTIME(1329585603) AND end_time > FROM_UNIXTIME(1329585603)) OR  (end_time IS NULL))
2012-02-18 18:20:05 CET FEHLER:  Funktion unix_timestamp(timestamp with time zone) existiert nicht bei Zeichen 23
2012-02-18 18:20:05 CET TIPP:  Keine Funktion stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen.
2012-02-18 18:20:05 CET ANWEISUNG:  SELECT slahistory_id, UNIX_TIMESTAMP(start_time) AS start_time, UNIX_TIMESTAMP(end_time) AS end_time, UNIX_TIMESTAMP(acknowledgement_time) AS acknowledgement_time, state, state_type, scheduled_downtime FROM icinga_slahistory WHERE instance_id = '1' AND object_id = '1069' AND ((start_time > FROM_UNIXTIME(1329585603) AND start_time < FROM_UNIXTIME(1329585603)) OR  (end_time > FROM_UNIXTIME(1329585603) AND end_time < FROM_UNIXTIME(1329585603)) OR  (start_time < FROM_UNIXTIME(1329585603) AND end_time > FROM_UNIXTIME(1329585603)) OR  (end_time IS NULL))
2012-02-18 18:20:05 CET FEHLER:  Funktion unix_timestamp(timestamp with time zone) existiert nicht bei Zeichen 23
2012-02-18 18:20:05 CET TIPP:  Keine Funktion stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen.
2012-02-18 18:20:05 CET ANWEISUNG:  SELECT slahistory_id, UNIX_TIMESTAMP(start_time) AS start_time, UNIX_TIMESTAMP(end_time) AS end_time, UNIX_TIMESTAMP(acknowledgement_time) AS acknowledgement_time, state, state_type, scheduled_downtime FROM icinga_slahistory WHERE instance_id = '1' AND object_id = '1080' AND ((start_time > FROM_UNIXTIME(1329585603) AND start_time < FROM_UNIXTIME(1329585603)) OR  (end_time > FROM_UNIXTIME(1329585603) AND end_time < FROM_UNIXTIME(1329585603)) OR  (start_time < FROM_UNIXTIME(1329585603) AND end_time > FROM_UNIXTIME(1329585603)) OR  (end_time IS NULL))
2012-02-18 18:20:05 CET FEHLER:  Funktion unix_timestamp(timestamp with time zone) existiert nicht bei Zeichen 23
2012-02-18 18:20:05 CET TIPP:  Keine Funktion stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen.
2012-02-18 18:20:05 CET ANWEISUNG:  SELECT slahistory_id, UNIX_TIMESTAMP(start_time) AS start_time, UNIX_TIMESTAMP(end_time) AS end_time, UNIX_TIMESTAMP(acknowledgement_time) AS acknowledgement_time, state, state_type, scheduled_downtime FROM icinga_slahistory WHERE instance_id = '1' AND object_id = '1059' AND ((start_time > FROM_UNIXTIME(1329585603) AND start_time < FROM_UNIXTIME(1329585603)) OR  (end_time > FROM_UNIXTIME(1329585603) AND end_time < FROM_UNIXTIME(1329585603)) OR  (start_time < FROM_UNIXTIME(1329585603) AND end_time > FROM_UNIXTIME(1329585603)) OR  (end_time IS NULL))

[icinga-migration]

Updated by mfriedrich on 2012-04-03 11:01:48 +00:00

probably related to #2203 - though, any updates?

[icinga-migration]

Updated by mfriedrich on 2012-04-25 16:43:21 +00:00

status?

[icinga-migration]

Updated by mfriedrich on 2012-04-30 16:11:58 +00:00

• Status changed from Assigned to Closed
• Assigned to changed from gbeutner to mfriedrich
• Target Version deleted 1.7
• Done % changed from 0 to 100

this is resolved with #2203

[icinga-migration]

Updated by mfriedrich on 2014-12-08 14:35:58 +00:00

• Project changed from 18 to Core, Classic UI, IDOUtils
• Category changed from 57 to IDOUtils
• Icinga Version set to 1
• OS Version set to any