[HIVE-18886] ACID: NPE on unexplained mysql exceptions

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: Transactions
• Assignee: Gopal Vijayaraghavan
• Reporter: Gopal Vijayaraghavan
• Created: 07/Mar/18 00:18
• Updated: 22/May/18 23:13
• Resolved: 09/Apr/18 01:53

Description

At 200+ sessions on a single HS2, the DbLock impl fails to propagate mysql exceptions

2018-03-06T22:55:16,197 ERROR [HiveServer2-Background-Pool: Thread-12867]: ql.Driver (:()) - FAILED: Error in acquiring locks: null
java.lang.NullPointerException
        at org.apache.hadoop.hive.metastore.DatabaseProduct.isDeadlock(DatabaseProduct.java:56)
        at org.apache.hadoop.hive.metastore.txn.TxnHandler.checkRetryable(TxnHandler.java:2459)
        at org.apache.hadoop.hive.metastore.txn.TxnHandler.getOpenTxns(TxnHandler.java:499)

    return e instanceof SQLTransactionRollbackException
        || ((dbProduct == MYSQL || dbProduct == POSTGRES || dbProduct == SQLSERVER)
            && e.getSQLState().equals("40001"))
        || (dbProduct == POSTGRES && e.getSQLState().equals("40P01"))
        || (dbProduct == ORACLE && (e.getMessage().contains("deadlock detected")
            || e.getMessage().contains("can't serialize access for this transaction")));