hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alan Gates (JIRA)" <>
Subject [jira] [Commented] (HIVE-6710) Deadlocks seen in transaction handler using mysql
Date Thu, 20 Mar 2014 17:24:44 GMT


Alan Gates commented on HIVE-6710:

The issue is two fold:
# The code is not disciplined about ordering the access to the TXNS and HIVE_LOCKS tables,
this needs to be fixed
# Per the [mysql documentation |],
even when tables are accessed in the right order deadlocks can be seen due to row locking
issues and thus the application should always be ready to re-start the transaction.  This
is observed in the TxnManager.lock function when two clients are obtaining locks at the same

> Deadlocks seen in transaction handler using mysql
> -------------------------------------------------
>                 Key: HIVE-6710
>                 URL:
>             Project: Hive
>          Issue Type: Bug
>          Components: Locking
>    Affects Versions: 0.13.0
>            Reporter: Alan Gates
>            Assignee: Alan Gates
>             Fix For: 0.13.0
> When multiple clients attempt to obtain locks a deadlock on the mysql database occasionally

This message was sent by Atlassian JIRA

View raw message