Re: [1.9.0] : UserException: SYSTEM ERROR: IllegalReferenceCountException: refCnt: 0 and then SYSTEM ERROR: IOException: Failed to shutdown streamer

[Anup Tiwari]

ll-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 :-* >> >
&

Re: [1.9.0] : UserException: SYSTEM ERROR: IllegalReferenceCountException: refCnt: 0 and then SYSTEM ERROR: IOException: Failed to shutdown streamer

[Anup Tiwari]

(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 

RE: [1.9.0] : UserException: SYSTEM ERROR: IllegalReferenceCountException: refCnt: 0 and then SYSTEM ERROR: IOException: Failed to shutdown streamer

[Kunal Khatua]

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 
> >>

Re: [1.9.0] : UserException: SYSTEM ERROR: IllegalReferenceCountException: refCnt: 0 and then SYSTEM ERROR: IOException: Failed to shutdown streamer

[Anup Tiwari]

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 >>

Re: [1.9.0] : UserException: SYSTEM ERROR: IllegalReferenceCountException: refCnt: 0 and then SYSTEM ERROR: IOException: Failed to shutdown streamer

[Kunal Khatua]

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=yes%' >> > > or ajaxUrl like 
'/pl%/loadResponsePage.htm%fD=true=YES%') OR >> > (ajaxUrl >> > > like 
'loadSuccessPage.do%fD=true=yes%' or ajaxUrl like >> > > 
'loadSuccessPage.do%fD=true=YES%')) then sessionid end) ) as fd >> , >> > > 
>> > > count(distinct (case when ((ajaxUrl like >> 
'/pl%/loadResponsePage.htm%fD= >> > false=yes%' >> > > or ajaxUrl like 
'/pl%/loadResponsePage.htm%fD=false=YES%') OR >> > > (ajaxUrl like 
'loadSuccessPage.do%fD=false=yes%' or ajaxUrl 

Re: [1.9.0] : UserException: SYSTEM ERROR: IllegalReferenceCountException: refCnt: 0 and then SYSTEM ERROR: IOException: Failed to shutdown streamer

[Anup Tiwari]

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=yes%'
>> > > or ajaxUrl like '/pl%/loadResponsePage.htm%fD=true=YES%') OR
>> > (ajaxUrl
>> > > like 'loadSuccessPage.do%fD=true=yes%' or ajaxUrl like
>> > > 'loadSuccessPage.do%fD=true=YES%'))  then sessionid end) ) as fd
>> ,
>> > >
>> > > count(distinct (case when ((ajaxUrl like
>> '/pl%/loadResponsePage.htm%fD=
>> > false=yes%'
>> > > or ajaxUrl like '/pl%/loadResponsePage.htm%fD=false=YES%') OR
>> > > (ajaxUrl like 'loadSuccessPage.do%fD=false=yes%' or ajaxUrl like
>> > > 'loadSuccessPage.do%fD=false=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 

Re: [1.9.0] : UserException: SYSTEM ERROR: IllegalReferenceCountException: refCnt: 0 and then SYSTEM ERROR: IOException: Failed to shutdown streamer

[Anup Tiwari]

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=yes%'
> > > or ajaxUrl like '/pl%/loadResponsePage.htm%fD=true=YES%') OR
> > (ajaxUrl
> > > like 'loadSuccessPage.do%fD=true=yes%' or ajaxUrl like
> > > 'loadSuccessPage.do%fD=true=YES%'))  then sessionid end) ) as fd ,
> > >
> > > count(distinct (case when ((ajaxUrl like '/pl%/loadResponsePage.htm%fD=
> > false=yes%'
> > > or ajaxUrl like '/pl%/loadResponsePage.htm%fD=false=YES%') OR
> > > (ajaxUrl like 'loadSuccessPage.do%fD=false=yes%' or ajaxUrl like
> > > 'loadSuccessPage.do%fD=false=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: 

Re: [1.9.0] : UserException: SYSTEM ERROR: IllegalReferenceCountException: refCnt: 0 and then SYSTEM ERROR: IOException: Failed to shutdown streamer

[Aman Sinha]

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=yes%'
> > or ajaxUrl like '/pl%/loadResponsePage.htm%fD=true=YES%') OR
> (ajaxUrl
> > like 'loadSuccessPage.do%fD=true=yes%' or ajaxUrl like
> > 'loadSuccessPage.do%fD=true=YES%'))  then sessionid end) ) as fd ,
> >
> > count(distinct (case when ((ajaxUrl like '/pl%/loadResponsePage.htm%fD=
> false=yes%'
> > or ajaxUrl like '/pl%/loadResponsePage.htm%fD=false=YES%') OR
> > (ajaxUrl like 'loadSuccessPage.do%fD=false=yes%' or ajaxUrl like
> > 'loadSuccessPage.do%fD=false=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 

Re: [1.9.0] : UserException: SYSTEM ERROR: IllegalReferenceCountException: refCnt: 0 and then SYSTEM ERROR: IOException: Failed to shutdown streamer

[Anup Tiwari]

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=yes%'
> or ajaxUrl like '/pl%/loadResponsePage.htm%fD=true=YES%') OR (ajaxUrl
> like 'loadSuccessPage.do%fD=true=yes%' or ajaxUrl like
> 'loadSuccessPage.do%fD=true=YES%'))  then sessionid end) ) as fd ,
>
> count(distinct (case when ((ajaxUrl like 
> '/pl%/loadResponsePage.htm%fD=false=yes%'
> or ajaxUrl like '/pl%/loadResponsePage.htm%fD=false=YES%') OR
> (ajaxUrl like 'loadSuccessPage.do%fD=false=yes%' or ajaxUrl like
> 'loadSuccessPage.do%fD=false=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 

[1.9.0] : UserException: SYSTEM ERROR: IllegalReferenceCountException: refCnt: 0 and then SYSTEM ERROR: IOException: Failed to shutdown streamer

[Anup Tiwari]

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=yes%' or ajaxUrl like
'/pl%/loadResponsePage.htm%fD=true=YES%') OR (ajaxUrl like
'loadSuccessPage.do%fD=true=yes%' or ajaxUrl like
'loadSuccessPage.do%fD=true=YES%'))  then sessionid end) ) as fd ,

count(distinct (case when ((ajaxUrl like
'/pl%/loadResponsePage.htm%fD=false=yes%' or ajaxUrl like
'/pl%/loadResponsePage.htm%fD=false=YES%') OR (ajaxUrl like
'loadSuccessPage.do%fD=false=yes%' or ajaxUrl like
'loadSuccessPage.do%fD=false=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