Bug 1558626 - PG::InvalidTableDefinition: ERROR: cannot alter inherited column "resource_type
Summary: PG::InvalidTableDefinition: ERROR: cannot alter inherited column "resource_type
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat CloudForms Management Engine
Classification: Red Hat
Component: Appliance
Version: 5.9.0
Hardware: Unspecified
OS: Unspecified
unspecified
low
Target Milestone: GA
: 5.9.2
Assignee: Gregg Tanzillo
QA Contact: luke couzens
URL:
Whiteboard:
Depends On: 1558617
Blocks:
TreeView+ depends on / blocked
 
Reported: 2018-03-20 16:03 UTC by Satoe Imaishi
Modified: 2022-07-09 09:34 UTC (History)
9 users (show)

Fixed In Version: 5.9.2.0
Doc Type: If docs needed, set a value
Doc Text:
Clone Of: 1558617
Environment:
Last Closed: 2018-05-07 20:46:50 UTC
Category: ---
Cloudforms Team: ---
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHSA-2018:1328 0 None None None 2018-05-07 20:47:44 UTC

Comment 2 CFME Bot 2018-03-20 16:03:59 UTC
New commit detected on ManageIQ/manageiq-schema/gaprindashvili:

https://github.com/ManageIQ/manageiq-schema/commit/73f1f7633ae4ffa726c1fceec92c42465500429a
commit 73f1f7633ae4ffa726c1fceec92c42465500429a
Author:     Jason Frey <fryguy9>
AuthorDate: Fri Mar 16 12:04:36 2018 -0400
Commit:     Jason Frey <fryguy9>
CommitDate: Fri Mar 16 12:04:36 2018 -0400

    Merge pull request #179 from carbonin/sort_tables_before_removing_limits

    Remove the limits from the tables in sorted order
    (cherry picked from commit 565c01f3b9282952bb4e6d38316222dbed5ee77f)

    Fixes https://bugzilla.redhat.com/show_bug.cgi?id=1558626

 db/migrate/20171109225052_remove_string_column_limits.rb | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

Comment 4 luke couzens 2018-05-03 20:44:07 UTC
So I tested this against a fresh 5.6 appliance and migration was successful so I would guess there is another issue with the customer db backup.

Comment 5 Gregg Tanzillo 2018-05-03 22:01:39 UTC
Jason, can you take a look at this? It looks like the TimeProfile.default method in the migration is returning nil - https://github.com/gtanzillo/manageiq-schema/blob/4e927e1e1263320480c26b48d2f667232b2b0aaa/db/migrate/20170207215322_fix_vpor_time_profile_ids.rb#L40

Seems like that should never happen if there are actually VimPerformanceOperatingRange instances in the DB

Comment 8 errata-xmlrpc 2018-05-07 20:46:50 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHSA-2018:1328


Note You need to log in before you can comment on or make changes to this bug.