[
https://issues.apache.org/jira/browse/RANGER-4932?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881376#comment-17881376
]
Basapuram Kumar commented on RANGER-4932:
-----------------------------------------
PR
https://github.com/apache/ranger/pull/391
> Specified key was too long; max key length is 3072 bytes
> --------------------------------------------------------
>
> Key: RANGER-4932
> URL: https://issues.apache.org/jira/browse/RANGER-4932
> Project: Ranger
> Issue Type: Bug
> Components: admin
> Affects Versions: 2.5.0
> Reporter: Basapuram Kumar
> Priority: Major
>
> Trying upgrade ranger from 2.3.0 to 2.5.0, but failed with the below error.
>
> Error logging
> {noformat}
> 2024-09-12 20:35:21,377 [I] Executing patch on ranger from file:
> 073-create-x_trx_log_v2.sql
> 2024-09-12 20:35:21,377 [JISQL] /usr/lib/jvm/java-11-openjdk/bin/java -cp
> /usr/odp/current/ranger-admin/ews/lib/mysql-jdbc-driver.jar:/usr/odp/current/ranger-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://ce19.acceldata.dvl/ranger?useSSL=false -u 'ranger' -p '********'
> -noheader -trim -c \; -query "select version from x_db_version_h where
> version = '073' and active = 'Y';"2024-09-12 20:35:21,528 [JISQL]
> /usr/lib/jvm/java-11-openjdk/bin/java -cp
> /usr/odp/current/ranger-admin/ews/lib/mysql-jdbc-driver.jar:/usr/odp/current/ranger-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://ce19.acceldata.dvl/ranger?useSSL=false -u 'ranger' -p '********'
> -noheader -trim -c \; -query "select version from x_db_version_h where
> version = '073' and active = 'N';"2024-09-12 20:35:21,687 [JISQL]
> /usr/lib/jvm/java-11-openjdk/bin/java -cp
> /usr/odp/current/ranger-admin/ews/lib/mysql-jdbc-driver.jar:/usr/odp/current/ranger-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://ce19.acceldata.dvl/ranger?useSSL=false -u 'ranger' -p '********'
> -noheader -trim -c \; -query "insert into x_db_version_h (version, inst_at,
> inst_by, updated_at, updated_by,active) values ('073', current_timestamp,
> 'Ranger 2.5.0.3.3.6.0-2', current_timestamp, 'ce19.acceldata.dvl','N')
> ;"2024-09-12 20:35:21,839 [I] Patch 073-create-x_trx_log_v2.sql is being
> applied..
> 2024-09-12 20:35:21,839 [JISQL] /usr/lib/jvm/java-11-openjdk/bin/java -cp
> /usr/odp/current/ranger-admin/ews/lib/mysql-jdbc-driver.jar:/usr/odp/current/ranger-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://ce19.acceldata.dvl/ranger?useSSL=false -u 'ranger' -p '********'
> -noheader -trim -c \; -input
> /usr/odp/current/ranger-admin/db/mysql/patches/073-create-x_trx_log_v2.sql
> Error executing: 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: 10712024-09-12
> 20:35:21,986 [JISQL] /usr/lib/jvm/java-11-openjdk/bin/java -cp
> /usr/odp/current/ranger-admin/ews/lib/mysql-jdbc-driver.jar:/usr/odp/current/ranger-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://ce19.acceldata.dvl/ranger?useSSL=false -u 'ranger' -p '********'
> -noheader -trim -c \; -query "select version from x_db_version_h where
> version = '073' and active = 'Y';"
> 2024-09-12 20:35:22,145 [JISQL] /usr/lib/jvm/java-11-openjdk/bin/java -cp
> /usr/odp/current/ranger-admin/ews/lib/mysql-jdbc-driver.jar:/usr/odp/current/ranger-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://ce19.acceldata.dvl/ranger?useSSL=false -u 'ranger' -p '********'
> -noheader -trim -c \; -query "delete from x_db_version_h where version =
> '073' and active = 'N' and updated_by='ce19.acceldata.dvl';"
> 2024-09-12 20:35:22,297 [E] 073-create-x_trx_log_v2.sql import
> failed!{noformat}
> When checked at MySql, the table DDL is as follows as per
> [this|https://github.com/apache/ranger/blob/master/security-admin/db/mysql/patches/073-create-x_trx_log_v2.sql]
> {noformat}
> 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;{noformat}
> By Adding the "DEFAULT CHARSET=latin1", able to get rid of this error.
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
