Basapuram Kumar created RANGER-4932:
---------------------------------------
Summary: 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
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
{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)
