[OAK-4199] RDBBlobStore: garbage collection fails to delete DATA records when there was subsequent blobstore activity

• Type: Technical task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.29, 1.2.13, 1.4.1, 1.5.1
• Fix Version/s: 1.0.30, 1.2.14, 1.4.3, 1.5.2, 1.6.0
• Component/s: blob, rdbmk
• Assignee: Julian Reschke
• Reporter: Julian Reschke
• Created: 13/Apr/16 13:36
• Updated: 10/Nov/16 09:03
• Resolved: 13/Apr/16 15:38

Description

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:

dataStatement.append(" and not exists(select * from " + this.tnMeta + 
  " where " + this.tnMeta + ".ID = " + this.tnData + ".ID and LASTMOD > ?)");