-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/71757/
-----------------------------------------------------------
(Updated Nov. 13, 2019, 2:17 p.m.)
Review request for ranger, Ankita Sinha, Gautam Borad, Abhay Kulkarni, Madhan
Neethiraj, Mehul Parikh, Pradeep Agrawal, Ramesh Mani, and Velmurugan Periasamy.
Changes
-------
Merged SQL Patch 045 and 046.
Bugs: RANGER-2641
https://issues.apache.org/jira/browse/RANGER-2641
Repository: ranger
Description
-------
Ranger upgrade fails giving following error.
Error executing: drop procedure if exists
add-role-version-in-serviceVersionInfo;
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in
your SQL syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near 'add-role-version-in-serviceVersionInfo' at
line 1
SQLException : SQL state: 42000
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in
your SQL syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near 'add-role-version-in-serviceVersionInfo' at
line 1 ErrorCode: 1064
2019-11-07 07:26:17,379 [JISQL] /root/jdk1.8.0_112/bin/java -cp
/usr/share/java/mysql-connector-java.jar:/root/0711finaltar25902632/ranger-2.1.0-SNAPSHOT-admin/jisql/lib/*
org.apache.util.sql.Jisql -driver mysqlconj -cstring
jdbc:mysql://172.22.86.187/ranger -u 'rangeradmin' -p '********' -noheader
-trim -c \; -query "select version from x_db_version_h where version = '043'
and active = 'Y';"
2019-11-07 07:26:17,846 [JISQL] /root/jdk1.8.0_112/bin/java -cp
/usr/share/java/mysql-connector-java.jar:/root/0711finaltar25902632/ranger-2.1.0-SNAPSHOT-admin/jisql/lib/*
org.apache.util.sql.Jisql -driver mysqlconj -cstring
jdbc:mysql://172.22.86.187/ranger -u 'rangeradmin' -p '********' -noheader
-trim -c \; -query "delete from x_db_version_h where version = '043' and
active = 'N' and updated_by='pt-test2590-1.openstacklocal';"
2019-11-07 07:26:18,293 [E] 043-add-role-version-in-serviceVersionInfo.sql
import failed!
Diffs (updated)
-----
security-admin/db/mysql/patches/043-add-role-version-in-serviceVersionInfo.sql
def5678b0
security-admin/db/mysql/patches/044-add-displayName-col-in-x_service_def_and_x_service.sql
b552c422c
security-admin/db/mysql/patches/045-add-otherAttributes-col-in-x_user-x_portal_user-x_group.sql
fa9bd1af9
security-admin/db/oracle/patches/043-add-role-version-in-serviceVersionInfo.sql
security-admin/db/oracle/patches/044-add-displayName-col-in-x_service_def_and_x_service.sql
0d634c66d
security-admin/db/oracle/patches/045-add-otherAttributes-col-in-x_user-x_portal_user-x_group.sql
01ad18790
security-admin/db/postgres/patches/043-add-role-version-in-serviceVersionInfo.sql
4801ec334
security-admin/db/postgres/patches/044-add-displayName-col-in-x_service_def_and_x_service.sql
2f316853f
security-admin/db/postgres/patches/045-add-otherAttributes-col-in-x_user-x_portal_user-x_group.sql
49628911f
security-admin/db/sqlanywhere/patches/043-add-role-version-in-serviceVersionInfo.sql
security-admin/db/sqlanywhere/patches/044-add-displayName-col-in-x_service_def_and_x_service.sql
76bb78083
security-admin/db/sqlanywhere/patches/045-add-otherAttributes-col-in-x_user-x_portal_user-x_group.sql
a70bf9db9
security-admin/db/sqlserver/patches/042-add-role-version-in-serviceVersionInfo.sql
4f9b3790a
security-admin/db/sqlserver/patches/044-add-displayName-col-in-x_service_def_and_x_service.sql
2d47927a6
security-admin/db/sqlserver/patches/045-add-otherAttributes-col-in-x_user-x_portal_user-x_group.sql
6bd0ff99b
Diff: https://reviews.apache.org/r/71757/diff/3/
Changes: https://reviews.apache.org/r/71757/diff/2-3/
Testing
-------
Verified fresh install.
Also varified upgrade scenario
Thanks,
Kishor Gollapalliwar
