Decrease MariaDB wait timeout

[Bjoern]

Currently MariaDB uses the default session timeout of 8 hours and unused SQL Alchemy connections stay open for that time causing a high floor if idling sessions

The fix should be to reduce the wait timeout to the SQL Alchemy pool recycling which is currently using 1h as default setting

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/307231
Committed: https://git.openstack.org/cgit/openstack/openstack-ansible-galera_server/commit/?id=a1636b3bb3c5c7588c8e92d4da45198929f7e833
Submitter: Jenkins
Branch: master

commit a1636b3bb3c5c7588c8e92d4da45198929f7e833
Author: Bjoern Teipel <email address hidden>
Date: Mon Apr 18 09:32:27 2016 -0500

    Decrease MariaDB wait timeout

    This MariaDB setting uses the same timeout for SQL connections
    as configured inside SQL Alchemy (pool_recycle) and prevent possibly
    SQL session build up due to a large default setting (8 Hours).

    Nova and Neutron are using a idle_timeout of 3600 by default,
    for example
    https://github.com/openstack/nova/blob/master/nova/db/sqlalchemy/api.py#L101
    and respectively for Neutron
    https://github.com/openstack/neutron/blob/stable/liberty/etc/neutron.conf#L761

    Change-Id: I273739c3c10616cac148aeb839154e0fb3359bca
    Closes-Bug: #1571682

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: liberty
Review: https://review.openstack.org/307826

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/307691
Committed: https://git.openstack.org/cgit/openstack/openstack-ansible-galera_server/commit/?id=a8e0ba70990c23ecc19eebf8299e698f2d140202
Submitter: Jenkins
Branch: stable/mitaka

commit a8e0ba70990c23ecc19eebf8299e698f2d140202
Author: Bjoern Teipel <email address hidden>
Date: Mon Apr 18 09:32:27 2016 -0500

    Decrease MariaDB wait timeout

    This MariaDB setting uses the same timeout for SQL connections
    as configured inside SQL Alchemy (pool_recycle) and prevent possibly
    SQL session build up due to a large default setting (8 Hours).

    Nova and Neutron are using a idle_timeout of 3600 by default,
    for example
    https://github.com/openstack/nova/blob/master/nova/db/sqlalchemy/api.py#L101
    and respectively for Neutron
    https://github.com/openstack/neutron/blob/stable/liberty/etc/neutron.conf#L761

    Change-Id: I273739c3c10616cac148aeb839154e0fb3359bca
    Closes-Bug: #1571682
    (cherry picked from commit a1636b3bb3c5c7588c8e92d4da45198929f7e833)

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/307826
Committed: https://git.openstack.org/cgit/openstack/openstack-ansible/commit/?id=7f17043a9273e0dbe49369cd80a04cefcd177be0
Submitter: Jenkins
Branch: liberty

commit 7f17043a9273e0dbe49369cd80a04cefcd177be0
Author: Bjoern Teipel <email address hidden>
Date: Tue Apr 19 08:41:45 2016 -0500

    Decrease MariaDB wait timeout

    This MariaDB setting uses the same timeout for SQL connections
    as configured inside SQL Alchemy (pool_recycle) and prevent possibly
    SQL session build up due to a large default setting (8 Hours).

    Nova and Neutron are using a idle_timeout of 3600 by default,
    for example
    https://github.com/openstack/nova/blob/master/nova/db/sqlalchemy/api.py#L101
    and respectively for Neutron
    https://github.com/openstack/neutron/blob/stable/liberty/etc/neutron.conf#L761

    This change is related to https://review.openstack.org/#/c/307231/

    Change-Id: Ib0b743f35790a3ad9eae10b9551d010282879877
    Closes-Bug: #1571682

[Doug Hellmann (doug-hellmann)]

This issue was fixed in the openstack/openstack-ansible-galera_server 13.0.1 release.

[Davanum Srinivas (DIMS) (dims-v)]

This issue was fixed in the openstack/openstack-ansible-galera_server 13.0.1 release.

[Davanum Srinivas (DIMS) (dims-v)]

This issue was fixed in the openstack/openstack-ansible 12.0.11 release.

[Thierry Carrez (ttx)]

This issue was fixed in the openstack/openstack-ansible-galera_server 14.0.0.0b1 development milestone.