Daniel Erez has uploaded a new change for review.

Change subject: core: clear snapshot_id from floating disks script
......................................................................

core: clear snapshot_id from floating disks script

Clearing snapshot_id from floating disks upgrade script.

Change-Id: Ifa0863a7338e22d7fbb96766937edfe28881ad57
Bug-Url: https://bugzilla.redhat.com/1015170
Signed-off-by: Daniel Erez <[email protected]>
---
A packaging/dbscripts/upgrade/03_03_0980_clear_snapshot_id_of_floating_disks.sql
1 file changed, 3 insertions(+), 0 deletions(-)


  git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/76/19976/1

diff --git 
a/packaging/dbscripts/upgrade/03_03_0980_clear_snapshot_id_of_floating_disks.sql
 
b/packaging/dbscripts/upgrade/03_03_0980_clear_snapshot_id_of_floating_disks.sql
new file mode 100644
index 0000000..1ce1265
--- /dev/null
+++ 
b/packaging/dbscripts/upgrade/03_03_0980_clear_snapshot_id_of_floating_disks.sql
@@ -0,0 +1,3 @@
+UPDATE images
+SET    vm_snapshot_id = NULL
+WHERE  image_group_id NOT IN (SELECT device_id FROM vm_device);
\ No newline at end of file


-- 
To view, visit http://gerrit.ovirt.org/19976
To unsubscribe, visit http://gerrit.ovirt.org/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ifa0863a7338e22d7fbb96766937edfe28881ad57
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Daniel Erez <[email protected]>
_______________________________________________
Engine-patches mailing list
[email protected]
http://lists.ovirt.org/mailman/listinfo/engine-patches

Reply via email to