JDBC Purge consistency issues ----------------------------- Key: ISPN-10337 URL: https://issues.jboss.org/browse/ISPN-10337 Project: Infinispan Issue Type: Bug Components: Loaders and Stores Affects Versions: 10.0.0.Beta3, 9.4.15.Final Reporter: Ryan Emerson Assignee: Ryan Emerson Priority: Major Fix For: 10.0.0.Beta4 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