Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1232720

Summary:	Add /var/log/mysqld.log to sos mysql/mariadb plugin
Product:	Red Hat OpenStack	Reporter:	Alan Pevec <apevec>
Component:	sos	Assignee:	Lee Yarwood <lyarwood>
Status:	CLOSED ERRATA	QA Contact:	Ofer Blaut <oblaut>
Severity:	high	Docs Contact:
Priority:	medium
Version:	7.0 (Kilo)	CC:	agk, bmr, dkutalek, gavin, jherrman, jschluet, mbayer, pablo.iranzo, plambri, pmoravec, qe-baseos-apps, sbradley, yeylon
Target Milestone:	ga	Keywords:	Triaged
Target Release:	7.0 (Kilo)
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	sos-3.2-16.el7ost.2	Doc Type:	Bug Fix
Doc Text:	When using the sosreport utility on a Pacemaker node, one of the MariaDB MySQL server log-files was not properly collected. With this update, the underlying code has been corrected, and the log-file is now collected as expected.	Story Points:	---
Clone Of:	1210906	Environment:
Last Closed:	2015-08-05 13:27:22 UTC	Type:	Bug
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:	1210906, 1237208
Bug Blocks:

Description Alan Pevec 2015-06-17 11:30:48 UTC

+++ This bug was initially created as a clone of Bug #1210906 +++

Description of problem:

We frequently get SOS reports where we'd like to see the status of mariadb-galera running under pacemaker, and current installer configurations log this status in the file /var/log/mysqld.log; however, this file is not present.

While there is a /var/log/mariadb/mariadb.log that we are already getting, this is typically only populated during the initial server configuration phase; the actual galera bootstrapping / clustering ends up in /var/log/mysqld.log since Mariadb is run under Pacemaker OCF resource agents for the full run, instead of via systemd which is only during setup.

...SNIP...

--- Additional comment from Pavel Moravec on 2015-04-17 11:51:42 EDT ---

Upstream issue: https://github.com/sosreport/sos/issues/554

--- Additional comment from Pavel Moravec on 2015-05-31 08:01:28 EDT ---

Committed to upstream as https://github.com/sosreport/sos/commit/f8ab86cbd2302812cd9160bec4478cb4f84e1442

Comment 3 Jon Schlueter 2015-07-08 14:37:36 UTC

adding blocker flag for OSP 7 GA as this will make our lives a lot easier for bug report if this makes it in.

Comment 6 Ofer Blaut 2015-07-19 11:23:01 UTC

[root@overcloud-controller-2 tmp]# ll sosreport-overcloud-controller-2.localdomain-20150719070722/var/log/mysqld.log 
-rw-r-----. 1 mysql mysql 19557 Jul 19 04:51 sosreport-overcloud-controller-2.localdomain-20150719070722/var/log/mysqld.log


sos-3.2-16.el7ost.2.noarch

Comment 8 errata-xmlrpc 2015-08-05 13:27:22 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-2015:1548