[
https://issues.apache.org/jira/browse/RANGER-3680?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pradeep Agrawal reassigned RANGER-3680:
---------------------------------------
Assignee: Pradeep Agrawal
> mysql ErrorCode:1118 when Importing DB schema to database
> ---------------------------------------------------------
>
> Key: RANGER-3680
> URL: https://issues.apache.org/jira/browse/RANGER-3680
> Project: Ranger
> Issue Type: Bug
> Components: admin
> Affects Versions: 2.2.0
> Environment: os: centos 7
> mysql: 5.7.30
> jdk: 1.8.0_251
> Reporter: vesence
> Assignee: Pradeep Agrawal
> Priority: Major
>
> ranger_core_db_mysql.sql file import failed when initializing admin database,
> here is the specific imformation below:
> [I] Importing DB schema to database bdp_ranger from file:
> ranger_core_db_mysql.sql
> Error executing:
> CREATE TABLE `x_portal_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT,
> `create_time` datetime DEFAULT NULL,
> `update_time` datetime DEFAULT NULL,
> `added_by_id` bigint(20) DEFAULT NULL,
> `upd_by_id` bigint(20) DEFAULT NULL,
> `first_name` varchar(1022) DEFAULT NULL,
> `last_name` varchar(1022) DEFAULT NULL,
> `pub_scr_name` varchar(2048) DEFAULT NULL,
> `login_id` varchar(767) DEFAULT NULL,
> `password` varchar(512) NOT NULL,
> `email` varchar(512) DEFAULT NULL,
> `status` int(11) NOT NULL DEFAULT '0',
> `user_src` int(11) NOT NULL DEFAULT '0',
> `notes` varchar(4000) DEFAULT NULL,
> `other_attributes` varchar(4000) DEFAULT NULL,
> `sync_source` varchar(4000) DEFAULT NULL,
> PRIMARY KEY (`id`),
> UNIQUE KEY `x_portal_user_UK_login_id` (`login_id`),
> UNIQUE KEY `x_portal_user_UK_email` (`email`),
> KEY `x_portal_user_FK_added_by_id` (`added_by_id`),
> KEY `x_portal_user_FK_upd_by_id` (`upd_by_id`),
> KEY `x_portal_user_cr_time` (`create_time`),
> KEY `x_portal_user_up_time` (`update_time`),
> KEY `x_portal_user_name` (`first_name`(767)),
> KEY `x_portal_user_email` (`email`),
> CONSTRAINT `x_portal_user_FK_added_by_id` FOREIGN KEY (`added_by_id`)
> REFERENCES `x_portal_user` (`id`),
> CONSTRAINT `x_portal_user_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES
> `x_portal_user` (`id`) ) ROW_FORMAT=DYNAMIC;
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> Row size too large. The maximum row size for the used table type, not
> counting BLOBs, is 65535.
> This includes storage overhead, check the manual. You have to change some
> columns to TEXT or BLOBs
> SQLException : SQL state: 42000
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too
> large. The maximum row size for the used table type, not counting BLOBs, is
> 65535. This includes storage overhead, check the manual. You have to change
> some columns to TEXT or BLOBs ErrorCode: 1118
>
> [E] ranger_core_db_mysql.sql file import failed!
>
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
