[ 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)