[jira] [Created] (HIVE-15308) Create ACID table failed intermittently: due to Postgres (SQLState=25P02, ErrorCode=0)

["Eugene Koifman (JIRA)" <ji...@apache.org>]

Eugene Koifman created HIVE-15308:
-------------------------------------

             Summary: Create ACID table failed intermittently: due to Postgres (SQLState=25P02, ErrorCode=0)
                 Key: HIVE-15308
                 URL: https://issues.apache.org/jira/browse/HIVE-15308
             Project: Hive
          Issue Type: Bug
          Components: Transactions
    Affects Versions: 2.1.0
            Reporter: Eugene Koifman
            Assignee: Eugene Koifman


if 2 concurrent calls to MutexApi.acquireLock() happen with the same "key" value and there is no row in AUX_TABLE for that value yet (i.e. both are attempting to insert it) Postgres kills the txn which gets the Duplicate Key error and no more statements can be executed on this txn.
(This is different from the way most DBs behave).





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)