-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/71757/
-----------------------------------------------------------
Review request for ranger, Ankita Sinha, Gautam Borad, Abhay Kulkarni, Madhan
Neethiraj, Mehul Parikh, Pradeep Agrawal, Ramesh Mani, and Velmurugan Periasamy.
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
-----
security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql 2bbce2dec
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
security-admin/db/mysql/patches/045-add-otherAttributes-col-in-x_user-x_portal_user-x_group.sql
security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql
8587a0b91
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
security-admin/db/oracle/patches/045-add-otherAttributes-col-in-x_user-x_portal_user-x_group.sql
security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql
f2d1512e8
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
security-admin/db/postgres/patches/045-add-otherAttributes-col-in-x_user-x_portal_user-x_group.sql
security-admin/db/sqlanywhere/optimized/current/ranger_core_db_sqlanywhere.sql
0c17eb9fd
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
security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql
d04911022
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
security-admin/src/main/java/org/apache/ranger/patch/PatchForHiveServiceDefUpdate_J10027.java
a54d69eb0
Diff: https://reviews.apache.org/r/71757/diff/1/
Testing
-------
Verified fresh install.
Also varified upgrade scenario
Thanks,
Kishor Gollapalliwar
