Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 4661C200BBB for ; Thu, 10 Nov 2016 19:04:00 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 454DB160AF7; Thu, 10 Nov 2016 18:04:00 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 90D00160B10 for ; Thu, 10 Nov 2016 19:03:59 +0100 (CET) Received: (qmail 27816 invoked by uid 500); 10 Nov 2016 18:03:58 -0000 Mailing-List: contact issues-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 issues@ambari.apache.org Received: (qmail 27791 invoked by uid 99); 10 Nov 2016 18:03:58 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 10 Nov 2016 18:03:58 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id 669BC2C4C78 for ; Thu, 10 Nov 2016 18:03:58 +0000 (UTC) Date: Thu, 10 Nov 2016 18:03:58 +0000 (UTC) From: "Hudson (JIRA)" To: issues@ambari.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (AMBARI-18640) Ambari upgrade failed while running 'Alter Table blueprint' - blueprint_name column MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Thu, 10 Nov 2016 18:04:00 -0000 [ https://issues.apache.org/jira/browse/AMBARI-18640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15654704#comment-15654704 ] Hudson commented on AMBARI-18640: --------------------------------- FAILURE: Integrated in Jenkins build Ambari-trunk-Commit #5987 (See [https://builds.apache.org/job/Ambari-trunk-Commit/5987/]) AMBARI-18640. Part2.Ambari upgrade failed while running "Alter Table (vbrodetskyi: [http://git-wip-us.apache.org/repos/asf?p=ambari.git&a=commit&h=7d1cb6ca64074ca5af34566cdc3364e213c96b0a]) * (edit) ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog242.java * (edit) ambari-server/src/test/java/org/apache/ambari/server/upgrade/UpgradeCatalog242Test.java > Ambari upgrade failed while running 'Alter Table blueprint' - blueprint_name column > ----------------------------------------------------------------------------------- > > Key: AMBARI-18640 > URL: https://issues.apache.org/jira/browse/AMBARI-18640 > Project: Ambari > Issue Type: Bug > Components: ambari-upgrade > Affects Versions: 2.4.2 > Reporter: Vitaly Brodetskyi > Assignee: Vitaly Brodetskyi > Priority: Blocker > Fix For: 2.4.2 > > Attachments: AMBARI-18640.patch, AMBARI-18640_part2.patch > > > Observed errors in today's run during Ambari upgrade from 2.2.1.1 to 2.4.2.0-36 > ambari-server --hash > c6da6776f029f15d3a7d6009697371eee4e5f4c5 > Ambari DB - MySQL; Secure HDP-2.4.0.0 cluster deployed via UI > *Upgrade Log indicates below:* > {code} > 18 Oct 2016 14:17:59,115 INFO [main] DBAccessorImpl:824 - Executing query: ALTER TABLE users MODIFY user_name VARCHAR(100) > 18 Oct 2016 14:17:59,154 INFO [main] DBAccessorImpl:824 - Executing query: ALTER TABLE users MODIFY user_name VARCHAR(100) NOT NULL > 18 Oct 2016 14:17:59,191 INFO [main] DBAccessorImpl:824 - Executing query: ALTER TABLE host_role_command MODIFY role VARCHAR(100) > 18 Oct 2016 14:17:59,428 INFO [main] DBAccessorImpl:824 - Executing query: ALTER TABLE host_role_command MODIFY status VARCHAR(100) > 18 Oct 2016 14:17:59,656 INFO [main] DBAccessorImpl:824 - Executing query: ALTER TABLE blueprint MODIFY blueprint_name VARCHAR(100) > 18 Oct 2016 14:17:59,678 ERROR [main] DBAccessorImpl:830 - Error executing query: ALTER TABLE blueprint MODIFY blueprint_name VARCHAR(100) > java.sql.SQLException: Cannot change column 'blueprint_name': used in a foreign key constraint 'FK_blueprint_setting_name' of table 'ambaricustom.blueprint_setting' > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484) > at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848) > at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742) > at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:827) > at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:819) > at org.apache.ambari.server.orm.DBAccessorImpl.alterColumn(DBAccessorImpl.java:610) > at org.apache.ambari.server.upgrade.UpgradeCatalog242.updateTablesForMysql(UpgradeCatalog242.java:120) > at org.apache.ambari.server.upgrade.UpgradeCatalog242.executeDDLUpdates(UpgradeCatalog242.java:95) > at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:889) > at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:206) > at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:349) > 18 Oct 2016 14:17:59,680 ERROR [main] SchemaUpgradeHelper:208 - Upgrade failed. > java.sql.SQLException: Cannot change column 'blueprint_name': used in a foreign key constraint 'FK_blueprint_setting_name' of table 'ambaricustom.blueprint_setting' > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484) > at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)