----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/72383/#review220563 -----------------------------------------------------------
Ship it! Ship It! - Mehul Parikh On April 17, 2020, 9:46 p.m., Pradeep Agrawal wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/72383/ > ----------------------------------------------------------- > > (Updated April 17, 2020, 9:46 p.m.) > > > Review request for ranger, Ankita Sinha, Dhaval Shah, Dineshkumar Yadav, > Gautam Borad, Jayendra Parab, Kishor Gollapalliwar, Abhay Kulkarni, Madhan > Neethiraj, Mehul Parikh, Nitin Galave, Nixon Rodrigues, Ramesh Mani, Sailaja > Polavarapu, and Velmurugan Periasamy. > > > Bugs: RANGER-2802 > https://issues.apache.org/jira/browse/RANGER-2802 > > > Repository: ranger > > > Description > ------- > > **Problem Statement:** Faced below errors while upgrading from ranger 0.7 to > master branch : > > > org.apache.ranger.patch.PatchForAtlasToAddEntityLabelAndBusinessMetadata_J10034 > (PatchForAtlasToAddEntityLabelAndBusinessMetadata_J10034.java:122) - ==> > PatchForAtlasToAddEntityLabelAndBusinessMetadata.execLoad()2020-04-14 > 06:16:01,739 [Loader Monitor] INFO > org.apache.ranger.patch.PatchForAtlasToAddEntityLabelAndBusinessMetadata_J10034 > (PatchForAtlasToAddEntityLabelAndBusinessMetadata_J10034.java:135) - > PatchForAtlasToAddEntityLabelAndBusinessMetadata Logs2020-04-14 06:16:02,598 > [main] ERROR org.apache.ranger.plugin.store.AbstractServiceStore > (AbstractServiceStore.java:327) - > AbstractServiceStore.updateTagServiceDefForUpdatingAccessTypes -- Failed to > update TAG ServiceDef..javax.persistence.PersistenceException: Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): > org.eclipse.persistence.exceptions.DatabaseExceptionInternal Exception: > com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for > column 'sort_order' at row 1Error Cod e: 1264Call: INSERT INTO x_access_type_def (ADDED_BY_ID, CREATE_TIME, datamask_options, def_id, item_id, label, name, sort_order, rb_key_label, rowfilter_options, UPDATE_TIME, UPD_BY_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [12 parameters bound]Query: ValueReadQuery(name="x_access_type_def_SEQ" sql="SELECT LAST_INSERT_ID()") at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:868) at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source) at > > **Proposed solution:** sort_order column of x_access_type_def should be > increased in upgrade case. > > **Note:** Patch will also address changes in other columns which i covered in > RANGER-2550 patch. > > > Diffs > ----- > > security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql > f39b29971 > security-admin/db/mysql/patches/047-sortorder-column-size.sql PRE-CREATION > security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql > 67877a57c > security-admin/db/oracle/patches/043-add-tag-change-log-table.sql 691cbdb57 > > security-admin/db/oracle/patches/046-insert-statename-in-x-ranger-global-state.sql > 8359f7713 > security-admin/db/oracle/patches/047-sortorder-column-size.sql PRE-CREATION > security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql > e59694105 > security-admin/db/postgres/patches/043-add-tag-change-log-table.sql > 3e060d7ad > security-admin/db/postgres/patches/047-sortorder-column-size.sql > PRE-CREATION > > security-admin/db/sqlanywhere/optimized/current/ranger_core_db_sqlanywhere.sql > a7b1a40aa > security-admin/db/sqlanywhere/patches/047-sortorder-column-size.sql > PRE-CREATION > security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql > aaf19e7be > security-admin/db/sqlserver/patches/047-sortorder-column-size.sql > PRE-CREATION > > > Diff: https://reviews.apache.org/r/72383/diff/3/ > > > Testing > ------- > > > Thanks, > > Pradeep Agrawal > >
