question "Upgrade" table missing from Ambari database in Archives of Support Questions (Read Only)

"Upgrade" table missing from Ambari database

bcobb — Thu, 07 Apr 2016 01:01:00 GMT

Hello- I the process of upgrading Ambari to 2.2.1.1 I hit the following error after $ ambari-server upgrade:

06 Apr 2016 13:22:52,129 ERROR [main] SchemaUpgradeHelper:315 - Exception occurred during upgrade, failed
org.apache.ambari.server.AmbariException: Errors found while populating the upgrade table with values for columns upgrade_type and upgrade_package.
at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executePreDMLUpdates(SchemaUpgradeHelper.java:215)
at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:302)
Caused by: org.apache.ambari.server.AmbariException: Errors found while populating the upgrade table with values for columns upgrade_type and upgrade_package.

Took a look at my (external) Postgres database and found the ambari database does not have an "upgrade" table. I checked another cluster with a similar external Postgres instance and it does have that table.

Should I create the table manually? If so, anyone have the appropriate create statement for the table? If there's a more ambari-friendly way get the tables straight, that would be preferable. Thanks.

Re: "Upgrade" table missing from Ambari database

jluniya — Thu, 07 Apr 2016 01:03:00 GMT

@Brenden Cobb

From what ambari version are you upgrading?

Re: "Upgrade" table missing from Ambari database

bcobb — Thu, 07 Apr 2016 01:07:05 GMT

Ambari 2.1.2.1

Re: "Upgrade" table missing from Ambari database

afernandez — Thu, 07 Apr 2016 01:14:44 GMT

This is happening during the upgrade to Ambari 2.2.0 https://github.com/apache/ambari/blob/release-2.2.1-rc2/ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog220.java#L508-L598

What is the output of running,

SELECT upgrade_id, cluster_id, from_version, to_version, direction, upgrade_package, upgrade_type FROM upgrade;

Basically, you have to populate the upgrade_type and upgrade_pack columns based on the versions used.

Re: "Upgrade" table missing from Ambari database

bcobb — Thu, 07 Apr 2016 01:31:20 GMT

Thanks, but since I don't have an "upgrade" table I can't run a select.

Re: "Upgrade" table missing from Ambari database

jluniya — Fri, 08 Apr 2016 04:09:00 GMT

I believe, the failure seems to be caused while setting "upgrade_package" column for existing entries in the upgrade DB because there is no repo_version DB entry that matches with the from_version entry for a DOWNGRADE entry in the upgrade table.

However, I do believe the upgrade DB table should exist as it also existed in 2.1.2.1 and we dont delete the table. You can check your DB dump before the upgrade to verify if the table existed

Re: "Upgrade" table missing from Ambari database

afernandez — Fri, 08 Apr 2016 06:14:00 GMT

This happened because a record may be missing in the repo_version table. If you insert the record before performing the Ambari Upgrade it should work. You can make sure you have a record for each one of the versions.

SELECT from_version, to_version FROM upgrade;

-- Assuming 2.2.0.0-2041 is missing
INSERT INTO repo_version (repo_version_id, version, display_name, upgrade_package, repositories, stack_id) VALUES (1, '2.2.0.0-2041', 'HDP-2.2.0.0-2041', 'upgrade-2.2', '', (SELECT stack_id FROM stack WHERE stack_version = '2.2'));

Re: "Upgrade" table missing from Ambari database

bcobb — Tue, 12 Apr 2016 01:16:37 GMT

Accepting @Alejandro Fernandez 's answer as this is what we essentially did, but I definitely recommend treading cautiously and of course backup your database before making changes. This does appear to be a bug.