Bug 1658571
| Summary: | sosreport collects only the tail of a postgresql dump [rhel-7.6.z] | ||
|---|---|---|---|
| Product: | Red Hat Enterprise Linux 7 | Reporter: | RAD team bot copy to z-stream <autobot-eus-copy> |
| Component: | sos | Assignee: | Pavel Moravec <pmoravec> |
| Status: | CLOSED ERRATA | QA Contact: | Miroslav Hradílek <mhradile> |
| Severity: | high | Docs Contact: | Marie Hornickova <mdolezel> |
| Priority: | high | ||
| Version: | 7.6 | CC: | agk, bmr, didi, gavin, lrotenbe, plambri, pmoravec, sbradley |
| Target Milestone: | rc | Keywords: | OtherQA, ZStream |
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | sos-3.6-13.el7_6 | Doc Type: | Bug Fix |
| Doc Text: |
If a PostgreSQL database was dumped into a file larger than 25 MB, the sosreport tool collected only the last 25 MB of the dump. With this update, sosreport has been fixed, and it now collects PostgreSQL dumps of any size correctly.
|
Story Points: | --- |
| Clone Of: | 1656278 | Environment: | |
| Last Closed: | 2019-01-29 17:23:32 UTC | Type: | --- |
| 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: | 1656278, 1658939 | ||
| Bug Blocks: | 1654068 | ||
|
Description
RAD team bot copy to z-stream
2018-12-12 12:35:14 UTC
Didi, could you please verify the fix against this build for 7.6.2? A yum repository for the build of sos-3.6-12.el7_6 (task 19472493) is available at: http://brew-task-repos.usersys.redhat.com/repos/official/sos/3.6/12.el7_6/ You can install the rpms locally by putting this .repo file in your /etc/yum.repos.d/ directory: http://brew-task-repos.usersys.redhat.com/repos/official/sos/3.6/12.el7_6/sos-3.6-12.el7_6.repo RPMs and build logs can be found in the following locations: http://brew-task-repos.usersys.redhat.com/repos/official/sos/3.6/12.el7_6/noarch/ The full list of available rpms is: http://brew-task-repos.usersys.redhat.com/repos/official/sos/3.6/12.el7_6/noarch/sos-3.6-12.el7_6.src.rpm http://brew-task-repos.usersys.redhat.com/repos/official/sos/3.6/12.el7_6/noarch/sos-3.6-12.el7_6.noarch.rpm Build output will be available for the next 21 days. That build is failing, please use this one instead: A yum repository for the build of sos-3.6-13.el7_6 (task 19473075) is available at: http://brew-task-repos.usersys.redhat.com/repos/official/sos/3.6/13.el7_6/ You can install the rpms locally by putting this .repo file in your /etc/yum.repos.d/ directory: http://brew-task-repos.usersys.redhat.com/repos/official/sos/3.6/13.el7_6/sos-3.6-13.el7_6.repo RPMs and build logs can be found in the following locations: http://brew-task-repos.usersys.redhat.com/repos/official/sos/3.6/13.el7_6/noarch/ The full list of available rpms is: http://brew-task-repos.usersys.redhat.com/repos/official/sos/3.6/13.el7_6/noarch/sos-3.6-13.el7_6.src.rpm http://brew-task-repos.usersys.redhat.com/repos/official/sos/3.6/13.el7_6/noarch/sos-3.6-13.el7_6.noarch.rpm Build output will be available for the next 21 days. Verified on: Red Hat Enterprise Linux Server release 7.6 (Maipo) sos-3.6-13.el7_6.noarch ovirt-engine-setup-4.3.0-0.6.alpha2.el7.noarch Steps taken from: https://bugzilla.redhat.com/show_bug.cgi?id=1654068#c9 1. Make sure your engine db is large enough, so that its dump is > 25MiB. I did this with: su - postgres scl enable rh-postgresql95 bash psql engine create table test1(a varchar(512)) alter table test1 owner to engine \q a=$(printf 'a%.0s' $(seq 511)); for i in $(seq 50000); do echo "insert into test1 values('$a');"; done | psql engine Obviously, there are other means (such as creating many VMs/Disks/NICs/etc. and/or causing lots of errors so that the audit_log is filled). 2. ovirt-log-collector This creates an archive /tmp/sosreport-LogCollector-$TIMESTAMP.tar.xz 3. cd /tmp; tar xpf sosreport-LogCollector-$TIMESTAMP.tar.xz 4. cd sosreport-LogCollector-$TIMESTAMP 5. cd log-collector-data 6. tar xpf postgresql-sosreport-*.tar.xz 7. cd to generated directory postgresql-sosreport-* 8. cd sos_commands/postgresql 9. check the files there (e.g. with ls -l, 'file', or 'less < file'). Results: # ls -sh total 29M 29M pgdump-scl-rh-postgresql95.tar # file pgdump-scl-rh-postgresql95.tar pgdump-scl-rh-postgresql95.tar: POSIX tar archive As expected. Removing Didi from needinfo flag. 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/RHBA-2019:0184 |