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