Details
-
Bug
-
Resolution: Fixed
-
Critical
-
6.5.0
-
Untriaged
-
Yes
Description
Build : 6.5.0-4218
Last known good build : 6.5.0-4169
Possible change that could have caused the regression :
Commit: ab6d8e9af451b140e00365492554e744a0689334 in build: 6.5.0-4189
|
MB-35490, MB-35237 - Add support for the following 1. Auto discovery of Analytics nodes (along with N1QL) for cbq using option --analytics. and 2. Alternate address support for the same using --networkconfig.
|
|
Change-Id: I1f1b86a37d139706579157b0ead529476eac9855
|
Reviewed-on: http://review.couchbase.org/113666
|
Reviewed-by: Sitaram Vemulapalli <sitaram.vemulapalli@couchbase.com>
|
Reviewed-by: Johan Larson <johan.larson@couchbase.com>
|
Tested-by: Isha Kandaswamy <isha@couchbase.com>
|
On a single node cluster, connecting to cluster using cbq via 8091 port results in an error - ERROR 100 : N1QL: Alternate Addresses required. Using port 8093, it works fine.
root@deb91-qe:/opt/couchbase/bin# /opt/couchbase/bin/cbq -engine=http://172.23.96.55:8091/ -q -u Administrator -p password -s="SELECT * FROM system:keyspaces"
|
ERROR 100 : N1QL: Alternate Addresses required.
|
|
ERROR 107 : Not connected to any cluster. Use \CONNECT command.
|
|
root@deb91-qe:/opt/couchbase/bin# /opt/couchbase/bin/cbq -engine=http://127.0.0.1:8093^C
|
root@deb91-qe:/opt/couchbase/bin# /opt/couchbase/bin/cbq -engine=http://172.23.96.55:8093/ -q -u Administrator -p password -s="SELECT * FROM system:keyspaces"
|
{
|
"requestID": "6619402e-da0b-480c-b12d-ad6ec3a18cc8",
|
"signature": {
|
"*": "*"
|
},
|
"results": [
|
],
|
"status": "success",
|
"metrics": {
|
"elapsedTime": "4.658701ms",
|
"executionTime": "4.581223ms",
|
"resultCount": 0,
|
"resultSize": 0
|
}
|
}
|
root@deb91-qe:/opt/couchbase/bin# /opt/couchbase/bin/cbq -engine=http://172.23.96.55:8093 -q -u Administrator -p password -s="SELECT * FROM system:keyspaces"
|
{
|
"requestID": "0f4f44d9-63f9-415c-8978-2e4753a436b0",
|
"signature": {
|
"*": "*"
|
},
|
"results": [
|
],
|
"status": "success",
|
"metrics": {
|
"elapsedTime": "5.095207ms",
|
"executionTime": "5.019844ms",
|
"resultCount": 0,
|
"resultSize": 0
|
}
|
}
|
On build 6.5.0-4169, this used to work fine with either ports - 8091/8093.
root@deb91-qe:/tmp# /opt/couchbase/bin/cbq -engine=http://172.23.96.55:8093 -q -u Administrator -p password -s="SELECT * FROM system:keyspaces"
|
{
|
"requestID": "947a3e56-be34-41a4-9eb9-84a335bb152f",
|
"signature": {
|
"*": "*"
|
},
|
"results": [
|
],
|
"status": "success",
|
"metrics": {
|
"elapsedTime": "5.589239ms",
|
"executionTime": "5.486449ms",
|
"resultCount": 0,
|
"resultSize": 0
|
}
|
}
|
root@deb91-qe:/tmp# /opt/couchbase/bin/cbq -engine=http://172.23.96.55:8091/ -q -u Administrator -p password -s="SELECT * FROM system:keyspaces"
|
{
|
"requestID": "74a191da-4bbe-4dc3-9d16-e74f539be771",
|
"signature": {
|
"*": "*"
|
},
|
"results": [
|
],
|
"status": "success",
|
"metrics": {
|
"elapsedTime": "5.131577ms",
|
"executionTime": "5.040666ms",
|
"resultCount": 0,
|
"resultSize": 0
|
}
|
}
|
This was tested on a VM where alternate addr is not configured.