[icinga-checkins] icinga.org: icingaweb2-module-director/master: schema/mysql: sync_run.duration_ms might be null

git at icinga.org git at icinga.org
Wed Feb 24 11:24:49 CET 2016


Module: icingaweb2-module-director
Branch: master
Commit: ab5bc8035d1e70c92786bc5175189cecd38e24cb
URL:    https://git.icinga.org/?p=icingaweb2-module-director.git;a=commit;h=ab5bc8035d1e70c92786bc5175189cecd38e24cb

Author: Thomas Gelf <thomas at gelf.net>
Date:   Wed Feb 24 11:23:01 2016 +0100

schema/mysql: sync_run.duration_ms might be null

This allows us to store sync_run stats without a duration in the sync
transaction while updating duration afterwards. This way the commit
duration makes part of our measurement.

---

 schema/mysql.sql |    4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/schema/mysql.sql b/schema/mysql.sql
index 61cf55d..90da630 100644
--- a/schema/mysql.sql
+++ b/schema/mysql.sql
@@ -1060,7 +1060,7 @@ CREATE TABLE sync_run (
   rule_id INT(10) UNSIGNED DEFAULT NULL,
   rule_name VARCHAR(255) NOT NULL,
   start_time DATETIME NOT NULL,
-  duration_ms INT(10) UNSIGNED NOT NULL,
+  duration_ms INT(10) UNSIGNED DEFAULT NULL,
   objects_deleted INT(10) UNSIGNED DEFAULT 0,
   objects_created INT(10) UNSIGNED DEFAULT 0,
   objects_modified INT(10) UNSIGNED DEFAULT 0,
@@ -1076,5 +1076,5 @@ CREATE TABLE sync_run (
 
 INSERT INTO director_schema_migration
   SET migration_time = NOW(),
-      schema_version = 67;
+      schema_version = 68
 



More information about the icinga-checkins mailing list