Michael Kublin has posted comments on this change. Change subject: core: Added template & pool cleanups to force remove SD (#818091) ......................................................................
Patch Set 1: (3 inline comments) .................................................... File backend/manager/dbscripts/storages_sp.sql Line 521: CREATE GLOBAL TEMPORARY TABLE tt_TEMPTEMPLATESTABLE AS select vm_guid Do we still need these table? Line 538: Is it possible to reduce complexity of query? Line 540: delete FROM snapshots where vm_id in (select vm_guid FROM vm_static where vmt_guid in (select vm_guid from tt_TEMPTEMPLATESTABLE)); we are deleting twice from that table -- To view, visit http://gerrit.ovirt.org/5407 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: comment Gerrit-Change-Id: I4b4035a593dc208fa485c5c5ea970c949cb1d6f6 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Tal Nisan <[email protected]> Gerrit-Reviewer: Allon Mureinik <[email protected]> Gerrit-Reviewer: Maor Lipchuk <[email protected]> Gerrit-Reviewer: Michael Kublin <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
