ORA-8177 with Hive transactions

2015-09-18 Thread Steve Howard
While troubleshooting an issue with transactions shortly after enabling them, I noticed the following in an Oracle trace, which is our metastore for hive... ORA-8177: can't serialize access for this transaction These were thrown on "insert into HIVE_LOCKS..." Traditionally in Oracle, if an appli

Re: ORA-8177 with Hive transactions

2015-09-18 Thread Sergey Shelukhin
r@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Date: Friday, September 18, 2015 at 10:54 To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Subject: ORA-8177 with Hive transactions While

Re: ORA-8177 with Hive transactions

2015-09-18 Thread Steve Howard
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 > Reply-To: "user@hive.apache.org" > Date: Friday, September 18, 2015 at 10:54 > To: "user@hive.apach

RE: ORA-8177 with Hive transactions

2015-09-18 Thread Mich Talebzadeh
To: user@hive.apache.org Subject: ORA-8177 with Hive transactions While troubleshooting an issue with transactions shortly after enabling them, I noticed the following in an Oracle trace, which is our metastore for hive... ORA-8177: can't serialize access for this transaction These w

Re: ORA-8177 with Hive transactions

2015-09-24 Thread Steve Howard
e/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 >> Reply-To: "user@hive.apache.org" >> Date: Friday, September 18, 2015 at 10:54 >> To: "user@hive.apache.org&q

RE: ORA-8177 with Hive transactions

2015-09-24 Thread Mich Talebzadeh
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