Loading...

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

XML

Word

Printable

Type: Bug
Resolution: Done
Priority: Major
Fix Version/s: 9.4.16.Final, 10.0.0.Final
Affects Version/s: 9.4.15.Final, 10.0.0.Final
Component/s: Loaders and Stores
Labels:
None

Git Pull Request:
https://github.com/infinispan/infinispan/pull/7082, https://github.com/infinispan/infinispan/pull/7085

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

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

Assignee:: Ryan Emerson

Reporter:: Ryan Emerson

Archiver:: Amol Dongare

Created:: 2019/06/21 8:51 AM

Updated:: 2024/07/15 8:10 AM

Resolved:: 2019/06/25 1:17 PM

Archived:: 2024/11/28 6:21 AM