[LocalID] Concurrent submission of same localID issue

CDLUC3 / mrt-doc

Documentation and Information regarding the Merritt repository

8 stars 4 forks source link

[LocalID] Concurrent submission of same localID issue #2029

Closed mreyescdl closed 2 weeks ago

mreyescdl commented 2 months ago

When submitting multiple new objects with the same local ID concurrently, the following can occur:

Different primary IDs can get bound to the same Local ID

This occurs due to the Local ID not being locked during the DB update.
A fix would be for either Ingest or the Local ID service to create a Zookeeper lock based on OWNER + LOCAL ID before the update and release after the update

elopatin-uc3 commented 1 month ago

Local ID integration test can trigger this error. If local id exists previously, error is not triggered. Error can be triggered after the stage cleanup script runs on Fridays.