Sahina Bose has uploaded a new change for review. Change subject: engine:Fixed FK violation on update of gluster event names ......................................................................
engine:Fixed FK violation on update of gluster event names A FK violation occurs during upgrade due to event_up name being present in event_subscriber Change-Id: If8d811be0e8eb52d3ebf2d1bfb4e391398b65abe Signed-off-by: Sahina Bose <sab...@redhat.com> --- M backend/manager/dbscripts/upgrade/03_02_0060_change_host_to_server_event_map.sql 1 file changed, 9 insertions(+), 1 deletion(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/06/15706/1 diff --git a/backend/manager/dbscripts/upgrade/03_02_0060_change_host_to_server_event_map.sql b/backend/manager/dbscripts/upgrade/03_02_0060_change_host_to_server_event_map.sql index 54f93e7..62a9ff4 100644 --- a/backend/manager/dbscripts/upgrade/03_02_0060_change_host_to_server_event_map.sql +++ b/backend/manager/dbscripts/upgrade/03_02_0060_change_host_to_server_event_map.sql @@ -1,3 +1,11 @@ -- Change Host to Server in gluster related events +ALTER TABLE event_subscriber DROP CONSTRAINT FK_EVENT_SUBSCRIBER_EVENT_MAP; + +update event_subscriber set event_up_name = 'GLUSTER_SERVER_ADD_FAILED' where event_up_name = 'GLUSTER_HOST_ADD_FAILED'; +update event_subscriber set event_up_name = 'GLUSTER_SERVER_REMOVE_FAILED' where event_up_name = 'GLUSTER_HOST_REMOVE_FAILED'; + update event_map set event_up_name = 'GLUSTER_SERVER_ADD_FAILED' where event_up_name = 'GLUSTER_HOST_ADD_FAILED'; -update event_map set event_up_name = 'GLUSTER_SERVER_REMOVE_FAILED' where event_up_name = 'GLUSTER_HOST_REMOVE_FAILED'; \ No newline at end of file +update event_map set event_up_name = 'GLUSTER_SERVER_REMOVE_FAILED' where event_up_name = 'GLUSTER_HOST_REMOVE_FAILED'; + +ALTER TABLE event_subscriber ADD CONSTRAINT FK_EVENT_SUBSCRIBER_EVENT_MAP FOREIGN KEY(event_up_name) +REFERENCES event_map(event_up_name) ON DELETE CASCADE; -- To view, visit http://gerrit.ovirt.org/15706 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: If8d811be0e8eb52d3ebf2d1bfb4e391398b65abe Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Sahina Bose <sab...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
