Red Hat Bugzilla – Bug 1254003
Deadlock in user sync causes failures in collections and aggregation- unblock 3.5 users.
Last modified: 2016-02-10 14:28:29 EST
Description of problem:
Deadlock in user sync causes failures in collections and aggregation. The users details sync is done every minute it lock 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.
See Thread about this issue:
and fix in 9.3 for this:
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. add many users to engine.
2. use users on some vm.
3. waiting a few hours for aggregation to start
Deadlock between aggregation (due to foreign keys) and collection.
Should not deadlock.
Created attachment 1063520 [details]
Created attachment 1063521 [details]
To unblock 3.5 users that might hit this, we will remove the foreign key completely. For 3.6 we will try to find a better way to fix this, maybe by reducing the amount of updates done in each time.
Since oVirt 3.5.5 has been released, moving this from verified to closed current release.