Long running queries


(Oren Mazor) #1

Is there any way for me to kill a long running query?

while exploring various mapping types, on several occasions I've
attempted to sort a few thousand records, and this resulted in a query
the appears to run forever.

is there any way to see what ES is doing and/or to kill those actions
without having to kill the ES process?

thanks
Oren


(Shay Banon) #2

No, there isn't an option to stop a query that is executing. One of the
possible reasons why a query with sort takes a long time for the first time
is because it needs to load the values to be sorted to memory (and check
the logs to see if there are no failures doing that).

On Wed, Dec 28, 2011 at 8:18 AM, Oren Mazor oren.mazor@gmail.com wrote:

Is there any way for me to kill a long running query?

while exploring various mapping types, on several occasions I've
attempted to sort a few thousand records, and this resulted in a query
the appears to run forever.

is there any way to see what ES is doing and/or to kill those actions
without having to kill the ES process?

thanks
Oren


(Oren Mazor) #3

Got it. so really my only option is to kill ES, when it's become
completely unresponsive after running a query for 10 hours.

is there a safe way to do that? or do I just kill/restart the process?

On Dec 28, 5:35 am, Shay Banon kim...@gmail.com wrote:

No, there isn't an option to stop a query that is executing. One of the
possible reasons why a query with sort takes a long time for the first time
is because it needs to load the values to be sorted to memory (and check
the logs to see if there are no failures doing that).

On Wed, Dec 28, 2011 at 8:18 AM, Oren Mazor oren.ma...@gmail.com wrote:

Is there any way for me to kill a long running query?

while exploring various mapping types, on several occasions I've
attempted to sort a few thousand records, and this resulted in a query
the appears to run forever.

is there any way to see what ES is doing and/or to kill those actions
without having to kill the ES process?

thanks
Oren


(Shay Banon) #4

10 hours sounds excessive, anything in the logs?

On Wed, Dec 28, 2011 at 4:57 PM, Oren Mazor oren.mazor@gmail.com wrote:

Got it. so really my only option is to kill ES, when it's become
completely unresponsive after running a query for 10 hours.

is there a safe way to do that? or do I just kill/restart the process?

On Dec 28, 5:35 am, Shay Banon kim...@gmail.com wrote:

No, there isn't an option to stop a query that is executing. One of the
possible reasons why a query with sort takes a long time for the first
time
is because it needs to load the values to be sorted to memory (and check
the logs to see if there are no failures doing that).

On Wed, Dec 28, 2011 at 8:18 AM, Oren Mazor oren.ma...@gmail.com
wrote:

Is there any way for me to kill a long running query?

while exploring various mapping types, on several occasions I've
attempted to sort a few thousand records, and this resulted in a query
the appears to run forever.

is there any way to see what ES is doing and/or to kill those actions
without having to kill the ES process?

thanks
Oren


(system) #5