neutron

configuration of QueuePool not possible

Bug #1158235 reported by Christian Berendt
16
This bug affects 2 people
Affects Status Importance Assigned to Milestone
neutron
Fix Released
Low
Christian Berendt
neutron 2013.2 "havana"

Bug Description

It's not possible to change the size and overflow parameters of the SQLAlchemy QueuePool. It's only possible when using the MySQL pool of eventlet.

I received a lot of exceptions in the Quantum server log (using the OVS plugin):

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

After manually setting the pool_size=20 and max_overflow=50 everything is working fine.

I suggest adding two new parameters: sqlalchemy_pool_size and sqlalchemy_max_overflow to be able to configure the QueuePool.

Tags: db
Revision history for this message
Eugene Nikanorov (enikanorov) wrote :

Please specify which version of the quantum code are you using.
Also please specify conditions which have lead to exceptions.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to quantum (master)

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

Changed in quantum:
assignee: nobody → Christian Berendt (berendt)
status: New → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to quantum (master)

Reviewed: https://review.openstack.org/24986
Committed: http://github.com/openstack/quantum/commit/55f2e16178e55bb5a7e3a379f28a020305462005
Submitter: Jenkins
Branch: master

commit 55f2e16178e55bb5a7e3a379f28a020305462005
Author: Christian Berendt <email address hidden>
Date: Thu Mar 21 12:06:33 2013 +0100

    adding parameter to configure QueuePool in SQLAlchemy

    This patch introduces the parameter sqlalchemy_pool_size.
    The parameter is used to configure the QueuePool, created
    in configure_db(). At the moment the configuration of the
    pool is only possible when using eventlet's db_pool for
    MySQL (sql_dbpool_enable = True).

    Change-Id: I64dec2863c1ee88215ef9b28054ba3bfaafa3b32
    fixes: bug #1158235

Changed in quantum:
status: In Progress → Fix Committed
Mark McClain (markmcclain)
Changed in quantum:
milestone: none → havana-1
importance: Undecided → Low
tags: added: db
Revision history for this message
Aaron Rosen (arosen) wrote :

In my opinion I think we should also backport this to grizzly. What do you guys think?

Thierry Carrez (ttx)
Changed in quantum:
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in neutron:
milestone: havana-1 → 2013.2
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.