[HIVE-7069] Zookeeper connection leak

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.12.0
• Fix Version/s: 1.1.0
• Component/s: HiveServer2

Environment

Linux 2.6.32-431.11.2.el6.x86_64 #1 SMP Tue Mar 25 19:59:55 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux

• Assignee: Unassigned
• Reporter: Z. S.
• Created: 15/May/14 14:43
• Updated: 12/Feb/15 23:40
• Resolved: 04/Feb/15 19:18

Description

We're using CDH 5.0.0 which ships with HIVE 0.12.0. We're running HiveServer2 and connect to it via JDBC. We have zookeeper support enabled. If a connection is made to HS2 and not explicitly closed via JDBC then a connection made to zookeeper is never released. It reaches a point where HS2 hangs and stops executing any new queries. It's easy to replicate with a simple script that connects to HS2 via JDBC and runs a simple query like 'show tables'. At the same time run this on the hive server machine to monitor zookeeper connections: 'while sleep 1; do netstat -anlp | grep 2181 | wc -l; done' .. If you close the connection explicitly the count will go down soon after the program exits.

Issue Links

• relates to: HIVE-9119 ZooKeeperHiveLockManager does not use zookeeper in the proper way