[
https://issues.apache.org/jira/browse/RANGER-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mehul Parikh updated RANGER-2641:
---------------------------------
Attachment: RANGER-2641.patch
> 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
> Priority: Major
> Fix For: 2.1.0
>
> Attachments: RANGER-2641.patch
>
>
> 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)
