Steven Weiss created RANGER-4888:
------------------------------------
Summary: The ranger setup.sh/db setup fails on Mysql ranger
creation
Key: RANGER-4888
URL: https://issues.apache.org/jira/browse/RANGER-4888
Project: Ranger
Issue Type: Bug
Components: Ranger
Affects Versions: 2.4.0
Environment: Ubuntu 20.04
Reporter: Steven Weiss
{quote}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{quote}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
