Bug 1538365

Summary: log-collector fails to collect database dump
Product: Red Hat Enterprise Virtualization Manager Reporter: Derrick Ornelas <dornelas>
Component: ovirt-log-collectorAssignee: Sandro Bonazzola <sbonazzo>
Status: CLOSED DUPLICATE QA Contact: Pavel Stehlik <pstehlik>
Severity: high Docs Contact:
Priority: unspecified    
Version: 4.2.0   
Target Milestone: ovirt-4.2.0   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2018-01-24 23:19:43 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Sub-Eng RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1538360    

Description Derrick Ornelas 2018-01-24 22:45:04 UTC 
Description of problem:

ovirt-log-collector fails to collect the engine database dump because of the use of the rh-postgresql95-postgresql package instead of postgresql.  The pg_dump command is not available in the normal path.


Version-Release number of selected component (if applicable):
ovirt-log-collector-4.2.0-1.el7ev.noarch


How reproducible:
100%


Steps to Reproduce:
1.  Install rhvm-4.2.0.2-0.1.el7 and ovirt-log-collector-4.2.0-1.el7ev
2.  Run 'ovirt-log-collector'
3.  Extract sosreport-LogCollector-*/log-collector-data/postgresql-sosreport-*.tar.xz archive


Actual results:

archive does not contain /tmp/<tmpdir>/sos_pgdump.tar


Expected results:

archive contains /tmp/<tmpdir>/sos_pgdump.tar


Additional info:


$ tar xf postgresql-sosreport-rhv42.example.com-20180122152044.tar.xz

$ cat sosreport-rhv42.example.com-20180122152044/sos_logs/sos.log 
2018-01-22 15:20:44,609 INFO: [archive:TarFileArchive] initialised empty FileCacheArchive at '/tmp/logcollector-RIWF8D/working/log-collector-data/sos.cgEmht/sosreport-rhv42db.rhev.gsslab.rdu.redhat.com-20180122152044'
2018-01-22 15:20:44,610 INFO: [sos.sosreport:setup] executing 'sosreport --batch -o postgresql --tmp-dir=/tmp/logcollector-RIWF8D/working/log-collector-data -k postgresql.dbname=engine -k postgresql.dbhost=localhost -k postgresql.dbport=5432 -k postgresql.username=engine'
2018-01-22 15:20:44,618 INFO: [plugin:postgresql] command 'pg_dump' not found in / - re-trying in host root
2018-01-22 15:20:44,625 ERROR: [plugin:postgresql] Unable to execute pg_dump. Error()
2018-01-22 15:20:44,627 INFO: [plugin:postgresql] collecting path '/var/lib/pgsql/initdb_rh-postgresql95-postgresql.log'
Comment 1 Derrick Ornelas 2018-01-24 23:19:43 UTC 
Found:

Bug 1494420 - sos doesn't support PostgreSQL95 from Software Collections
Bug 1515113 - sos doesn't support PostgreSQL95 from Software Collections [rhel-7.4.z]

*** This bug has been marked as a duplicate of bug 1515113 ***
Comment 2 Franta Kust 2019-05-16 12:54:36 UTC 
BZ<2>Jira re-sync