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 <dev....@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....@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>