You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by "Velmurugan Periasamy (Jira)" <ji...@apache.org> on 2019/11/14 12:53:00 UTC
[jira] [Updated] (RANGER-2641) Upgrade scenario fails in MYSQL DB
[ https://issues.apache.org/jira/browse/RANGER-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Velmurugan Periasamy updated RANGER-2641:
-----------------------------------------
Fix Version/s: 2.1.0
> 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
>
>
> 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)