Bug 1558626

Summary:	PG::InvalidTableDefinition: ERROR: cannot alter inherited column "resource_type
Product:	Red Hat CloudForms Management Engine	Reporter:	Satoe Imaishi <simaishi>
Component:	Appliance	Assignee:	Gregg Tanzillo <gtanzill>
Status:	CLOSED ERRATA	QA Contact:	luke couzens <lcouzens>
Severity:	low	Docs Contact:
Priority:	unspecified
Version:	5.9.0	CC:	abellott, fdewaley, gtanzill, jfrey, jkrocil, lcouzens, obarenbo, psavage, simaishi
Target Milestone:	GA	Keywords:	ZStream
Target Release:	5.9.2
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	5.9.2.0	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:	1558617	Environment:
Last Closed:	2018-05-07 20:46:50 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:	1558617
Bug Blocks:

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