-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/74803/
-----------------------------------------------------------

Review request for ranger, Anand Nadar, Ankita Sinha, Abhay Kulkarni, Monika 
Kachhadiya, Ramesh Mani, Subhrat Chaudhary, and Velmurugan Periasamy.


Bugs: RANGER-4566
    https://issues.apache.org/jira/browse/RANGER-4566


Repository: ranger


Description
-------

added patch PatchSetAccessTypeCategory_J10061 to set category column for 
existing entries in x_access_type_def table


Diffs
-----

  
security-admin/src/main/java/org/apache/ranger/patch/PatchSetAccessTypeCategory_J10061.java
 PRE-CREATION 


Diff: https://reviews.apache.org/r/74803/diff/1/


Testing
-------

- verified that upgrade from Ranger 2.4.0 to Ranger 3.0.0-SNAPSHOT updated 
x_access_type_def.category entries from embededed service-defs
- here are the contents from ranger_db_patch.log:
```
2023-12-22 00:36:13,703 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:75) ==> 
PatchSetAccessTypeCategory_J10061.execLoad()
2023-12-22 00:36:13,703 [Loader Monitor] INFO  
o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:88) PatchSetAccessTypeCategory_J10061
2023-12-22 00:36:13,703 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:92) ==> 
PatchSetAccessTypeCategory_J10061.updateAllServiceDef()
2023-12-22 00:36:13,795 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:103) Updating access-type categories 
for service-def:[hdfs]
2023-12-22 00:36:13,905 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:149) Updated access-type categories for 
service-def:[hdfs]
2023-12-22 00:36:13,905 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:103) Updating access-type categories 
for service-def:[hbase]
2023-12-22 00:36:13,959 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:149) Updated access-type categories for 
service-def:[hbase]
2023-12-22 00:36:13,959 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:103) Updating access-type categories 
for service-def:[hive]
2023-12-22 00:36:13,960 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:139) Category not found for 
access-type:[all] in embedded service-def:[hive]. Will not be updated
2023-12-22 00:36:14,023 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:149) Updated access-type categories for 
service-def:[hive]
2023-12-22 00:36:14,023 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:103) Updating access-type categories 
for service-def:[yarn]
2023-12-22 00:36:14,056 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:149) Updated access-type categories for 
service-def:[yarn]
2023-12-22 00:36:14,056 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:103) Updating access-type categories 
for service-def:[knox]
2023-12-22 00:36:14,084 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:149) Updated access-type categories for 
service-def:[knox]
2023-12-22 00:36:14,084 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:103) Updating access-type categories 
for service-def:[storm]
2023-12-22 00:36:14,125 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:149) Updated access-type categories for 
service-def:[storm]
2023-12-22 00:36:14,126 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:103) Updating access-type categories 
for service-def:[kms]
2023-12-22 00:36:14,160 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:149) Updated access-type categories for 
service-def:[kms]
2023-12-22 00:36:14,160 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:103) Updating access-type categories 
for service-def:[solr]
2023-12-22 00:36:14,191 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:149) Updated access-type categories for 
service-def:[solr]
2023-12-22 00:36:14,191 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:103) Updating access-type categories 
for service-def:[kafka]
2023-12-22 00:36:14,235 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:149) Updated access-type categories for 
service-def:[kafka]
2023-12-22 00:36:14,235 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:103) Updating access-type categories 
for service-def:[nifi]
2023-12-22 00:36:14,264 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:149) Updated access-type categories for 
service-def:[nifi]
2023-12-22 00:36:14,264 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:103) Updating access-type categories 
for service-def:[kylin]
2023-12-22 00:36:14,293 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:149) Updated access-type categories for 
service-def:[kylin]
2023-12-22 00:36:14,293 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:103) Updating access-type categories 
for service-def:[nifi-registry]
2023-12-22 00:36:14,327 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:149) Updated access-type categories for 
service-def:[nifi-registry]
2023-12-22 00:36:14,327 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:103) Updating access-type categories 
for service-def:[sqoop]
2023-12-22 00:36:14,371 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:149) Updated access-type categories for 
service-def:[sqoop]
2023-12-22 00:36:14,371 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:103) Updating access-type categories 
for service-def:[atlas]
2023-12-22 00:36:14,434 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:149) Updated access-type categories for 
service-def:[atlas]
2023-12-22 00:36:14,435 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:103) Updating access-type categories 
for service-def:[elasticsearch]
2023-12-22 00:36:14,435 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:139) Category not found for 
access-type:[all] in embedded service-def:[elasticsearch]. Will not be updated
2023-12-22 00:36:14,474 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:149) Updated access-type categories for 
service-def:[elasticsearch]
2023-12-22 00:36:14,474 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:103) Updating access-type categories 
for service-def:[presto]
2023-12-22 00:36:14,475 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:139) Category not found for 
access-type:[all] in embedded service-def:[presto]. Will not be updated
2023-12-22 00:36:14,523 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:149) Updated access-type categories for 
service-def:[presto]
2023-12-22 00:36:14,523 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:103) Updating access-type categories 
for service-def:[kudu]
2023-12-22 00:36:14,523 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:139) Category not found for 
access-type:[all] in embedded service-def:[kudu]. Will not be updated
2023-12-22 00:36:14,554 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:149) Updated access-type categories for 
service-def:[kudu]
2023-12-22 00:36:14,554 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:103) Updating access-type categories 
for service-def:[ozone]
2023-12-22 00:36:14,555 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:139) Category not found for 
access-type:[all] in embedded service-def:[ozone]. Will not be updated
2023-12-22 00:36:14,589 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:149) Updated access-type categories for 
service-def:[ozone]
2023-12-22 00:36:14,590 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:103) Updating access-type categories 
for service-def:[schema-registry]
2023-12-22 00:36:14,624 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:149) Updated access-type categories for 
service-def:[schema-registry]
2023-12-22 00:36:14,625 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:103) Updating access-type categories 
for service-def:[trino]
2023-12-22 00:36:14,625 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:139) Category not found for 
access-type:[all] in embedded service-def:[trino]. Will not be updated
2023-12-22 00:36:14,672 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:149) Updated access-type categories for 
service-def:[trino]
2023-12-22 00:36:14,672 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:103) Updating access-type categories 
for service-def:[nestedstructure]
2023-12-22 00:36:14,702 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:149) Updated access-type categories for 
service-def:[nestedstructure]
2023-12-22 00:36:14,707 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:155) Updating access-type categories 
for service-def:[tag]
2023-12-22 00:36:14,707 [main] WARN  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:179) Category not found for 
access-type:[all] in embedded service-def:[elasticsearch]. Access type category 
will not be updated in tag service-def
2023-12-22 00:36:14,707 [main] WARN  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:179) Category not found for 
access-type:[all] in embedded service-def:[trino]. Access type category will 
not be updated in tag service-def
2023-12-22 00:36:14,707 [main] WARN  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:179) Category not found for 
access-type:[all] in embedded service-def:[presto]. Access type category will 
not be updated in tag service-def
2023-12-22 00:36:14,708 [main] WARN  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:179) Category not found for 
access-type:[all] in embedded service-def:[ozone]. Access type category will 
not be updated in tag service-def
2023-12-22 00:36:14,708 [main] WARN  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:179) Category not found for 
access-type:[all] in embedded service-def:[kudu]. Access type category will not 
be updated in tag service-def
2023-12-22 00:36:14,708 [main] WARN  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:179) Category not found for 
access-type:[all] in embedded service-def:[hive]. Access type category will not 
be updated in tag service-def
2023-12-22 00:36:14,950 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:189) Updated access-type categories for 
service-def:[tag]
2023-12-22 00:36:14,950 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:192) <== 
PatchSetAccessTypeCategory_J10061.updateAllServiceDef()
2023-12-22 00:36:14,950 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:83) <== 
PatchSetAccessTypeCategory_J10061.execLoad()
2023-12-22 00:36:14,950 [main] INFO  o.a.r.p.BaseLoader (BaseLoader.java:108) 
###############################################
2023-12-22 00:36:14,950 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:88) PatchSetAccessTypeCategory_J10061
2023-12-22 00:36:14,950 [main] INFO  o.a.r.p.BaseLoader (BaseLoader.java:110) 
Loading completed!!!. Time taken=1secs, 247ms for 0
2023-12-22 00:36:14,951 [main] INFO  o.a.r.p.BaseLoader (BaseLoader.java:113) 
###############################################
2023-12-22 00:36:14,951 [Loader Monitor] INFO  o.a.r.p.BaseLoader$1 
(BaseLoader.java:140) Monitor Thread exiting!!!
2023-12-22 00:36:14,974 [main] INFO  o.a.r.p.PatchSetAccessTypeCategory_J10061 
(PatchSetAccessTypeCategory_J10061.java:58) Load complete. Exiting!!!
```


Thanks,

Madhan Neethiraj

Reply via email to