You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Divya Gehlot <di...@gmail.com> on 2018/10/26 03:15:24 UTC
Query hung in Cancelled_Requested state
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
Re: Query hung in Cancelled_Requested state
Posted by Arina Yelchiyeva <ar...@gmail.com>.
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 <kf...@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 <di...@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 <sh...@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 <ku...@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 <di...@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
>>>>
>>>
>>
Re: Query hung in Cancelled_Requested state
Posted by Khurram Faraaz <kf...@mapr.com>.
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 <di...@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 <sh...@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 <ku...@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 <di...@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
> > >
> >
>
Re: Query hung in Cancelled_Requested state
Posted by Divya Gehlot <di...@gmail.com>.
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 <sh...@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 <ku...@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 <di...@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
> >
>
Re: Query hung in Cancelled_Requested state
Posted by Sorabh Hamirwasia <sh...@mapr.com>.
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 <ku...@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 <di...@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
>
Re: Query hung in Cancelled_Requested state
Posted by Kunal Khatua <ku...@apache.org>.
What is the Drillbit's JStack? You can try seeing the /threads webpage.
On 10/25/2018 8:16:06 PM, Divya Gehlot <di...@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