[I] Patch 006-createdefaultpublicgroup.sql is being applied.. 2018-08-25 21:48:33,172 [JISQL] /usr/bin/java -cp /usr/hdp/current/ranger-admin/ews/lib/mysql-connector-java-5.1.25-bin.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://host/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -input /usr/hdp/current/ranger-admin/db/mysql/patches/006-createdefaultpublicgroup.sql
Error executing: call insert_public_group_in_x_group_table();
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`ranger`.`x_group`, CONSTRAINT `x_group_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`))
SQLException : SQL state: 23000 com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`ranger`.`x_group`, CONSTRAINT `x_group_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`)) ErrorCode: 1452
2018-08-25 21:48:33,618 [JISQL] /usr/bin/java -cp /usr/hdp/current/ranger-admin/ews/lib/mysql-connector-java-5.1.25-bin.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://xxx/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = '006' and active = 'Y';"
2018-08-25 21:48:34,038 [JISQL] /usr/bin/java -cp /usr/hdp/current/ranger-admin/ews/lib/mysql-connector-java-5.1.25-bin.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://xxx/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "delete from x_db_version_h where version='006' and active='N' and updated_by='xxx';"
2018-08-25 21:48:34,483 [E] 006-createdefaultpublicgroup.sql import failed!
... View more
