ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AMBARI-8082) 1.6.0 -> 1.7.0 upgrade with mysql shows exceptions
Date Fri, 31 Oct 2014 21:52:35 GMT

    [ https://issues.apache.org/jira/browse/AMBARI-8082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14192567#comment-14192567
] 

Hudson commented on AMBARI-8082:
--------------------------------

SUCCESS: Integrated in Ambari-branch-1.7.0 #277 (See [https://builds.apache.org/job/Ambari-branch-1.7.0/277/])
AMBARI-8082. 1.6.0 -> 1.7.0 upgrade with mysql shows exceptions. (swagle) (swagle: http://git-wip-us.apache.org/repos/asf?p=ambari.git&a=commit&h=240c9f69c701a1a573c416477b5df925d08c2845)
* ambari-server/src/main/java/org/apache/ambari/server/orm/DBAccessorImpl.java


> 1.6.0 -> 1.7.0 upgrade with mysql shows exceptions
> --------------------------------------------------
>
>                 Key: AMBARI-8082
>                 URL: https://issues.apache.org/jira/browse/AMBARI-8082
>             Project: Ambari
>          Issue Type: Task
>          Components: ambari-server
>    Affects Versions: 1.7.0
>            Reporter: Siddharth Wagle
>            Assignee: Siddharth Wagle
>             Fix For: 1.7.0
>
>         Attachments: AMBARI-8082_branch-1.7.0.patch
>
>
> ambari 1.6.0 with mysql as ambari db
> upgrade to 1.7.0
> Says upgrade completed. There are exceptions in log:
> {code}
> 12:35:02,807  WARN [main] DBAccessorImpl:535 - Error executing query: ALTER TABLE confgroupclusterconfigmapping
ADD CONSTRAINT FK_confg FOREIGN KEY (cluster_id, config_type, version_tag) REFERENCES clusterconfig
(cluster_id, type_name, version_tag)
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate key name 'FK_confg'
> 	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.addFKConstraint(DBAccessorImpl.java:353)
> 	at org.apache.ambari.server.upgrade.UpgradeCatalog170.executeDDLUpdates(UpgradeCatalog170.java:413)
> 	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:35:02,813  WARN [main] DBAccessorImpl:355 - Add FK constraint failed, constraintName
= FK_confg, tableName = confgroupclusterconfigmapping
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate key name 'FK_confg'
> 	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.addFKConstraint(DBAccessorImpl.java:353)
> 	at org.apache.ambari.server.upgrade.UpgradeCatalog170.executeDDLUpdates(UpgradeCatalog170.java:413)
> 	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:35:02,862  INFO [main] DBAccessorImpl:529 - Executing query: ALTER TABLE serviceconfighosts
ADD CONSTRAINT FK_scvhosts_scv FOREIGN KEY (service_config_id) REFERENCES serviceconfig (service_config_id)
> 12:35:02,869  INFO [mai
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message