This is an interesting observation. Can you add it as a comment to DRILL-4398, it may help fix the issue.
Thanks On Thu, Mar 31, 2016 at 10:25 AM, Devender Yadav <[email protected]> wrote: > 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 <[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>
