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>
