RHEL Engineering is moving the tracking of its product development work on RHEL 6 through RHEL 9 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 "RHEL project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs in the statuses "NEW", "ASSIGNED", and "POST" are being migrated throughout September 2023. Bugs of Red Hat partners with an assigned Engineering Partner Manager (EPM) are migrated in late September as per pre-agreed dates. Bugs against components "kernel", "kernel-rt", and "kpatch" are only migrated if still in "NEW" or "ASSIGNED". 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 "RHEL project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/RHEL-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 1494420 - sos doesn't support PostgreSQL95 from Software Collections
Summary: sos doesn't support PostgreSQL95 from Software Collections
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Enterprise Linux 7
Classification: Red Hat
Component: sos
Version: 7.4
Hardware: Unspecified
OS: Unspecified
high
urgent
Target Milestone: rc
: 7.4
Assignee: Pavel Moravec
QA Contact: Lukas Svaty
URL:
Whiteboard:
Depends On:
Blocks: 1494419 1513071 1515113
TreeView+ depends on / blocked
 
Reported: 2017-09-22 08:49 UTC by Sandro Bonazzola
Modified: 2018-04-10 18:07 UTC (History)
14 users (show)

Fixed In Version: sos-3.5-3.el7
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
: 1515113 (view as bug list)
Environment:
Last Closed: 2018-04-10 18:05:49 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Github sosreport sos issues 1090 0 None None None 2017-09-22 10:14:34 UTC
Red Hat Product Errata RHEA-2018:0963 0 None None None 2018-04-10 18:07:12 UTC

Description Sandro Bonazzola 2017-09-22 08:49:50 UTC 
Description of problem:
In RHV 4.2 we are now moving to PostgreSQL95 from software collections.
sos postresql plugin doesn't work with software collections.
Issue reported upstream: https://github.com/sosreport/sos/issues/1090
Comment 1 Pavel Moravec 2017-09-22 10:11:06 UTC 
Technical specification what change is required is completely missing (here and also in the upstream issue). Also relationship to sos PR 900 is unclear.

Please react in https://github.com/sosreport/sos/issues/1090#issuecomment-331407466 to let me understand what are the requirements.

(hint: if you would follow the default BZ template and fill "Steps to Reproduce:", "Actual results:" and "Expected results:", we would know much more)
Comment 2 Oneata Mircea Teodor 2017-09-22 10:14:23 UTC 
Please refer to zstream documentation when creating bugs for cloning, rhel 7.5 flag added.
https://mojo.redhat.com/docs/DOC-1021938#jive_content_id_Executive_Summary
Comment 3 Pavel Moravec 2017-11-02 15:15:19 UTC 
Fixed via sos 3.5 rebase.
Comment 9 Pavel Moravec 2017-11-19 17:21:33 UTC 
Due to the late phase and our QE capacity constrains, could Sandro or somebody else from RHEV team verify the z-stream BZ (I doubt sos QE will have capacity for it and I wont commit anything to 7.4.z until I have *some* qa_ack)?
Comment 11 Sandro Bonazzola 2017-11-30 09:32:07 UTC 
(In reply to Pavel Moravec from comment #9)
> Due to the late phase and our QE capacity constrains, could Sandro or
> somebody else from RHEV team verify the z-stream BZ (I doubt sos QE will
> have capacity for it and I wont commit anything to 7.4.z until I have *some*
> qa_ack)?

Lukas?
Comment 12 David Necpal 2017-11-30 10:24:49 UTC 
Hi Sandro, can you provide verification steps please?

Using 
sos-3.5-1.el7.noarch
ovirt-log-collector-4.2.1-0.0.master.20171129193044.git105bbe9.el7.centos.noarch

I encountred the same issue:

/tmp/sosreport-LogCollector-20171130115825/log-collector-data/sosreport-example.com-20171130115825/sos_logs:

2017-11-30 11:58:25,365 INFO: [archive:TarFileArchive] initialised empty FileCacheArchive at '/tmp/logcollector-pWgn45/working/log-collector-data/sos.VfKUEb/sosreport-example.com-20171130115825'
2017-11-30 11:58:25,366 INFO: [sos.sosreport:setup] executing 'sosreport --batch -o postgresql --tmp-dir=/tmp/logcollector-pWgn45/working/log-collector-data -k postgresql.dbname=engine -k postgresql.dbhost=localhost -k postgresql.dbport=5432 -k postgresql.username=engine'

*******************
2017-11-30 11:58:25,375 INFO: [plugin:postgresql] Unable to execute pg_dump. Error()
2017-11-30 11:58:25,475 INFO: [plugin:postgresql] Unable to execute pg_dump. Error()
*******************
2017-11-30 11:58:25,476 INFO: [plugin:postgresql] collecting path '/var/lib/pgsql/initdb_rh-postgresql95-postgresql.log'
2017-11-30 11:58:25,477 INFO: [plugin:postgresql] collecting path '/var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_log/postgresql-Tue.log'
2017-11-30 11:58:25,479 INFO: [plugin:postgresql] collecting path '/var/opt/rh/rh-postgresql95/lib/pgsql/data/PG_VERSION'
2017-11-30 11:58:25,480 INFO: [plugin:postgresql] collecting path '/var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_log/postgresql-Thu.log'
2017-11-30 11:58:25,481 INFO: [plugin:postgresql] collecting path '/var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_log/postgresql-Sat.log'
2017-11-30 11:58:25,482 INFO: [plugin:postgresql] collecting path '/var/opt/rh/rh-postgresql95/lib/pgsql/data/postgresql.conf'
2017-11-30 11:58:25,483 INFO: [plugin:postgresql] collecting path '/var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_ident.conf'
2017-11-30 11:58:25,484 INFO: [plugin:postgresql] collecting path '/var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_hba.conf'
2017-11-30 11:58:25,484 INFO: [plugin:postgresql] collecting path '/var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_log/postgresql-Fri.log'
2017-11-30 11:58:25,485 INFO: [plugin:postgresql] collecting path '/var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_log/postgresql-Wed.log'
2017-11-30 11:58:25,486 INFO: [plugin:postgresql] collecting path '/var/opt/rh/rh-postgresql95/lib/pgsql/data/postmaster.opts'
2017-11-30 11:58:25,487 INFO: [plugin:postgresql] collecting path '/var/opt/rh/rh-postgresql95/lib/pgsql/data/postgresql.auto.conf'
2017-11-30 11:58:25,488 INFO: [plugin:postgresql] collecting path '/var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_log/postgresql-Mon.log'
2017-11-30 11:58:25,488 INFO: [plugin:postgresql] collecting path '/var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_log/postgresql-Sun.log'
Comment 13 Douglas Schilling Landgraf 2017-11-30 20:15:17 UTC 
(In reply to David Necpal from comment #12)
> Hi Sandro, can you provide verification steps please?
> 
> Using 
> sos-3.5-1.el7.noarch
> ovirt-log-collector-4.2.1-0.0.master.20171129193044.git105bbe9.el7.centos.
> noarch
> 
> I encountred the same issue:
> 

It's not fixed in sos-3-5-1.  Pavel might know the right rpm to test.

> /tmp/sosreport-LogCollector-20171130115825/log-collector-data/sosreport-
> example.com-20171130115825/sos_logs:
> 
> 2017-11-30 11:58:25,365 INFO: [archive:TarFileArchive] initialised empty
> FileCacheArchive at
> '/tmp/logcollector-pWgn45/working/log-collector-data/sos.VfKUEb/sosreport-
> example.com-20171130115825'
> 2017-11-30 11:58:25,366 INFO: [sos.sosreport:setup] executing 'sosreport
> --batch -o postgresql
> --tmp-dir=/tmp/logcollector-pWgn45/working/log-collector-data -k
> postgresql.dbname=engine -k postgresql.dbhost=localhost -k
> postgresql.dbport=5432 -k postgresql.username=engine'
> 
> *******************
> 2017-11-30 11:58:25,375 INFO: [plugin:postgresql] Unable to execute pg_dump.
> Error()
> 2017-11-30 11:58:25,475 INFO: [plugin:postgresql] Unable to execute pg_dump.
> Error()
> *******************
> 2017-11-30 11:58:25,476 INFO: [plugin:postgresql] collecting path
> '/var/lib/pgsql/initdb_rh-postgresql95-postgresql.log'
> 2017-11-30 11:58:25,477 INFO: [plugin:postgresql] collecting path
> '/var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_log/postgresql-Tue.log'
> 2017-11-30 11:58:25,479 INFO: [plugin:postgresql] collecting path
> '/var/opt/rh/rh-postgresql95/lib/pgsql/data/PG_VERSION'
> 2017-11-30 11:58:25,480 INFO: [plugin:postgresql] collecting path
> '/var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_log/postgresql-Thu.log'
> 2017-11-30 11:58:25,481 INFO: [plugin:postgresql] collecting path
> '/var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_log/postgresql-Sat.log'
> 2017-11-30 11:58:25,482 INFO: [plugin:postgresql] collecting path
> '/var/opt/rh/rh-postgresql95/lib/pgsql/data/postgresql.conf'
> 2017-11-30 11:58:25,483 INFO: [plugin:postgresql] collecting path
> '/var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_ident.conf'
> 2017-11-30 11:58:25,484 INFO: [plugin:postgresql] collecting path
> '/var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_hba.conf'
> 2017-11-30 11:58:25,484 INFO: [plugin:postgresql] collecting path
> '/var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_log/postgresql-Fri.log'
> 2017-11-30 11:58:25,485 INFO: [plugin:postgresql] collecting path
> '/var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_log/postgresql-Wed.log'
> 2017-11-30 11:58:25,486 INFO: [plugin:postgresql] collecting path
> '/var/opt/rh/rh-postgresql95/lib/pgsql/data/postmaster.opts'
> 2017-11-30 11:58:25,487 INFO: [plugin:postgresql] collecting path
> '/var/opt/rh/rh-postgresql95/lib/pgsql/data/postgresql.auto.conf'
> 2017-11-30 11:58:25,488 INFO: [plugin:postgresql] collecting path
> '/var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_log/postgresql-Mon.log'
> 2017-11-30 11:58:25,488 INFO: [plugin:postgresql] collecting path
> '/var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_log/postgresql-Sun.log'
Comment 14 Pavel Moravec 2017-11-30 21:48:08 UTC 
(In reply to Douglas Schilling Landgraf from comment #13)
> (In reply to David Necpal from comment #12)
> > Hi Sandro, can you provide verification steps please?
> > 
> > Using 
> > sos-3.5-1.el7.noarch
> > ovirt-log-collector-4.2.1-0.0.master.20171129193044.git105bbe9.el7.centos.
> > noarch
> > 
> > I encountred the same issue:
> > 
> 
> It's not fixed in sos-3-5-1.  Pavel might know the right rpm to test.
> 

This isnt yet fully resolved due to:

bz1513071: Log Analyzer unable to detect sos_pgdump.tar

Most of the requirements in this BZ _are_ fixed (most of the data collected for non-SCL postgres are collected also for SCL-installed postgres), but it makes sense to defer verification a week when I should have a package respin incl. sos PR:

https://github.com/sosreport/sos/pull/1154

merged and backported.

I am changing the BZ status to make it explicit.

Let me know if description of particular verification steps are required.
Comment 18 Lukas Svaty 2018-01-19 17:10:33 UTC 
verified with 
sos-3.5-4.el7.noarch
rh-postgresql95-postgresql-9.5.9-1.el7.x86_64
Red Hat Enterprise Linux Server release 7.5 Beta (Maipo) Build: RHEL-7.5-20171130.0
Comment 22 errata-xmlrpc 2018-04-10 18:05:49 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHEA-2018:0963
Note You need to log in before you can comment on or make changes to this bug.