Defect #1705
closed
Check running operation for same automatic role (recount automatic role task ends with exception, after last rule is removed)
100%
Description
Please disallows running two and more operations for same automatic role. For example I remove last rule for automatic roles this operation execute one LRT with remove identity roles. Immediate after this operation i create new request for same automatic role with add some new rules. This operation execute another LRT for same role.
This beahvior can throw exception with deadlocks on database or some strange behavior during assign new roles.
< 2019-06-05 07:46:43.051 CEST > DETAIL: parameters: $1 = 'idm-primary', $2 = 'CREATED'
< 2019-06-05 07:46:55.257 CEST > ERROR: deadlock detected
< 2019-06-05 07:46:55.257 CEST > DETAIL: Process 30697 waits for ExclusiveLock on tuple (17,48) of relation 2279145 of database 2277391; blocked by process 6652.
Process 6652 waits for ShareLock on transaction 50256652; blocked by process 4554.
Process 4554 waits for ShareLock on transaction 50256058; blocked by process 30697.
Process 30697: update idm_auto_role_request
Related issues
Updated by Radek Tomiška over 3 years ago
- Tracker changed from Task to Defect
- Subject changed from Check running operation for same automatic role to Check running operation for same automatic role (recount automatic task ends wit exception after last rule is removed)
- Status changed from New to In Progress
- Target version set to 11.1.0
- Affected versions 10.0.0 added
Updated by Radek Tomiška over 3 years ago
- Related to Task #1801: Upgrade backend dependencies added
Updated by Radek Tomiška over 3 years ago
- Subject changed from Check running operation for same automatic role (recount automatic task ends wit exception after last rule is removed) to Check running operation for same automatic role (recount automatic role task ends with exception, after last rule is removed)
Updated by Radek Tomiška over 3 years ago
- Status changed from In Progress to Needs feedback
- Assignee changed from Radek Tomiška to Ondrej Husník
Both issues fixed:
- when last rule is removed and automatic role is changed again, when next task waits to previous task ends.
- when last rule is removed, then automatic role recount task is executed successfully.
Commit:
https://github.com/bcvsolutions/CzechIdMng/commit/96baa83fab4083d6da478afd1791e794171f2eb6
Could you provide me a feedback, please?
Updated by Ondrej Husník over 3 years ago
- Status changed from Needs feedback to Resolved
- Assignee changed from Ondrej Husník to Radek Tomiška
- % Done changed from 0 to 100
I tried the described scenario and it works. The problem did not occur.
Updated by Radek Tomiška over 3 years ago
- Status changed from Resolved to Closed