[RANGER-3914] Change sync_source column's datatype from varchar to text

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0, 2.3.0
• Fix Version/s: 3.0.0, 2.4.0
• Component/s: Ranger
• Assignee: Pradeep Agrawal
• Reporter: Pradeep Agrawal
• Created: 15/Sep/22 16:20
• Updated: 20/Sep/23 10:05
• Resolved: 21/Sep/22 07:12

Description

Ranger install on mysql engine with utf8mb4 may hit the below issue due to sync_source column in x_portal_user table. 

https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html#:~:text=The%20internal%20representation%20of%20a,the%20rest%20of%20the%20row.

Issue Links

• causes: RANGER-4422 Searching for users/groups with Sync source filter on the users/groups page leads to error on Oracle DB
• is duplicated by: RANGER-3394 Too much `varchar(4000)` causes table to exceed ROW SIZE limit in MySQL
• is duplicated by: RANGER-3680 mysql ErrorCode:1118 when Importing DB schema to database
• is duplicated by: RANGER-3719 Can not create mysql table with charset utf8mb4.
• links to: Review request