Details
Description
1. Fetch latest source using "git clone https://git-wip-us.apache.org/repos/asf/ranger.git" command.
2. Build.
3. Install Ranger admin.
Error information is as following:
2017-09-16 23:39:54,695 [E] 028-add-unique-constraint-on-table-x_group.sql import failed!
Execute 028-add-unique-constraint-on-table-x_group.sql file separately, there are following:
1. error code:1314 ALTER VIEW is not allowed in stored procedures 2. error code:1305 PROCEDURE ranger.create_unique_constraint_on_groupname does not exist
This issue was introduced by the RANGER-1765.
mysql> source /diskc/installranger/run/ranger-1.0.0-admin/db/mysql/patches/028-add-unique-constraint-on-table-x_group.sql Query OK, 0 rows affected, 1 warning (0.00 sec) ERROR 1314 (0A000): ALTER VIEW is not allowed in stored procedures ERROR 1305 (42000): PROCEDURE ranger.create_unique_constraint_on_groupname does not exist Query OK, 0 rows affected, 1 warning (0.00 sec)
Reason:
As of MySQL 5.7.4, the IGNORE clause for ALTER TABLE is removed and its use produces an error.
Attachments
Attachments
Issue Links
- links to
peng.jianhua "IGNORE" keyword will work for mysql 5.6 version. For generic solution you can remove ignore keyword or un-comment line below that statement and remove the current line.
Also provide same fix for ranger-0.7 branch.