[jira] [Created] (RANGER-3680) mysql ErrorCode:1118 when Importing DB schema to database

["vesence (Jira)" <ji...@apache.org>]

vesence created RANGER-3680:
-------------------------------

             Summary: 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


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.1#820001)