hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "bharath v (JIRA)" <>
Subject [jira] [Created] (HIVE-9938) Add retry logic to DbTxnMgr instead of aborting transactions.
Date Thu, 12 Mar 2015 07:30:38 GMT
bharath v created HIVE-9938:

             Summary: Add retry logic to DbTxnMgr instead of aborting transactions.
                 Key: HIVE-9938
             Project: Hive
          Issue Type: Improvement
    Affects Versions: 0.14.0
            Reporter: bharath v

Sometimes parallel updates using DBTxnMgr results in the following error trace

5325 [main] INFO org.apache.hadoop.hive.ql.log.PerfLogger - <PERFLOG method=acquireReadWriteLocks
5351 [main] ERROR org.apache.hadoop.hive.ql.Driver - FAILED: Error in acquiring locks: Error
communicating with the metastore 
org.apache.hadoop.hive.ql.lockmgr.LockException: Error communicating with the metastore 
at org.apache.hadoop.hive.ql.lockmgr.DbLockManager.lock( 
at org.apache.hadoop.hive.ql.lockmgr.DbTxnManager.acquireLocks( 

Internally looking at the postgres logs we see 

2015-02-02 06:36:05,632 ERROR org.apache.hadoop.hive.metastore.RetryingHMSHandler: org.apache.thrift.TException:
MetaException(message:Unable to update transaction database org.postgresql.util.PSQLException:
ERROR: could not serialize access due to concurrent update 

Ideally we should add a retry logic to retry the failed transaction.

This message was sent by Atlassian JIRA

View raw message