[
https://issues.apache.org/jira/browse/HIVE-8711?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alan Gates updated HIVE-8711:
-----------------------------
Attachment: HIVE-8711.patch
This patch changes the deadlock detection to be more standards based. It now
looks for the SQLState of 40001 (which is the standard state for deadlock) or a
SQLTransactionRollbackException (which as of JDK 1.6 is the standard exception
for it). It still has to special case Oracle, as it is non-standard.
> DB deadlocks not handled in TxnHandler for Postgres, Oracle, and SQLServer
> --------------------------------------------------------------------------
>
> Key: HIVE-8711
> URL: https://issues.apache.org/jira/browse/HIVE-8711
> Project: Hive
> Issue Type: Bug
> Components: Transactions
> Affects Versions: 0.14.0
> Reporter: Alan Gates
> Assignee: Alan Gates
> Priority: Critical
> Fix For: 0.14.0
>
> Attachments: HIVE-8711.patch
>
>
> TxnHandler.detectDeadlock has code to catch deadlocks in MySQL and Derby.
> But it does not detect a deadlock for Postgres, Oracle, or SQLServer
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
