I am experiencing the same issue:
Our Couchbase cluster is 6.0.2
Node SDK 2.6.9
Hosted in Serverless Amazon Linux 2
I am trying to use the “total hits” returned from FTS search as the basis for paging through those results. Example,
query returns 4940 total hits. when I pass in 0 offset and limit 100.
As I increase the offset from 0 up to 2800 and the total hits remains consistently what i would expect, 4940.
However, as I page beyond 2800 the total hit counts become erratic and the number swings wildly. I ran the same query with offset 2900 3 consecutive times and each time was a different “total hits”
Any ideas?
JG