Remove general_log in ansible/roles/mariadb/templates/galera.cnf.j2

[Vikram Hosakote]

general_log in ansible/roles/mariadb/templates/galera.cnf.j2 is _too_ verbose and logs _each_ mariadb database query.

https://github.com/openstack/kolla/blob/master/ansible/roles/mariadb/templates/galera.cnf.j2#L7-L8

Hence, lots of mariadb logs are collected. This will consume all the disk space on the mariadb node, and will eventually crash the node over time.

In the gate, just after few minutes, 2.5M of mariadb logs were collected due to general_log.

See mariadb.log in this link:

http://logs.openstack.org/26/302026/4/check/gate-kolla-dsvm-deploy-ubuntu-source/00f3f0f/logs/kolla/mariadb/

The mariadb codumentation says "Since general_log is a record of every query received by the server, it can grow large quite quickly".

https://mariadb.com/kb/en/mariadb/general-query-log/

Hence, general_log must be removed in ansible/roles/mariadb/templates/galera.cnf.j2.

[Vikram Hosakote (vhosakot)]

https://review.openstack.org/#/c/302401/ fixes this bug.

[OpenStack Infra (hudson-openstack)]

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

commit df53d92db6464f5347d21972664caa69eb6d99a2
Author: Vikram Hosakote <email address hidden>
Date: Wed Apr 6 17:33:59 2016 +0000

    Revert "Add general_log to mariadb container and make heka collect it"

    This reverts commit 86bafeee7a8926d212e8d089fade667772dbcc83.

    Closes-Bug: #1568670

    Change-Id: I88563292e29d691c27a3640e5232b9f22c7a288a

[Doug Hellmann (doug-hellmann)]

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