[
https://issues.apache.org/jira/browse/RANGER-5557?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pradeep Agrawal updated RANGER-5557:
------------------------------------
Description:
Ranger upgrade in mysql 8 with utf8mb4 charset may fail with below error
{code:java}
2026-04-17 06:50:51,529 [I] Patch 074-create-index-for-x_trx_log.sql is being
applied..
2026-04-17 06:50:51,530 [JISQL]
/usr/lib/jvm/jdk1.17.0.11.0-openjdk-cloudera/bin/java -cp
/usr/share/java/mysql-connector-java.jar:/root/ranger-admin/jisql/lib/*
org.apache.util.sql.Jisql -driver mysqlconj -cstring
jdbc:mysql://localhost/ranger1703?useSSL=false -u 'ranger1703' -p '********'
-noheader -trim -c \; -input
/root/ranger-admin/db/mysql/patches/074-create-index-for-x_trx_log.sql
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class
is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the
SPI and manual loading of the driver class is generally unnecessary.
Error executing: call create_index_for_x_trx_log();
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 {code}
> Ranger Database Upgrade Failure Due to MySQL Index Key Length Exceeding Limit
> (utf8mb4)
> ---------------------------------------------------------------------------------------
>
> Key: RANGER-5557
> URL: https://issues.apache.org/jira/browse/RANGER-5557
> Project: Ranger
> Issue Type: Bug
> Components: Ranger
> Reporter: Pradeep Agrawal
> Assignee: Pradeep Agrawal
> Priority: Major
> Fix For: 3.0.0
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Ranger upgrade in mysql 8 with utf8mb4 charset may fail with below error
> {code:java}
> 2026-04-17 06:50:51,529 [I] Patch 074-create-index-for-x_trx_log.sql is
> being applied..
> 2026-04-17 06:50:51,530 [JISQL]
> /usr/lib/jvm/jdk1.17.0.11.0-openjdk-cloudera/bin/java -cp
> /usr/share/java/mysql-connector-java.jar:/root/ranger-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://localhost/ranger1703?useSSL=false -u 'ranger1703' -p '********'
> -noheader -trim -c \; -input
> /root/ranger-admin/db/mysql/patches/074-create-index-for-x_trx_log.sql
> Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver
> class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered
> via the SPI and manual loading of the driver class is generally unnecessary.
> Error executing: call create_index_for_x_trx_log();
> 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 {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
