You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Devender Yadav <de...@gmail.com> on 2016/03/31 09:04:30 UTC
simple join failing for SQL server.
Hi All,
I tried a simple join in two tables in SQL server for testing purpose.
Two tables test01 & test02 with same data (just 4 records).
Join query:
*select t1.num_tiny, t2.num_small from mssql.dbo.`test01` t1 join
mssql.dbo.`test02` t2 on t1.num_int = t2.num_int;*
*Error: SYSTEM ERROR: IllegalStateException: Failure while closing
accountor. Expected private and shared pools to be set to initial values.
However, one or more were not. Stats are*
* zone init allocated delta *
* private 1000000 926272 73728 *
* shared 9999000000 9999000000 0.*
*Fragment 0:0*
What could be the reason for that? Anything wrong from my side or is it a
bug?
Regards,
Devender
Re: simple join failing for SQL server.
Posted by Devender Yadav <de...@gmail.com>.
Thanks Abdel. I added comment there.
On Thu, Mar 31, 2016 at 3:30 PM, Abdel Hakim Deneche <ad...@maprtech.com>
wrote:
> This is a known issue:
>
> https://issues.apache.org/jira/browse/DRILL-4398
>
>
>
> On Thu, Mar 31, 2016 at 9:33 AM, Devender Yadav <de...@gmail.com> wrote:
>
> > Tested same query with Drill 1.5 and 1.6 with no success.
> >
> >
> > Error: SYSTEM ERROR: IllegalStateException: Memory was leaked by query.
> > Memory leaked: (73728)
> > Allocator(op:0:0:3:JdbcSubScan) 1000000/73728/569344/10000000000
> > (res/actual/peak/limit)
> >
> >
> >
> > Regards,
> > Devender
> >
> > On Thu, Mar 31, 2016 at 12:45 PM, Devender Yadav <de...@gmail.com>
> > wrote:
> >
> > > Yes Abdel. I will try with 1.6 & let you know.
> > >
> > > Regards,
> > > Devender
> > >
> > > On Thu, Mar 31, 2016 at 12:43 PM, Abdel Hakim Deneche <
> > > adeneche@maprtech.com> wrote:
> > >
> > >> "we" did fix so many of them. =P
> > >>
> > >> On Thu, Mar 31, 2016 at 8:12 AM, Abdel Hakim Deneche <
> > >> adeneche@maprtech.com>
> > >> wrote:
> > >>
> > >> > Hi Devender,
> > >> >
> > >> > Whenever you see such errors, it's Drill's internal memory
> accounting
> > >> > reporting a memory leak. This is "always" a bug, but you did fix so
> > >> many of
> > >> > them(*) since 1.4 and we even improved the memory allocator in 1.5.
> Do
> > >> you
> > >> > want to try again on the latest version and see if you still see
> this
> > >> issue
> > >> > ?
> > >> >
> > >> > (*) not all of them of course ;)
> > >> >
> > >> > On Thu, Mar 31, 2016 at 8:08 AM, Devender Yadav <de...@gmail.com>
> > >> wrote:
> > >> >
> > >> >> Forgot to add details about Drill.
> > >> >>
> > >> >> Drill Version - 1.4
> > >> >> OS - Ubuntu 14.0.4
> > >> >> Mode- Embedded
> > >> >> Memory - DRILL_MAX_DIRECT_MEMORY="4G"
> > >> >> DRILL_HEAP="2G"
> > >> >>
> > >> >> Regards,
> > >> >> Devender
> > >> >>
> > >> >> On Thu, Mar 31, 2016 at 12:34 PM, Devender Yadav <
> dev.emr@gmail.com>
> > >> >> wrote:
> > >> >>
> > >> >> > Hi All,
> > >> >> >
> > >> >> > I tried a simple join in two tables in SQL server for testing
> > >> purpose.
> > >> >> >
> > >> >> > Two tables test01 & test02 with same data (just 4 records).
> > >> >> >
> > >> >> > Join query:
> > >> >> >
> > >> >> > *select t1.num_tiny, t2.num_small from mssql.dbo.`test01` t1 join
> > >> >> > mssql.dbo.`test02` t2 on t1.num_int = t2.num_int;*
> > >> >> >
> > >> >> >
> > >> >> > *Error: SYSTEM ERROR: IllegalStateException: Failure while
> closing
> > >> >> > accountor. Expected private and shared pools to be set to
> initial
> > >> >> values.
> > >> >> > However, one or more were not. Stats are*
> > >> >> > * zone init allocated delta *
> > >> >> > * private 1000000 926272 73728 *
> > >> >> > * shared 9999000000 9999000000 0.*
> > >> >> >
> > >> >> > *Fragment 0:0*
> > >> >> >
> > >> >> > What could be the reason for that? Anything wrong from my side or
> > is
> > >> it
> > >> >> a
> > >> >> > bug?
> > >> >> >
> > >> >> >
> > >> >> > Regards,
> > >> >> > Devender
> > >> >> >
> > >> >>
> > >> >
> > >> >
> > >> >
> > >> > --
> > >> >
> > >> > 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
> >
>
Re: simple join failing for SQL server.
Posted by Abdel Hakim Deneche <ad...@maprtech.com>.
This is a known issue:
https://issues.apache.org/jira/browse/DRILL-4398
On Thu, Mar 31, 2016 at 9:33 AM, Devender Yadav <de...@gmail.com> wrote:
> Tested same query with Drill 1.5 and 1.6 with no success.
>
>
> Error: SYSTEM ERROR: IllegalStateException: Memory was leaked by query.
> Memory leaked: (73728)
> Allocator(op:0:0:3:JdbcSubScan) 1000000/73728/569344/10000000000
> (res/actual/peak/limit)
>
>
>
> Regards,
> Devender
>
> On Thu, Mar 31, 2016 at 12:45 PM, Devender Yadav <de...@gmail.com>
> wrote:
>
> > Yes Abdel. I will try with 1.6 & let you know.
> >
> > Regards,
> > Devender
> >
> > On Thu, Mar 31, 2016 at 12:43 PM, Abdel Hakim Deneche <
> > adeneche@maprtech.com> wrote:
> >
> >> "we" did fix so many of them. =P
> >>
> >> On Thu, Mar 31, 2016 at 8:12 AM, Abdel Hakim Deneche <
> >> adeneche@maprtech.com>
> >> wrote:
> >>
> >> > Hi Devender,
> >> >
> >> > Whenever you see such errors, it's Drill's internal memory accounting
> >> > reporting a memory leak. This is "always" a bug, but you did fix so
> >> many of
> >> > them(*) since 1.4 and we even improved the memory allocator in 1.5. Do
> >> you
> >> > want to try again on the latest version and see if you still see this
> >> issue
> >> > ?
> >> >
> >> > (*) not all of them of course ;)
> >> >
> >> > On Thu, Mar 31, 2016 at 8:08 AM, Devender Yadav <de...@gmail.com>
> >> wrote:
> >> >
> >> >> Forgot to add details about Drill.
> >> >>
> >> >> Drill Version - 1.4
> >> >> OS - Ubuntu 14.0.4
> >> >> Mode- Embedded
> >> >> Memory - DRILL_MAX_DIRECT_MEMORY="4G"
> >> >> DRILL_HEAP="2G"
> >> >>
> >> >> Regards,
> >> >> Devender
> >> >>
> >> >> On Thu, Mar 31, 2016 at 12:34 PM, Devender Yadav <de...@gmail.com>
> >> >> wrote:
> >> >>
> >> >> > Hi All,
> >> >> >
> >> >> > I tried a simple join in two tables in SQL server for testing
> >> purpose.
> >> >> >
> >> >> > Two tables test01 & test02 with same data (just 4 records).
> >> >> >
> >> >> > Join query:
> >> >> >
> >> >> > *select t1.num_tiny, t2.num_small from mssql.dbo.`test01` t1 join
> >> >> > mssql.dbo.`test02` t2 on t1.num_int = t2.num_int;*
> >> >> >
> >> >> >
> >> >> > *Error: SYSTEM ERROR: IllegalStateException: Failure while closing
> >> >> > accountor. Expected private and shared pools to be set to initial
> >> >> values.
> >> >> > However, one or more were not. Stats are*
> >> >> > * zone init allocated delta *
> >> >> > * private 1000000 926272 73728 *
> >> >> > * shared 9999000000 9999000000 0.*
> >> >> >
> >> >> > *Fragment 0:0*
> >> >> >
> >> >> > What could be the reason for that? Anything wrong from my side or
> is
> >> it
> >> >> a
> >> >> > bug?
> >> >> >
> >> >> >
> >> >> > Regards,
> >> >> > Devender
> >> >> >
> >> >>
> >> >
> >> >
> >> >
> >> > --
> >> >
> >> > 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>
Re: simple join failing for SQL server.
Posted by Abdel Hakim Deneche <ad...@maprtech.com>.
This is an interesting observation. Can you add it as a comment to
DRILL-4398, it may help fix the issue.
Thanks
On Thu, Mar 31, 2016 at 10:25 AM, Devender Yadav <de...@gmail.com> wrote:
> I want to add one more observation.
>
> If I create a different plugin with same configuration
>
> Say my SQL Server plugin name is mssql. I created mssql1 with same
> configuration and modified query with mssql1 plugin name on 2nd table.
>
> *select t1.num_tiny, t2.num_small from mssql.dbo.`test01` t1 join
> mssql1.dbo.`test02` t2 on t1.num_int = t2.num_int;*
>
> *The query returned expected output.*
>
>
>
> On Thu, Mar 31, 2016 at 2:03 PM, Devender Yadav <de...@gmail.com> wrote:
>
> > Tested same query with Drill 1.5 and 1.6 with no success.
> >
> >
> > Error: SYSTEM ERROR: IllegalStateException: Memory was leaked by query.
> > Memory leaked: (73728)
> > Allocator(op:0:0:3:JdbcSubScan) 1000000/73728/569344/10000000000
> > (res/actual/peak/limit)
> >
> >
> >
> > Regards,
> > Devender
> >
> > On Thu, Mar 31, 2016 at 12:45 PM, Devender Yadav <de...@gmail.com>
> > wrote:
> >
> >> Yes Abdel. I will try with 1.6 & let you know.
> >>
> >> Regards,
> >> Devender
> >>
> >> On Thu, Mar 31, 2016 at 12:43 PM, Abdel Hakim Deneche <
> >> adeneche@maprtech.com> wrote:
> >>
> >>> "we" did fix so many of them. =P
> >>>
> >>> On Thu, Mar 31, 2016 at 8:12 AM, Abdel Hakim Deneche <
> >>> adeneche@maprtech.com>
> >>> wrote:
> >>>
> >>> > Hi Devender,
> >>> >
> >>> > Whenever you see such errors, it's Drill's internal memory accounting
> >>> > reporting a memory leak. This is "always" a bug, but you did fix so
> >>> many of
> >>> > them(*) since 1.4 and we even improved the memory allocator in 1.5.
> Do
> >>> you
> >>> > want to try again on the latest version and see if you still see this
> >>> issue
> >>> > ?
> >>> >
> >>> > (*) not all of them of course ;)
> >>> >
> >>> > On Thu, Mar 31, 2016 at 8:08 AM, Devender Yadav <de...@gmail.com>
> >>> wrote:
> >>> >
> >>> >> Forgot to add details about Drill.
> >>> >>
> >>> >> Drill Version - 1.4
> >>> >> OS - Ubuntu 14.0.4
> >>> >> Mode- Embedded
> >>> >> Memory - DRILL_MAX_DIRECT_MEMORY="4G"
> >>> >> DRILL_HEAP="2G"
> >>> >>
> >>> >> Regards,
> >>> >> Devender
> >>> >>
> >>> >> On Thu, Mar 31, 2016 at 12:34 PM, Devender Yadav <dev.emr@gmail.com
> >
> >>> >> wrote:
> >>> >>
> >>> >> > Hi All,
> >>> >> >
> >>> >> > I tried a simple join in two tables in SQL server for testing
> >>> purpose.
> >>> >> >
> >>> >> > Two tables test01 & test02 with same data (just 4 records).
> >>> >> >
> >>> >> > Join query:
> >>> >> >
> >>> >> > *select t1.num_tiny, t2.num_small from mssql.dbo.`test01` t1 join
> >>> >> > mssql.dbo.`test02` t2 on t1.num_int = t2.num_int;*
> >>> >> >
> >>> >> >
> >>> >> > *Error: SYSTEM ERROR: IllegalStateException: Failure while closing
> >>> >> > accountor. Expected private and shared pools to be set to initial
> >>> >> values.
> >>> >> > However, one or more were not. Stats are*
> >>> >> > * zone init allocated delta *
> >>> >> > * private 1000000 926272 73728 *
> >>> >> > * shared 9999000000 9999000000 0.*
> >>> >> >
> >>> >> > *Fragment 0:0*
> >>> >> >
> >>> >> > What could be the reason for that? Anything wrong from my side or
> >>> is it
> >>> >> a
> >>> >> > bug?
> >>> >> >
> >>> >> >
> >>> >> > Regards,
> >>> >> > Devender
> >>> >> >
> >>> >>
> >>> >
> >>> >
> >>> >
> >>> > --
> >>> >
> >>> > 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>
Re: simple join failing for SQL server.
Posted by Devender Yadav <de...@gmail.com>.
I want to add one more observation.
If I create a different plugin with same configuration
Say my SQL Server plugin name is mssql. I created mssql1 with same
configuration and modified query with mssql1 plugin name on 2nd table.
*select t1.num_tiny, t2.num_small from mssql.dbo.`test01` t1 join
mssql1.dbo.`test02` t2 on t1.num_int = t2.num_int;*
*The query returned expected output.*
On Thu, Mar 31, 2016 at 2:03 PM, Devender Yadav <de...@gmail.com> wrote:
> Tested same query with Drill 1.5 and 1.6 with no success.
>
>
> Error: SYSTEM ERROR: IllegalStateException: Memory was leaked by query.
> Memory leaked: (73728)
> Allocator(op:0:0:3:JdbcSubScan) 1000000/73728/569344/10000000000
> (res/actual/peak/limit)
>
>
>
> Regards,
> Devender
>
> On Thu, Mar 31, 2016 at 12:45 PM, Devender Yadav <de...@gmail.com>
> wrote:
>
>> Yes Abdel. I will try with 1.6 & let you know.
>>
>> Regards,
>> Devender
>>
>> On Thu, Mar 31, 2016 at 12:43 PM, Abdel Hakim Deneche <
>> adeneche@maprtech.com> wrote:
>>
>>> "we" did fix so many of them. =P
>>>
>>> On Thu, Mar 31, 2016 at 8:12 AM, Abdel Hakim Deneche <
>>> adeneche@maprtech.com>
>>> wrote:
>>>
>>> > Hi Devender,
>>> >
>>> > Whenever you see such errors, it's Drill's internal memory accounting
>>> > reporting a memory leak. This is "always" a bug, but you did fix so
>>> many of
>>> > them(*) since 1.4 and we even improved the memory allocator in 1.5. Do
>>> you
>>> > want to try again on the latest version and see if you still see this
>>> issue
>>> > ?
>>> >
>>> > (*) not all of them of course ;)
>>> >
>>> > On Thu, Mar 31, 2016 at 8:08 AM, Devender Yadav <de...@gmail.com>
>>> wrote:
>>> >
>>> >> Forgot to add details about Drill.
>>> >>
>>> >> Drill Version - 1.4
>>> >> OS - Ubuntu 14.0.4
>>> >> Mode- Embedded
>>> >> Memory - DRILL_MAX_DIRECT_MEMORY="4G"
>>> >> DRILL_HEAP="2G"
>>> >>
>>> >> Regards,
>>> >> Devender
>>> >>
>>> >> On Thu, Mar 31, 2016 at 12:34 PM, Devender Yadav <de...@gmail.com>
>>> >> wrote:
>>> >>
>>> >> > Hi All,
>>> >> >
>>> >> > I tried a simple join in two tables in SQL server for testing
>>> purpose.
>>> >> >
>>> >> > Two tables test01 & test02 with same data (just 4 records).
>>> >> >
>>> >> > Join query:
>>> >> >
>>> >> > *select t1.num_tiny, t2.num_small from mssql.dbo.`test01` t1 join
>>> >> > mssql.dbo.`test02` t2 on t1.num_int = t2.num_int;*
>>> >> >
>>> >> >
>>> >> > *Error: SYSTEM ERROR: IllegalStateException: Failure while closing
>>> >> > accountor. Expected private and shared pools to be set to initial
>>> >> values.
>>> >> > However, one or more were not. Stats are*
>>> >> > * zone init allocated delta *
>>> >> > * private 1000000 926272 73728 *
>>> >> > * shared 9999000000 9999000000 0.*
>>> >> >
>>> >> > *Fragment 0:0*
>>> >> >
>>> >> > What could be the reason for that? Anything wrong from my side or
>>> is it
>>> >> a
>>> >> > bug?
>>> >> >
>>> >> >
>>> >> > Regards,
>>> >> > Devender
>>> >> >
>>> >>
>>> >
>>> >
>>> >
>>> > --
>>> >
>>> > 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
>>> >
>>>
>>
>>
>
Re: simple join failing for SQL server.
Posted by Devender Yadav <de...@gmail.com>.
Tested same query with Drill 1.5 and 1.6 with no success.
Error: SYSTEM ERROR: IllegalStateException: Memory was leaked by query.
Memory leaked: (73728)
Allocator(op:0:0:3:JdbcSubScan) 1000000/73728/569344/10000000000
(res/actual/peak/limit)
Regards,
Devender
On Thu, Mar 31, 2016 at 12:45 PM, Devender Yadav <de...@gmail.com> wrote:
> Yes Abdel. I will try with 1.6 & let you know.
>
> Regards,
> Devender
>
> On Thu, Mar 31, 2016 at 12:43 PM, Abdel Hakim Deneche <
> adeneche@maprtech.com> wrote:
>
>> "we" did fix so many of them. =P
>>
>> On Thu, Mar 31, 2016 at 8:12 AM, Abdel Hakim Deneche <
>> adeneche@maprtech.com>
>> wrote:
>>
>> > Hi Devender,
>> >
>> > Whenever you see such errors, it's Drill's internal memory accounting
>> > reporting a memory leak. This is "always" a bug, but you did fix so
>> many of
>> > them(*) since 1.4 and we even improved the memory allocator in 1.5. Do
>> you
>> > want to try again on the latest version and see if you still see this
>> issue
>> > ?
>> >
>> > (*) not all of them of course ;)
>> >
>> > On Thu, Mar 31, 2016 at 8:08 AM, Devender Yadav <de...@gmail.com>
>> wrote:
>> >
>> >> Forgot to add details about Drill.
>> >>
>> >> Drill Version - 1.4
>> >> OS - Ubuntu 14.0.4
>> >> Mode- Embedded
>> >> Memory - DRILL_MAX_DIRECT_MEMORY="4G"
>> >> DRILL_HEAP="2G"
>> >>
>> >> Regards,
>> >> Devender
>> >>
>> >> On Thu, Mar 31, 2016 at 12:34 PM, Devender Yadav <de...@gmail.com>
>> >> wrote:
>> >>
>> >> > Hi All,
>> >> >
>> >> > I tried a simple join in two tables in SQL server for testing
>> purpose.
>> >> >
>> >> > Two tables test01 & test02 with same data (just 4 records).
>> >> >
>> >> > Join query:
>> >> >
>> >> > *select t1.num_tiny, t2.num_small from mssql.dbo.`test01` t1 join
>> >> > mssql.dbo.`test02` t2 on t1.num_int = t2.num_int;*
>> >> >
>> >> >
>> >> > *Error: SYSTEM ERROR: IllegalStateException: Failure while closing
>> >> > accountor. Expected private and shared pools to be set to initial
>> >> values.
>> >> > However, one or more were not. Stats are*
>> >> > * zone init allocated delta *
>> >> > * private 1000000 926272 73728 *
>> >> > * shared 9999000000 9999000000 0.*
>> >> >
>> >> > *Fragment 0:0*
>> >> >
>> >> > What could be the reason for that? Anything wrong from my side or is
>> it
>> >> a
>> >> > bug?
>> >> >
>> >> >
>> >> > Regards,
>> >> > Devender
>> >> >
>> >>
>> >
>> >
>> >
>> > --
>> >
>> > 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
>> >
>>
>
>
Re: simple join failing for SQL server.
Posted by Devender Yadav <de...@gmail.com>.
Yes Abdel. I will try with 1.6 & let you know.
Regards,
Devender
On Thu, Mar 31, 2016 at 12:43 PM, Abdel Hakim Deneche <adeneche@maprtech.com
> wrote:
> "we" did fix so many of them. =P
>
> On Thu, Mar 31, 2016 at 8:12 AM, Abdel Hakim Deneche <
> adeneche@maprtech.com>
> wrote:
>
> > Hi Devender,
> >
> > Whenever you see such errors, it's Drill's internal memory accounting
> > reporting a memory leak. This is "always" a bug, but you did fix so many
> of
> > them(*) since 1.4 and we even improved the memory allocator in 1.5. Do
> you
> > want to try again on the latest version and see if you still see this
> issue
> > ?
> >
> > (*) not all of them of course ;)
> >
> > On Thu, Mar 31, 2016 at 8:08 AM, Devender Yadav <de...@gmail.com>
> wrote:
> >
> >> Forgot to add details about Drill.
> >>
> >> Drill Version - 1.4
> >> OS - Ubuntu 14.0.4
> >> Mode- Embedded
> >> Memory - DRILL_MAX_DIRECT_MEMORY="4G"
> >> DRILL_HEAP="2G"
> >>
> >> Regards,
> >> Devender
> >>
> >> On Thu, Mar 31, 2016 at 12:34 PM, Devender Yadav <de...@gmail.com>
> >> wrote:
> >>
> >> > Hi All,
> >> >
> >> > I tried a simple join in two tables in SQL server for testing purpose.
> >> >
> >> > Two tables test01 & test02 with same data (just 4 records).
> >> >
> >> > Join query:
> >> >
> >> > *select t1.num_tiny, t2.num_small from mssql.dbo.`test01` t1 join
> >> > mssql.dbo.`test02` t2 on t1.num_int = t2.num_int;*
> >> >
> >> >
> >> > *Error: SYSTEM ERROR: IllegalStateException: Failure while closing
> >> > accountor. Expected private and shared pools to be set to initial
> >> values.
> >> > However, one or more were not. Stats are*
> >> > * zone init allocated delta *
> >> > * private 1000000 926272 73728 *
> >> > * shared 9999000000 9999000000 0.*
> >> >
> >> > *Fragment 0:0*
> >> >
> >> > What could be the reason for that? Anything wrong from my side or is
> it
> >> a
> >> > bug?
> >> >
> >> >
> >> > Regards,
> >> > Devender
> >> >
> >>
> >
> >
> >
> > --
> >
> > 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
> >
>
Re: simple join failing for SQL server.
Posted by Abdel Hakim Deneche <ad...@maprtech.com>.
"we" did fix so many of them. =P
On Thu, Mar 31, 2016 at 8:12 AM, Abdel Hakim Deneche <ad...@maprtech.com>
wrote:
> Hi Devender,
>
> Whenever you see such errors, it's Drill's internal memory accounting
> reporting a memory leak. This is "always" a bug, but you did fix so many of
> them(*) since 1.4 and we even improved the memory allocator in 1.5. Do you
> want to try again on the latest version and see if you still see this issue
> ?
>
> (*) not all of them of course ;)
>
> On Thu, Mar 31, 2016 at 8:08 AM, Devender Yadav <de...@gmail.com> wrote:
>
>> Forgot to add details about Drill.
>>
>> Drill Version - 1.4
>> OS - Ubuntu 14.0.4
>> Mode- Embedded
>> Memory - DRILL_MAX_DIRECT_MEMORY="4G"
>> DRILL_HEAP="2G"
>>
>> Regards,
>> Devender
>>
>> On Thu, Mar 31, 2016 at 12:34 PM, Devender Yadav <de...@gmail.com>
>> wrote:
>>
>> > Hi All,
>> >
>> > I tried a simple join in two tables in SQL server for testing purpose.
>> >
>> > Two tables test01 & test02 with same data (just 4 records).
>> >
>> > Join query:
>> >
>> > *select t1.num_tiny, t2.num_small from mssql.dbo.`test01` t1 join
>> > mssql.dbo.`test02` t2 on t1.num_int = t2.num_int;*
>> >
>> >
>> > *Error: SYSTEM ERROR: IllegalStateException: Failure while closing
>> > accountor. Expected private and shared pools to be set to initial
>> values.
>> > However, one or more were not. Stats are*
>> > * zone init allocated delta *
>> > * private 1000000 926272 73728 *
>> > * shared 9999000000 9999000000 0.*
>> >
>> > *Fragment 0:0*
>> >
>> > What could be the reason for that? Anything wrong from my side or is it
>> a
>> > bug?
>> >
>> >
>> > Regards,
>> > Devender
>> >
>>
>
>
>
> --
>
> 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>
Re: simple join failing for SQL server.
Posted by Abdel Hakim Deneche <ad...@maprtech.com>.
Hi Devender,
Whenever you see such errors, it's Drill's internal memory accounting
reporting a memory leak. This is "always" a bug, but you did fix so many of
them(*) since 1.4 and we even improved the memory allocator in 1.5. Do you
want to try again on the latest version and see if you still see this issue
?
(*) not all of them of course ;)
On Thu, Mar 31, 2016 at 8:08 AM, Devender Yadav <de...@gmail.com> wrote:
> Forgot to add details about Drill.
>
> Drill Version - 1.4
> OS - Ubuntu 14.0.4
> Mode- Embedded
> Memory - DRILL_MAX_DIRECT_MEMORY="4G"
> DRILL_HEAP="2G"
>
> Regards,
> Devender
>
> On Thu, Mar 31, 2016 at 12:34 PM, Devender Yadav <de...@gmail.com>
> wrote:
>
> > Hi All,
> >
> > I tried a simple join in two tables in SQL server for testing purpose.
> >
> > Two tables test01 & test02 with same data (just 4 records).
> >
> > Join query:
> >
> > *select t1.num_tiny, t2.num_small from mssql.dbo.`test01` t1 join
> > mssql.dbo.`test02` t2 on t1.num_int = t2.num_int;*
> >
> >
> > *Error: SYSTEM ERROR: IllegalStateException: Failure while closing
> > accountor. Expected private and shared pools to be set to initial
> values.
> > However, one or more were not. Stats are*
> > * zone init allocated delta *
> > * private 1000000 926272 73728 *
> > * shared 9999000000 9999000000 0.*
> >
> > *Fragment 0:0*
> >
> > What could be the reason for that? Anything wrong from my side or is it a
> > bug?
> >
> >
> > Regards,
> > Devender
> >
>
--
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>
Re: simple join failing for SQL server.
Posted by Devender Yadav <de...@gmail.com>.
Forgot to add details about Drill.
Drill Version - 1.4
OS - Ubuntu 14.0.4
Mode- Embedded
Memory - DRILL_MAX_DIRECT_MEMORY="4G"
DRILL_HEAP="2G"
Regards,
Devender
On Thu, Mar 31, 2016 at 12:34 PM, Devender Yadav <de...@gmail.com> wrote:
> Hi All,
>
> I tried a simple join in two tables in SQL server for testing purpose.
>
> Two tables test01 & test02 with same data (just 4 records).
>
> Join query:
>
> *select t1.num_tiny, t2.num_small from mssql.dbo.`test01` t1 join
> mssql.dbo.`test02` t2 on t1.num_int = t2.num_int;*
>
>
> *Error: SYSTEM ERROR: IllegalStateException: Failure while closing
> accountor. Expected private and shared pools to be set to initial values.
> However, one or more were not. Stats are*
> * zone init allocated delta *
> * private 1000000 926272 73728 *
> * shared 9999000000 9999000000 0.*
>
> *Fragment 0:0*
>
> What could be the reason for that? Anything wrong from my side or is it a
> bug?
>
>
> Regards,
> Devender
>