Alexander Posledov created RANGER-2109:
------------------------------------------
Summary: 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
Affects Versions: 0.7.0
Reporter: Alexander Posledov
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)
