[infinispan-issues] [JBoss JIRA] (ISPN-10337) JDBC Purge consistency issues

[Ryan Emerson (Jira)]

     [ https://issues.jboss.org/browse/ISPN-10337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ryan Emerson updated ISPN-10337:
--------------------------------
    Git Pull Request: https://github.com/infinispan/infinispan/pull/7082, https://github.com/infinispan/infinispan/pull/7085  (was: https://github.com/infinispan/infinispan/pull/7082)


> 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, 9.4.16.Final
>
>
> 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



--
This message was sent by Atlassian Jira
(v7.12.1#712002)