[jira] [Commented] (SENTRY-547) Drop table may dead lock, getChildPrivileges should in one transaction with revoke

["Hadoop QA (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SENTRY-547?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14225659#comment-14225659 ] 

Hadoop QA commented on SENTRY-547:
----------------------------------

Here are the results of testing the latest attachment
https://issues.apache.org/jira/secure/attachment/12683731/SENTRY-547.001.patch against master.

{color:green}Overall:{color} +1 all checks pass

{color:green}SUCCESS:{color} all tests passed

Console output: https://builds.apache.org/job/PreCommit-SENTRY-Build/74/console

This message is automatically generated.

> Drop table may dead lock, getChildPrivileges should in one transaction with revoke
> ----------------------------------------------------------------------------------
>
>                 Key: SENTRY-547
>                 URL: https://issues.apache.org/jira/browse/SENTRY-547
>             Project: Sentry
>          Issue Type: Bug
>            Reporter: Xiaomeng Huang
>            Assignee: Xiaomeng Huang
>            Priority: Critical
>         Attachments: SENTRY-547.001.patch
>
>
> please see my test in TestSentryStore.testDropTableWithcAction. If we execute below commands:
> {code}
> grant select to tb1
> grant insert to tb1
> drop tb1
> {code}
> it will throw exception
> {code}
> Caused by: java.sql.SQLException: A lock could not be obtained within the time requested
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
> 	... 48 more
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)