[
https://issues.apache.org/jira/browse/OAK-2093?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14133874#comment-14133874
]
Thomas Mueller commented on OAK-2093:
-------------------------------------
I think we should have a test case, and fix the deleteChunks then, for example
using a statement like this:
{noformat}
delete from <dataTable> where id in (<...>) and not exists(
select * from <metaTable> m where id = m.id and m.lastMod <= ?)
{noformat}
I think this statement should work with all databases, should be quite fast,
and would be transactionally safe (no race condition possible). The statement
would need to be tested on common databases.
> RDBBlobStore failure because of missing lastmod column on datastore_data table
> ------------------------------------------------------------------------------
>
> Key: OAK-2093
> URL: https://issues.apache.org/jira/browse/OAK-2093
> Project: Jackrabbit Oak
> Issue Type: Bug
> Components: blob
> Reporter: Julian Reschke
> Fix For: 1.1
>
>
> Revision 1571268 introduced a lastmod check on deleteChunks (see OAK-377). It
> is applied to both tables, however only _meta has it.
> We either need to add the column (and maintain it), or change the code in
> deleteChunks.
> [~tmueller] feedback appreciated
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
