Details
-
New Feature
-
Status: In Refinement (View Workflow)
-
P3
-
Resolution: Unresolved
-
None
-
None
-
None
-
Thunderjet
-
-
60
-
R1
-
R1
-
R2
-
R3
-
R2
Description
Problem statement
In FOLIO, most storage modules follow the "last writer wins" strategy for handling record updates. From the UI perspective this may lead to a situation when a stale record (older version of a give record) previously loaded into the UI may override a more recent version on the server. Hence relevant updates may get lost in the process and the user is not made aware of what has happened.
This situation can happen when multiple data imports are happening at the same time (or data import and a user acting on the same record at the same time) and can affect many records at the same time. Cleanup can then be very time-consuming and confusing.
Proposed solution
From the storage and API perspective, optimistic locking is the proposed strategy to handle conflicts. Handling of updates in FOLIO should rely on more explicit semantics, both in the storage (backend) APIs and the way it is communicated to the user through the UI.
Use cases:
Two automated processes acting on the same record.
- TBD
User impact
- prevent collisions?
- notify the user when they happen and offer them a choice? Something like, "Sorry AgentB has already updated the record and your working copy might not be up-to-date? Would you like to:" (a) Update anyway (b) Reload.
TestRail: Results
Attachments
Issue Links
- clones
-
UXPROD-2798 Prevent update conflicts (two automated processes acting on the same record)
-
- Closed
-
- is defined by
-
MODINVOICE-233 Integration test check-invoice-and-invoice-lines-deletion-restrictions fails randomly
-
- Closed
-
-
MODINVOICE-274 Implementing optimistic locking for invoice module
-
- Open
-
- relates to
-
MODINVOICE-297 Spike: Optimistic Locking for Acquisition
-
- Open
-