Sahina Bose has posted comments on this change. Change subject: engine:Fixed FK violation on update of gluster event names ......................................................................
Patch Set 1: @Eli, 1. The issue is only when there's data in event_subscriber table as in bug 973712. If there's existing data with event_up_name = GLUSTER_HOST_REMOVE_FAILED or GLUSTER_HOST_ADD_FAILED, while trying to rename the event_up_name in event_map table, there's a FK violation. 2. In my patch, I'm trying to address the above case. That is, there's data in the event_subscriber table for event_up_name GLUSTER_HOST_REMOVE_FAILED or GLUSTER_HOST_ADD_FAILED. I cannot update either of these tables without causing a FK violation. Since PostgresSQL does not provide a way to disable a single FK constraint, I drop and recreate the constraints. Regarding deleting data from event_subscriber table and recreating it, is it possible to do that without using a temp table or stored procedure variables to store the data? If so, please advise. -- To view, visit http://gerrit.ovirt.org/15706 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: comment Gerrit-Change-Id: If8d811be0e8eb52d3ebf2d1bfb4e391398b65abe Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Sahina Bose <sab...@redhat.com> Gerrit-Reviewer: Barak Azulay <bazu...@redhat.com> Gerrit-Reviewer: Eli Mesika <emes...@redhat.com> Gerrit-Reviewer: Lee Yarwood <lyarw...@redhat.com> Gerrit-Reviewer: Sahina Bose <sab...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
