yahoo-eng-team team mailing list archive

Thread
Date

[Bug 1184484] Re: Quantum default settings will cause deadlocks due to overflow of sqlalchemy_pool

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>
Date: Thu, 05 Sep 2013 15:43:52 -0000
Reply-to: Bug 1184484 <1184484@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx

** Changed in: neutron
       Status: Fix Committed => Fix Released

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1184484

Title:
  Quantum default settings will cause deadlocks due to overflow of
  sqlalchemy_pool

Status in OpenStack Neutron (virtual network service):
  Fix Released
Status in tripleo - openstack on openstack:
  Fix Released

Bug description:
  quantum-server by default will create an sqlalchemy_pool of 5
  connections. This will start to fail as more and more data and compute
  nodes are added. Raising it to 40 seems to stop the problem, it may
  need to go higher. Raising it to 20 still results in:

  TimeoutError: QueuePool limit of size 20 overflow 10 reached,
  connection timed out, timeout 30

  Raising it to 40 seems to have restored responsiveness. I suspect it
  may be too low as the number of clients increases.

  [DATABASE]
  sqlalchemy_pool_size = 40

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1184484/+subscriptions