Add general_log to mariadb container and make heka collect it

Bug #1563668 reported by Vikram Hosakote
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
kolla
Fix Released
High
Vikram Hosakote

Bug Description

mariadb needs two types of logging enabled in ansible/roles/mariadb/templates/galera.cnf.j2.

1) "log-error" that logs just the mariadb errors (https://github.com/openstack/kolla/blob/master/ansible/roles/mariadb/templates/galera.cnf.j2#L6)

2) "general_log" that logs all the other mariadb activities and database queries. general_log is not in ansible/roles/mariadb/templates/galera.cnf.j2.

general_log must also be added to ansible/roles/mariadb/templates/galera.cnf.j2 so that all the mariadb logs are seen. This will be helpful to debug mariadb issues especially when mariadb is scaled.

tags: added: logging mariadb
Changed in kolla:
status: New → In Progress
assignee: nobody → Vikram Hosakote (vhosakot)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to kolla (master)

Fix proposed to branch: master
Review: https://review.openstack.org/299133

Changed in kolla:
importance: Undecided → High
milestone: none → newton-1
tags: added: rc-backport-potential
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to kolla (master)

Reviewed: https://review.openstack.org/299133
Committed: https://git.openstack.org/cgit/openstack/kolla/commit/?id=86bafeee7a8926d212e8d089fade667772dbcc83
Submitter: Jenkins
Branch: master

commit 86bafeee7a8926d212e8d089fade667772dbcc83
Author: Vikram Hosakote <email address hidden>
Date: Wed Mar 30 04:43:48 2016 +0000

    Add general_log to mariadb container and make heka collect it

    Added general_log to ansible/roles/mariadb/templates/galera.cnf.j2
    to improve mariadb logging.

    This will be helpful to debug mariadb issues especially when
    mariadb is scaled.

    Test results of this patch set are at:
    http://paste.openstack.org/show/492852/

    Change-Id: I80438d1bbdd1ed2a1f47489c6f9c45b8107340a0
    Closes-Bug: #1563668

Changed in kolla:
status: In Progress → Fix Released
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to kolla (stable/mitaka)

Fix proposed to branch: stable/mitaka
Review: https://review.openstack.org/301975

Steven Dake (sdake)
tags: removed: rc-backport-potential
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Change abandoned on kolla (stable/mitaka)

Change abandoned by Vikram Hosakote (<email address hidden>) on branch: stable/mitaka
Review: https://review.openstack.org/301975
Reason: Abandoning this patch set as general_log is too verbose and consumes a lot of disk space. This change will be reverted in master as well.

Revision history for this message
Steven Dake (sdake) wrote :

Removing from Mitaka since this will be reverted in master.

no longer affects: kolla/mitaka
Revision history for this message
Doug Hellmann (doug-hellmann) wrote : Fix included in openstack/kolla 3.0.0.0b1

This issue was fixed in the openstack/kolla 3.0.0.0b1 development milestone.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.