Red Hat Satellite engineering is moving the tracking of its product development work on Satellite to Red Hat Jira (issues.redhat.com). If you're a Red Hat customer, please continue to file support cases via the Red Hat customer portal. If you're not, please head to the "Satellite project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs will be migrated starting at the end of May. If you cannot log in to RH Jira, please consult article #7032570. That failing, please send an e-mail to the RH Jira admins at rh-issues@redhat.com to troubleshoot your issue as a user management inquiry. The email creates a ServiceNow ticket with Red Hat. Individual Bugzilla bugs that are migrated will be moved to status "CLOSED", resolution "MIGRATED", and set with "MigratedToJIRA" in "Keywords". The link to the successor Jira issue will be found under "Links", have a little "two-footprint" icon next to it, and direct you to the "Satellite project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/SAT-XXXX", where "X" is a digit). This same link will be available in a blue banner at the top of the page informing you that that bug has been migrated.
Bug 1335750 - Upgrade [sat618 -> 6.2 snap11.0] failed at step migrate_foreman with error: relation "katello_content_facets" does not exist
Summary: Upgrade [sat618 -> 6.2 snap11.0] failed at step migrate_foreman with error: r...
Keywords:
Status: CLOSED DUPLICATE of bug 1334961
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Upgrades
Version: 6.2.0
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: Unspecified
Assignee: satellite6-bugs
QA Contact: Katello QA List
URL:
Whiteboard:
Depends On:
Blocks: 1335807
TreeView+ depends on / blocked
 
Reported: 2016-05-13 07:23 UTC by Sachin Ghai
Modified: 2019-04-01 20:27 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-05-16 12:39:21 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)
foreman-debug logs (388.03 KB, application/x-xz)
2016-05-13 09:13 UTC, Sachin Ghai
no flags Details

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 ***


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