OpenStack-Ansible

set default database pool timeouts and pool sizes for larger deployments

Bug #1478071 reported by Matthew Thode
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack-Ansible
Fix Released
Wishlist
Matthew Thode
Juno
Fix Released
Wishlist
Matthew Thode
OpenStack-Ansible 10.1.11
Kilo
Fix Released
Wishlist
Matthew Thode
OpenStack-Ansible 11.1.0
Trunk
Fix Released
Wishlist
Matthew Thode

Bug Description

these values have been shown to allow for a greater cluster size.

keystone_db_max_pool_size: 120
keystone_db_pool_timeout: 30
neutron_db_pool_size: 120
neutron_db_pool_timeout: 30
nova_db_max_pool_size: 120
nova_db_pool_timeout: 30

these options disappeared in kilo and will need to be readded.

Matthew Thode (prometheanfire)
Changed in openstack-ansible:
assignee: nobody → Matthew Thode (prometheanfire)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to os-ansible-deployment (master)

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

Changed in openstack-ansible:
status: New → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to os-ansible-deployment (kilo)

Fix proposed to branch: kilo
Review: https://review.openstack.org/205675

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to os-ansible-deployment (juno)

Fix proposed to branch: juno
Review: https://review.openstack.org/205678

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to os-ansible-deployment (master)

Reviewed: https://review.openstack.org/205671
Committed: https://git.openstack.org/cgit/stackforge/os-ansible-deployment/commit/?id=aad47c91897315e32212948985a93debb060cec6
Submitter: Jenkins
Branch: master

commit aad47c91897315e32212948985a93debb060cec6
Author: Matthew Thode <email address hidden>
Date: Fri Jul 24 13:41:03 2015 -0500

    Update defaults for db_timeout/max_pool_size for nova/neutron/keystone

    These values have been shown to work well with larger cluster sizes.

    Closes-bug: 1478071
    Change-Id: Iec44ef4b2c1d89537ffd1237322a44be5c357699

Changed in openstack-ansible:
status: In Progress → Fix Committed
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to os-ansible-deployment (juno)

Reviewed: https://review.openstack.org/205678
Committed: https://git.openstack.org/cgit/stackforge/os-ansible-deployment/commit/?id=62e4be6114286b5a10197a9c1dc1f4b50e3bc8ef
Submitter: Jenkins
Branch: juno

commit 62e4be6114286b5a10197a9c1dc1f4b50e3bc8ef
Author: Matthew Thode <email address hidden>
Date: Fri Jul 24 13:57:53 2015 -0500

    Update defaults for db_timeout/max_pool_size for nova/neutron/keystone

    These values have been shown to work well with larger cluster sizes.

    Closes-bug: 1478071
    (cherry-picked from commit Iec44ef4b2c1d89537ffd1237322a44be5c357699)

    Change-Id: I4cf99996666dd930738276fb0561203d57ef1b8a

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to os-ansible-deployment (kilo)

Reviewed: https://review.openstack.org/205675
Committed: https://git.openstack.org/cgit/stackforge/os-ansible-deployment/commit/?id=e44f05b29d60a30176a4e88f19218e8e2d68be01
Submitter: Jenkins
Branch: kilo

commit e44f05b29d60a30176a4e88f19218e8e2d68be01
Author: Matthew Thode <email address hidden>
Date: Fri Jul 24 13:53:15 2015 -0500

    Update defaults for db_timeout/max_pool_size for nova/neutron/keystone

    These values have been shown to work well with larger cluster sizes.
    I've also readded these values for neutron.

    Change-Id: I5641da683896e76121440620054103eab48b2838
    Closes-bug: 1478071
    (cherry-picked from commit Iec44ef4b2c1d89537ffd1237322a44be5c357699)

Revision history for this message
Davanum Srinivas (DIMS) (dims-v) wrote : Fix included in openstack/openstack-ansible 11.2.14

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

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Related fix proposed to openstack-ansible-os_nova (master)

Related fix proposed to branch: master
Review: https://review.opendev.org/c/openstack/openstack-ansible-os_nova/+/786592

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Change abandoned on openstack-ansible-os_nova (master)

Change abandoned by "Andrew Bonney <email address hidden>" on branch: master
Review: https://review.opendev.org/c/openstack/openstack-ansible-os_nova/+/786592

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

Other bug subscribers

Remote bug watches

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