Michael Lopez created AMBARI-8822:
-------------------------------------
Summary: 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)
