I have an empty document that is locked in my couchbase and unable to delete it. Details using N1QL queries:
delete from bucket where meta(bucket).id = 'docId'
[
{
"code": 12011,
"msg": "Some keys were not deleted [docId] - cause: MCResponse status=TMPFAIL, opcode=DELETE, opaque=0, msg: Temporary failure"
}
]
select * from bucket where meta(bucket).id = 'docId'
[
{
"bucket": null
}
]
select meta(bucket).id, meta(bucket).cas from bucket where meta(bucket).id = 'docId'
[
{
"cas": -1,
"id": "docId"
}
]
Basically, it looks like a null document, but I cannot delete it or save over it. Using node.js SDK, when we try to overwrite it we get the error:
The key already exists in the server. If you have supplied a CAS then the key exists with a CAS value different than specified
and when we try to remove it, the error is:
CouchbaseError: Temporary failure received from server. Try again later
The delete from the Couchbase UI does not show any errors, but deleting from N1QL query gives the response above: MCResponse status=TMPFAIL, opcode=DELETE, opaque=0, msg: Temporary failure
The only post in the forum that looks related is the one that has the opcode=INCREMENT, but there was no resolution. Unsure how to clear out this locked document that seems to exhibit Shrodinger Cat syndrome…