Yaniv Dary has submitted this change and it was merged. Change subject: etl: removed fk that cause deadlock occasionally ...................................................................... etl: removed fk that cause deadlock occasionally Deadlock in user sync causes failures in collections and aggregation. The users details sync is done every minute locking the row for update, once a hour the hourly aggregation tries to sync VM data containing users foreign key which causes deadlock due to wait on the users table update. To pervent for now we will drop fk. Change-Id: I895df0b263291e1b3d63284e671d9fcc092badc5 Signed-off-by: Yaniv Dary <ydary@redhat.com> Bug-Url: https://bugzilla.redhat.com/1254003 --- A packaging/dbscripts/upgrade/03_05_0080_remove_fk_to_users_table.sql 1 file changed, 14 insertions(+), 0 deletions(-) Approvals: Eli Mesika: Looks good to me, approved Jenkins CI: Passed CI tests Yaniv Dary: Verified; Looks good to me, approved -- To view, visit https://gerrit.ovirt.org/44885 To unsubscribe, visit https://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: I895df0b263291e1b3d63284e671d9fcc092badc5 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-dwh Gerrit-Branch: ovirt-engine-dwh-3.5 Gerrit-Owner: Yaniv Dary <ydary@redhat.com> Gerrit-Reviewer: Eli Mesika <emesika@redhat.com> Gerrit-Reviewer: Jenkins CI Gerrit-Reviewer: Yaniv Dary <ydary@redhat.com> Gerrit-Reviewer: automation@ovirt.org