Sync Gateway - Blob Attachment delete

nagarajan_subbaraj · September 4, 2020, 12:44pm

Hi Team,
we have a use case for the Sync Gateway attachment delete. There is a mobile app which uploads a document from their application which will be sent to a external system for further storage. User will not check these documents once they upload it, it is fire and forget scenario.

W e are think to get these sync gateway blob attachment using a webservice and sent to external system and then delete it at sync-gw level. How do we do that? I can get the document via GET api but how do i delete these attachments without deleting actual document.

Thanks.

jens · September 4, 2020, 5:05pm

Update the document without the attachment in it.

dipen_patel · September 8, 2020, 5:14pm

After the delete is the blob still in the database?

jens · September 8, 2020, 9:15pm

Until it gets garbage-collected at some unspecified time…

dipen_patel · September 8, 2020, 10:47pm

Let me clarify, does the binary attachment ever get removed from couchbase server?

nagarajan_subbaraj · September 9, 2020, 6:54am

I don’t see attachment document is getting deleted… not sure what is the unspecified time limit. Any idea?

jens · September 9, 2020, 7:46pm

@adamf … what’s the schedule for attachment GC?

adamf · September 9, 2020, 8:23pm

There’s nothing officially scheduled, although there are ongoing discussions around alignment of attachment handling between CBL, SG and CBS that would include this topic.

jens · September 9, 2020, 9:26pm

Oh, I meant “how does SG schedule when to delete attachments” … so you’re implying that it’s not implemented at all yet?

adamf · September 9, 2020, 9:26pm

Correct - there’s currently no GC for orphaned attachments.

nagarajan_subbaraj · September 11, 2020, 4:25am

so we have to manually delete those documents(attachment) from couch base bucket?