[AMBARI-22544] Upgrade from Ambari 2.5.2 to 2.6.0 fails

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 2.6.1
• Fix Version/s: 2.6.1
• Component/s: ambari-server
• Assignee: Papirkovskyy Myroslav
• Reporter: Papirkovskyy Myroslav
• Created: 29/Nov/17 14:14
• Updated: 30/Nov/17 21:20
• Resolved: 30/Nov/17 20:38

Description

When upgrading from Ambari 2.5.2 to Ambari 2.6.0, we hit this error preventing from completing the ambari-server upgrade.

20 Nov 2017 11:39:08,115 ERROR [main] SchemaUpgradeHelper:202 - Upgrade failed.
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`ambari_01`.`clusters`, CONSTRAINT `FK_clusters_upgrade_id` FOREIGN KEY (`upgrade_id`) REFERENCES `upgrade` (`upgrade_id`))

To get around this, he had to restore the db backup from 2.5.3 and adjust a table in mysql with ‘update clusters set upgrade_id = null’ so a record in the ‘upgrades’ table could be removed.

Issue Links

• links to: reviewboard