You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ranger.apache.org by Steven Weiss <sw...@iafrica.com> on 2024/08/02 10:30:01 UTC

setup.sh

Hi,

I’m trying to install ranger-admin with MYSQL 8 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.

Regards
Steven

Re: setup.sh

Posted by Bhavik Patel <bh...@gmail.com>.
Hi Steven,


You are correct. To move forward I will suggest you to reduce the `trx_id`
VARCHAR(767) DEFAULT NULL,


Also, can you kindly file a jira to RANGER board.


Thanks,
Bhavik Patel
+91-7208744109


On Fri, 2 Aug 2024, 4:01 pm Steven Weiss, <sw...@iafrica.com> wrote:

> Hi,
>
> I’m trying to install ranger-admin with MYSQL 8 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.
>
> Regards
> Steven
>
>