Bug 1494419 - PostgreSQL sos plugins doesn't collect PostgreSQL95 data. (depends on platform bug 1515113)
Summary: PostgreSQL sos plugins doesn't collect PostgreSQL95 data. (depends on platfor...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: ovirt-log-collector
Classification: oVirt
Component: SOS-plugins
Version: ---
Hardware: Unspecified
OS: Unspecified
urgent
urgent
Target Milestone: ovirt-4.2.2
: ---
Assignee: Douglas Schilling Landgraf
QA Contact: Jiri Belka
URL:
Whiteboard:
Depends On: 1494420 1515113
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-09-22 08:46 UTC by Sandro Bonazzola
Modified: 2018-03-29 11:15 UTC (History)
8 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2018-03-29 11:15:58 UTC
oVirt Team: Integration
Embargoed:
rule-engine: ovirt-4.2+
rule-engine: blocker+
lsvaty: testing_ack+


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
oVirt gerrit 82579 0 master MERGED inventory: Add support to software collection (postgresql95) 2017-10-06 14:51:40 UTC

Description Sandro Bonazzola 2017-09-22 08:46:45 UTC
Description of problem:
We moved from PostgreSQL to PostgreSQL95 from Software Collections.
sosreport is not able to collect data from that database configuration.
Reported to sos upstream here: https://github.com/sosreport/sos/issues/1090


Version-Release number of selected component (if applicable):
sos-3.4-6.el7.centos.noarch
ovirt-log-collector-4.2.0-0.0.master.20170914223756.git3ccf7d8.el7.centos.noarch

How reproducible:
100%

Steps to Reproduce:
1. install engine and log collector
2. ensure log-collector config has database credentials
3. # ovirt-log-collector --verbose --no-hypervisors collect

Actual results:
...
The following plugins are currently disabled:
...
postgresql           inactive       PostgreSQL RDBMS


Expected results:
either postgresql or a new plugin should collect postgresql data

Comment 1 Red Hat Bugzilla Rules Engine 2017-09-22 08:46:51 UTC
This bug report has Keywords: Regression or TestBlocker.
Since no regressions or test blockers are allowed between releases, it is also being identified as a blocker for this release. Please resolve ASAP.

Comment 2 Douglas Schilling Landgraf 2017-10-06 05:45:27 UTC
The oVirt gerrit 82579 is focused in the ovirt-log-collector-analyzer. On the other side, ovirt-log-collector only depends on changes in sos project via https://github.com/sosreport/sos/pull/1118. As soon this change (or similar) land in the sos ovirt-log-collector should be ready to go.

Comment 5 Yaniv Kaul 2018-01-08 14:13:51 UTC
Sandro, can this get into 4.2.1?

Comment 7 Lukas Svaty 2018-01-19 17:07:25 UTC
platform bug is fixed in sos-3.5-4.el7.noarch

we are currently tagging sos-3.5-1.el7.noarch

I verified in sos-3.5-4.el7 once we have this sos as dependency and in channels, we can Verify this one.

Comment 8 Jiri Belka 2018-02-20 09:09:56 UTC
- flow 1

  el: redhat-release-server-7.4-18.el7.x86_64
  sos: sos-3.4-13.el7_4.noarch
  ovirt-log-collector: ovirt-log-collector-4.2.3-1.el7ev.noarch
  rhv: rhvm-4.2.1.3-0.1.el7.noarch
  postgresql: rh-postgresql95-postgresql-server-9.5.9-1.el7.x86_64

# tar xOJf /tmp/sosreport-LogCollector-20180220090555.tar.xz sosreport-LogCollector-20180220090555/log-collector-data/postgresql-sosreport-brq-setup.rhev.lab.eng.brq.redhat.com-20180220090546.tar.xz | tar -xOJf - sosreport-brq-setup.rhev.lab.eng.brq.redhat.com-20180220090546/sos_commands/postgresql/pgdump-scl-rh-postgresql95.tar | tar --test-label -f - && echo "valid tar archive"
valid tar archive

# tar xOJf /tmp/sosreport-LogCollector-20180220090555.tar.xz sosreport-LogCollector-20180220090555/log-collector-data/postgresql-sosreport-brq-setup.rhev.lab.eng.brq.redhat.com-20180220090546.tar.xz | tar -xOJf - sosreport-brq-setup.rhev.lab.eng.brq.redhat.com-20180220090546/sos_commands/postgresql/pgdump-scl-rh-postgresql95.tar | tar -tf - | head
toc.dat
7428.dat
7430.dat
7432.dat
7434.dat
7437.dat
7438.dat
7440.dat
7442.dat
7444.dat

- flow 2

  el: redhat-release-server-7.5-3.el7.x86_64
  sos: sos-3.5-6.el7.noarch
  ovirt-log-collector: ovirt-log-collector-4.2.3-1.el7ev.noarch
  rhv: rhvm-4.2.2-0.1.el7.noarch
  postgresql: rh-postgresql95-postgresql-server-9.5.9-1.el7.x86_64

# tar xOJf /tmp/sosreport-LogCollector-20180220100521.tar.xz sosreport-LogCollector-20180220100521/log-collector-data/postgresql-sosreport-10-37-138-5.rhev.lab.eng.brq.redhat.com-20180220100517.tar.xz | tar -xOJf - sosreport-10-37-138-5.rhev.lab.eng.brq.redhat.com-20180220100517/sos_commands/postgresql/pgdump-scl-rh-postgresql95.tar | tar --test-label -f - && echo "valid tar archive"
valid tar archive

# tar xOJf /tmp/sosreport-LogCollector-20180220100521.tar.xz sosreport-LogCollector-20180220100521/log-collector-data/postgresql-sosreport-10-37-138-5.rhev.lab.eng.brq.redhat.com-20180220100517.tar.xz | tar -xOJf - sosreport-10-37-138-5.rhev.lab.eng.brq.redhat.com-20180220100517/sos_commands/postgresql/pgdump-scl-rh-postgresql95.tar | tar -tf - | head
toc.dat
7407.dat
7409.dat
7411.dat
7413.dat
7416.dat
7417.dat
7419.dat
7421.dat
7423.dat

Comment 9 Sandro Bonazzola 2018-03-29 11:15:58 UTC
This bugzilla is included in oVirt 4.2.2 release, published on March 28th 2018.

Since the problem described in this bug report should be
resolved in oVirt 4.2.2 release, it has been closed with a resolution of CURRENT RELEASE.

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


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