Details
Description
Internal error observed while running analytics query post couchbase server restart on one of the cbas nodes in the cluster, even when "cbas/analytics/cluster" endpoint returns analytics cluster status as active.
Steps to reproduce -
- Create a 4 node cluster with 1 KV-N1QL-Index and 3 CBAS node.
- Load travel-sample bucket.
- Wait for travel-sample.inventory datasets on analytics to completely ingest data.
- Create analytics sample on all the datasets under travel-sample.inventory.
- Run the following query -
-
select count(*) from (select ar.airportname, al.name as airlinename, ht.name as hotelname, ld.name as landmark from `travel-sample`.inventory.airport ar, `travel-sample`.inventory.airline al, `travel-sample`.inventory.hotel ht, `travel-sample`.inventory.landmark ld where ar.country = al.country and ar.city = ht.city and ht.city = ld.city) as x;
-
- Restart couchbase_server.
- Make a call to "cbas/analytics/cluster" endpoint, analytics cluster status is shown as active.
- Now try to run the query mentioned in step 5 again.
- Internal error is returned.
2023-03-23 16:22:29,142 | infra | ERROR | MainThread | [Rest_Connection:_http_request:318] POST http://10.112.230.104:8095/analytics/service body: {"pretty": "true", "client_context_id": null, "timeout": "120s", "statement": "select count(*) from (select ar.airportname, al.name as airlinename, ht.name as hotelname, ld.name as landmark from `travel-sample`.inventory.airport ar, `travel-sample`.inventory.airline al, `travel-sample`.inventory.hotel ht, `travel-sample`.inventory.landmark ld where ar.country = al.country and ar.city = ht.city and ht.city = ld.city) as x;"} headers: {'Accept': '*/*', 'Connection': 'close', 'Authorization': 'Basic QWRtaW5pc3RyYXRvcjpwYXNzd29yZA==', 'Content-Type': 'application/json'} error: 503 reason: unknown { |
"requestID": "acaf78f6-8032-438c-80f9-ed8722e08e1c", |
"clientContextID": "null", |
"errors": [{ |
"code": 25000, "msg": "Internal error" } |
],
|
"status": "failed", |
"metrics": { |
"elapsedTime": "508.731373ms", |
"executionTime": "507.591001ms", |
"resultCount": 0, |
"resultSize": 0, |
"processedObjects": 0, |
"errorCount": 1 |
}
|
} auth: Administrator:password
|
|