diff options
| author | melanie witt <melwittt@gmail.com> | 2017-05-16 10:25:42 +0000 |
|---|---|---|
| committer | melanie witt <melwittt@gmail.com> | 2017-05-18 18:17:06 +0000 |
| commit | 47fa88d94754fcdad6bb132b45196b4d44c0f4cd (patch) | |
| tree | f6534e1654234bc143e58b33b5c5c2b94cd1a760 /releasenotes | |
| parent | 902b7bf6f5425824a0661b8e4beac4a894749c03 (diff) | |
| download | nova-47fa88d94754fcdad6bb132b45196b4d44c0f4cd.tar.gz | |
Cache database and message queue connection objects
Recently in the gate we have seen a trace on some work-in-progress
patches:
OperationalError: (pymysql.err.OperationalError)
(1040, u'Too many connections')
and at least one operator has reported that the number of database
connections increased significantly going from Mitaka to Newton.
It was suspected that the increase was caused by creating new oslo.db
transaction context managers on-the-fly when switching database
connections for cells. Comparing the dstat --tcp output of runs of the
gate-tempest-dsvm-neutron-full-ubuntu-xenial job with and without
caching of the database connections showed a difference of 445 active
TCP connections and 1495 active TCP connections, respectively [1].
This adds caching of the oslo.db transaction context managers and the
oslo.messaging transports to avoid creating a large number of objects
that are not being garbage-collected as expected.
Closes-Bug: #1691545
[1] https://docs.google.com/spreadsheets/d/1DIfFfX3kaA_SRoCM-aO7BN4IBEShChXLztOBFeKryt4/edit?usp=sharing
Change-Id: I17e0eb836dd87aac5859f506e7d771d42753d31a
Diffstat (limited to 'releasenotes')
| -rw-r--r-- | releasenotes/notes/bug-1691545-1acd6512effbdffb.yaml | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/releasenotes/notes/bug-1691545-1acd6512effbdffb.yaml b/releasenotes/notes/bug-1691545-1acd6512effbdffb.yaml new file mode 100644 index 0000000000..e4a0bf4f90 --- /dev/null +++ b/releasenotes/notes/bug-1691545-1acd6512effbdffb.yaml @@ -0,0 +1,10 @@ +--- +fixes: + - | + Fixes `bug 1691545`_ in which there was a significant increase in database + connections because of the way connections to cell databases were being + established. With this fix, objects related to database connections are + cached in the API service and reused to prevent new connections being + established for every communication with cell databases. + + .. _bug 1691545: https://bugs.launchpad.net/nova/+bug/1691545 |