Preetam Tripathi created RANGER-2641:
----------------------------------------
Summary: Upgrade scenario fails in MYSQL DB
Key: RANGER-2641
URL: https://issues.apache.org/jira/browse/RANGER-2641
Project: Ranger
Issue Type: Bug
Components: Ranger
Reporter: Preetam Tripathi
Upgrade scenario gets failed, getting below error:
{code:java}
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!
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
