Kibana Query Timeout - Cancel in-process query


#1

Hi,

Kibana (5.x version) times out and changes status to RED for some time if a user submits any query taking long time like searching across all indexes with query starting with *. Kibana recovers automatically but its inaccessible during that time for all users. Please note that ES is still accessible and can be queried using curl etc.

  1. Can we kill such query from backend or any other way to stop the in-process query from Kibana. There is no way to stop the in-process query from kibana.
  2. How can we make Kibana immediately available after status changes to RED due to query timeout.

Thanks!


(Spencer Alger) #2

Can you share the status you are getting? The only searching we do as a part of our healthcheck (which determines the elasticsearch plugins status) is against the kibana index, which I can't imagine would be blocked by the slow query you're describing...

First thing that comes to mind is using a separate cluster for kibana admin and data, this is done with the elasticsearch.tribe.url and might not be around forever, but it would isolate the healthcheck and kibana index from slow queries executed by other users...

Any logs or errors or screenshots you can provide would be helpful.


#3

Hi Spencer,

Below is screenshot :

We have similar question asked earlier but no resolution : Terminate long running queries to protect the system from DoS

The issue occurs if a user fires a long running query from Kibana which times out after 300000ms as shown in screenshot. This makes Kibana inaccessible to other users as well. While the status is red I am able to query ES health using curl. Hope this clarifies.

Thanks
Bal


(system) #4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.