[
https://issues.apache.org/jira/browse/RANGER-2802?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pradeep Agrawal updated RANGER-2802:
------------------------------------
Attachment: 0001-RANGER-2802-Java-patch-J10034-may-fail-in-upgrade-ca.patch
> 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
> Priority: Major
> Fix For: 2.1.0, 2.1, 2.0.1
>
> Attachments:
> 0001-RANGER-2802-Java-patch-J10034-may-fail-in-upgrade-ca.patch
>
>
> 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)
