Details
Description
Summary: Certain query when fed into query advisor returns "Unknown response from server"
Repro:
- Install Couchbase Server enterprise
- Create bucket with primary key (I named mine survey_results_public)
- Enable developer preview mode (so that index advisor is enabled)
- Run the query (see attached)
Actual:
Message "Unknown response from server" appears in the UI. See screenshot and see JavaScript response.
Expected:
This depends on what's happening behind the scenes.
Is the advisor unable to make a recommendation? There isn't any "reason" or additional information in the response from the server. It would be nice if there was at least a short reason given why no indexes could be recommended.
Another possibility is that this is a bug in the advisor.
and/or
This might be mitigated in the UI with a more descriptive error message. But it seems like the UI is really at the mercy of the backend here, so I'm not sure what that message could be. At the least, something like "Unable to recommend an index" is slightly better than "Unknown response from server".
Attachments
For Gerrit Dashboard: MB-34662 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
111331,4 | MB-34662 Follow the valid index name pattern defined in indexing | master | query-ee | Status: MERGED | +2 | +1 |
111892,7 | MB-34662 fix bug in unnest array index(part 1) | master | query-ee | Status: MERGED | +2 | +1 |
111894,5 | MB-34662 add test cases(part 2) | master | query | Status: MERGED | +2 | +1 |