[jira] [Updated] (OAK-4199) RDBBlobStore: garbage collection fails to delete DATA records when there was subsequent blobstore activity
[
https://issues.apache.org/jira/browse/OAK-4199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Reschke updated OAK-4199:
Fix Version/s: 1.6
> 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.6, 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)
[jira] [Updated] (OAK-4199) RDBBlobStore: garbage collection fails to delete DATA records when there was subsequent blobstore activity
[
https://issues.apache.org/jira/browse/OAK-4199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Reschke updated OAK-4199:
Labels: (was: candidate_oak_1_4)
> 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)
[jira] [Updated] (OAK-4199) RDBBlobStore: garbage collection fails to delete DATA records when there was subsequent blobstore activity
[
https://issues.apache.org/jira/browse/OAK-4199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Reschke updated OAK-4199:
Fix Version/s: 1.4.3
> 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)
[jira] [Updated] (OAK-4199) RDBBlobStore: garbage collection fails to delete DATA records when there was subsequent blobstore activity
[
https://issues.apache.org/jira/browse/OAK-4199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Reschke updated OAK-4199:
Fix Version/s: 1.0.30
> 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
> Labels: candidate_oak_1_4
> Fix For: 1.0.30, 1.2.14, 1.5.2
>
>
> 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)
[jira] [Updated] (OAK-4199) RDBBlobStore: garbage collection fails to delete DATA records when there was subsequent blobstore activity
[
https://issues.apache.org/jira/browse/OAK-4199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Reschke updated OAK-4199:
Labels: candidate_oak_1_4 (was: candidate_oak_1_0 candidate_oak_1_4)
> 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
> Labels: candidate_oak_1_4
> Fix For: 1.0.30, 1.2.14, 1.5.2
>
>
> 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)
[jira] [Updated] (OAK-4199) RDBBlobStore: garbage collection fails to delete DATA records when there was subsequent blobstore activity
[
https://issues.apache.org/jira/browse/OAK-4199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Reschke updated OAK-4199:
Fix Version/s: 1.2.14
> 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
> Labels: candidate_oak_1_0, candidate_oak_1_4
> Fix For: 1.2.14, 1.5.2
>
>
> 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)
[jira] [Updated] (OAK-4199) RDBBlobStore: garbage collection fails to delete DATA records when there was subsequent blobstore activity
[
https://issues.apache.org/jira/browse/OAK-4199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Reschke updated OAK-4199:
Labels: candidate_oak_1_0 candidate_oak_1_4 (was: candidate_oak_1_0
candidate_oak_1_2 candidate_oak_1_4)
> 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
> Labels: candidate_oak_1_0, candidate_oak_1_4
> Fix For: 1.5.2
>
>
> 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)
[jira] [Updated] (OAK-4199) RDBBlobStore: garbage collection fails to delete DATA records when there was subsequent blobstore activity
[
https://issues.apache.org/jira/browse/OAK-4199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Reschke updated OAK-4199:
Fix Version/s: 1.5.2
> 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
> Labels: candidate_oak_1_0, candidate_oak_1_2, candidate_oak_1_4
> Fix For: 1.5.2
>
>
> 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)
[jira] [Updated] (OAK-4199) RDBBlobStore: garbage collection fails to delete DATA records when there was subsequent blobstore activity
[
https://issues.apache.org/jira/browse/OAK-4199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Reschke updated OAK-4199:
Labels: candidate_oak_1_0 candidate_oak_1_2 candidate_oak_1_4 (was: )
> 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
> Labels: candidate_oak_1_0, candidate_oak_1_2, candidate_oak_1_4
>
> 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)
[jira] [Updated] (OAK-4199) RDBBlobStore: garbage collection fails to delete DATA records when there was subsequent blobstore activity
[
https://issues.apache.org/jira/browse/OAK-4199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Reschke updated OAK-4199:
Summary: RDBBlobStore: garbage collection fails to delete DATA records when
there was subsequent blobstore activity (was: RDDBlobStore: garbage collection
fails to delete DATA records when there was subsequent blobstore activity)
> 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
>
> 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)
