The same query returns different results

SQL++
,
1

I have a Couchbase cluster which consists of multiple nodes installed on VMs.
The same query returns different results: empty list or existing document (there is an appropriate document in Couchbase). And there are no any errors and warnings in response.
I have this behavior both when working through the SDK, and through the UI.

Couchbase version: Community Edition 6.0.0 build 1693 ‧ IPv4

What can be a reason of such behavior?

2

Hi @johndoe,

Would you mind posting the quer(ies), the indexes, and what you expect the results to be?

3

Check the index used during empty results. See if that index has entries in it. If not drop and re-create and try it