question Re: Hive Acid: How to kill Locks & transaction ? in Support Questions

Hive Acid: How to kill Locks & transaction ?

ahmed_missaoui_ — Thu, 31 Dec 2015 20:43:35 GMT

Hello,

I have many open transactions on table that i cant' delete.

Even if i delete the table, transactions are still open.

There is a way to rollback these transactions?

There is a way to kill pending locks?

Hive version : 1.2.1

Thanks

Re: Hive Acid: How to kill Locks & transaction ?

nsabharwal — Thu, 31 Dec 2015 23:13:23 GMT

@Ahmed Missaoui

You may be hitting this https://issues.apache.org/jira/browse/HIVE-11934

I would say try killing HS2 and worse case case restart Hive components.

Re: Hive Acid: How to kill Locks & transaction ?

ahmed_missaoui_ — Thu, 31 Dec 2015 23:37:53 GMT

thank you very much 🙂

I suspected that is a bug.

Re: Hive Acid: How to kill Locks & transaction ?

ewalk — Fri, 01 Jan 2016 02:12:22 GMT

In the short run you can always look at the metastore database (assuming you're using the db txn manager) and try to clear them manually from the tables there.

Re: Hive Acid: How to kill Locks & transaction ?

ahmed_missaoui_ — Mon, 04 Jan 2016 20:42:48 GMT

Hello Eric, Thank you fro response. I will try it and will let you know the result.

Re: Hive Acid: How to kill Locks & transaction ?

gates — Tue, 05 Jan 2016 03:55:26 GMT

I don't recommend directly messing with the RDBMs. If you can't find any other way out and must make changes in the RDBMS, you should make sure to just switch the transactions states from open to aborted. Removing the transactions completely may have undesirable side effects.

Re: Hive Acid: How to kill Locks & transaction ?

ekoifman — Sat, 14 May 2016 02:09:27 GMT

https://issues.apache.org/jira/browse/HIVE-12634 will help here