hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eugene Koifman (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (HIVE-16933) ORA-00060: deadlock detected while waiting on commit
Date Wed, 21 Jun 2017 22:50:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-16933?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Eugene Koifman resolved HIVE-16933.
-----------------------------------
       Resolution: Fixed
    Fix Version/s: 2.4.0
                   3.0.0
                   2.3.0

this was fixed in HIVE-16399

> ORA-00060: deadlock detected while waiting on commit
> ----------------------------------------------------
>
>                 Key: HIVE-16933
>                 URL: https://issues.apache.org/jira/browse/HIVE-16933
>             Project: Hive
>          Issue Type: Improvement
>          Components: Transactions
>    Affects Versions: 1.2.0
>            Reporter: Eugene Koifman
>            Assignee: Eugene Koifman
>             Fix For: 2.3.0, 3.0.0, 2.4.0
>
>
> When running transactional workload (esp streaming ingest api) with Oracle backed Hive
metastore it's possible to see Deadlock exceptions from the DB.
> This due to lack of indexes on Foreign Key columns of Acid related metastore tables.
> For example, TXN_COMPONENTS references TXNS.  It should have
> CREATE INDEX TC_TXNID_INDEX ON TXN_COMPONENTS (TC_TXNID);
> {noformat}
> 2017-06-20 13:42:00,687 ERROR [pool-3-thread-182]: txn.TxnHandler (TxnHandler.java:checkRetryable(1952))
- Too many repeated deadlocks in commitTxn(CommitTxnRequest(txnid:293)), giving up.
> 2017-06-20 13:42:00,696 ERROR [pool-3-thread-182]: metastore.RetryingHMSHandler (RetryingHMSHandler.java:invokeInternal(195))
- MetaException(message:Unable to update transaction database java.sql.SQLException: ORA-00060:
deadlock detected while waiting for resource
>         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
>         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
>         at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
>         at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
>         at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
>         at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
>         at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
>         at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999)
>         at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
>         at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1822)
>         at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1787)
>         at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:280)
>         at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
>         at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
>         at org.apache.hadoop.hive.metastore.txn.TxnHandler.commitTxn(TxnHandler.java:756)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message