Central's update status method issues a large number of SQL
queries for large zones with many recent updates, as a result
it's checking out many connections from our connection pool one
after another, contributing to bug 1445123. By wrapping the
call in a transaction, a single connection will be checked out
of the pool.
Partial-Bug: 1445123
Change-Id: Idfde7578e1a17a6a0585835fe614f787102563fa
(cherry picked from commit ac79df1567fb040067ed59d948e8a39fb90af177)
Reviewed: https:/ /review. openstack. org/177107 /git.openstack. org/cgit/ openstack/ designate/ commit/ ?id=2900cd391ef ae38be1121e58e7 2f5519f4a95e90
Committed: https:/
Submitter: Jenkins
Branch: stable/kilo
commit 2900cd391efae38 be1121e58e72f55 19f4a95e90
Author: Kiall Mac Innes <email address hidden>
Date: Wed Apr 22 15:42:29 2015 +0100
central. update_ status should be transactional
Central's update status method issues a large number of SQL
queries for large zones with many recent updates, as a result
it's checking out many connections from our connection pool one
after another, contributing to bug 1445123. By wrapping the
call in a transaction, a single connection will be checked out
of the pool.
Partial-Bug: 1445123 6a0585835fe614f 787102563fa 067ed59d948e8a3 9fb90af177)
Change-Id: Idfde7578e1a17a
(cherry picked from commit ac79df1567fb040