[RANGER-4888] The ranger setup.sh/db setup fails on Mysql ranger creation

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.4.0
• Fix Version/s: 2.6.0
• Component/s: Ranger
• Environment: Ubuntu 20.04
• Flags: Patch, Important
• Assignee: Unassigned
• Reporter: Steven Weiss
• Created: 02/Aug/24 14:47
• Updated: 11/Aug/24 18:00

Description

Running setup.sh
 
Error:
 
CREATE TABLE `x_trx_log_v2` (   `id` bigint(20) NOT NULL AUTO_INCREMENT,   `create_time` datetime DEFAULT NULL,   `added_by_id` bigint(20) DEFAULT NULL,   `class_type` int(11) NOT NULL DEFAULT '0',   `object_id` bigint(20) DEFAULT NULL,   `parent_object_id` bigint(20) DEFAULT NULL,   `parent_object_class_type` int(11) NOT NULL DEFAULT '0',   `parent_object_name` varchar(1024) DEFAULT NULL,   `object_name` varchar(1024) DEFAULT NULL,   `change_info` MEDIUMTEXT NULL DEFAULT NULL,   `trx_id` varchar(1024) DEFAULT NULL,   `action` varchar(255) DEFAULT NULL,   `sess_id` varchar(512) DEFAULT NULL,   `req_id` varchar(30) DEFAULT NULL,   `sess_type` varchar(30) DEFAULT NULL,   PRIMARY KEY (`id`),   KEY `x_trx_log_v2_FK_added_by_id` (`added_by_id`),   KEY `x_trx_log_v2_cr_time` (`create_time`),   KEY `x_trx_log_v2_trx_id` (`trx_id`) )ROW_FORMAT=DYNAMIC;
java.sql.SQLSyntaxErrorException: Specified key was too long; max key length is 3072 bytes
SQLException : SQL state: 42000 java.sql.SQLSyntaxErrorException: Specified key was too long; max key length is 3072 bytes ErrorCode: 1071
 
Problem seems to be the trx_id is too long