Canvas - Unexpected error from Elasticsearch: [illegal_argument_exception] Illegal Capacity: -2

Elastic Stack Kibana
1

Hi,

This is w.r.t an error observed in Canvas dashboard containing a elsql. We are getting below error:
Unexpected error from Elasticsearch: [illegal_argument_exception] Illegal Capacity: -2
Please note that the index mentioned in the elsql has data in it.

Query is:
SELECT status,count() as CNT FROM "prd-gst-bg-jobs"
where created_ts > TODAY() and job_type_id NOT IN (16,27) group by status

Error is:

image
image.png1366×768 114 KB

2

Hi,

Any help would be appreciable.

3

@abdulsofts

  • What ES version is this?
  • Also, if you run the same query outside Canvas (using the REST API is one example), I am assuming you get the same error, but do you also get a more complete error message in Elasticsearch logs? (I'm interested in the stack trace especially)
  • prd-gst-bg-jobs is an alias or an index?
4

Hi Andrei Stefan,

Thank you for your response.

ES version is 7.2.
I think there are no related logs for this. Anyways, I will check again and post the logs if I find any.
prd-gst-bg-jobs is the alias of index with which the query was working earlier and this issue was observed recently.

5

@abdulsofts can you be more specific on the version of ES? There isn't one single 7.2 version.

Also, a similar looking bug has been fixed for 7.2.2 version. So, it's important to know the exact version. If you are using a version earlier than 7.2.2, can you upgrade and test this again? Thanks.

6

Hi,

Our elastic search version is 7.2.0.

{
"name" : "<host_name>",
"cluster_name" : "logging-prod",
"cluster_uuid" : "<cluster_uuid>",
"version" : {
"number" : "7.2.0",
"build_flavor" : "default",
"build_type" : "deb",
"build_hash" : "508c38a",
"build_date" : "2019-06-20T15:54:18.811730Z",
"build_snapshot" : false,
"lucene_version" : "8.0.0",
"minimum_wire_compatibility_version" : "6.8.0",
"minimum_index_compatibility_version" : "6.0.0-beta1"
},
"tagline" : "You Know, for Search"
}

7

@abdulsofts then I recommend upgrading to at least version 7.2.2 as there are high changes the bug is fixed there.

8

Thank you so much for your inputs.