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
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)
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.
@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.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.