refresh_cluster_map fails with ERROR 199 : N1QL: Invalid query service endpoint
Description
Components
Affects versions
Fix versions
Labels
None
Environment
7.1.0-2551
Link to Log File, atop/blg, CBCollectInfo, Core dump
None
Release Notes Description
None
backports to
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
@Donald Haggart
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
@Pierre Regazzoni , I never saw any indication of approval for 7.1.1; @Kamini Jagtiani is this to be fixed in 7.1.1 too?
Pierre Regazzoni June 10, 2022 at 9:19 PM
@Donald Haggart 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
Reporter
Pierre Regazzoni
Pierre RegazzoniIs this a Regression?
Unknown
Triage
Untriaged
Story Points
1
Priority
Major
Instabug
Open Instabug
PagerDuty
PagerDuty Incident
PagerDuty Incident
Sentry
Linked Issues
Linked Issues
Zendesk Support
Linked Tickets
Linked Tickets
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
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", ... } }