Eli Mesika has submitted this change and it was merged. Change subject: core: Failed to activate ISO domain ...(#854492) ...................................................................... core: Failed to activate ISO domain ...(#854492) core: Failed to activate ISO domain that is already attached to 2 DC https://bugzilla.redhat.com/854492 Replacing "UNION" with "UNION ALL" in fn_get_entity_parents when sub query may return more than one result. For the reported scenario in the BZ the following query was part of the UNION : SELECT storage_pool_id as id FROM storage_pool_iso_map WHERE storage_id = v_entity_id Since in this scenario the ISO domain exists in 2 DCs the sub query returned 2 rows and Postgres throwed the reported SQL exception. Change-Id: I887005e3fc0461101b4b8ec9e24654e7dc228142 Signed-off-by: Eli Mesika <emesika(a)redhat.com&gt; --- M backend/manager/dbscripts/create_functions.sql 1 file changed, 1 insertion(+), 1 deletion(-) Approvals: Eli Mesika: Verified; Looks good to me, approved -- To view, visit http://gerrit.ovirt.org/7804 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: I887005e3fc0461101b4b8ec9e24654e7dc228142 Gerrit-PatchSet: 2 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Eli Mesika <emesika(a)redhat.com&gt; Gerrit-Reviewer: Allon Mureinik <amureini(a)redhat.com&gt; Gerrit-Reviewer: Eli Mesika <emesika(a)redhat.com&gt; Gerrit-Reviewer: Michael Kublin <mkublin(a)redhat.com&gt; Gerrit-Reviewer: Yair Zaslavsky <yzaslavs(a)redhat.com&gt;