refresh_cluster_map fails with ERROR 199 :  N1QL: Invalid query service endpoint

Description

refresh_cluster_map command returns ERROR 199

# /opt/couchbase/bin/cbq -u Administrator -p password -e couchbase://172.23.104.90  Connected to : http://172.23.104.90:8091/. Type Ctrl-D or \QUIT to exit. Path to history file for the shell : /root/.cbq_history  cbq> \refresh_cluster_map;  ERROR 199 :  N1QL: Invalid query service endpoint.

Note that issue above is on first attempt. If I run one query first the refresh_map will work

cbq> select 1; {     "requestID": "0937aa90-0f23-4be1-8660-353823f30dab",     "signature": {         "$1": "number"     },     "results": [     {         "$1": 1     }     ],     "status": "success",     "metrics": {         "elapsedTime": "1.165093ms",         "executionTime": "971.268µs",         "resultCount": 1,         "resultSize": 23,         "serviceLoad": 6     },     "profile": { ...         "requestTime": "2022-04-19T14:48:09.718-07:00",         "servicingHost": "172.23.104.90:8091", ...     } } cbq> \refresh_cluster_map; cbq> select 1; {     "requestID": "8b7e4cbb-774b-4e04-82e0-33a64a601021",     "signature": {         "$1": "number"     },     "results": [     {         "$1": 1     }     ],     "status": "success",     "metrics": {         "elapsedTime": "1.115136ms",         "executionTime": "912.802µs",         "resultCount": 1,         "resultSize": 23,         "serviceLoad": 6     },     "profile": { ...         "requestTime": "2022-04-19T14:48:32.449-07:00",         "servicingHost": "172.23.104.92:8091", ...     } }

 

Components

Affects versions

Fix versions

Labels

Environment

7.1.0-2551

Link to Log File, atop/blg, CBCollectInfo, Core dump

None

Release Notes Description

None

Activity

Show:

Pierre Regazzoni January 5, 2023 at 9:57 PM

Verified on 7.5.0-3465

[root@node1 ~]# /opt/couchbase/bin/cbq -u Administrator -p password -e couchbase://172.23.104.90  Connected to : http://172.23.104.90:8091/. Type Ctrl-D or \QUIT to exit. Path to history file for the shell : /root/.cbq_history  cbq> \refresh_cluster_map; cbq>

Kamini Jagtiani June 10, 2022 at 10:00 PM

 

Yes, would be good to fix. Can you clone this defect to backport to 7.1.1?Thanks!

Donald Haggart June 10, 2022 at 9:54 PM

, I never saw any indication of approval for 7.1.1; is this to be fixed in 7.1.1 too?

Pierre Regazzoni June 10, 2022 at 9:19 PM

is the plan to fix this for 7.1.1 as well?

CB robot April 22, 2022 at 6:10 PM

Build couchbase-server-7.2.0-1091 contains query commit 3ff7be0 with commit message:
https://couchbasecloud.atlassian.net/browse/MB-51867#icft=MB-51867 Ensure valid URL for cluster refresh

Fixed
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Pierre Regazzoni

Reporter

Is this a Regression?

Unknown

Triage

Untriaged

Story Points

1

Priority

Instabug

Open Instabug

PagerDuty

Sentry

Zendesk Support

Created April 19, 2022 at 9:22 PM
Updated January 5, 2023 at 9:57 PM
Resolved April 22, 2022 at 6:36 PM
Instabug