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

Na Li commented on SENTRY-1643:
-------------------------------

What are the scenarios that changeID should be increased by one? Does that 
includes granting privilege to a table? If both sentry servers can do that, 
assigning changeID in sentry server would be hard.

Can we use notification Id to help managing the changeId to make sure that two 
sentry servers process HMS notifications and both are trying to apply the same 
delta, one of them should fail? 



> AutoIncrement ChangeID of MSentryPermChange/MSentryPathChange may be 
> error-prone
> --------------------------------------------------------------------------------
>
>                 Key: SENTRY-1643
>                 URL: https://issues.apache.org/jira/browse/SENTRY-1643
>             Project: Sentry
>          Issue Type: Sub-task
>          Components: Hdfs Plugin
>    Affects Versions: sentry-ha-redesign
>            Reporter: Hao Hao
>            Assignee: Lei (Eddy) Xu
>            Priority: Critical
>             Fix For: sentry-ha-redesign
>
>
> In MSentryPermChange/MSentryPathChange table, the changeID field is 
> auto-increment. 
> {noformat}
> <field name="changeID" primary-key="true" value-strategy="increment">
>   <column name="CHANGE_ID" jdbc-type="BIGINT" allows-null="false"/>
> </field>{noformat}
> However, found through the integration unit test TestHDFSIntegration, the 
> value does not seem to be correctly auto increased. e.g Instead of increasing 
> by one for each new entry, it increased by some unexpected number.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to