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