Prevent race conditions when multiple users try to borrow the same book simultaneously, or when a book is being returned while a reservation is being processed.
Acceptance Criteria:
Implement pessimistic locking or optimistic locking for book availability updates
Ensure book inventory count updates are atomic
Handle concurrent loan creation for the same book
Add appropriate database constraints/transactions
Technical Notes:
Consider using SELECT FOR UPDATE in critical sections or implement a distributed lock mechanism if the application is clustered.
Prevent race conditions when multiple users try to borrow the same book simultaneously, or when a book is being returned while a reservation is being processed.
Acceptance Criteria:
Implement pessimistic locking or optimistic locking for book availability updates
Ensure book inventory count updates are atomic
Handle concurrent loan creation for the same book
Add appropriate database constraints/transactions
Technical Notes:
Consider using SELECT FOR UPDATE in critical sections or implement a distributed lock mechanism if the application is clustered.