Thanks Abdel. I added comment there.
On Thu, Mar 31, 2016 at 3:30 PM, Abdel Hakim Deneche <[email protected]> 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 <[email protected]> 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 <[email protected]> > > 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 < > > > [email protected]> wrote: > > > > > >> "we" did fix so many of them. =P > > >> > > >> On Thu, Mar 31, 2016 at 8:12 AM, Abdel Hakim Deneche < > > >> [email protected]> > > >> 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 <[email protected]> > > >> 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 < > [email protected]> > > >> >> 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 > > >
