[
https://issues.apache.org/jira/browse/AMBARI-25198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16797330#comment-16797330
]
Hudson commented on AMBARI-25198:
---------------------------------
SUCCESS: Integrated in Jenkins build Ambari-branch-2.7 #456 (See
[https://builds.apache.org/job/Ambari-branch-2.7/456/])
AMBARI-25198. MYSQL connector exception while upgrading ambari to (github:
[https://gitbox.apache.org/repos/asf?p=ambari.git&a=commit&h=ed80f7add8a4cc02192671647d7cda2c8f938797])
* (edit)
ambari-server/src/main/java/org/apache/ambari/server/orm/DBAccessorImpl.java
> MYSQL connector exception while upgrading ambari to ambari-2.7.3
> ----------------------------------------------------------------
>
> Key: AMBARI-25198
> URL: https://issues.apache.org/jira/browse/AMBARI-25198
> Project: Ambari
> Issue Type: Bug
> Components: ambari-server
> Affects Versions: 2.7.3
> Reporter: Myroslav Papirkovskyi
> Assignee: Myroslav Papirkovskyi
> Priority: Major
> Labels: pull-request-available
> Fix For: 2.7.4
>
> Time Spent: 1h 20m
> Remaining Estimate: 0h
>
> h2. Description
> Problem statement : ambari-server upgrade command is failing with below
> exception in ambari-server.log If using mysqlconnector-8.0.1.x.jar
> {code:java}
> 2018-12-28 13:59:07,062 INFO [main] DBAccessorImpl:869 - Executing query:
> CREATE TABLE ambari_configuration (category_name VARCHAR(100) NOT NULL,
> property_name VARCHAR(100) NOT NULL, property_value VARCHAR(2048))
> ENGINE=INNODB
> 2018-12-28 13:59:07,087 ERROR [main] SchemaUpgradeHelper:209 - Upgrade failed.
> java.sql.SQLSyntaxErrorException: Unknown table 'ambari_configuration' in
> information_schema
> at
> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
> at
> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
> at
> com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
> at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1218)
> at com.mysql.cj.jdbc.DatabaseMetaData$7.forEach(DatabaseMetaData.java:2965)
> at com.mysql.cj.jdbc.DatabaseMetaData$7.forEach(DatabaseMetaData.java:2953)
> at com.mysql.cj.jdbc.IterateBlock.doForAll(IterateBlock.java:56)
> at
> com.mysql.cj.jdbc.DatabaseMetaData.getPrimaryKeys(DatabaseMetaData.java:3006)
> at
> org.apache.ambari.server.orm.DBAccessorImpl.tableHasPrimaryKey(DBAccessorImpl.java:1086)
> at
> org.apache.ambari.server.orm.DBAccessorImpl.addPKConstraint(DBAccessorImpl.java:577)
> at
> org.apache.ambari.server.orm.DBAccessorImpl.addPKConstraint(DBAccessorImpl.java:588)
> at
> org.apache.ambari.server.upgrade.UpgradeCatalog270.addAmbariConfigurationTable(UpgradeCatalog270.java:989)
> at
> org.apache.ambari.server.upgrade.UpgradeCatalog270.executeDDLUpdates(UpgradeCatalog270.java:319)
> at
> org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:970)
> at
> org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:207)
> at
> org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:450)
> 2018-12-28 13:59:07,093 ERROR [main] SchemaUpgradeHelper:475 - Exception
> occurred during upgrade, failed
> org.apache.ambari.server.AmbariException: Unknown table
> 'ambari_configuration' in information_schema
> at
> org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:210)
> at
> org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:450)
> Caused by: java.sql.SQLSyntaxErrorException: Unknown table
> 'ambari_configuration' in information_schema
> at
> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
> at
> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
> at
> com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
> {code}
> Supportmatrix says ambari supports mysql-5.7 version. but its not mentioning
> anything about connector jar or connector.jar version.
> Currently there is this exception in Ambari upgrade is mysqlConnector jar
> version is 8.0.15 .
> If ambari doesnt support mysqlConnector.jar version 8.x this should be
> documented in hortonworks docs and also in supportmatrix website.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
