RE: ORA-8177 with Hive transactions

ore neither Peridale Ltd, its subsidiaries nor their employees accept any responsibility. From: Steve Howard [mailto:stevedhow...@gmail.com] Sent: 24 September 2015 14:53 To: user@hive.apache.org Subject: Re: ORA-8177 with Hive transactions All, We continue to struggle with th

Re: ORA-8177 with Hive transactions

All, We continue to struggle with this. We *never* get the lock, and found one issue in which the retry logic gets in an infinite loop. We submitted a JIRA for that (https://issues.apache.org/jira/browse/HIVE-11934), and patched our version (HDP 2.3, Hive 1.2.1) with a fix in which the deadlock

RE: ORA-8177 with Hive transactions

I have seen this one before as I use oracle database as my metastore. Two things if I recall correctly 1. Have you run the oracle sql script for concurrency against your metastore. For example hive-txn-schema-0.14.0.oracle.sql 2. You also need to run zookeeper for concurrency

Re: ORA-8177 with Hive transactions

I think ROWDEPENDENCIES on an Oracle table also covers this issue, so I don't think a separate JIRA is needed for the INITRANS change. On Fri, Sep 18, 2015 at 2:51 PM, Sergey Shelukhin wrote: > There’s HIVE-11831 and > https://issues.apache.org/

Re: ORA-8177 with Hive transactions

There’s HIVE-11831 and https://issues.apache.org/jira/browse/HIVE-11833 that try to address this. We can do a patch similar to the first one; can you file a JIRA? From: Steve Howard mailto:stevedhow...@gmail.com>> Reply-To: "user@hive.apache.org