Change in ovirt-engine[master]: core: Failed to activate ISO domain ...(#854492)
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>
---
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>
Gerrit-Reviewer: Allon Mureinik <amureini(a)redhat.com>
Gerrit-Reviewer: Eli Mesika <emesika(a)redhat.com>
Gerrit-Reviewer: Michael Kublin <mkublin(a)redhat.com>
Gerrit-Reviewer: Yair Zaslavsky <yzaslavs(a)redhat.com>