You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2014/10/31 22:52:35 UTC
[jira] [Commented] (AMBARI-8079) 1.5.1 -> 1.7.0 upgrade fails with
mysql DB
[ https://issues.apache.org/jira/browse/AMBARI-8079?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14192566#comment-14192566 ]
Hudson commented on AMBARI-8079:
--------------------------------
SUCCESS: Integrated in Ambari-branch-1.7.0 #277 (See [https://builds.apache.org/job/Ambari-branch-1.7.0/277/])
AMBARI-8079. 1.5.1 -> 1.7.0 upgrade fails with mysql DB. (Myroslav Papirkovskyy via swagle) (swagle: http://git-wip-us.apache.org/repos/asf?p=ambari.git&a=commit&h=fe30baed43c4c84dee27da39d3c37fa22cddb2b0)
* ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog160.java
> 1.5.1 -> 1.7.0 upgrade fails with mysql DB
> ------------------------------------------
>
> Key: AMBARI-8079
> URL: https://issues.apache.org/jira/browse/AMBARI-8079
> Project: Ambari
> Issue Type: Bug
> Components: ambari-server
> Affects Versions: 1.7.0
> Reporter: Myroslav Papirkovskyy
> Assignee: Myroslav Papirkovskyy
> Priority: Blocker
> Fix For: 1.7.0
>
>
> ambari 1.5.1 with mysqldb for ambari db
> upgraded to 1.70, fails with the error below
> {code}
> [root@c6402 yum.repos.d]# ambari-server upgrade
> Using python /usr/bin/python2.6
> Upgrading ambari-server
> Updating properties in ambari.properties ...
> ERROR: Error executing schema upgrade, please check the server logs.
> ERROR: Ambari server upgrade failed. Please look at /var/log/ambari-server/ambari-server.log, for more details.
> ERROR: Exiting with exit code 11.
> REASON: Schema upgrade failed.
> [root@c6402 yum.repos.d]#
> {code}
> {code}
> 12:34:42,587 WARN [main] DBAccessorImpl:535 - Error executing query: ALTER TABLE viewmain ADD icon VARCHAR(255)
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ambaridb.viewmain' doesn't exist
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> at com.mysql.jdbc.Util.getInstance(Util.java:386)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2569)
> at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:824)
> at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:667)
> at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:532)
> at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:518)
> at org.apache.ambari.server.orm.DBAccessorImpl.addColumn(DBAccessorImpl.java:384)
> at org.apache.ambari.server.upgrade.UpgradeCatalog161.executeDDLUpdates(UpgradeCatalog161.java:113)
> at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:383)
> at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:179)
> at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:239)
> 12:34:42,594 ERROR [main] SchemaUpgradeHelper:181 - Upgrade failed.
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ambaridb.viewmain' doesn't exist
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> at com.mysql.jdbc.Util.getInstance(Util.java:386)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2569)
> at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:824)
> at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:667)
> at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:532)
> at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:518)
> at org.apache.ambari.server.orm.DBAccessorImpl.addColumn(DBAccessorImpl.java:384)
> at org.apache.ambari.server.upgrade.UpgradeCatalog161.executeDDLUpdates(UpgradeCatalog161.java:113)
> at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:383)
> at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:179)
> at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:239)
> 12:34:42,596 ERROR [main] SchemaUpgradeHelper:252 - Exception occured during upgrade, failed
> org.apache.ambari.server.AmbariException: Table 'ambaridb.viewmain' doesn't exist
> at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:182)
> at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:239)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ambaridb.viewmain' doesn't exist
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> at com.mysql.jdbc.Util.getInstance(Util.java:386)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2569)
> at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:824)
> at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:667)
> at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:532)
> at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:518)
> at org.apache.ambari.server.orm.DBAccessorImpl.addColumn(DBAccessorImpl.java:384)
> at org.apache.ambari.server.upgrade.UpgradeCatalog161.executeDDLUpdates(UpgradeCatalog161.java:113)
> at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:383)
> at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:179)
> ... 1 more
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)