[jira] [Issue Comment Deleted] (OAK-4199) RDBBlobStore: garbage collection fails to delete DATA records when there was subsequent blobstore activity

["Julian Reschke (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OAK-4199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Julian Reschke updated OAK-4199:
--------------------------------
    Comment: was deleted

(was: trunk: http://svn.apache.org/r1738957 http://svn.apache.org/r1738950
1.2: http://svn.apache.org/r1738961
1.0: http://svn.apache.org/r1738965
)

> RDBBlobStore: garbage collection fails to delete DATA records when there was subsequent blobstore activity
> ----------------------------------------------------------------------------------------------------------
>
>                 Key: OAK-4199
>                 URL: https://issues.apache.org/jira/browse/OAK-4199
>             Project: Jackrabbit Oak
>          Issue Type: Technical task
>          Components: blob, rdbmk
>    Affects Versions: 1.2.13, 1.0.29, 1.4.1, 1.5.1
>            Reporter: Julian Reschke
>            Assignee: Julian Reschke
>             Fix For: 1.0.30, 1.2.14, 1.5.2, 1.4.3
>
>
> The {{countDeleteChunks}}, the statement used to cleanup the DATA table will not affect any rows if there are *any* rows never than {{maxLastModified}}. This is because the alias m matches the wrong table name.
> Will add test case.
> The fix likely is to use fully qualified table names, like:
> {noformat}
> dataStatement.append(" and not exists(select * from " + this.tnMeta + 
>   " where " + this.tnMeta + ".ID = " + this.tnData + ".ID and LASTMOD > ?)");
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)