Details
-
Bug
-
Resolution: Done
-
Major
-
10.0.0.Beta3, 9.4.15.Final
-
None
Description
The JdbcStringBasedStore's purge method requires the following enhancements:
- The connection should be enrolled in a transaction via autoCommit(false) with commit/rollback.
- Implementations of TableManager#getSelectOnlyExpiredRowsSql should utilise a SELECT ... FOR UPDATE statement to ensure that the expired entries are locked throughout the Tx
Attachments
Issue Links
- causes
-
ISPN-11101 Purge on JDBC shared stores can cause deadlocks
- Closed
- is related to
-
ISPN-11110 JdbcStringBasedStore Purge should not use FOR UPDATE to avoid excessive locking
- Closed