Hi Abdel, I just noticed I'm still on v. 1.2, so maybe upgrading will help. I could open a Jira, if need be.
As far as restarting and reproducing, I restarted and after running my app with the jdbc logic for a while, I get an IOException: Error accessing / I paused the app and restarted the specific bit from the jdbc connection below, which gave me the "Too many open files" exception again. Now, restarting that bit won't fix the error. On Monday, January 11, 2016, Abdel Hakim Deneche <[email protected]> wrote: > Hi Ian, > > Can you open up a JIRA for this ? is it easy to reproduce ? > > Thanks > > On Mon, Jan 11, 2016 at 8:59 AM, Ian Maloney <[email protected] > <javascript:;>> > wrote: > > > Hi, > > > > I've been running a lot of queries via jdbc/drill. I have four drillbits, > > but I could not get the zk jdbc URL to work so I used: > > jdbc:drill:drillbit=a-bits-hostname > > > > Now I get a SocketException for too many open files, even when accessing > > via cli. I imagine I could restart the bits, but for something intended > for > > production, that doesn't seem like a viable solution. Any ideas on how to > > keep the (suspected) resource leak from happening? > > > > I'm closing ResultSet, Statement, and Connection, after each query. > > > > > > -- > > 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 > > >
