Bug 1558617
| Summary: | PG::InvalidTableDefinition: ERROR: cannot alter inherited column "resource_type | |||
|---|---|---|---|---|
| Product: | Red Hat CloudForms Management Engine | Reporter: | Jared Deubel <jdeubel> | |
| Component: | Appliance | Assignee: | Gregg Tanzillo <gtanzill> | |
| Status: | CLOSED NEXTRELEASE | QA Contact: | Dave Johnson <dajohnso> | |
| Severity: | low | Docs Contact: | ||
| Priority: | unspecified | |||
| Version: | 5.9.0 | CC: | abellott, fdewaley, obarenbo, simaishi | |
| Target Milestone: | GA | Keywords: | TestOnly, ZStream | |
| Target Release: | 5.10.0 | |||
| Hardware: | Unspecified | |||
| OS: | Unspecified | |||
| Whiteboard: | ||||
| Fixed In Version: | 5.10.0.0 | Doc Type: | If docs needed, set a value | |
| Doc Text: | Story Points: | --- | ||
| Clone Of: | ||||
| : | 1558626 (view as bug list) | Environment: | ||
| Last Closed: | 2018-08-20 14:26:39 UTC | Type: | Bug | |
| 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: | ||||
| Bug Blocks: | 1558626 | |||
Description of problem: Brand new 4.6 appliance that was configured to join an existing region. When running rake db:migrate we get the following error: -- change_column("metric_rollups_01", "resource_type", :string, {:limit=>nil}) rake aborted! StandardError: An error has occurred, this and all later migrations canceled: PG::InvalidTableDefinition: ERROR: cannot alter inherited column "resource_type" : ALTER TABLE "metric_rollups_01" ALTER COLUMN "resource_type" TYPE character varying /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/database_statements.rb:98:in `async_exec' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/database_statements.rb:98:in `block in execute' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract_adapter.rb:590:in `block in log' /opt/rh/cfme-gemset/gems/activesupport-5.0.6/lib/active_support/notifications/instrumenter.rb:21:in `instrument' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract_adapter.rb:583:in `log' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/database_statements.rb:97:in `execute' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/schema_statements.rb:504:in `change_column' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/migration.rb:846:in `block in method_missing' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/migration.rb:815:in `block in say_with_time' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/migration.rb:815:in `say_with_time' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/migration.rb:835:in `method_missing' /opt/rh/cfme-gemset/bundler/gems/manageiq-schema-684c1d234a55/db/migrate/20171109225052_remove_string_column_limits.rb:6:in `block (2 levels) in up' /opt/rh/cfme-gemset/bundler/gems/manageiq-schema-684c1d234a55/db/migrate/20171109225052_remove_string_column_limits.rb:4:in `each' /opt/rh/cfme-gemset/bundler/gems/manageiq-schema-684c1d234a55/db/migrate/20171109225052_remove_string_column_limits.rb:4:in `block in up' /opt/rh/cfme-gemset/bundler/gems/manageiq-schema-684c1d234a55/db/migrate/20171109225052_remove_string_column_limits.rb:3:in `each' /opt/rh/cfme-gemset/bundler/gems/manageiq-schema-684c1d234a55/db/migrate/20171109225052_remove_string_column_limits.rb:3:in `up' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/migration.rb:792:in `exec_migration' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/migration.rb:773:in `block (2 levels) in migrate' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/migration.rb:772:in `block in migrate' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:398:in `with_connection' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/migration.rb:771:in `migrate' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/migration.rb:951:in `migrate' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/migration.rb:1232:in `block in execute_migration_in_transaction' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/migration.rb:1300:in `block in ddl_transaction' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/database_statements.rb:232:in `block in transaction' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/transaction.rb:189:in `within_new_transaction' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/database_statements.rb:232:in `transaction' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/transactions.rb:211:in `transaction' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/migration.rb:1300:in `ddl_transaction' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/migration.rb:1231:in `execute_migration_in_transaction' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/migration.rb:1203:in `block in migrate_without_lock' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/migration.rb:1202:in `each' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/migration.rb:1202:in `migrate_without_lock' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/migration.rb:1150:in `block in migrate' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/migration.rb:1319:in `with_advisory_lock' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/migration.rb:1150:in `migrate' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/migration.rb:1006:in `up' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/migration.rb:984:in `migrate' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/tasks/database_tasks.rb:163:in `migrate' /opt/rh/cfme-gemset/gems/activerecord-5.0.6/lib/active_record/railties/databases.rake:58:in `block (2 levels) in <top (required)>' /opt/rh/cfme-gemset/gems/rake-12.3.0/exe/rake:27:in `<top (required)>' Version-Release number of selected component (if applicable): 5.9