N1ql query timeout

Python SDK
1

I have a N1QL query that uses a selection on an indexed field (VIEW index not GSI). It seems to work well in the web console:

58
Screen Shot 2017-10-05 at 10.18.58.png911×204 26.3 KB

But it fails in Python:

39
Screen Shot 2017-10-05 at 10.18.39.png649×573 69.3 KB

I run the IPython notebook in the same subnet, as I thought it might have to do with the private IPs of the nodes.

To get stuck at something simple as this is pretty frustrating.
What can I do to get this to work?

Version python module couchbase==2.1.0
Version Couchbase 4.5.1 on cluster
Version Couchbase 4.1.0-5005 on query running computer (dont know if that matters)

2

Hi. You seem to have backticks surrounding the ‘occupancyHistory’ string in your query. Try changing them to quotes to match the query you put into the web UI.

HTH