[HIVE-9203] CREATE TEMPORARY FUNCTION hangs trying to acquire lock

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

Environment

CDH5.2.1

• Assignee: Chaoyu Tang
• Reporter: Johndee Burks
• Created: 23/Dec/14 22:46
• Updated: 12/Feb/15 23:40
• Resolved: 08/Jan/15 17:29

Description

If there are SHARED locks on default database. CREATE TEMPORARY FUNCTION will hang until the operation completes or until lock acquisition timeout is reached.

== General Reproduction Steps ==

1. Create a table in default.

2. Do a query against that table that last a long time. I achieved this by creating a UDF that does sleep for 100 minutes.

3. Try to create temporary function in another Hive CLI session. This should hang waiting for a ZK exclusive lock on default.

== Script Details ==

• Works only out of box on CDH with parcels. If you are not using parcels then you need to modify paths in builder.sh.

Issue Links

• is duplicated by: HIVE-9199 Excessive exclusive lock used in some DDLs with DummyTxnManager