[
https://issues.apache.org/jira/browse/AMBARI-25198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhiguo Wu updated AMBARI-25198:
-------------------------------
Fix Version/s: 2.8.0
> 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: Papirkovskyy Myroslav
> Assignee: Papirkovskyy Myroslav
> Priority: Major
> Labels: pull-request-available
> Fix For: 2.8.0, 2.7.4
>
> Time Spent: 2h
> 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
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@ambari.apache.org
For additional commands, e-mail: issues-h...@ambari.apache.org
