[
https://issues.apache.org/jira/browse/RANGER-2109?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pradeep Agrawal resolved RANGER-2109.
-------------------------------------
Fix Version/s: 2.1.0
Resolution: Implemented
Implemented in RANGER-2802
> Ranger mysql db does not allow creation of many service definitions
> -------------------------------------------------------------------
>
> Key: RANGER-2109
> URL: https://issues.apache.org/jira/browse/RANGER-2109
> Project: Ranger
> Issue Type: Bug
> Components: Ranger
> Reporter: Alexander Posledov
> Priority: Major
> Fix For: 2.1.0
>
>
> We need to add many service definitions to Ranger. After some time, service
> definitions cannot be added, and the following error is returned:
> {code:java}
> Reply from service: {"statusCode":1,"msgDesc":"Exception [EclipseLink-4002]
> (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd):
> org.eclipse.persistence.exceptions.DatabaseException\nInternal Exception:
> com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for
> column 'sort_order' at row 1\nError Code: 1264\nCall: 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n\tbind
> => [12 parameters bound]\nQuery: InsertObjectQuery(XXAccessTypeDef
> [XXDBBase={createTime={Fri Apr 06 16:15:17 UTC 2018} updateTime={Fri May 18
> 17:58:12 UTC 2018} addedByUserId={1} updatedByUserId={1} } id=null,
> defId=100, itemId=837838,
> name=c9999990-def-51c64923-3650-48b4-b4e9-abfd9fe0ed7a-1526666291595:read,
> label=Read, rbKeyLabel=null, dataMaskOptions=null, rowFilterOptions=null,
> order=128])"}
> {code}
> changing sort_order column type to INT helps, but I think this should be done
> in the initial Ranger setup.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
