Grafana 7.1.4, ElasticSearch7.9, Chrome Version 84.0.4147.135
Adhoc filters (ElasticSearch Datasource) are not working correctly on a Table Panel.
I have created a table panel aggregating (count)
Group By TERMS user_name Order by: Term value (desc)
Then By TERMS group_name Order by: Term value (desc)
Then By TERMS job_status Order by: Term value (desc)
using an Elastic DS and an adhoc filter using the same Elastic DS for the adhoc filter.
Selecting to positively filter on one of the fields yields no data resulting in the following error.
{
“request”: {
“url”: “api/datasources/proxy/2/_msearch?max_concurrent_shard_requests=5”,
“method”: “POST”,
“data”: “{“search_type”:“query_then_fetch”,“ignore_unavailable”:true,“index”:“lsf_job_acct*”}\n{“size”:0,“query”:{“bool”:{“filter”:[{“range”:{“event_time”:{“gte”:1598418487404,“lte”:1598429287404,“format”:“epoch_millis”}}},{“query_string”:{“analyze_wildcard”:true,“query”:”"}}],“must”:[{“match_phrase”:{“job_group”:{“query”:"/AA/BB/Job_Group_1"}}}]}},“aggs”:{“6”:{“terms”:{“field”:“user_name”,“size”:500,“order”:{"_key":“desc”},“min_doc_count”:0},“aggs”:{“8”:{“terms”:{“field”:“job_group”,“size”:500,“order”:{"_key":“desc”},“min_doc_count”:0},“aggs”:{“7”:{“terms”:{“field”:“job_status”,“size”:500,“order”:{"_key":“desc”},“min_doc_count”:0},“aggs”:{}}}}}}}}\n"
},
“response”: {
“took”: 6,
“responses”: [
{
“error”: {
“root_cause”: [
{
“type”: “array_index_out_of_bounds_exception”,
“reason”: “Index -1 out of bounds for length 1”
}
],
“type”: “search_phase_execution_exception”,
“reason”: “all shards failed”,
“phase”: “query”,
“grouped”: true,
“failed_shards”: [
{
“shard”: 0,
“index”: “lsf_job_acct-202008”,
“node”: “RmFuqUbWQV-7qm0b4E9rjg”,
“reason”: {
“type”: “array_index_out_of_bounds_exception”,
“reason”: “Index -1 out of bounds for length 1”
}
}
],
“caused_by”: {
“type”: “array_index_out_of_bounds_exception”,
“reason”: “Index -1 out of bounds for length 1”,
“caused_by”: {
“type”: “array_index_out_of_bounds_exception”,
“reason”: “Index -1 out of bounds for length 1”
}
}
},
“status”: 500
}
],
“$$config”: {
“url”: “api/datasources/proxy/2/_msearch?max_concurrent_shard_requests=5”,
“method”: “POST”,
“data”: "{“search_type”:“query_then_fetch”,“ignore_unavailable”:true,“index”:"lsf_job_acct"}\n{“size”:0,“query”:{“bool”:{“filter”:[{“range”:{“event_time”:{“gte”:1598418487404,“lte”:1598429287404,“format”:“epoch_millis”}}},{“query_string”:{“analyze_wildcard”:true,“query”:"*"}}],“must”:[{“match_phrase”:{“job_group”:{“query”:"/AA/BB/Job_Group_1"}}}]}},“aggs”:{“6”:{“terms”:{“field”:“user_name”,“size”:500,“order”:{"_key":“desc”},“min_doc_count”:0},“aggs”:{“8”:{“terms”:{“field”:“job_group”,“size”:500,“order”:{"_key":“desc”},“min_doc_count”:0},“aggs”:{“7”:{“terms”:{“field”:“job_status”,“size”:500,“order”:{"_key":“desc”},“min_doc_count”:0},“aggs”:{}}}}}}}}\n"
}
}
}
Any ideas?
Thanks
W