Bug 1335750

Summary: Upgrade [sat618 -> 6.2 snap11.0] failed at step migrate_foreman with error: relation "katello_content_facets" does not exist
Product: Red Hat Satellite Reporter: Sachin Ghai <sghai>
Component: UpgradesAssignee: satellite6-bugs <satellite6-bugs>
Status: CLOSED DUPLICATE QA Contact: Katello QA List <katello-qa-list>
Severity: high Docs Contact:
Priority: unspecified    
Version: 6.2.0CC: bbuckingham, lpramuk
Target Milestone: Unspecified   
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-05-16 12:39:21 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: 1335807    
Attachments:
Description Flags
foreman-debug logs none

Description Sachin Ghai 2016-05-13 07:23:39 UTC 
Description of problem:
I was trying to upgrade from [sat618 -> 6.2 snap11.0] and upgrade failed with error:

~]# satellite-installer --scenario satellite --upgrade --force
Upgrading...
Upgrade Step: stop_services...
Upgrade Step: start_databases...
Upgrade Step: update_http_conf...
Upgrade Step: migrate_pulp...
Upgrade Step: start_httpd...
Upgrade Step: migrate_candlepin...
Upgrade Step: migrate_foreman...
Upgrade step migrate_foreman failed. Check logs for more information.


/var/log/foreman-installer/satellite.log:
=======================================

[ERROR 2016-05-13 02:47:47 main] /opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.0.0.28/config/routes/overrides.rb:3: warning: already initialized constant Katello::WhitelistConstraint::PATHS
PG::Error: ERROR:  relation "katello_content_facets" does not exist
ActiveRecord::StatementInvalid: PG::Error: ERROR:  relation "katello_content_facets" does not exist
PG::Error: ERROR:  relation "katello_content_facets" does not exist
[ERROR 2016-05-13 02:47:47 main] Upgrade step migrate_foreman failed. Check logs for more information.
[ERROR 2016-05-13 02:47:47 main] Errors encountered during run:
[ERROR 2016-05-13 02:47:47 main] /opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.0.0.28/config/routes/overrides.rb:3: warning: already initialized constant Katello::WhitelistConstraint::PATHS
PG::Error: ERROR:  relation "katello_content_facets" does not exist
ActiveRecord::StatementInvalid: PG::Error: ERROR:  relation "katello_content_facets" does not exist
PG::Error: ERROR:  relation "katello_content_facets" does not exist
[ERROR 2016-05-13 02:47:47 main] Upgrade step migrate_foreman failed. Check logs for more information.
[

Version-Release number of selected component (if applicable):
Upgrade [sat618 -> 6.2 snap11.0]

How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:
PG::Error: ERROR:  relation "katello_content_facets" does not exist
[ERROR 2016-05-13 02:47:47 main] Upgrade step migrate_foreman failed. Check logs for more information.
[

Expected results:


Additional info:
Comment 2 Sachin Ghai 2016-05-13 09:13:05 UTC 
Created attachment 1157051 [details]
foreman-debug logs
Comment 3 Lukas Pramuk 2016-05-16 09:38:20 UTC 
RHEL6 Upgrades fails the same way

[ INFO 2016-05-15 10:14:53 main] Upgrade Step: migrate_foreman...
[ERROR 2016-05-15 10:15:05 main] /opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.0.0.28/config/routes/overrides.rb:3: warning: already initialized constant Katello::Whi
telistConstraint::PATHS
/opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.0.0.28/config/routes/overrides.rb:3: warning: previous definition of PATHS was here
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:

PG::Error: ERROR:  relation "katello_content_facets" does not exist
LINE 5:                WHERE a.attrelid = '"katello_content_facets"'...
                                          ^
:               SELECT a.attname, format_type(a.atttypid, a.atttypmod),
                     pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
                FROM pg_attribute a LEFT JOIN pg_attrdef d
                  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
               WHERE a.attrelid = '"katello_content_facets"'::regclass
                 AND a.attnum > 0 AND NOT a.attisdropped
               ORDER BY a.attnum
Comment 4 Brad Buckingham 2016-05-16 12:39:21 UTC 

*** This bug has been marked as a duplicate of bug 1334961 ***