You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by "Michael Lopez (JIRA)" <ji...@apache.org> on 2014/12/23 15:32:13 UTC
[jira] [Resolved] (AMBARI-8822) ambari-server upgrade Fail
[ https://issues.apache.org/jira/browse/AMBARI-8822?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michael Lopez resolved AMBARI-8822.
-----------------------------------
Resolution: Later
Issue resolved by convert clusters table to InnoDB engine.
Add constraint with both MyISAM and InnoDB table doesn't work
Please update the upgrade script/process !
Regards.
> ambari-server upgrade Fail
> --------------------------
>
> Key: AMBARI-8822
> URL: https://issues.apache.org/jira/browse/AMBARI-8822
> Project: Ambari
> Issue Type: Bug
> Components: ambari-server
> Affects Versions: 1.7.0
> Environment: Centos 6, Mysql 5.6.22
> Reporter: Michael Lopez
>
> Hi,
> I've an error when I try to execute *ambari-server upgrade*
> It try to make this SQL query but the column "value" does not exists:
> 16:26:56,630 INFO [main] Configuration:411 - Reading password from existing file
> 16:26:56,647 INFO [main] Configuration:622 - Hosts Mapping File null
> 16:26:56,647 INFO [main] HostsMap:60 - Using hostsmap file null
> 16:27:00,925 INFO [main] SchemaUpgradeHelper:225 - Upgrading schema to target version = 1.7.0
> 16:27:00,938 INFO [main] SchemaUpgradeHelper:234 - Upgrading schema from source version = 1.6.1
> 16:27:00,944 INFO [main] SchemaUpgradeHelper:142 - Upgrade path: [{ ugradeCatalog: sourceVersion = 1.6.1, targetVersion = 1.7.0 }]
> 16:27:00,945 INFO [main] SchemaUpgradeHelper:174 - Executing DDL upgrade...
> 16:27:00,949 INFO [main] DBAccessorImpl:529 - Executing query: ALTER TABLE ambari_sequences CHANGE value sequence_value DECIMAL(38) NOT NULL
> 16:27:00,967 ERROR [main] DBAccessorImpl:535 - Error executing query: ALTER TABLE ambari_sequences CHANGE value sequence_value DECIMAL(38) NOT NULL
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'value' in 'ambari_sequences'
> 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.upgrade.UpgradeCatalog170.renameSequenceValueColumnName(UpgradeCatalog170.java:499)
> at org.apache.ambari.server.upgrade.UpgradeCatalog170.executeDDLUpdates(UpgradeCatalog170.java:165)
> 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)
> 16:27:00,975 ERROR [main] SchemaUpgradeHelper:181 - Upgrade failed.
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'value' in 'ambari_sequences'
> 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.upgrade.UpgradeCatalog170.renameSequenceValueColumnName(UpgradeCatalog170.java:499)
> at org.apache.ambari.server.upgrade.UpgradeCatalog170.executeDDLUpdates(UpgradeCatalog170.java:165)
> 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)
> 16:27:00,976 ERROR [main] SchemaUpgradeHelper:252 - Exception occured during upgrade, failed
> org.apache.ambari.server.AmbariException: Unknown column 'value' in 'ambari_sequences'
> 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: Unknown column 'value' in 'ambari_sequences'
> 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.upgrade.UpgradeCatalog170.renameSequenceValueColumnName(UpgradeCatalog170.java:499)
> at org.apache.ambari.server.upgrade.UpgradeCatalog170.executeDDLUpdates(UpgradeCatalog170.java:165)
> at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:383)
> at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:179)
> ... 1 more
> Regards.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)