You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by "Abhishek Kumar (Jira)" <ji...@apache.org> on 2025/01/26 23:25:00 UTC
[jira] [Commented] (RANGER-4888) The ranger setup.sh/db setup fails on Mysql ranger creation
[ https://issues.apache.org/jira/browse/RANGER-4888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17921223#comment-17921223 ]
Abhishek Kumar commented on RANGER-4888:
----------------------------------------
Please update the Priority to Blocker if this needs addressed in the 2.6.0 release, the ranger-2.6 branch will be in locked mode after Jan-29. thanks.
> 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
> Priority: Major
> Fix For: 2.6.0
>
>
> {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)