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)
