Summary: Certain query when fed into query advisor returns "Unknown response from server"
- 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)
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.
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".