Querying views from python works.... but N1QL doesn't

SQL++
1

Hi

I’ve deployed the Couchbase community addition AMI on amazon, and whilst N1QL queries work from cbq the same query timeouts via a python client on a remote machine. This is probably something to do with port 8093.

Here’s cbq some output:

cbq> select * from myBucket limit 1;
{
“requestID”: “115707f3-e026-450e-a2a2-6aa73beca478”,
“signature”: {
“": "”
},
“results”: [
{
“Statistics”: { …
}
}
],
“status”: “success”,
“metrics”: {
“elapsedTime”: “31.595524ms”,
“executionTime”: “31.532054ms”,
“resultCount”: 1,
“resultSize”: 22016
}
}

And here’s the same query from a python client on a separate machine (note I’ve replaced the public machine name with HOST for posting here):

from couchbase.n1ql import N1QLQuery
from couchbase.bucket import Bucket
bu=Bucket(‘http://HOST’, timeout=60000, unlock_gil=True)
qu=N1QLQuery(“select * from myBucket LIMIT 1;”)

for row in bu.n1ql_query(qu):
… print(row)
…
Traceback (most recent call last):
File “”, line 1, in
File “/usr/local/lib/python2.7/dist-packages/couchbase/n1ql.py”, line 508, in iter
raw_rows = self.raw.fetch(self._mres)
couchbase.exceptions._TimeoutError_0x17 (generated, catch TimeoutError): <RC=0x17[Client-Side timeout exceeded for operation. Inspect network conditions or increase the timeout], HTTP Request failed. Examine ‘objextra’ for full result, Results=1, C Source=(src/http.c,140), OBJ=ViewResult<rc=0x17[Client-Side timeout exceeded for operation. Inspect network conditions or increase the timeout], value=None, http_status=0>>

I can query views from the python client without any problems.

Any tips or guidance would be appreciated.

Kind regards

Darren

2

Actually as I type I should probably check the AWS security group… duh, looks like port 8093 isn’t open in the default security group. :anguished:

1 Like
3

Following link lists relevant steps & best practices on AWS:
http://developer.couchbase.com/documentation/server/4.5/install/deployment-aws.html