Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

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

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:

Upgrades

Assignee:

satellite6-bugs <satellite6-bugs>

Status:

CLOSED DUPLICATE

QA Contact:

Katello QA List <katello-qa-list>

Severity:

high

Docs Contact:

Priority:

unspecified

Version:

6.2.0

CC:

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