You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Butao Zhang (Jira)" <ji...@apache.org> on 2024/04/10 13:47:00 UTC

[jira] [Commented] (HIVE-28189) PrivilegeSynchonizer Need to lock the table while synchronizing privs data

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

Butao Zhang commented on HIVE-28189:
------------------------------------

I don't understand the question a little bit.

Did you use Apache Ranger to check permision?

What error was thrown when the table delete failing?

You said  *"the synchronization time exceeds 1 minute"* ; I think it is better to provide the jstack  of HS2&HMS in that time.

Is there an easy way to reproduce this problem?

 

Thanks.

> PrivilegeSynchonizer Need to lock the table while synchronizing privs data
> --------------------------------------------------------------------------
>
>                 Key: HIVE-28189
>                 URL: https://issues.apache.org/jira/browse/HIVE-28189
>             Project: Hive
>          Issue Type: Bug
>          Components: HiveServer2
>    Affects Versions: 3.1.0
>            Reporter: Yuping Fan
>            Priority: Major
>
> Due to the large number of permissions, the synchronization time exceeds 1 minute. 
> If I delete this table during that 1 minute, it will cause the table to fail to delete, with the error that the tbl_col_privs foreign key constraint check failed. So I think the table should be locked when the permissions are synchronized



--
This message was sent by Atlassian Jira
(v8.20.10#820010)