Hive Hangs unexpectedly and ends up with : Error in acquireLock..

Error in acquireLock… FAILED: Error in acquiring locks: Locks on the underlying objects cannot be acquired.

Instant Patchy workaround:

SET hive.support.concurrency=false;

Unlock table:

unlock table my_table;

Some other tricks that work – as suggested in cloudera forums – Hue leaves locks on tables sometimes.
HUE_SER=`ls -alrt /var/run/cloudera-scm-agent/process | grep HUE | tail -1 | awk ‘{print $9}’`
HUE_CONF_DIR=/var/run/cloudera-scm-agent/process/${HUE_SER}
ls HUE_CONF_DIR
/opt/cloudera/parcels/CDH/share/hue/build/env/bin/hue close_queries > tmp.log 2>> tmp.log

Search is still On !!

Yash Sharma is a Big Data & Machine Learning Engineer, A newbie OpenSource contributor, Plays guitar and enjoys teaching as part time hobby.
Talk to Yash about Distributed Systems and Data platform designs.

Leave a Reply

Your email address will not be published. Required fields are marked *