Eli Mesika has uploaded a new change for review. Change subject: core:Upgrade - Error Can't start the ovirt-engine-dwhd service ......................................................................
core:Upgrade - Error Can't start the ovirt-engine-dwhd service Upgrade - Error Can't start the ovirt-engine-dwhd service Adding a new varaible to dwh_history_timekeeping named lastStatisticsUpdate. This variable indicates when statistics on vm/vm interface/host/host insterface/disk was changed. Change-Id: I3461f0bf9ac30b8413179f32d50e017fca0cf777 Signed-off-by: Eli Mesika <[email protected]> Bug-Url: https://bugzilla.redhat.com/show_bug.cgi?id=918152 --- M backend/manager/dbscripts/common_sp.sql M backend/manager/dbscripts/disk_image_dynamic_sp.sql M backend/manager/dbscripts/network_sp.sql A backend/manager/dbscripts/upgrade/03_02_0490_add_lastStatisticsUpdate_to_dwh_history_timekeeping.sql M backend/manager/dbscripts/vds_sp.sql M backend/manager/dbscripts/vms_sp.sql 6 files changed, 26 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/39/12739/1 diff --git a/backend/manager/dbscripts/common_sp.sql b/backend/manager/dbscripts/common_sp.sql index 212975c..75d4eb0 100644 --- a/backend/manager/dbscripts/common_sp.sql +++ b/backend/manager/dbscripts/common_sp.sql @@ -574,3 +574,14 @@ RETURN; END; $procedure$ LANGUAGE plpgsql; + +-- update dwh lastStatisticsUpdate on dwh_history_timekeeping +create or replace FUNCTION fn_dwh_update_last_statistics() +returns VOID +AS $procedure$ +begin + update dwh_history_timekeeping set var_datetime = now() where var_name = 'lastStatisticsUpdate'; + RETURN; +END; $procedure$ +LANGUAGE plpgsql; + diff --git a/backend/manager/dbscripts/disk_image_dynamic_sp.sql b/backend/manager/dbscripts/disk_image_dynamic_sp.sql index 072f6b6..bfbf606 100644 --- a/backend/manager/dbscripts/disk_image_dynamic_sp.sql +++ b/backend/manager/dbscripts/disk_image_dynamic_sp.sql @@ -42,6 +42,9 @@ UPDATE disk_image_dynamic SET read_rate = v_read_rate,write_rate = v_write_rate,actual_size = v_actual_size,read_latency_seconds = v_read_latency_seconds,write_latency_seconds = v_write_latency_seconds,flush_latency_seconds = v_flush_latency_seconds WHERE image_id = v_image_id; + + PERFORM fn_dwh_update_last_statistics(); + END; $procedure$ LANGUAGE plpgsql; diff --git a/backend/manager/dbscripts/network_sp.sql b/backend/manager/dbscripts/network_sp.sql index 6f0ac8d..f447868 100644 --- a/backend/manager/dbscripts/network_sp.sql +++ b/backend/manager/dbscripts/network_sp.sql @@ -573,6 +573,9 @@ SET rx_drop = v_rx_drop,rx_rate = v_rx_rate,tx_drop = v_tx_drop,tx_rate = v_tx_rate, vm_id = v_vm_id,iface_status = v_iface_status WHERE id = v_id; + + PERFORM fn_dwh_update_last_statistics(); + END; $procedure$ LANGUAGE plpgsql; @@ -681,6 +684,9 @@ SET rx_drop = v_rx_drop,rx_rate = v_rx_rate,tx_drop = v_tx_drop,tx_rate = v_tx_rate, vds_id = v_vds_id,iface_status = v_iface_status WHERE id = v_id; + + PERFORM fn_dwh_update_last_statistics(); + END; $procedure$ LANGUAGE plpgsql; diff --git a/backend/manager/dbscripts/upgrade/03_02_0490_add_lastStatisticsUpdate_to_dwh_history_timekeeping.sql b/backend/manager/dbscripts/upgrade/03_02_0490_add_lastStatisticsUpdate_to_dwh_history_timekeeping.sql new file mode 100644 index 0000000..0329a08 --- /dev/null +++ b/backend/manager/dbscripts/upgrade/03_02_0490_add_lastStatisticsUpdate_to_dwh_history_timekeeping.sql @@ -0,0 +1 @@ +insert into dwh_history_timekeeping(var_name, var_value, var_datetime) values ('lastStatisticsUpdate', NULL, now()); diff --git a/backend/manager/dbscripts/vds_sp.sql b/backend/manager/dbscripts/vds_sp.sql index 32a4494..aadd833 100644 --- a/backend/manager/dbscripts/vds_sp.sql +++ b/backend/manager/dbscripts/vds_sp.sql @@ -70,6 +70,9 @@ swap_free = v_swap_free,swap_total = v_swap_total,ksm_cpu_percent = v_ksm_cpu_percent, ksm_pages = v_ksm_pages,ksm_state = v_ksm_state WHERE vds_id = v_vds_id; + + PERFORM fn_dwh_update_last_statistics(); + END; RETURN; diff --git a/backend/manager/dbscripts/vms_sp.sql b/backend/manager/dbscripts/vms_sp.sql index 0d7773c..c689717 100644 --- a/backend/manager/dbscripts/vms_sp.sql +++ b/backend/manager/dbscripts/vms_sp.sql @@ -159,6 +159,8 @@ usage_cpu_percent = v_usage_cpu_percent,usage_mem_percent = v_usage_mem_percent, usage_network_percent = v_usage_network_percent,disks_usage = v_disks_usage WHERE vm_guid = v_vm_guid; + + PERFORM fn_dwh_update_last_statistics(); END; $procedure$ LANGUAGE plpgsql; -- To view, visit http://gerrit.ovirt.org/12739 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I3461f0bf9ac30b8413179f32d50e017fca0cf777 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Eli Mesika <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
