I tried updating bulk documents using the n1ql update query. The issue I have faced was that only a subset of documents was getting updated in the first try, a little more in the second try and so on without change the condition in WHERE part. Is this a bug in couchbase server or a limit on the number of documents getting updated in one single query. I am using couchbase version
Enterprise Edition 5.1.0 build 5552.
Can you tell why partial mutations without creating index, from my understanding indexing is used to avoid latency? And one more thing I tried now without indexing on query workbench it worked fine, sometimes it causes partial mutations, and sometimes it works as excpected.
Without index it might use primary index. get all documents and apply filters and discard entries.
Lot of unnecessary work. Also check any timeout . Any index is eventual consistent if index is not up to date on mutations those might not updated.