Support Questions
Find answers, ask questions, and share your expertise

HIVE --- ORA-00060: Deadlock detected in Oracle Database

HIVE --- ORA-00060: Deadlock detected in Oracle Database

HI All,

I have ORACLE as my Hive Database and I am getting belwo error in ORACLE DB :

"ORA-00060: Deadlock detected. See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors. More info in file /apps/oracle/diag/rdbms/hive"

WHat could be the possible reasons for this...how to resolve this? It is creating trace files of very large sizes and sending alerts

4 REPLIES 4
Highlighted

Re: HIVE --- ORA-00060: Deadlock detected in Oracle Database

Super Guru

@Akash S

Is ACID enabled? If yes, you might be hitting one of the bugs. Both have been fixed, so please see the version of Hive you are using and whether you have applied the patch or not:

https://issues.apache.org/jira/browse/HIVE-16321

https://issues.apache.org/jira/browse/HIVE-10500

Another issue pointed out is below when metastore throws a deadlock. There is a workaround mentioned in case you have same issue:

https://community.hortonworks.com/articles/73418/hivemetastore-dead-lock-while-running-compaction.ht...

Highlighted

Re: HIVE --- ORA-00060: Deadlock detected in Oracle Database

Thank you for the comments mqureshi. Will check on this and update

Highlighted

Re: HIVE --- ORA-00060: Deadlock detected in Oracle Database

@Akash S

Adding to @mqureshi reply, please check the connecction pooling type of the Metastore "datanucleus.connectionPoolingType".

Highlighted

Re: HIVE --- ORA-00060: Deadlock detected in Oracle Database

HI Sindhu, datanucleus.connectionPoolingType is dbcp.

If there are inputs based on this.. please let me know