[
https://issues.apache.org/jira/browse/RANGER-4894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872624#comment-17872624
]
Femi commented on RANGER-4894:
------------------------------
Hi,
I was able to proceed to deployment but I run into the following issue.
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;
{color:#de350b}java.sql.SQLSyntaxErrorException: Specified key was too long;
max key length is 3072 bytes{color}
{color:#de350b}SQLException : SQL state: 42000
java.sql.SQLSyntaxErrorException: Specified key was too long; max key length is
3072 bytes ErrorCode: 1071{color}
{color:#de350b}2024-08-10 15:16:32,189 [E] ranger_core_db_mysql.sql file
import failed!{color}
2024-08-10 15:16:32,190 [I] Unable to create DB schema, Please drop the
database and try again
Please Let me know if this is resolved in 2.5 as well. The database is myql 8 (
mysql --version
mysql Ver 8.0.36 for Linux on x86_64 (Source distribution))
RHEL9
Thank you
> org.apache.ranger:ranger-trino-plugin
> --------------------------------------
>
> Key: RANGER-4894
> URL: https://issues.apache.org/jira/browse/RANGER-4894
> Project: Ranger
> Issue Type: Bug
> Components: plugins
> Affects Versions: 2.4.0
> Reporter: Femi
> Priority: Major
> Original Estimate: 48h
> Remaining Estimate: 48h
>
> Please can I skip org.apache.ranger:ranger-trino-plugin. Because I ran into
> this issue during compilation. or if there is any recommendation it will be
> greatly appreciated.
> [INFO] Building Ranger Security Plugin for Trino 3.0.0-SNAPSHOT
> [65/66]
> [INFO] --------------------------------[ jar
> ]---------------------------------
> Downloading from apache.snapshots.https:
> https://repository.apache.org/content/repositories/snapshots/com/google/api/gax-bom/2.49.0/gax
> -bom-2.49.0.pom
> Downloading from apache.public.https:
> https://repository.apache.org/content/repositories/public/com/google/api/gax-bom/2.49.0/gax-bom-2
> .49.0.pom
> Downloading from google-maven-central-copy:
> https://maven-central.storage-download.googleapis.com/maven2/com/google/api/gax-bom/2.49.0/
> gax-bom-2.49.0.pom
> [INFO] I/O exception (java.net.SocketException) caught when processing
> request to \{s}->https://maven-central.storage-download.googleapi
> s.com:443: Connection timed out (Read failed)
> [INFO] Retrying request to
> \{s}->https://maven-central.storage-download.googleapis.com:443
>
> compilation issue when this command is runs mvn -DskipTests=true
> clean package
>
> Based on the retying effort it possible it firewall, since I dont need this
> plugin could this be skip during the plugin without any issue to the Ranger
> admin functionality.
> Best Regards
> Femi
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
