[jira] [Commented] (RANGER-2109) Ranger mysql db does not allow creation of many service definitions

["Alexander Posledov (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/RANGER-2109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16498018#comment-16498018 ] 

Alexander Posledov commented on RANGER-2109:
--------------------------------------------

[~pradeep.agrawal] : we are testing performance and stability of our product, and during one of the test's steps we concurrently (4 threads) add 1000 service definitions to Ranger, which leads to the error, shown above. 

> 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
>
> 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
(v7.6.3#76005)