[ https://issues.apache.org/jira/browse/RANGER-3670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Abhay Kulkarni resolved RANGER-3670. ------------------------------------ Resolution: Fixed Commit details: master: https://github.com/apache/ranger/commit/20f021c1e642e74f99da8ebee594be21088e7fc3 > Policy update creates unnecessary entries in transaction log table > ------------------------------------------------------------------ > > Key: RANGER-3670 > URL: https://issues.apache.org/jira/browse/RANGER-3670 > Project: Ranger > Issue Type: Bug > Components: Ranger > Affects Versions: 2.2.0 > Reporter: Madhan Neethiraj > Assignee: Abhishek Kumar > Priority: Major > > When a policy is updated, Ranger creates entries in x_trx_log table for each > updated field in the policy. For example, when a policy is disabled, > following record is added in this table: > > ||object_id||object_name||attr_name||prev_val||new_val|| > |6|all - database|Policy Status|true|false| > > Following 2 additional records are added in this table even though these > fields are not updated in the policy: > ||object_id||object_name||attr_name||prev_val||new_val|| > |6|all - database|Validity Schedules|[]|[]| > |6|all - database|Policy Conditions| | | > > Above entries should be avoided. -- This message was sent by Atlassian Jira (v8.20.7#820007)