----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/71757/#review218644 -----------------------------------------------------------
Ship it! Ship It! - Gautam Borad On Nov. 14, 2019, 1:43 p.m., Kishor Gollapalliwar wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/71757/ > ----------------------------------------------------------- > > (Updated Nov. 14, 2019, 1:43 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/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/5/ > > > Testing > ------- > > Verified fresh install. > Also varified upgrade scenario > > > Thanks, > > Kishor Gollapalliwar > >
