CB returning old data

Couchbase Server
1

Basically, we see old information from CB that after investigation we realized that data is OK, code is OK but the COVER INDEX for the involved query was returning wrong data. After drop and create index it worked fine.
couchbase.client.version: 3.4.0
CB Server version: 7.1.1 CE

2

Indexes are not updated synchronously. Usually the delay is very brief - a second or less. To ensure the indexes are updated to a particular point, use QueryScanConsistency=REQUEST_PLUS. See the documentation for other options.

3

The problem is NOT seconds or minutes. The data it returns is WRONG. We DO use the REQUEST PLUS scan consistency. To confirm that we run the same query adding some extra field check to break the COVER index and pick another normal GSI index and it worked as expected. So, we suspect that in the current version of our setup there is a bug in the COVER index. This is the 3rd time it happens in PROD that 1 doc is returned when there should not be and our workaround is to re-build the cover index to fix it.

4

It could be that the indexer stops working.
Please open an issue at issues.couchbase.com.

5

@mreiche
We have created a case Loading...
Please let us know what addition details we can provide to get the issue resolved.

6

Provide the server logs.
Better yet, look in the server logs to see if there are issues with the indexer.

7

Hi @Nikhil_Singh

Please provide us the server logs to check the issue in the case you have opened.
Along with other information requested on the bug

  • SQL Query
  • Covered Index definition
  • EXPLAIN output

You can use cbcollect_info to collect the logs.

The Couchbase Server logs will give us further detail around the issue itself and the health of your environment. Before collecting logs, we recommend temporarily turning off auto-failover

Example usage:

  • Linux (run as root or use sudo as below)
    sudo /opt/couchbase/bin/cbcollect_info <node_name>.zip
  • Windows (run as an administrator)
    C:\Program Files\Couchbase\Server\bin\cbcollect_info <node_name>.zip

Run cbcollect_info on all nodes in the cluster, and upload all of the resulting files to us.

Thanks
Sai

8

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.