N1QL ScanConsistency issue

n1ql
#1

I have noticed some issues when I do an insert to my buckets that the new document isn’t being fetched on my select.

My current workflow is the following:

Create document, Document was created successfully, redirect to list page
List Page select all documents of that type.

I have tried the following:
new QueryRequest().Statement(query).ScanConsistency(ScanConsistency.RequestPlus);

new QueryRequest().Statement(query).ScanConsistency(ScanConsistency.RequestPlus).ScanWait(new TimeSpan(0, 0, 0, 10, 0));

new QueryRequest().Statement(query).ScanWait(new TimeSpan(0, 0, 0, 10, 0));

With limited success. My structure is a 3 node cluster and I have flush enabled on there. I don’t have this issue when removing items it’s only on the insert. If I refresh the page manually after the new document doesn’t show up it then pops up. So it’s an odd behavior.

#2

@schuranator -

Which version of Couchbase are you using?

-Jeff