Hi Kunal,
Please find below answers to your question :-
1. Setup description :-
Number of Nodes : 5
RAM/Node : 32GB
Core/Node : 8
DRILL_MAX_DIRECT_MEMORY="20G"
DRILL_HEAP="16G"
2. What queries were you running and against what kind of dataset :-
Same type of queries as mentioned in trail mail and
dataset :- Drill Tables created from Hive Parquet Table which is created
from Json Log Files.
3. How frequently is it occurring :- 2-3 times in a month.
Please find below *Drill Logs* :-
[Error Id: e4cf470d-5aa8-4b9a-b8dd-d6201996cabe on host1:31010]
org.apache.drill.common.exceptions.UserException: SYSTEM ERROR:
IllegalReferenceCountException: refCnt: 0
Fragment 3:13
[Error Id: e4cf470d-5aa8-4b9a-b8dd-d6201996cabe on host1:31010]
at
org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:544)
~[drill-common-1.10.0.jar:1.10.0]
at
org.apache.drill.exec.work.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:293)
[drill-java-exec-1.10.0.jar:1.10.0]
at
org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:160)
[drill-java-exec-1.10.0.jar:1.10.0]
at
org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:262)
[drill-java-exec-1.10.0.jar:1.10.0]
at
org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38)
[drill-common-1.10.0.jar:1.10.0]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[na:1.8.0_72]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[na:1.8.0_72]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_72]
Caused by: io.netty.util.IllegalReferenceCountException: refCnt: 0
at
io.netty.buffer.AbstractByteBuf.ensureAccessible(AbstractByteBuf.java:1178)
~[netty-buffer-4.0.27.Final.jar:4.0.27.Final]
at io.netty.buffer.DrillBuf.checkIndexD(DrillBuf.java:115)
~[drill-memory-base-1.10.0.jar:4.0.27.Final]
at io.netty.buffer.DrillBuf.checkBytes(DrillBuf.java:141)
~[drill-memory-base-1.10.0.jar:4.0.27.Final]
at
org.apache.drill.exec.expr.fn.impl.ByteFunctionHelpers.compare(ByteFunctionHelpers.java:99)
~[vector-1.10.0.jar:1.10.0]
at
org.apache.drill.exec.test.generated.ProjectorGen3570.doEval(ProjectorTemplate.java:187)
~[na:na]
at
org.apache.drill.exec.test.generated.ProjectorGen3570.projectRecords(ProjectorTemplate.java:67)
~[na:na]
at
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.doWork(ProjectRecordBatch.java:199)
~[drill-java-exec-1.10.0.jar:1.10.0]
at
org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext(AbstractSingleRecordBatch.java:93)
~[drill-java-exec-1.10.0.jar:1.10.0]
at
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:135)
~[drill-java-exec-1.10.0.jar:1.10.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:162)
~[drill-java-exec-1.10.0.jar:1.10.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119)
~[drill-java-exec-1.10.0.jar:1.10.0]
at
org.apache.drill.exec.test.generated.HashAggregatorGen120.doWork(HashAggTemplate.java:312)
~[na:na]
at
org.apache.drill.exec.physical.impl.aggregate.HashAggBatch.innerNext(HashAggBatch.java:143)
~[drill-java-exec-1.10.0.jar:1.10.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:162)
~[drill-java-exec-1.10.0.jar:1.10.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119)
~[drill-java-exec-1.10.0.jar:1.10.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:109)
~[drill-java-exec-1.10.0.jar:1.10.0]
at
org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext(AbstractSingleRecordBatch.java:51)
~[drill-java-exec-1.10.0.jar:1.10.0]
at
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:135)
~[drill-java-exec-1.10.0.jar:1.10.0]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:162)
~[drill-java-exec-1.10.0.jar:1.10.0]
at
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:104)
~[drill-java-exec-1.10.0.jar:1.10.0]
at
org.apache.drill.exec.physical.impl.SingleSenderCreator$SingleSenderRootExec.innerNext(SingleSenderCreator.java:92)
~[drill-java-exec-1.10.0.jar:1.10.0]
at
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:94)
~[drill-java-exec-1.10.0.jar:1.10.0]
at
org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:232)
~[drill-java-exec-1.10.0.jar:1.10.0]
at
org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:226)
~[drill-java-exec-1.10.0.jar:1.10.0]
at java.security.AccessController.doPrivileged(Native Method)
~[na:1.8.0_72]
at javax.security.auth.Subject.doAs(Subject.java:422) ~[na:1.8.0_72]
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657)
~[hadoop-common-2.7.1.jar:na]
at
org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:226)
[drill-java-exec-1.10.0.jar:1.10.0]
... 4 common frames omitted
Regards,
*Anup Tiwari*
On Tue, Dec 12, 2017 at 11:46 AM, Kunal Khatua <kkha...@mapr.com> wrote:
> Sorry, I meant that Drill shutdown a *query* prematurely. When a query
> completes, all the related threads (fragments) need to perform a clean up
> and give resources back to the pool.
>
> This ideally should not have the need to be handled by the application.
> So, what would be good to know is
>
> 1. Setup description
> 2. What queries were you running and against what kind of dataset
> 3. How frequently is it occurring.
>
> The Drill logs also tend to have a stack trace for such errors, so it
> helps if you can share that too.
>
> ~Kunal
>
> -----Original Message-----
> From: Anup Tiwari [mailto:anup.tiw...@games24x7.com]
> Sent: Friday, December 08, 2017 12:35 AM
> To: user@drill.apache.org
> Subject: Re: [1.9.0] : UserException: SYSTEM ERROR:
> IllegalReferenceCountException: refCnt: 0 and then SYSTEM ERROR:
> IOException: Failed to shutdown streamer
>
> Hi Kunal,
>
> I was executing a similar query shared in trail mail also as you have
> mentioned :- *This is a system error and the message appears to hint that
> Drill shutdown a prematurely , *I have checked on all nodes and drill-bit
> is running properly.
>
> Note :- We are using Drill 1.10.0.
>
> Regards,
> *Anup Tiwari*
>
> On Thu, Dec 7, 2017 at 10:33 PM, Kunal Khatua <kkha...@mapr.com> wrote:
>
> > What is it that you were trying to do when you encountered this?
> >
> > This is a system error and the message appears to hint that Drill
> > shutdown a prematurely and is unable to account for that
> >
> > Kunal
> >
> >
> > From: Anup Tiwari
> > Sent: Wednesday, December 6, 7:46 PM
> > Subject: Re: [1.9.0] : UserException: SYSTEM ERROR:
> > IllegalReferenceCountException: refCnt: 0 and then SYSTEM ERROR:
> > IOException: Failed to shutdown streamer
> > To: user@drill.apache.org
> >
> >
> > Hi All, As asked in trail mail can someone explain how to handle :-
> > *UserException: SYSTEM ERROR: IllegalReferenceCountException* *: refCnt:
> > 0?* As above error doesn't explain what and where the real problem is?
> > But if we execute same query in hive for which we get above error then
> > it works. Regards, *Anup Tiwari* On Mon, Dec 12, 2016 at 5:07 PM, Anup
> > Tiwari
> > wrote: > Hi Aman, > > Sorry for delayed response, since we are
> > executing this query on our > ~150GB logs and as i have mentioned in
> > trail mail, by executing "removed > conditions alone" CTAS got
> > executed successfully, so i don't know which > sample data i should
> share(since i don't know pattern)?
> > > > Can you tell me in which scenarios we throw " >
> > IllegalReferenceCountException" and how to handle this in different >
> > scenarios? > > Regards, > *Anup Tiwari* > > On Thu, Dec 8, 2016 at
> > 10:55 PM, Aman Sinha wrote: > >> Hi Anup, >> since your original query
> > was working on 1.6 and failed in 1.9, could you >> pls file a JIRA for
> this ?
> > It sounds like a regression related to >> evaluation of a Project
> > expression (based on the stack trace). Since >> there >> are several
> > CASE exprs, quite likely something related to its evaluation. >> It
> > would be great if you can provide some sample data for someone to >>
> > debug. >> Thanks. >> >> On Thu, Dec 8, 2016 at 12:50 AM, Anup Tiwari
> > >> wrote: >> >>
> > > Hi, >> > >> > I have removed few conditions from my query then it
> > > just
> > worked fine. >> > >> > Also can someone tell me in which scenarios we
> > throw " >> > *IllegalReferenceCountException*" and how to handle it in
> > different >> > scenarios ? >> > >> > As i got this in another query
> > and by removing some conditions it worked >> > for me but when i
> > execute that removed conditions alone in CTAS , it got >> > executed
> > successfully. >> >
> > >> > Regards, >> > *Anup Tiwari* >> > >> > On Wed, Dec 7, 2016 at
> > >> > 12:22 PM,
> > Anup Tiwari > > >> > wrote: >> > >> > > Hi Team, >> > > >> > > I am
> > getting below 2 error in my one of the query which was working >> fine
> > >> > > on 1.6, Please help me out in this:- >> > > >> > > 1.
> > UserException: SYSTEM
> > ERROR: IllegalReferenceCountException: >> refCnt: >> > 0 >> > > 2.
> > SYSTEM
> > ERROR: IOException: Failed to shutdown streamer >> > > >> > > Please
> > find below query and its stack trace :- >> > > >> > > *Query :-* >> >
> > > >> > > create table a_tt3_reg_login as >> > > select sessionid, >> >
> > > >> > > count(distinct (case when ((( event = 'e.a' and ajaxUrl like
> > >> > > '%/ab/pL%t=r%' ) or ( (Base64Conv(Response) like '%st%tr%' and
> > >> > >
> > Base64Conv(Response) not like '%error%') and ajaxUrl like >>
> '%/sign/ter%'
> > >> > )) >> > > OR ( event = 'e.a' and ajaxUrl like
> '%/player/ter/ter.htm%'
> > and >> > > Base64Conv(Response) like '%st%tr%ter%tr%') OR (id =
> > '/ter/thyou.htm' >> > and >> > > url = '/pla/natlob.htm')) then
> > sessionid
> > end) ) as regs, >> > > >> > > count(distinct (case when ( ajaxUrl like
> > '%/signup/poLo%t=log%' and >> event >> > > = 'e.a' ) or ( event =
> > 'e.a' and ajaxUrl like >> '%j_spring_security_check%' >> > > and
> > Base64Conv(Response) like '%st%tr%') then sessionid end) ) as >> login
> > >> > , >> > > >> > > count(distinct (case when ((ajaxUrl like >>
> > '/pl%/loadResponsePage.htm%fD=
> > >> > true&sta=yes%' >> > > or ajaxUrl like
> > >> > '/pl%/loadResponsePage.htm%fD=true&sta=YES%')
> > OR >> > (ajaxUrl >> > > like 'loadSuccessPage.do%fD=true&sta=yes%' or
> > ajaxUrl like >> > > 'loadSuccessPage.do%fD=true&sta=YES%')) then
> > sessionid end) ) as fd >> , >> > > >> > > count(distinct (case when
> > ((ajaxUrl like >> '/pl%/loadResponsePage.htm%fD= >> > false&sta=yes%'
> > >> >
> > > or ajaxUrl like '/pl%/loadResponsePage.htm%fD=false&sta=YES%') OR >>
> > > > (ajaxUrl like 'loadSuccessPage.do%fD=false&sta=yes%' or ajaxUrl
> > > like >>
> > > > 'loadSuccessPage.do%fD=false&sta=YES%')) then sessionid end) ) as
> > > > rd
> > >> > > >> > > from >> > > tt2 >> > > group by sessionid; >> > > Error:
> > SYSTEM ERROR: IllegalReferenceCountException: refCnt: 0 >> > > >> > >
> > Fragment 14:19 >> > > >> > > [Error Id:
> > e4659753-f8d0-403c-9eec-0ff6f2e30dd9
> > on namenode:31010] >> > > (state=,code=0) >> > > >> > > >> > > *Stack
> > Trace From Drillbit.log:-* >> > > >> > > [Error Id:
> > e4659753-f8d0-403c-9eec-0ff6f2e30dd9
> > on namenode:31010] >> > > org.apache.drill.common.
> exceptions.UserException:
> > SYSTEM ERROR: >> > > IllegalReferenceCountException: refCnt: 0 >> > >
> > >>
> > > > Fragment 14:19 >> > > >> > > [Error Id:
> > > > e4659753-f8d0-403c-9eec-0ff6f2e30dd9
> > on namenode:31010] >> > > at
> > org.apache.drill.common.exceptions.UserException$
> > >> > > Builder.build(UserException.java:543)
> > >> > > ~[drill-common-1.9.0.jar:1.9.0] at
> > >> > > org.apache.drill.exec.work.fragment.FragmentExecutor. >> > >
> > sendFinalState(FragmentExecutor.java:293) >>
> > [drill-java-exec-1.9.0.jar:1. >> > > 9.0] >> > > at
> > org.apache.drill.exec.work.fragment.FragmentExecutor. >> > >
> > cleanup(FragmentExecutor.java:160) [drill-java-exec-1.9.0.jar:1.9.0]
> > >> >
> > > at org.apache.drill.exec.work.fragment.FragmentExecutor.run( >> >
> > FragmentExecutor.java:262) >> > > [drill-java-exec-1.9.0.jar:1.9.0] >>
> > >
> > > at org.apache.drill.common.SelfCleaningRunnable.run( >> >
> > SelfCleaningRunnable.java:38) >> > > [drill-common-1.9.0.jar:1.9.0] >>
> > > > at java.util.concurrent.ThreadPoolExecutor.runWorker( >> >
> > ThreadPoolExecutor.java:1142) >> > > [na:1.8.0_74] >> > > at
> > java.util.concurrent.ThreadPoolExecutor$Worker.run( >> >
> > ThreadPoolExecutor.java:617) >> > > [na:1.8.0_74] >> > > at
> > java.lang.Thread.run(Thread.java:745) [na:1.8.0_74] >> > > Caused by:
> > io.netty.util.IllegalReferenceCountException: refCnt: 0 >> > > at
> > io.netty.buffer.AbstractByteBuf.ensureAccessible( >> >
> > AbstractByteBuf.java:1178) >> > >
> > ~[netty-buffer-4.0.27.Final.jar:4.0.27.Final]
> > >> > > at io.netty.buffer.DrillBuf.checkIndexD(DrillBuf.java:115) >> >
> > >> > > >
> > ~[drill-memory-base-1.9.0.jar:4.0.27.Final] >> > > at
> > io.netty.buffer.DrillBuf.chk(DrillBuf.java:147) >> > >
> > ~[drill-memory-base-1.9.0.jar:4.0.27.Final] >> > > at
> > io.netty.buffer.DrillBuf.getByte(DrillBuf.java:775) >> > >
> > ~[drill-memory-base-1.9.0.jar:4.0.27.Final] >> > > at
> > org.apache.drill.exec.expr.fn.impl.CharSequenceWrapper. >> > >
> > isAscii(CharSequenceWrapper.java:143) ~[drill-java-exec-1.9.0.jar:1.
> > >> 9.0] >> > > at
> > org.apache.drill.exec.expr.fn.impl.CharSequenceWrapper. >>
> > > > setBuffer(CharSequenceWrapper.java:106) >>
> > ~[drill-java-exec-1.9.0.jar:1. >> > 9.0] >> > > at
> > org.apache.drill.exec.test.generated.ProjectorGen980. >> > >
> > doEval(ProjectorTemplate.java:776) ~[na:na] >> > > at
> > org.apache.drill.exec.test.generated.ProjectorGen980. >> > >
> > projectRecords(ProjectorTemplate.java:62) ~[na:na] >> > > at
> > org.apache.drill.exec.physical.impl.project. >> > >
> > ProjectRecordBatch.doWork(ProjectRecordBatch.java:199) >> > >
> > ~[drill-java-exec-1.9.0.jar:1.9.0] >> > > at
> org.apache.drill.exec.record.AbstractSingleRecordBatch.
> > >> > > innerNext(AbstractSingleRecordBatch.java:93) >> > >
> > ~[drill-java-exec-1.9.0.jar:1.9.0] >> > > at org.apache.drill.exec.
> physical.impl.project.
> > >> > > ProjectRecordBatch.innerNext(ProjectRecordBatch.java:135) >> >
> > >> > > >
> > ~[drill-java-exec-1.9.0.jar:1.9.0] >> > > at
> > org.apache.drill.exec.record.AbstractRecordBatch.next(
> > >> > AbstractRecordBatch.java:162) >> > >
> > >> > ~[drill-java-exec-1.9.0.jar:1.9.0]
> > >> > > at org.apache.drill.exec.record.AbstractRecordBatch.next( >> >
> > AbstractRecordBatch.java:119) >> > >
> > ~[drill-java-exec-1.9.0.jar:1.9.0]
> > >> > > at org.apache.drill.exec.test.generated.HashAggregatorGen33. >>
> > >> > > >
> > > doWork(HashAggTemplate.java:313) ~[na:na] >> > > at
> > org.apache.drill.exec.physical.impl.aggregate. >> > >
> > HashAggBatch.innerNext(HashAggBatch.java:144) >> > >
> > ~[drill-java-exec-1.9.0.jar:1.9.0] >> > > at
> > org.apache.drill.exec.record.AbstractRecordBatch.next(
> > >> > AbstractRecordBatch.java:162) >> > >
> > >> > ~[drill-java-exec-1.9.0.jar:1.9.0]
> > >> > > at org.apache.drill.exec.record.AbstractRecordBatch.next( >> >
> > AbstractRecordBatch.java:119) >> > >
> > ~[drill-java-exec-1.9.0.jar:1.9.0]
> > >> > > at org.apache.drill.exec.record.AbstractRecordBatch.next( >> >
> > AbstractRecordBatch.java:109) >> > >
> > ~[drill-java-exec-1.9.0.jar:1.9.0]
> > >> > > at org.apache.drill.exec.record.AbstractSingleRecordBatch. >> >
> > >> > > >
> > innerNext(AbstractSingleRecordBatch.java:51) >> > >
> > ~[drill-java-exec-1.9.0.jar:1.9.0] >> > > at org.apache.drill.exec.
> physical.impl.project.
> > >> > > ProjectRecordBatch.innerNext(ProjectRecordBatch.java:135) >> >
> > >> > > >
> > ~[drill-java-exec-1.9.0.jar:1.9.0] >> > > at
> > org.apache.drill.exec.record.AbstractRecordBatch.next(
> > >> > AbstractRecordBatch.java:162) >> > >
> > >> > ~[drill-java-exec-1.9.0.jar:1.9.0]
> > >> > > at org.apache.drill.exec.physical.impl.BaseRootExec. >> >
> > next(BaseRootExec.java:104) >> > > ~[drill-java-exec-1.9.0.jar:1.9.0]
> > >>
> > > > at org.apache.drill.exec.physical.impl.SingleSenderCreator$ >> > >
> > SingleSenderRootExec.innerNext(SingleSenderCreator.java:92) >> > >
> > ~[drill-java-exec-1.9.0.jar:1.9.0] >> > > at org.apache.drill.exec.
> physical.impl.BaseRootExec.
> > >> > next(BaseRootExec.java:94) >> > >
> > >> > ~[drill-java-exec-1.9.0.jar:1.9.0]
> > >> > > at org.apache.drill.exec.work.fragment.FragmentExecutor$1. >> >
> > run(FragmentExecutor.java:232) >> > >
> > ~[drill-java-exec-1.9.0.jar:1.9.0]
> > >> > > at org.apache.drill.exec.work.fragment.FragmentExecutor$1. >> >
> > run(FragmentExecutor.java:226) >> > >
> > ~[drill-java-exec-1.9.0.jar:1.9.0]
> > >> > > at java.security.AccessController.doPrivileged(Native Method)
> > >> > > >> >
> > > ~[na:1.8.0_74] >> > > at
> > > javax.security.auth.Subject.doAs(Subject.java:422)
> > >> > > ~[na:1.8.0_74] >> > > at
> > >> > > org.apache.hadoop.security.UserGroupInformation.doAs(
> > >> > > UserGroupInformation.java:1657) ~[hadoop-common-2.7.1.jar:na]
> > >> > > >> >
> > > at org.apache.drill.exec.work.fragment.FragmentExecutor.run( >> >
> > FragmentExecutor.java:226) >> > > [drill-java-exec-1.9.0.jar:1.9.0] >>
> > >
> > > ... 4 common frames omitted >> > > 2016-12-07 11:47:54,616
> > [CONTROL-rpc-event-queue] INFO >> >
> > o.a.d.e.w.fragment.FragmentExecutor
> > >> > > - 27b85671-2a57-7d5f-18a5-680566b07067:2:1: State change
> > >> > > requested RUNNING --> CANCELLATION_REQUESTED >> > > 2016-12-07
> > >> > > 11:47:54,616
> > [CONTROL-rpc-event-queue] INFO o.a.d.e.w.f. >> >
> > FragmentStatusReporter >>
> > > > - 27b85671-2a57-7d5f-18a5-680566b07067:2:1: State to report: >> >
> > > > >
> > CANCELLATION_REQUESTED >> > > 2016-12-07 11:47:54,617
> > [27b85671-2a57-7d5f-18a5-68056 >> 6b07067:frag:2:1] >> > > INFO
> > o.a.d.e.w.fragment.FragmentExecutor - 27b85671-2a57-7d5f-18a5- >> >
> > 680566b07067:2:1: >> > > State change requested CANCELLATION_REQUESTED
> > --> FINISHED >> > > 2016-12-07 11:47:54,617
> > [27b85671-2a57-7d5f-18a5-68056 >> 6b07067:frag:2:1] >> > > INFO
> > o.a.d.e.w.f.FragmentStatusReporter -
> > 27b85671-2a57-7d5f-18a5- >> > 680566b07067:2:1: >> > > State to report:
> > CANCELLED >> > > 2016-12-07 11:47:54,617 [CONTROL-rpc-event-queue]
> > INFO >>
> > > o.a.d.e.w.fragment.FragmentExecutor >> > > - 27b85671-2a57-7d5f-18a5-
> 680566b07067:7:1:
> > State change requested >> > > RUNNING --> CANCELLATION_REQUESTED >> >
> > >
> > 2016-12-07 11:47:54,663 [CONTROL-rpc-event-queue] INFO o.a.d.e.w.f. >>
> > > FragmentStatusReporter >> > > - 27b85671-2a57-7d5f-18a5-
> 680566b07067:7:1:
> > State to report: >> > > CANCELLATION_REQUESTED >> > > 2016-12-07
> > 11:47:54,664 [27b85671-2a57-7d5f-18a5-68056 >> 6b07067:frag:7:1] >> >
> > > INFO o.a.d.e.w.fragment.FragmentExecutor - 27b85671-2a57-7d5f-18a5-
> > >> >
> > 680566b07067:7:1: >> > > State change requested CANCELLATION_REQUESTED
> > --> FINISHED >> > > 2016-12-07 11:47:54,722
> > [27b85671-2a57-7d5f-18a5-68056 >> 6b07067:frag:7:1] >> > > INFO
> > o.a.d.e.w.f.FragmentStatusReporter -
> > 27b85671-2a57-7d5f-18a5- >> > 680566b07067:7:1: >> > > State to report:
> > CANCELLED >> > > 2016-12-07 11:47:54,675 [CONTROL-rpc-event-queue]
> > INFO >>
> > > o.a.d.e.w.fragment.FragmentExecutor >> > > - 27b85671-2a57-7d5f-18a5-
> 680566b07067:7:5:
> > State change requested >> > > RUNNING --> CANCELLATION_REQUESTED >> >
> > >
> > 2016-12-07 11:47:54,727 [CONTROL-rpc-event-queue] INFO o.a.d.e.w.f. >>
> > > FragmentStatusReporter >> > > - 27b85671-2a57-7d5f-18a5-
> 680566b07067:7:5:
> > State to report: >> > > CANCELLATION_REQUESTED >> > > 2016-12-07
> > 11:47:54,727 [27b85671-2a57-7d5f-18a5-68056 >> 6b07067:frag:7:5] >> >
> > > INFO o.a.d.e.w.fragment.FragmentExecutor - 27b85671-2a57-7d5f-18a5-
> > >> >
> > 680566b07067:7:5: >> > > State change requested CANCELLATION_REQUESTED
> > --> FINISHED >> > > 2016-12-07 11:47:54,727
> > [27b85671-2a57-7d5f-18a5-68056 >> 6b07067:frag:7:5] >> > > INFO
> > o.a.d.e.w.f.FragmentStatusReporter -
> > 27b85671-2a57-7d5f-18a5- >> > 680566b07067:7:5: >> > > State to report:
> > CANCELLED >> > > 2016-12-07 11:47:54,733 [CONTROL-rpc-event-queue]
> > INFO >>
> > > o.a.d.e.w.fragment.FragmentExecutor >> > > - 27b85671-2a57-7d5f-18a5-
> 680566b07067:7:9:
> > State change requested >> > > RUNNING --> CANCELLATION_REQUESTED >> >
> > >
> > 2016-12-07 11:47:54,733 [CONTROL-rpc-event-queue] INFO o.a.d.e.w.f. >>
> > > FragmentStatusReporter >> > > - 27b85671-2a57-7d5f-18a5-
> 680566b07067:7:9:
> > State to report: >> > > CANCELLATION_REQUESTED >> > > 2016-12-07
> > 11:47:54,733 [drill-executor-652] WARN >> >
> > o.a.d.exec.rpc.control.WorkEventBus
> > >> > > - Fragment 27b85671-2a57-7d5f-18a5-680566b07067:2:1 not found
> > >> > > in
> > the >> > work >> > > bus. >> > > 2016-12-07 11:47:54,734
> > [drill-executor-624] WARN >> > o.a.d.exec.rpc.control.WorkEventBus >>
> > > >
> > - Fragment 27b85671-2a57-7d5f-18a5-680566b07067:7:5 not found in the
> > >> > work >> > > bus. >> > > 2016-12-07 11:47:54,734
> > [drill-executor-621] WARN
> > >> > o.a.d.exec.rpc.control.WorkEventBus >> > > - Fragment
> > 27b85671-2a57-7d5f-18a5-680566b07067:7:1 not found in the >> > work >>
> > >
> > > bus. >> > > 2016-12-07 11:47:54,780 [27b85671-2a57-7d5f-18a5-68056
> > > >>
> > 6b07067:frag:7:9] >> > > INFO o.a.d.e.w.fragment.FragmentExecutor -
> > 27b85671-2a57-7d5f-18a5- >> > 680566b07067:7:9: >> > > State change
> > requested CANCELLATION_REQUESTED --> FINISHED >> > > 2016-12-07
> > 11:47:54,780 [27b85671-2a57-7d5f-18a5-68056 >> 6b07067:frag:7:9] >> >
> > > INFO o.a.d.e.w.f.FragmentStatusReporter - 27b85671-2a57-7d5f-18a5-
> > >> >
> > 680566b07067:7:9: >> > > State to report: CANCELLED >> > > 2016-12-07
> > 11:47:54,781 [drill-executor-625] WARN >> >
> > o.a.d.exec.rpc.control.WorkEventBus
> > >> > > - Fragment 27b85671-2a57-7d5f-18a5-680566b07067:7:9 not found
> > >> > > in
> > the >> > work >> > > bus. >> > > 2016-12-07 11:47:54,796
> > [CONTROL-rpc-event-queue] INFO >> >
> > o.a.d.e.w.fragment.FragmentExecutor
> > >> > > - 27b85671-2a57-7d5f-18a5-680566b07067:7:13: State change
> > requested >> > > RUNNING --> CANCELLATION_REQUESTED >> > > 2016-12-07
> > 11:47:54,796 [CONTROL-rpc-event-queue] INFO o.a.d.e.w.f. >> >
> > FragmentStatusReporter >> > > - 27b85671-2a57-7d5f-18a5-
> 680566b07067:7:13:
> > State to report: >> > > CANCELLATION_REQUESTED >> > > 2016-12-07
> > 11:47:54,796 [CONTROL-rpc-event-queue] INFO o.a.d.e.w.f. >> >
> > FragmentStatusReporter >> > > - 27b85671-2a57-7d5f-18a5-
> 680566b07067:7:13:
> > State to report: >> > > CANCELLATION_REQUESTED >> > > 2016-12-07
> > 11:47:54,797 [27b85671-2a57-7d5f-18a5-68056 >> 6b07067:frag:7:13] >> >
> > > INFO o.a.d.e.w.fragment.FragmentExecutor - 27b85671-2a57-7d5f-18a5-
> > >> >
> > 680566b07067:7:13: >> > > State change requested
> > CANCELLATION_REQUESTED --> FINISHED >> > > 2016-12-07 11:47:54,797
> > [CONTROL-rpc-event-queue] INFO >> > o.a.d.e.w.fragment.FragmentExecutor
> >> > > - 27b85671-2a57-7d5f-18a5-680566b07067:7:17:
> > State change requested >> > > RUNNING --> CANCELLATION_REQUESTED >> >
> > >
> > 2016-12-07 11:47:54,847 [27b85671-2a57-7d5f-18a5-68056 >>
> > 6b07067:frag:7:13] >> > > INFO o.a.d.e.w.f.FragmentStatusReporter -
> > 27b85671-2a57-7d5f-18a5- >> > 680566b07067:7:13: >> > > State to report:
> > CANCELLED >> > > 2016-12-07 11:47:54,847 [CONTROL-rpc-event-queue]
> > INFO o.a.d.e.w.f. >> > FragmentStatusReporter >> > > -
> 27b85671-2a57-7d5f-18a5-680566b07067:7:17:
> > State to report: >> > > CANCELLATION_REQUESTED >> > > 2016-12-07
> > 11:47:54,847 [drill-executor-626] WARN >> >
> > o.a.d.exec.rpc.control.WorkEventBus
> > >> > > - Fragment 27b85671-2a57-7d5f-18a5-680566b07067:7:13 not found
> > >> > > in
> > the >> > > work bus. >> > > 2016-12-07 11:47:54,855
> > [CONTROL-rpc-event-queue] INFO >> >
> > o.a.d.e.w.fragment.FragmentExecutor
> > >> > > - 27b85671-2a57-7d5f-18a5-680566b07067:7:21: State change
> > requested >> > > RUNNING --> CANCELLATION_REQUESTED >> > > 2016-12-07
> > 11:47:54,855 [CONTROL-rpc-event-queue] INFO o.a.d.e.w.f. >> >
> > FragmentStatusReporter >> > > - 27b85671-2a57-7d5f-18a5-
> 680566b07067:7:21:
> > State to report: >> > > CANCELLATION_REQUESTED >> > > 2016-12-07
> > 11:47:54,855 [27b85671-2a57-7d5f-18a5-68056 >> 6b07067:frag:7:17] >> >
> > > INFO o.a.d.e.w.fragment.FragmentExecutor - 27b85671-2a57-7d5f-18a5-
> > >> >
> > 680566b07067:7:17: >> > > State change requested
> > CANCELLATION_REQUESTED --> FINISHED >> > > 2016-12-07 11:47:54,855
> > [27b85671-2a57-7d5f-18a5-68056 >> 6b07067:frag:7:17] >> > > INFO
> > o.a.d.e.w.f.FragmentStatusReporter -
> > 27b85671-2a57-7d5f-18a5- >> > 680566b07067:7:17: >> > > State to report:
> > CANCELLED >> > > 2016-12-07 11:47:54,855 [drill-executor-628] WARN >>
> > > o.a.d.exec.rpc.control.WorkEventBus >> > > - Fragment
> > 27b85671-2a57-7d5f-18a5-680566b07067:7:17 not found in the >> > > work
> > bus. >> > > 2016-12-07 11:47:54,855 [27b85671-2a57-7d5f-18a5-68056 >>
> > 6b07067:frag:7:21] >> > > INFO o.a.d.e.w.fragment.FragmentExecutor -
> > 27b85671-2a57-7d5f-18a5- >> > 680566b07067:7:21: >> > > State change
> > requested CANCELLATION_REQUESTED --> FINISHED >> > > 2016-12-07
> > 11:47:54,855 [27b85671-2a57-7d5f-18a5-68056 >> 6b07067:frag:7:21] >> >
> > > INFO o.a.d.e.w.f.FragmentStatusReporter - 27b85671-2a57-7d5f-18a5-
> > >> >
> > 680566b07067:7:21: >> > > State to report: CANCELLED >> > > 2016-12-07
> > 11:47:54,856 [CONTROL-rpc-event-queue] INFO >> >
> > o.a.d.e.w.fragment.FragmentExecutor
> > >> > > - 27b85671-2a57-7d5f-18a5-680566b07067:8:1: State change
> > >> > > requested RUNNING --> CANCELLATION_REQUESTED >> > > 2016-12-07
> > >> > > 11:47:54,856
> > [CONTROL-rpc-event-queue] INFO o.a.d.e.w.f. >> >
> > FragmentStatusReporter >>
> > > > - 27b85671-2a57-7d5f-18a5-680566b07067:8:1: State to report: >> >
> > > > >
> > CANCELLATION_REQUESTED >> > > 2016-12-07 11:47:54,857
> > [27b85671-2a57-7d5f-18a5-68056 >> 6b07067:frag:8:1] >> > > INFO
> > o.a.d.e.w.fragment.FragmentExecutor - 27b85671-2a57-7d5f-18a5- >> >
> > 680566b07067:8:1: >> > > State change requested CANCELLATION_REQUESTED
> > --> FINISHED >> > > .... >> > > >> > > 2016-12-07 11:47:55,172
> > [27b85671-2a57-7d5f-18a5-68056 >> 6b07067:frag:1:1] >> > > INFO
> > o.a.d.e.w.fragment.FragmentExecutor - 27b85671-2a57-7d5f-18a5- >> >
> > 680566b07067:1:1: >> > > State change requested FAILED --> FINISHED >>
> > > >
> > 2016-12-07 11:47:55,174 [27b85671-2a57-7d5f-18a5-68056 >>
> > 6b07067:frag:1:1]
> > >> > > ERROR o.a.d.e.w.fragment.FragmentExecutor - SYSTEM ERROR: >>
> > IOException: >> > > Failed to shutdown streamer >> > > >> > > Fragment
> > 1:1
> > >> > > >> > > [Error Id: 594a2ba9-6e58-4602-861e-8333f4356752 on
> > namenode:31010] >> > > org.apache.drill.common.exceptions.UserException:
> > SYSTEM ERROR: >> > > IOException: Failed to shutdown streamer >> > >
> > >> > > Fragment 1:1 >> > > >> > > [Error Id:
> > 594a2ba9-6e58-4602-861e-8333f4356752
> > on namenode:31010] >> > > at
> > org.apache.drill.common.exceptions.UserException$
> > >> > > Builder.build(UserException.java:543)
> > >> > > ~[drill-common-1.9.0.jar:1.9.0] at
> > >> > > org.apache.drill.exec.work.fragment.FragmentExecutor. >> > >
> > sendFinalState(FragmentExecutor.java:293) >>
> > [drill-java-exec-1.9.0.jar:1. >> > > 9.0] >> > > at
> > org.apache.drill.exec.work.fragment.FragmentExecutor. >> > >
> > cleanup(FragmentExecutor.java:160) [drill-java-exec-1.9.0.jar:1.9.0]
> > >> >
> > > at org.apache.drill.exec.work.fragment.FragmentExecutor.run( >> >
> > FragmentExecutor.java:262) >> > > [drill-java-exec-1.9.0.jar:1.9.0] >>
> > >
> > > at org.apache.drill.common.SelfCleaningRunnable.run( >> >
> > SelfCleaningRunnable.java:38) >> > > [drill-common-1.9.0.jar:1.9.0] >>
> > > > at java.util.concurrent.ThreadPoolExecutor.runWorker( >> >
> > ThreadPoolExecutor.java:1142) >> > > [na:1.8.0_74] >> > > at
> > java.util.concurrent.ThreadPoolExecutor$Worker.run( >> >
> > ThreadPoolExecutor.java:617) >> > > [na:1.8.0_74] >> > > at
> > java.lang.Thread.run(Thread.java:745) [na:1.8.0_74] >> > > Caused by:
> > java.io.IOException: Failed to shutdown streamer >> > > at
> > org.apache.hadoop.hdfs.DFSOutputStream.closeThreads( >> >
> > DFSOutputStream.java:2187) >> > > ~[hadoop-hdfs-2.7.1.jar:na] >> > >
> > at org.apache.hadoop.hdfs.DFSOutputStream.closeImpl( >> >
> > DFSOutputStream.java:2235) >> > > ~[hadoop-hdfs-2.7.1.jar:na] >> > >
> > at org.apache.hadoop.hdfs.DFSOutputStream.close( >> >
> > DFSOutputStream.java:2204) >> > > ~[hadoop-hdfs-2.7.1.jar:na] >> > >
> > at org.apache.hadoop.fs.FSDataOut >> putStream$PositionCache.close( >>
> > >
> > FSDataOutputStream.java:72) >> > > ~[hadoop-common-2.7.1.jar:na] >> >
> > > at org.apache.hadoop.fs.FSDataOutputStream.close( >> >
> > FSDataOutputStream.java:106) >> > > ~[hadoop-common-2.7.1.jar:na] >> >
> > > at org.apache.drill.exec.store.easy.json.JsonRecordWriter. >> > >
> > cleanup(JsonRecordWriter.java:246) ~[drill-java-exec-1.9.0.jar:1.9.0]
> > >>
> > > > at org.apache.drill.exec.physical.impl. >> > >
> > WriterRecordBatch.closeWriter(WriterRecordBatch.java:180) >> > >
> > ~[drill-java-exec-1.9.0.jar:1.9.0] >> > > at org.apache.drill.exec.
> physical.impl.
> > >> > > WriterRecordBatch.innerNext(WriterRecordBatch.java:128) >> > >
> > ~[drill-java-exec-1.9.0.jar:1.9.0] >> > > at
> > org.apache.drill.exec.record.AbstractRecordBatch.next(
> > >> > AbstractRecordBatch.java:162) >> > >
> > >> > ~[drill-java-exec-1.9.0.jar:1.9.0]
> > >> > > at org.apache.drill.exec.physical.impl.BaseRootExec. >> >
> > next(BaseRootExec.java:104) >> > > ~[drill-java-exec-1.9.0.jar:1.9.0]
> > >>
> > > > at org.apache.drill.exec.physical.impl.SingleSenderCreator$ >> > >
> > SingleSenderRootExec.innerNext(SingleSenderCreator.java:92) >> > >
> > ~[drill-java-exec-1.9.0.jar:1.9.0] >> > > at org.apache.drill.exec.
> physical.impl.BaseRootExec.
> > >> > next(BaseRootExec.java:94) >> > >
> > >> > ~[drill-java-exec-1.9.0.jar:1.9.0]
> > >> > > at org.apache.drill.exec.work.fragment.FragmentExecutor$1. >> >
> > run(FragmentExecutor.java:232) >> > >
> > ~[drill-java-exec-1.9.0.jar:1.9.0]
> > >> > > at org.apache.drill.exec.work.fragment.FragmentExecutor$1. >> >
> > run(FragmentExecutor.java:226) >> > >
> > ~[drill-java-exec-1.9.0.jar:1.9.0]
> > >> > > at java.security.AccessController.doPrivileged(Native Method)
> > >> > > >> >
> > > ~[na:1.8.0_74] >> > > at
> > > javax.security.auth.Subject.doAs(Subject.java:422)
> > >> > > ~[na:1.8.0_74] >> > > at
> > >> > > org.apache.hadoop.security.UserGroupInformation.doAs(
> > >> > > UserGroupInformation.java:1657) ~[hadoop-common-2.7.1.jar:na]
> > >> > > >> >
> > > at org.apache.drill.exec.work.fragment.FragmentExecutor.run( >> >
> > FragmentExecutor.java:226) >> > > [drill-java-exec-1.9.0.jar:1.9.0] >>
> > >
> > > ... 4 common frames omitted >> > > >> > > >> > > Regards, >> > >
> > > *Anup
> > Tiwari* >> > > >> > >> > >
> >
> >
>
