Project

General

Profile

Bug #27401

Foreman-debug katello_repositories SQL query no longer works

Added by Lukas Zapletal 3 months ago. Updated about 2 months ago.

Status:
Closed
Priority:
Normal
Category:
foreman-debug
Target version:
Difficulty:
Triaged:
Yes
Bugzilla link:
Fixed in Releases:
Found in Releases:

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1725244

Description of problem:

Foreman-debug collecting repos data through below command and displays that output in katello_repositories file.

  1. echo "select id, name, checksum_type, updated_at from katello_repositories" | su postgres -c 'psql foreman'

But this command does not work in satellite 6.5

Version-Release number of selected component (if applicable):
satellite-6.5.0-11.el7sat.noarch

How reproducible:

Reproducible on 6.5 only

Actual results:

  1. echo "select id, name, checksum_type, updated_at from katello_repositories" | su postgres -c 'psql foreman'
    could not change directory to "/root"
    ERROR: column "name" does not exist
    LINE 1: select id, name, checksum_type, updated_at from katello_repo...

Expected results:

Foreman-debug should collect the repos data in all version.

Additional info:

This works in satellite 6.5

  1. echo "select id, name, checksum_type, updated_at from katello_root_repositories" | su postgres -c 'psql foreman'

History

#1 Updated by The Foreman Bot 3 months ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman-packaging/pull/3954 added

#2 Updated by John Mitsch 3 months ago

  • Triaged changed from No to Yes
  • Target version set to Katello 3.13.0
  • Subject changed from Foreman-debug katello_repositories SQL query no longer works to Foreman-debug katello_repositories SQL query no longer works

#3 Updated by Evgeni Golov about 2 months ago

  • Status changed from Ready For Testing to Closed

Also available in: Atom PDF