drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Arina Yelchiyeva <arina.yelchiy...@gmail.com>
Subject Re: Query hung in Cancelled_Requested state
Date Fri, 26 Oct 2018 08:39:30 GMT
If query is in cancellation_requested state for days, the only way to kill it to restart the
Drillbits.

Kind regards,
Arina

> On Oct 26, 2018, at 10:45 AM, Khurram Faraaz <kfaraaz@mapr.com> wrote:
> 
> Hi Divya,
> 
> Please see link below for more info, I have added details of how to Cancel
> a query using the REST API
> https://drill.apache.org/docs/rest-api-introduction/
> 
> GET /profiles/cancel/{queryid}
> Cancel the query that has the given queryid.
> 
> Parameter
> 
> queryid--The UUID of the query in standard UUID format that Drill assigns
> to each query.
> 
> Example
> 
> curl
> http://localhost:8047/profiles/cancel/29b2e988-35e7-4c85-3151-32c7d3347f15
> 
> Thanks,
> Khurram
> 
> On Thu, Oct 25, 2018 at 11:50 PM Divya Gehlot <divya.htconex@gmail.com>
> wrote:
> 
>> Hi ,
>> The query hanging in Cancellation_Request is one of the bug on Drill 1.10
>> and this issue has been resolved  post Drill 1.10 .
>> That's why I am asking is there any way apart from Web UI where I can kill
>> the query using the query id ?
>> The queries that I am trying to kill are running for days .
>> 
>> Thanks,
>> Divya
>> 
>> On Fri, 26 Oct 2018 at 14:04, Sorabh Hamirwasia <shamirwasia@mapr.com>
>> wrote:
>> 
>>> Hi Divya,
>>> If possible can you also try running same query on master ? There have
>> been
>>> lots of improvement/bug fixes in cancellation code path to resolve hang
>>> situations post 1.10.
>>> 
>>> Thanks,
>>> Sorabh
>>> 
>>>> On Thu, Oct 25, 2018 at 10:49 PM Kunal Khatua <kunal@apache.org> wrote:
>>>> 
>>>> What is the Drillbit's JStack? You can try seeing the /threads webpage.
>>>> 
>>>> On 10/25/2018 8:16:06 PM, Divya Gehlot <divya.htconex@gmail.com>
>> wrote:
>>>> Hi,
>>>> I am using Dril 1.10 and I have query running for days and when I click
>>> on
>>>> cacel the query through Drill Web UI . It hung in
>> Cancellation_Requested
>>>> state .
>>>> Is there any way to cancel the query using query id though terminal ?
>>>> Appreciate your help !
>>>> 
>>>> Thanks,
>>>> Divya
>>>> 
>>> 
>> 

Mime
View raw message