----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/74958/ -----------------------------------------------------------
(Updated April 18, 2024, 8:57 a.m.) Review request for ranger, bhavik patel, Dineshkumar Yadav, Jayendra Parab, Kishor Gollapalliwar, Abhay Kulkarni, Madhan Neethiraj, Mehul Parikh, Pradeep Agrawal, Ramesh Mani, Sailaja Polavarapu, Vikas Kumar, and Velmurugan Periasamy. Bugs: RANGER-4775 https://issues.apache.org/jira/browse/RANGER-4775 Repository: ranger Description (updated) ------- Ranger KMS is failing with Oracle 23 database with below error. ``` 2024-04-01 07:25:27,032 INFO org.apache.hadoop.crypto.key.RangerMasterKey: Master Key doesn't exist in DB, Generating the Master Key 2024-04-01 07:25:27,169 ERROR org.apache.hadoop.crypto.key.RangerMasterKey: Error while saving master key in Database!!! java.lang.ClassCastException: java.lang.String cannot be cast to java.sql.Clob at org.eclipse.persistence.platform.database.oracle.Oracle8Platform.writeLOB(Oracle8Platform.java:194) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at org.eclipse.persistence.internal.helper.LOBValueWriter.fetchLocatorAndWriteValue(LOBValueWriter.java:94) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processResultSet(DatabaseAccessor.java:758) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:673) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:567) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at org.eclipse.persistence.internal.helper.LOBValueWriter.buildAndExecuteCall(LOBValueWriter.java:79) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at org.eclipse.persistence.internal.helper.LOBValueWriter.buildAndExecuteSelectCalls(LOBValueWriter.java:190) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.flushSelectCalls(DatabaseAccessor.java:175) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:457) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:182) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:197) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at ``` Diffs ----- kms/src/main/java/org/apache/ranger/entity/XXRangerKeyStore.java 6b541eca5 kms/src/main/java/org/apache/ranger/entity/XXRangerMasterKey.java 64fdd56e4 Diff: https://reviews.apache.org/r/74958/diff/1/ Testing ------- Successful build with test cases. Successfully validated with all the supported DB Flavor Thanks, Dhaval Shah