[ 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)