[
https://issues.apache.org/jira/browse/HIVE-24589?focusedWorklogId=535878&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-535878
]
ASF GitHub Bot logged work on HIVE-24589:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 14/Jan/21 05:03
Start Date: 14/Jan/21 05:03
Worklog Time Spent: 10m
Work Description: maheshk114 merged pull request #1850:
URL: https://github.com/apache/hive/pull/1850
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 535878)
Time Spent: 20m (was: 10m)
> Drop catalog failing with deadlock error for Oracle backend dbms.
> -----------------------------------------------------------------
>
> Key: HIVE-24589
> URL: https://issues.apache.org/jira/browse/HIVE-24589
> Project: Hive
> Issue Type: Bug
> Reporter: mahesh kumar behera
> Assignee: mahesh kumar behera
> Priority: Major
> Labels: pull-request-available
> Time Spent: 20m
> Remaining Estimate: 0h
>
> When we do a drop catalog we drop the catalog from the CTLGS table. The DBS
> table has a foreign key reference on CTLGS for CTLG_NAME. This is causing the
> DBS table to be locked exclusively and causing deadlocks. This can be avoided
> by creating an index in the DBS table on CTLG_NAME.
> {code:java}
> CREATE INDEX CTLG_NAME_DBS ON DBS(CTLG_NAME); {code}
> {code:java}
> Oracle Database maximizes the concurrency control of parent keys in relation
> to dependent foreign keys.Locking behaviour depends on whether foreign key
> columns are indexed. If foreign keys are not indexed, then the child table
> will probably be locked more frequently, deadlocks will occur, and
> concurrency will be decreased. For this reason foreign keys should almost
> always be indexed. The only exception is when the matching unique or primary
> key is never updated or deleted.{code}
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
