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 <dev....@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 <dev....@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 < >> adene...@maprtech.com> wrote: >> >>> "we" did fix so many of them. =P >>> >>> On Thu, Mar 31, 2016 at 8:12 AM, Abdel Hakim Deneche < >>> adene...@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 <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 >>> > >>> > >>> >>> >>> >>> -- >>> >>> 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 >>> > >>> >> >> >