hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alan Gates (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-8711) DB deadlocks not handled in TxnHandler for Postgres, Oracle, and SQLServer
Date Tue, 04 Nov 2014 04:10:33 GMT

     [ 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)

Mime
View raw message