Using the following code, the second query is successful when parsing the results, the first returns a timeout. The only difference between them is the addition of the timeout. In both cases the query should return nothing found. Interestingly, if there is something to find, both queries are successful. Is this a known issue or does anyone have any ideas on why this might be happening?
Couchbase community 6.6.0 7909, Python SDK 3.1.2, Python 3.9.5
from couchbase.cluster import Cluster, ClusterOptions, QueryOptions, QueryScanConsistency
from couchbase_core.cluster import PasswordAuthenticator
cluster = Cluster.connect("couchbase://couchbase1.data", ClusterOptions(PasswordAuthenticator("Administrator", "password")))
This query returns successfully, but upon iterating over the rows, returns a timeout exception.
r = cluster.query('SELECT RAW meta(`resource`).id as docid from `resource` WHERE meta().id == $name', QueryOptions(read_only=True, scan_consistency=QueryScanConsistency.NOT_BOUNDED, named_parameters={'name': "NOSUCHKEY"}))
tuple(r)
Here’s the error:
Timeout Exception
couchbase.exceptions.TimeoutException: <RC=0xC9[LCB_ERR_TIMEOUT (201)], HTTP Request failed. Examine 'objextra' for full result, Results=1, C Source=(src/pycbc_http.c,212), OBJ=ViewResult<rc=0xC9[LCB_ERR_TIMEOUT (201)], value=None, http_status=0, tracing_context=0, tracing_output=None>, Context={'first_error_code': 0, 'http_response_code': 0, 'first_error_message': '', 'statement': 'SELECT RAW meta(resource).id as docid from resource WHERE meta().id == $name', 'client_context_id': '56a7431486c0527a', 'query_params': '', 'http_response_body': '', 'endpoint': '', 'type': 'QueryErrorContext'}, Tracing Output={":nokey:0": null}>
The next query is able to iterate over the rows, returning an empty tuple (as expected)
r = cluster.query('SELECT RAW meta(`resource`).id as docid from `resource` WHERE meta().id == $name', QueryOptions(scan_consistency=QueryScanConsistency.NOT_BOUNDED, named_parameters={'name': "NOSUCHKEY"}))
tuple(r)