Return-Path: X-Original-To: apmail-ambari-dev-archive@www.apache.org Delivered-To: apmail-ambari-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 8EAD017A30 for ; Fri, 31 Oct 2014 21:55:34 +0000 (UTC) Received: (qmail 5216 invoked by uid 500); 31 Oct 2014 21:55:34 -0000 Delivered-To: apmail-ambari-dev-archive@ambari.apache.org Received: (qmail 5178 invoked by uid 500); 31 Oct 2014 21:55:34 -0000 Mailing-List: contact dev-help@ambari.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ambari.apache.org Delivered-To: mailing list dev@ambari.apache.org Received: (qmail 5166 invoked by uid 99); 31 Oct 2014 21:55:34 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 31 Oct 2014 21:55:34 +0000 Date: Fri, 31 Oct 2014 21:55:34 +0000 (UTC) From: "Hudson (JIRA)" To: dev@ambari.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (AMBARI-8079) 1.5.1 -> 1.7.0 upgrade fails with mysql DB MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/AMBARI-8079?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14192569#comment-14192569 ] Hudson commented on AMBARI-8079: -------------------------------- SUCCESS: Integrated in Ambari-trunk-Commit #780 (See [https://builds.apache.org/job/Ambari-trunk-Commit/780/]) 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=87956856bb371bd61d9e154e554352486dba38ba) * 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)