-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/72383/
-----------------------------------------------------------
Review request for ranger.
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 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
**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 91f8db75a
security-admin/db/mysql/patches/047-sortorder-column-size.sql PRE-CREATION
security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql
b07fbf367
security-admin/db/oracle/patches/047-sortorder-column-size.sql PRE-CREATION
security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql
27d4f252b
security-admin/db/postgres/patches/047-sortorder-column-size.sql PRE-CREATION
security-admin/db/sqlanywhere/optimized/current/ranger_core_db_sqlanywhere.sql
5c6f896d0
security-admin/db/sqlanywhere/patches/047-sortorder-column-size.sql
PRE-CREATION
security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql
a94070935
security-admin/db/sqlserver/patches/047-sortorder-column-size.sql
PRE-CREATION
Diff: https://reviews.apache.org/r/72383/diff/1/
Testing
-------
Thanks,
Pradeep Agrawal
