Eli Mesika has posted comments on this change. Change subject: engine: Only iSCSI storage connections are viable for iSCSI Bond ......................................................................
Patch Set 3: (1 comment) http://gerrit.ovirt.org/#/c/23720/3/packaging/dbscripts/storages_san_sp.sql File packaging/dbscripts/storages_san_sp.sql: Line 554: Create or replace FUNCTION GetConnectableBlockStorageConnectionsByType(v_storage_pool_id UUID, v_storage_type integer) Line 555: RETURNS SETOF storage_server_connections STABLE Line 556: AS $procedure$ Line 557: BEGIN Line 558: RETURN QUERY SELECT distinct connection.* Do you need the distinct here , I remember this was taken from other SP , but the original had a UNION in it , so please check if this distinct is mandatory since it is not part of your second SP and I think that maybe it may be omitted here as well (distinct is relatively expensive in terms of DB performance) Line 559: FROM storage_server_connections connection, storage_domains domain, LUNs lun, LUN_storage_server_connection_map lun_connection Line 560: WHERE Line 561: connection.storage_type = v_storage_type and Line 562: connection.id = lun_connection.storage_server_connection and -- To view, visit http://gerrit.ovirt.org/23720 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: comment Gerrit-Change-Id: Iae30db6aa0c5d2989e9e31566d6555d70259799e Gerrit-PatchSet: 3 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Sergey Gotliv <[email protected]> Gerrit-Reviewer: Allon Mureinik <[email protected]> Gerrit-Reviewer: Daniel Erez <[email protected]> Gerrit-Reviewer: Eli Mesika <[email protected]> Gerrit-Reviewer: Eli Mesika <[email protected]> Gerrit-Reviewer: Maor Lipchuk <[email protected]> Gerrit-Reviewer: Sergey Gotliv <[email protected]> Gerrit-Reviewer: oVirt Jenkins CI Server Gerrit-HasComments: Yes _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
