Unfortunately there are many ways to trigger this error depending on version, etc - notably, the error reported in the coordinator log may not include 'IllegalStateException' at all. You can follow along the thread number in the log until the query fails, maybe there's a different (more helpful) stack trace there.
On Mon, Aug 12, 2019 at 8:26 PM Tim Armstrong <tarmstr...@cloudera.com> wrote: > > It you have a query profile, that's usually helpful to understand what > happened. Also the Impala version is helpful to diagnose. > > It's likely a bug in the frontend or in the metadata layer but hard to know > what it could be without more info. > > On Sun, Aug 11, 2019 at 9:01 PM Hendry Suwanda <suwanda.hen...@gmail.com> > wrote: >> >> Hi All, >> >> We got below intermittent error when running the query: >> >>> IllegalStateException: null >> >> >> the error not show in the log file, we got the error on the client side >> (impala-shell or impyla) >> >> after trying to re-run the query several times, the error is gone. >> >> when i check on the log, actually the query has been success to analyze >> >>> I0808 12:36:11.082648 26229 Frontend.java:1245] >>> 6d4a7a8d9810b706:84c7471800000000] Analyzing query: >>> .... query statement .... >>> I0808 12:36:11.089841 26229 Frontend.java:1285] >>> 6d4a7a8d9810b706:84c7471800000000] Analysis finished. >>> W0808 12:36:11.098770 26229 PlanNode.java:656] >>> 6d4a7a8d9810b706:84c7471800000000] overflow when adding longs: >>> 6769770590837407744, 6769770590837407744 >>> W0808 12:36:11.101025 26229 PlanNode.java:656] >>> 6d4a7a8d9810b706:84c7471800000000] overflow when adding longs: >>> 6769770590837407744, 6769770590837407744 >> >> >> i have check on all log (executor, coordinator & catalog) and not found the >> error related to that. On that day, i just found many log like below >> >>> Cancelling fragment instances as directed by the coordinator. Returned >>> status: Cancelled >> >> >> do you have suggestion, what else need to check? >> >> -- >> Regards, >> >> >> Hendry Suwanda >> >> Github: https://github.com/hendrysuwanda >> Blog: http://hendrysuwanda.github.io/