[
https://issues.apache.org/jira/browse/AMBARI-8822?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14253671#comment-14253671
]
Michael Lopez commented on AMBARI-8822:
---------------------------------------
I've change sequence_value to value to pass this step but after that it try to
insert data on some tables like an install instead of an upgrade.
Then it failed to these queries now :
18:07:31,245 ERROR [main] DBAccessorImpl:535 - Error executing query: ALTER
TABLE alert_definition ADD CONSTRAINT fk_alert_def_cluster_id FOREIGN KEY
(cluster_id) REFERENCES clusters (cluster_id)
java.sql.SQLException: Cannot add foreign key constraint
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
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.addFKConstraint(DBAccessorImpl.java:353)
at
org.apache.ambari.server.orm.DBAccessorImpl.addFKConstraint(DBAccessorImpl.java:337)
at
org.apache.ambari.server.upgrade.UpgradeCatalog170.addAlertingFrameworkDDL(UpgradeCatalog170.java:892)
at
org.apache.ambari.server.upgrade.UpgradeCatalog170.executeDDLUpdates(UpgradeCatalog170.java:295)
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)
18:07:31,248 WARN [main] DBAccessorImpl:355 - Add FK constraint failed,
constraintName = fk_alert_def_cluster_id, tableName = alert_definition
18:07:31,248 ERROR [main] SchemaUpgradeHelper:181 - Upgrade failed.
java.sql.SQLException: Cannot add foreign key constraint
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
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.addFKConstraint(DBAccessorImpl.java:353)
at
org.apache.ambari.server.orm.DBAccessorImpl.addFKConstraint(DBAccessorImpl.java:337)
at
org.apache.ambari.server.upgrade.UpgradeCatalog170.addAlertingFrameworkDDL(UpgradeCatalog170.java:892)
at
org.apache.ambari.server.upgrade.UpgradeCatalog170.executeDDLUpdates(UpgradeCatalog170.java:295)
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)
18:07:31,251 ERROR [main] SchemaUpgradeHelper:252 - Exception occured during
upgrade, failed
org.apache.ambari.server.AmbariException: Cannot add foreign key constraint
at
org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:182)
at
org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:239)
Caused by: java.sql.SQLException: Cannot add foreign key constraint
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
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.addFKConstraint(DBAccessorImpl.java:353)
at
org.apache.ambari.server.orm.DBAccessorImpl.addFKConstraint(DBAccessorImpl.java:337)
at
org.apache.ambari.server.upgrade.UpgradeCatalog170.addAlertingFrameworkDDL(UpgradeCatalog170.java:892)
at
org.apache.ambari.server.upgrade.UpgradeCatalog170.executeDDLUpdates(UpgradeCatalog170.java:295)
at
org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:383)
at
org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:179)
... 1 more
> 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)
