[
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)
