[DRILL-4268] Possible resource leak leading to SocketException: Too many open files

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.2.0

Environment

RHEL 6 running against Hive storage type

• Assignee: Unassigned
• Reporter: Ian Maloney
• Created: 12/Jan/16 19:00
• Updated: 09/Feb/16 21:37

Description

I have a java app accessing Drill 1.2 via JDBC, which runs 100s of counts on various tables. No concurrency is being used. The JDBC URL uses the format:
jdbc:drill:drillbit=a-bits-hostname

Hanifi suggested I check for open file descriptors using:
lsof -a -p DRILL_PID | wc -l

which I did on the two nodes, I currently have running drill, both, before and
after restarting.

Node from JDBC connection string (which had been previously restarted):
Before: 396
After: 396
Other node:
Before: 14
After: 395

The error, "Too many open files", persists after restarting the bits.

Opened as a result of this thread:
http://mail-archives.apache.org/mod_mbox/drill-user/201601.mbox/browser