Greg Padgett has uploaded a new change for review.
Change subject: backend, db: store additional hosted engine info
......................................................................
backend, db: store additional hosted engine info
New fields for hosted engine, allowing UI display/control of maintenance
operations. Adds:
ha_configured - HA is installed on the host
ha_active - HA is currently running/updating on the host
ha_global_maintenance - HA global maintenance is enabled according to
the host
ha_local_maintenance - HA local maintenance is enabled on the host
Change-Id: Ib62849ffe0f7392c1feb1f2a0536a23410b58210
Bug-Url: https://bugzilla.redhat.com/1047649
Signed-off-by: Greg Padgett <[email protected]>
---
M
backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/businessentities/VDS.java
M
backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/businessentities/VdsStatistics.java
M
backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/VdsDAODbFacadeImpl.java
M
backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/VdsStatisticsDAODbFacadeImpl.java
M backend/manager/modules/dal/src/test/resources/fixtures.xml
M
backend/manager/modules/vdsbroker/src/main/java/org/ovirt/engine/core/vdsbroker/vdsbroker/VdsBrokerObjectsBuilder.java
M
backend/manager/modules/vdsbroker/src/main/java/org/ovirt/engine/core/vdsbroker/vdsbroker/VdsProperties.java
M packaging/dbscripts/create_views.sql
A packaging/dbscripts/upgrade/03_04_0500_add_ha_columns_to_vds_statistics.sql
M packaging/dbscripts/vds_sp.sql
10 files changed, 191 insertions(+), 13 deletions(-)
git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/30/23530/1
diff --git
a/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/businessentities/VDS.java
b/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/businessentities/VDS.java
index 6fcf174..e26b778 100644
---
a/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/businessentities/VDS.java
+++
b/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/businessentities/VDS.java
@@ -171,6 +171,11 @@
vds.setActiveNic(getActiveNic());
vds.setPowerManagementControlledByPolicy(isPowerManagementControlledByPolicy());
vds.setDisablePowerManagementPolicy(isDisablePowerManagementPolicy());
+ vds.setHighlyAvailableScore(getHighlyAvailableScore());
+ vds.setHighlyAvailableIsConfigured(getHighlyAvailableIsConfigured());
+ vds.setHighlyAvailableIsActive(getHighlyAvailableIsActive());
+
vds.setHighlyAvailableGlobalMaintenance(getHighlyAvailableGlobalMaintenance());
+
vds.setHighlyAvailableLocalMaintenance(getHighlyAvailableLocalMaintenance());
return vds;
}
@@ -559,6 +564,38 @@
this.mVdsStatistics.setHighlyAvailableScore(value);
}
+ public Boolean getHighlyAvailableIsConfigured() {
+ return this.mVdsStatistics.getHighlyAvailableIsConfigured();
+ }
+
+ public void setHighlyAvailableIsConfigured(Boolean value) {
+ this.mVdsStatistics.setHighlyAvailableIsConfigured(value);
+ }
+
+ public Boolean getHighlyAvailableIsActive() {
+ return this.mVdsStatistics.getHighlyAvailableIsActive();
+ }
+
+ public void setHighlyAvailableIsActive(Boolean value) {
+ this.mVdsStatistics.setHighlyAvailableIsActive(value);
+ }
+
+ public Boolean getHighlyAvailableGlobalMaintenance() {
+ return this.mVdsStatistics.getHighlyAvailableGlobalMaintenance();
+ }
+
+ public void setHighlyAvailableGlobalMaintenance(Boolean value) {
+ this.mVdsStatistics.setHighlyAvailableGlobalMaintenance(value);
+ }
+
+ public Boolean getHighlyAvailableLocalMaintenance() {
+ return this.mVdsStatistics.getHighlyAvailableLocalMaintenance();
+ }
+
+ public void setHighlyAvailableLocalMaintenance(Boolean value) {
+ this.mVdsStatistics.setHighlyAvailableLocalMaintenance(value);
+ }
+
public int getVmCount() {
return this.mVdsDynamic.getvm_count();
}
diff --git
a/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/businessentities/VdsStatistics.java
b/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/businessentities/VdsStatistics.java
index 818f3e4..0aa6761 100644
---
a/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/businessentities/VdsStatistics.java
+++
b/backend/manager/modules/common/src/main/java/org/ovirt/engine/core/common/businessentities/VdsStatistics.java
@@ -29,6 +29,10 @@
// Positive score means there is an agent
private Integer highlyAvailableScore;
private int anonymousHugePages;
+ private Boolean highlyAvailableIsConfigured;
+ private Boolean highlyAvailableIsActive;
+ private Boolean highlyAvailableGlobalMaintenance;
+ private Boolean highlyAvailableLocalMaintenance;
public VdsStatistics() {
this.cpu_idle = BigDecimal.ZERO;
@@ -42,6 +46,10 @@
swap_total = 0L;
ksm_pages = 0L;
highlyAvailableScore = 0;
+ highlyAvailableIsConfigured = false;
+ highlyAvailableIsActive = false;
+ highlyAvailableGlobalMaintenance = false;
+ highlyAvailableLocalMaintenance = false;
}
public int getAnonymousHugePages() {
@@ -73,6 +81,10 @@
result = prime * result + ((swap_free == null) ? 0 :
swap_free.hashCode());
result = prime * result + ((highlyAvailableScore == null) ? 0 :
highlyAvailableScore.hashCode());
result = prime * result + anonymousHugePages;
+ result = prime * result + ((highlyAvailableIsConfigured == null) ? 0 :
highlyAvailableIsConfigured.hashCode());
+ result = prime * result + ((highlyAvailableIsActive == null) ? 0 :
highlyAvailableIsActive.hashCode());
+ result = prime * result + ((highlyAvailableGlobalMaintenance == null)
? 0 : highlyAvailableGlobalMaintenance.hashCode());
+ result = prime * result + ((highlyAvailableLocalMaintenance == null) ?
0 : highlyAvailableLocalMaintenance.hashCode());
return result;
}
@@ -104,7 +116,11 @@
&& ObjectUtils.objectsEqual(swap_total, other.swap_total)
&& ObjectUtils.objectsEqual(swap_free, other.swap_free)
&& ObjectUtils.objectsEqual(highlyAvailableScore,
other.highlyAvailableScore)
- && (anonymousHugePages == other.anonymousHugePages));
+ && (anonymousHugePages == other.anonymousHugePages)
+ && ObjectUtils.objectsEqual(highlyAvailableIsConfigured,
other.highlyAvailableIsConfigured)
+ && ObjectUtils.objectsEqual(highlyAvailableIsActive,
other.highlyAvailableIsActive)
+ && ObjectUtils.objectsEqual(highlyAvailableGlobalMaintenance,
other.highlyAvailableGlobalMaintenance)
+ && ObjectUtils.objectsEqual(highlyAvailableLocalMaintenance,
other.highlyAvailableLocalMaintenance));
}
public Double getcpu_idle() {
@@ -258,4 +274,36 @@
highlyAvailableScore = value;
}
+ public Boolean getHighlyAvailableIsConfigured() {
+ return highlyAvailableIsConfigured;
+ }
+
+ public void setHighlyAvailableIsConfigured(Boolean value) {
+ highlyAvailableIsConfigured = value;
+ }
+
+ public Boolean getHighlyAvailableIsActive() {
+ return highlyAvailableIsActive;
+ }
+
+ public void setHighlyAvailableIsActive(Boolean value) {
+ highlyAvailableIsActive = value;
+ }
+
+ public Boolean getHighlyAvailableGlobalMaintenance() {
+ return highlyAvailableGlobalMaintenance;
+ }
+
+ public void setHighlyAvailableGlobalMaintenance(Boolean value) {
+ highlyAvailableGlobalMaintenance = value;
+ }
+
+ public Boolean getHighlyAvailableLocalMaintenance() {
+ return highlyAvailableLocalMaintenance;
+ }
+
+ public void setHighlyAvailableLocalMaintenance(Boolean value) {
+ highlyAvailableLocalMaintenance = value;
+ }
+
}
diff --git
a/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/VdsDAODbFacadeImpl.java
b/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/VdsDAODbFacadeImpl.java
index 4c66558..f4c7f50 100644
---
a/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/VdsDAODbFacadeImpl.java
+++
b/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/VdsDAODbFacadeImpl.java
@@ -341,6 +341,10 @@
entity.setHighlyAvailableScore(rs.getInt("ha_score"));
entity.setDisablePowerManagementPolicy(rs.getBoolean("disable_auto_pm"));
entity.setPowerManagementControlledByPolicy(rs.getBoolean("controlled_by_pm_policy"));
+
entity.setHighlyAvailableIsConfigured(rs.getBoolean("ha_configured"));
+ entity.setHighlyAvailableIsActive(rs.getBoolean("ha_active"));
+
entity.setHighlyAvailableGlobalMaintenance(rs.getBoolean("ha_global_maintenance"));
+
entity.setHighlyAvailableLocalMaintenance(rs.getBoolean("ha_local_maintenance"));
entity.calculateFreeVirtualMemory();
return entity;
}
diff --git
a/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/VdsStatisticsDAODbFacadeImpl.java
b/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/VdsStatisticsDAODbFacadeImpl.java
index c1e84cd..c9deccb 100644
---
a/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/VdsStatisticsDAODbFacadeImpl.java
+++
b/backend/manager/modules/dal/src/main/java/org/ovirt/engine/core/dao/VdsStatisticsDAODbFacadeImpl.java
@@ -46,6 +46,11 @@
entity.setksm_pages(rs.getLong("ksm_pages"));
entity.setksm_state((Boolean) rs.getObject("ksm_state"));
entity.setAnonymousHugePages(rs.getInt("anonymous_hugepages"));
+ entity.setHighlyAvailableScore(rs.getInt("ha_score"));
+
entity.setHighlyAvailableIsConfigured(rs.getBoolean("ha_configured"));
+ entity.setHighlyAvailableIsActive(rs.getBoolean("ha_active"));
+
entity.setHighlyAvailableGlobalMaintenance(rs.getBoolean("ha_global_maintenance"));
+
entity.setHighlyAvailableLocalMaintenance(rs.getBoolean("ha_local_maintenance"));
return entity;
}
}
@@ -80,8 +85,12 @@
.addValue("ksm_cpu_percent", stats.getksm_cpu_percent())
.addValue("ksm_pages", stats.getksm_pages())
.addValue("ksm_state", stats.getksm_state())
+ .addValue("anonymous_hugepages", stats.getAnonymousHugePages())
.addValue("ha_score", stats.getHighlyAvailableScore())
- .addValue("anonymous_hugepages",
stats.getAnonymousHugePages());
+ .addValue("ha_configured",
stats.getHighlyAvailableIsConfigured())
+ .addValue("ha_active", stats.getHighlyAvailableIsActive())
+ .addValue("ha_global_maintenance",
stats.getHighlyAvailableGlobalMaintenance())
+ .addValue("ha_local_maintenance",
stats.getHighlyAvailableLocalMaintenance());
getCallsHandler().executeModification("InsertVdsStatistics",
parameterSource);
}
@@ -106,8 +115,12 @@
.addValue("ksm_cpu_percent", stats.getksm_cpu_percent())
.addValue("ksm_pages", stats.getksm_pages())
.addValue("ksm_state", stats.getksm_state())
+ .addValue("anonymous_hugepages", stats.getAnonymousHugePages())
.addValue("ha_score", stats.getHighlyAvailableScore())
- .addValue("anonymous_hugepages",
stats.getAnonymousHugePages());
+ .addValue("ha_configured",
stats.getHighlyAvailableIsConfigured())
+ .addValue("ha_active", stats.getHighlyAvailableIsActive())
+ .addValue("ha_global_maintenance",
stats.getHighlyAvailableGlobalMaintenance())
+ .addValue("ha_local_maintenance",
stats.getHighlyAvailableLocalMaintenance());
getCallsHandler().executeModification("UpdateVdsStatistics",
parameterSource);
}
diff --git a/backend/manager/modules/dal/src/test/resources/fixtures.xml
b/backend/manager/modules/dal/src/test/resources/fixtures.xml
index 5d62c7d..f1d972a 100644
--- a/backend/manager/modules/dal/src/test/resources/fixtures.xml
+++ b/backend/manager/modules/dal/src/test/resources/fixtures.xml
@@ -2563,8 +2563,12 @@
<column>ksm_pages</column>
<column>ksm_state</column>
<column>_update_date</column>
- <column>ha_score</column>
<column>anonymous_hugepages</column>
+ <column>ha_score</column>
+ <column>ha_configured</column>
+ <column>ha_active</column>
+ <column>ha_global_maintenance</column>
+ <column>ha_local_maintenance</column>
<row>
<value>afce7a39-8e8c-4819-ba9c-796d316592e6</value>
<value>100</value>
@@ -2584,6 +2588,10 @@
<null />
<value>0</value>
<value>0</value>
+ <value>false</value>
+ <value>false</value>
+ <value>false</value>
+ <value>false</value>
</row>
<row>
<value>afce7a39-8e8c-4819-ba9c-796d316592e7</value>
@@ -2604,6 +2612,10 @@
<null />
<value>0</value>
<value>0</value>
+ <value>false</value>
+ <value>false</value>
+ <value>false</value>
+ <value>false</value>
</row>
<row>
<value>afce7a39-8e8c-4819-ba9c-796d316592e8</value>
@@ -2624,6 +2636,10 @@
<null />
<value>0</value>
<value>0</value>
+ <value>false</value>
+ <value>false</value>
+ <value>false</value>
+ <value>false</value>
</row>
<row>
<value>23f6d691-5dfb-472b-86dc-9e1d2d3c18f3</value>
@@ -2644,6 +2660,10 @@
<null />
<value>0</value>
<value>0</value>
+ <value>false</value>
+ <value>false</value>
+ <value>false</value>
+ <value>false</value>
</row>
<row>
<value>2001751e-549b-4e7a-aff6-32d36856c125</value>
@@ -2664,6 +2684,10 @@
<null />
<value>0</value>
<value>0</value>
+ <value>false</value>
+ <value>false</value>
+ <value>false</value>
+ <value>false</value>
</row>
</table>
diff --git
a/backend/manager/modules/vdsbroker/src/main/java/org/ovirt/engine/core/vdsbroker/vdsbroker/VdsBrokerObjectsBuilder.java
b/backend/manager/modules/vdsbroker/src/main/java/org/ovirt/engine/core/vdsbroker/vdsbroker/VdsBrokerObjectsBuilder.java
index 3ad69e0..1f4ab7d 100644
---
a/backend/manager/modules/vdsbroker/src/main/java/org/ovirt/engine/core/vdsbroker/vdsbroker/VdsBrokerObjectsBuilder.java
+++
b/backend/manager/modules/vdsbroker/src/main/java/org/ovirt/engine/core/vdsbroker/vdsbroker/VdsBrokerObjectsBuilder.java
@@ -623,8 +623,36 @@
vds.setVmMigrating(AssignIntValue(xmlRpcStruct,
VdsProperties.vm_migrating));
updateVDSDomainData(vds, xmlRpcStruct);
updateLocalDisksUsage(vds, xmlRpcStruct);
- Integer haScore = AssignIntValue(xmlRpcStruct, VdsProperties.ha_score);
+
+ // hosted engine
+ Integer haScore = null;
+ Boolean haIsConfigured = null;
+ Boolean haIsActive = null;
+ Boolean haGlobalMaint = null;
+ Boolean haLocalMaint = null;
+ if (xmlRpcStruct.containsKey(VdsProperties.ha_stats)) {
+ Map<String, Object> haStats = (Map<String, Object>)
xmlRpcStruct.get(VdsProperties.ha_stats);
+ if (haStats != null) {
+ haScore = AssignIntValue(haStats,
VdsProperties.ha_stats_score);
+ haIsConfigured = AssignBoolValue(haStats,
VdsProperties.ha_stats_is_configured);
+ haIsActive = AssignBoolValue(haStats,
VdsProperties.ha_stats_is_active);
+ haGlobalMaint = AssignBoolValue(haStats,
VdsProperties.ha_stats_global_maintenance);
+ haLocalMaint = AssignBoolValue(haStats,
VdsProperties.ha_stats_local_maintenance);
+ }
+ } else {
+ haScore = AssignIntValue(xmlRpcStruct, VdsProperties.ha_score);
+ // prior to 3.4, haScore was returned if ha was installed; assume
active if > 0
+ if (haScore != null) {
+ haIsConfigured = true;
+ haIsActive = (haScore > 0);
+ }
+ }
vds.setHighlyAvailableScore(haScore != null ? haScore : 0);
+ vds.setHighlyAvailableIsConfigured(haIsConfigured != null ?
haIsConfigured : false);
+ vds.setHighlyAvailableIsActive(haIsActive != null ? haIsActive :
false);
+ vds.setHighlyAvailableGlobalMaintenance(haGlobalMaint != null ?
haGlobalMaint : false);
+ vds.setHighlyAvailableLocalMaintenance(haLocalMaint != null ?
haLocalMaint : false);
+
}
/**
diff --git
a/backend/manager/modules/vdsbroker/src/main/java/org/ovirt/engine/core/vdsbroker/vdsbroker/VdsProperties.java
b/backend/manager/modules/vdsbroker/src/main/java/org/ovirt/engine/core/vdsbroker/vdsbroker/VdsProperties.java
index 010094a..4c70f9a 100644
---
a/backend/manager/modules/vdsbroker/src/main/java/org/ovirt/engine/core/vdsbroker/vdsbroker/VdsProperties.java
+++
b/backend/manager/modules/vdsbroker/src/main/java/org/ovirt/engine/core/vdsbroker/vdsbroker/VdsProperties.java
@@ -67,6 +67,12 @@
public static final String images_last_check = "imagesLastCheck";
public static final String images_last_delay = "imagesLastDelay";
public static final String ha_score = "haScore";
+ public static final String ha_stats = "haStats";
+ public static final String ha_stats_score = "score";
+ public static final String ha_stats_is_configured = "configured";
+ public static final String ha_stats_is_active = "active";
+ public static final String ha_stats_global_maintenance =
"globalMaintenance";
+ public static final String ha_stats_local_maintenance = "localMaintenance";
public static final String INTERFACE = "iface";
diff --git a/packaging/dbscripts/create_views.sql
b/packaging/dbscripts/create_views.sql
index cc77956..d24582d 100644
--- a/packaging/dbscripts/create_views.sql
+++ b/packaging/dbscripts/create_views.sql
@@ -710,7 +710,8 @@
vds_static.recoverable as recoverable,
vds_static.sshKeyFingerprint as sshKeyFingerprint, vds_dynamic.hw_manufacturer
as hw_manufacturer, vds_dynamic.hw_product_name as hw_product_name,
vds_dynamic.hw_version as hw_version,
vds_dynamic.hw_serial_number as hw_serial_number,
vds_dynamic.hw_uuid as hw_uuid, vds_dynamic.hw_family as hw_family,
vds_static.console_address as console_address,
vds_dynamic.hbas as hbas,
vds_dynamic.supported_emulated_machines as supported_emulated_machines,
vds_static.ssh_port as ssh_port, vds_static.ssh_username as ssh_username,
vds_statistics.ha_score as ha_score,
- vds_static.disable_auto_pm as disable_auto_pm,
vds_dynamic.controlled_by_pm_policy as controlled_by_pm_policy
+ vds_statistics.ha_configured as ha_configured,
vds_statistics.ha_active as ha_active, vds_statistics.ha_global_maintenance as
ha_global_maintenance,
+ vds_statistics.ha_local_maintenance as
ha_local_maintenance, vds_static.disable_auto_pm as disable_auto_pm,
vds_dynamic.controlled_by_pm_policy as controlled_by_pm_policy
FROM vds_groups INNER JOIN
vds_static ON vds_groups.vds_group_id = vds_static.vds_group_id INNER JOIN
vds_dynamic ON vds_static.vds_id = vds_dynamic.vds_id INNER JOIN
@@ -751,7 +752,8 @@
vds_groups.compatibility_version AS
vds_group_compatibility_version, vds_dynamic.host_os, vds_dynamic.kvm_version,
vds_dynamic.libvirt_version,
vds_dynamic.spice_version, vds_dynamic.gluster_version,
vds_dynamic.kernel_version, vds_dynamic.iscsi_initiator_name,
vds_dynamic.transparent_hugepages_state,
vds_statistics.anonymous_hugepages, vds_dynamic.non_operational_reason,
- storage_pool_iso_map.storage_id, vds_static.ssh_port,
vds_static.ssh_username, vds_statistics.ha_score as ha_score,
+ storage_pool_iso_map.storage_id, vds_static.ssh_port,
vds_static.ssh_username, vds_statistics.ha_score,
+ vds_statistics.ha_configured, vds_statistics.ha_active,
vds_statistics.ha_global_maintenance, vds_statistics.ha_local_maintenance,
vds_static.disable_auto_pm as disable_auto_pm,
vds_dynamic.controlled_by_pm_policy as controlled_by_pm_policy
FROM vds_groups INNER JOIN
vds_static ON vds_groups.vds_group_id = vds_static.vds_group_id INNER JOIN
diff --git
a/packaging/dbscripts/upgrade/03_04_0500_add_ha_columns_to_vds_statistics.sql
b/packaging/dbscripts/upgrade/03_04_0500_add_ha_columns_to_vds_statistics.sql
new file mode 100644
index 0000000..36869f7
--- /dev/null
+++
b/packaging/dbscripts/upgrade/03_04_0500_add_ha_columns_to_vds_statistics.sql
@@ -0,0 +1,6 @@
+
+select fn_db_add_column('vds_statistics', 'ha_configured', 'BOOLEAN NOT NULL
DEFAULT FALSE');
+select fn_db_add_column('vds_statistics', 'ha_active', 'BOOLEAN NOT NULL
DEFAULT FALSE');
+select fn_db_add_column('vds_statistics', 'ha_global_maintenance', 'BOOLEAN
NOT NULL DEFAULT FALSE');
+select fn_db_add_column('vds_statistics', 'ha_local_maintenance', 'BOOLEAN NOT
NULL DEFAULT FALSE');
+
diff --git a/packaging/dbscripts/vds_sp.sql b/packaging/dbscripts/vds_sp.sql
index 4521ae9..a76f219 100644
--- a/packaging/dbscripts/vds_sp.sql
+++ b/packaging/dbscripts/vds_sp.sql
@@ -24,15 +24,19 @@
v_ksm_cpu_percent INTEGER ,
v_ksm_pages BIGINT ,
v_ksm_state BOOLEAN,
+ v_anonymous_hugepages INTEGER,
v_ha_score INTEGER,
- v_anonymous_hugepages INTEGER)
+ v_ha_configured BOOLEAN,
+ v_ha_active BOOLEAN,
+ v_ha_global_maintenance BOOLEAN,
+ v_ha_local_maintenance BOOLEAN)
RETURNS VOID
AS $procedure$
BEGIN
BEGIN
-INSERT INTO vds_statistics(cpu_idle, cpu_load, cpu_sys, cpu_user,
usage_cpu_percent, usage_mem_percent, usage_network_percent, vds_id,
mem_available, mem_free,
mem_shared,swap_free,swap_total,ksm_cpu_percent,ksm_pages,ksm_state,
ha_score,anonymous_hugepages)
- VALUES(v_cpu_idle, v_cpu_load, v_cpu_sys, v_cpu_user,
v_usage_cpu_percent, v_usage_mem_percent, v_usage_network_percent, v_vds_id,
v_mem_available, v_mem_free,
v_mem_shared,v_swap_free,v_swap_total,v_ksm_cpu_percent,v_ksm_pages,v_ksm_state,
v_ha_score,v_anonymous_hugepages);
+INSERT INTO vds_statistics(cpu_idle, cpu_load, cpu_sys, cpu_user,
usage_cpu_percent, usage_mem_percent, usage_network_percent, vds_id,
mem_available, mem_free,
mem_shared,swap_free,swap_total,ksm_cpu_percent,ksm_pages,ksm_state,
anonymous_hugepages, ha_score, ha_configured, ha_active, ha_global_maintenance,
ha_local_maintenance)
+ VALUES(v_cpu_idle, v_cpu_load, v_cpu_sys, v_cpu_user,
v_usage_cpu_percent, v_usage_mem_percent, v_usage_network_percent, v_vds_id,
v_mem_available, v_mem_free,
v_mem_shared,v_swap_free,v_swap_total,v_ksm_cpu_percent,v_ksm_pages,v_ksm_state,
v_anonymous_hugepages, v_ha_score, v_ha_configured, v_ha_active,
v_ha_global_maintenance, v_ha_local_maintenance);
END;
RETURN;
@@ -59,8 +63,12 @@
v_ksm_cpu_percent INTEGER ,
v_ksm_pages BIGINT ,
v_ksm_state BOOLEAN,
+ v_anonymous_hugepages INTEGER,
v_ha_score INTEGER,
- v_anonymous_hugepages INTEGER)
+ v_ha_configured BOOLEAN,
+ v_ha_active BOOLEAN,
+ v_ha_global_maintenance BOOLEAN,
+ v_ha_local_maintenance BOOLEAN)
RETURNS VOID
--The [vds_dynamic] table doesn't have a timestamp column. Optimistic
concurrency logic cannot be generated
@@ -74,8 +82,10 @@
usage_network_percent = v_usage_network_percent,
mem_available = v_mem_available, mem_free = v_mem_free, mem_shared =
v_mem_shared,
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, ha_score = v_ha_score,
_update_date = LOCALTIMESTAMP,
- anonymous_hugepages = v_anonymous_hugepages
+ ksm_pages = v_ksm_pages,ksm_state = v_ksm_state, anonymous_hugepages =
v_anonymous_hugepages,
+ ha_score = v_ha_score, ha_configured = v_ha_configured, ha_active =
v_ha_active,
+ ha_global_maintenance = v_ha_global_maintenance, ha_local_maintenance =
v_ha_local_maintenance,
+ _update_date = LOCALTIMESTAMP
WHERE vds_id = v_vds_id;
END;
--
To view, visit http://gerrit.ovirt.org/23530
To unsubscribe, visit http://gerrit.ovirt.org/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ib62849ffe0f7392c1feb1f2a0536a23410b58210
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: ovirt-engine-3.4
Gerrit-Owner: Greg Padgett <[email protected]>
_______________________________________________
Engine-patches mailing list
[email protected]
http://lists.ovirt.org/mailman/listinfo/engine-patches
