Mailing-List: contact dev-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
MIME-Version: 1.0
In-Reply-To: 
 <CAJrw0OTc7GWyy9ov0umFE9aQKDYBVR180PjpDWN2B+zY_Un++g@mail.gmail.com>
References: 
 <CAKTYAC_RFOMu9w4QkmBTrPXOa3+CfVr60=Dc2thUMv_M8jZZ7w@mail.gmail.com>
	<CANZQJAwbOUdeCBa_o=CYT7rw09jC6EY5xEZQ6Hv6Qiid7Uuy1A@mail.gmail.com>
	<CAKTYAC9+5d9BFDNuTAxdJFOtm+WdRnDeVMmesWu573xKs+vmzg@mail.gmail.com>
	<CAJrw0OTc7GWyy9ov0umFE9aQKDYBVR180PjpDWN2B+zY_Un++g@mail.gmail.com>
Date: Wed, 20 Jan 2016 13:42:29 -0800
Message-ID: 
 <CAKTYAC_VifeOpX-FMOqZRHinSvENk9eu4fjjXT-1fdh1m3ndeA@mail.gmail.com>
Subject: Re: query hanging in CANCELLATION_REQUEST
From: Abdel Hakim Deneche <adeneche@maprtech.com>
To: "dev@drill.apache.org" <dev@drill.apache.org>
Content-Type: multipart/alternative; boundary=047d7b5d977fe8e9800529cadc79

--047d7b5d977fe8e9800529cadc79
Content-Type: text/plain; charset=UTF-8

I found the issue, I think. Sort was spilling to disk and I run out of disk
space, for some reason this caused Zookeeper to behave incorrectly, I could
still connect to Drill after the first query hang, but once I run a second
query ZK died.

Could this explain the query hang ?

On Tue, Jan 19, 2016 at 1:57 PM, Jacques Nadeau <jacques@dremio.com> wrote:

> It sounds like the connection break is not correctly marking an ack fail.
>
> --
> Jacques Nadeau
> CTO and Co-Founder, Dremio
>
> On Tue, Jan 19, 2016 at 11:47 AM, Abdel Hakim Deneche <
> adeneche@maprtech.com
> > wrote:
>
> > Ok, I will create a JIRA
> >
> > On Tue, Jan 19, 2016 at 11:45 AM, Hanifi Gunes <hgunes@maprtech.com>
> > wrote:
> >
> > > I had reported this problem sometime last year verbally. I don't
> remember
> > > creating a JIRA though. In general, I dislike this sort of blocking
> calls
> > > anywhere in the execution even though one could argue it simplifies the
> > > code flow.
> > >
> > > A JIRA would be appreciated.
> > >
> > > On Tue, Jan 19, 2016 at 11:10 AM, Abdel Hakim Deneche <
> > > adeneche@maprtech.com
> > > > wrote:
> > >
> > > > I was running a query with a hash join that was generating lot's of
> > > > results. I cancelled the query from sqlline then closed it. Now the
> > query
> > > > is stuck in CANCELLATION_REQUEST state.
> > > >
> > > > Looking at jstack it looks like screenRoot is blocked waiting for
> data
> > > sent
> > > > to the client to be acknowledged.
> > > >
> > > > Do we have a JIRA similar to this ?
> > > >
> > > > --
> > > >
> > > > Abdelhakim Deneche
> > > >
> > > > Software Engineer
> > > >
> > > >   <http://www.mapr.com/>
> > > >
> > > >
> > > > Now Available - Free Hadoop On-Demand Training
> > > > <
> > > >
> > >
> >
> http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available
> > > > >
> > > >
> > >
> >
> >
> >
> > --
> >
> > Abdelhakim Deneche
> >
> > Software Engineer
> >
> >   <http://www.mapr.com/>
> >
> >
> > Now Available - Free Hadoop On-Demand Training
> > <
> >
> http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available
> > >
> >
>


-- 

Abdelhakim Deneche

Software Engineer

  <http://www.mapr.com/>


Now Available - Free Hadoop On-Demand Training
<http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>

--047d7b5d977fe8e9800529cadc79--