Gopal V created HIVE-18886: ------------------------------ Summary: ACID: NPE on unexplained mysql exceptions Key: HIVE-18886 URL: https://issues.apache.org/jira/browse/HIVE-18886 Project: Hive Issue Type: Bug Components: Transactions Reporter: Gopal V
At 200+ sessions on a single HS2, the DbLock impl fails to propagate mysql exceptions {code} 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) {code} {code} 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"))); {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)