Details
-
Bug
-
Status: Closed (View Workflow)
-
P2
-
Resolution: Done
-
7.0.1
-
None
-
Prokopovych - Sprint 122
-
Prokopovych
Description
Steps to Reproduce
- Log into https://core-platform.ci.folio.org/ where optimistic locking (fail on conflict) has been enabled.
- Open an item record for edit
- Change the item material type
- Save the item record
- (If it succeeds repeat Open, Change, and Save one time.)
Expected Results
Save succeeds.
Actual Results
Optimistic locking conflict detection modal with this error message:
ERROR: in module @folio/inventory, operation PUT on resource 'items' failed, saying: { "message": "Cannot update record eedd13c4-7d40-4b1e-8f77-b0b9d19a896b because it has been changed (optimistic locking): Stored _version is 1, _version of request is <NULL>", "severity": "ERROR", "code": "23F09", "where": "PL/pgSQL function item_set_ol_version() line 8 at RAISE", "file": "pl_exec.c", "line": "3862", "routine": "exec_stmt_raise", "schema": "diku_mod_inventory_storage", "table": "item" }
Additional information
The front-end doesn't send the _version property when submitting the PUT request to the back-end.
Updating instance and updating holding work and are not affected because the frontend sends the instance _version and holdings _version to the back-end when submitting the PUT request.
TestRail: Results
Attachments
Issue Links
- defines
-
UXPROD-3089 Inventory. Implementing Optimistic Locking
-
- Closed
-
- is blocked by
-
MODINV-484 /inventory/items should return _version property
-
- Closed
-
- relates to
-
MODINV-398 Optimistic locking (_version field, 409 HTTP status code) in instances/holdings/items
-
- Closed
-
-
UIIN-1568 align dependency versions affected by Inventory's Optimistic Locking
-
- Closed
-