Eli Mesika has uploaded a new change for review.
Change subject: core:unlock_entity.sh is not finding a locked ...
......................................................................
core:unlock_entity.sh is not finding a locked ...
unlock_entity.sh is not finding a locked template
Fixing a bug in the query that finds locked query.
Since templates does not have dynamic attributes only vm_static should
be looked for to find locked templates.
Change-Id: I42fb511c83ce0b7012581254c696a6c578737252
Signed-off-by: Eli Mesika <emes...@redhat.com>
---
M backend/manager/dbscripts/dbfunctions.sh
1 file changed, 2 insertions(+), 3 deletions(-)
git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/51/11251/1
diff --git a/backend/manager/dbscripts/dbfunctions.sh
b/backend/manager/dbscripts/dbfunctions.sh
index 97dfe2c..5fab570 100755
--- a/backend/manager/dbscripts/dbfunctions.sh
+++ b/backend/manager/dbscripts/dbfunctions.sh
@@ -453,9 +453,8 @@
(select device_id from vm_device where is_plugged);"
psql -c "${CMD}" -U ${USERNAME} -d "${DATABASE}" -h "${SERVERNAME}" -p
"${PORT}"
elif [ "${object_type}" = "template" ]; then
- CMD="select vm_name as template_name from vm_static a ,vm_dynamic b
- where a.vm_guid = b.vm_guid and
- template_status = ${TEMPLATE_LOCKED};"
+ CMD="select vm_name as template_name from vm_static
+ where template_status = ${TEMPLATE_LOCKED};"
psql -c "${CMD}" -U ${USERNAME} -d "${DATABASE}" -h "${SERVERNAME}" -p
"${PORT}"
CMD="select vm_name as template_name, image_group_id as disk_id
from images a,vm_static b,vm_device c
--
To view, visit http://gerrit.ovirt.org/11251
To unsubscribe, visit http://gerrit.ovirt.org/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I42fb511c83ce0b7012581254c696a6c578737252
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Eli Mesika <emes...@redhat.com>
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches
