Pradeep Agrawal created RANGER-2802: ---------------------------------------
Summary: Java patch J10034 may fail in upgrade case Key: RANGER-2802 URL: https://issues.apache.org/jira/browse/RANGER-2802 Project: Ranger Issue Type: Bug Components: Ranger Affects Versions: 2.1.0, 2.1, 2.0.1 Reporter: Pradeep Agrawal Assignee: Pradeep Agrawal Fix For: 2.1.0, 2.1, 2.0.1 Faced below errors while upgrading from ranger 0.7 to master branch : {code:java} 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 Code: 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 {code} Proposed solution : sort_order column of x_access_type_def should be increased in upgrade case. -- This message was sent by Atlassian Jira (v8.3.4#803005)