Change in ovirt-dwh[master]: etl: removed fk that cause deadlock occasionally
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: I00b2eeb15f5a2b983a5072a837409735667b9e42
Signed-off-by: Yaniv Dary <ydary(a)redhat.com>
Bug-Url: https://bugzilla.redhat.com/1254003
---
A packaging/dbscripts/upgrade/03_06_0060_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/44884
To unsubscribe, visit https://gerrit.ovirt.org/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I00b2eeb15f5a2b983a5072a837409735667b9e42
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-dwh
Gerrit-Branch: master
Gerrit-Owner: Yaniv Dary <ydary(a)redhat.com>
Gerrit-Reviewer: Eli Mesika <emesika(a)redhat.com>
Gerrit-Reviewer: Jenkins CI
Gerrit-Reviewer: Yaniv Dary <ydary(a)redhat.com>
Gerrit-Reviewer: automation(a)ovirt.org