----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/71757/#review218611 -----------------------------------------------------------
Ship it! Ship It! - Velmurugan Periasamy On Nov. 12, 2019, 2:10 p.m., Kishor Gollapalliwar wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/71757/ > ----------------------------------------------------------- > > (Updated Nov. 12, 2019, 2:10 p.m.) > > > 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 > >
