yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1136064] Re: quantum server consumes all of sqlalchemy sessions

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Launchpad Bug Tracker <1136064@xxxxxxxxxxxxxxxxxx>
Date: Sun, 29 Nov 2015 04:17:49 -0000
Reply-to: Bug 1136064 <1136064@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
[Expired for neutron because there has been no activity for 60 days.]

** Changed in: neutron
       Status: Incomplete => Expired

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

Title:
  quantum server consumes all of sqlalchemy sessions

Status in neutron:
  Expired

Bug description:
  2013-03-01 01:19:44.356 17363 DEBUG quantum.openstack.common.rpc.amqp [-] unpacked context: {'user_id': None, 'roles': [u'admin'], 'tenant_id': None, 'is_admin': True, 'timestamp': u'2013-02-28 17:19:35.268564', 'project_id': None, 'read_deleted': u'no'} _safe_log /mnt/data/git/quantum/quantum/openstack/common/rpc/common.py:254
  2013-03-01 01:19:44.450 17363 DEBUG quantum.db.dhcp_rpc_base [-] Network list requested from HostC get_active_networks /mnt/data/git/quantum/quantum/db/dhcp_rpc_base.py:35
  2013-03-01 01:19:44.454 17363 DEBUG quantum.scheduler.dhcp_agent_scheduler [-] No non-hosted networks auto_schedule_networks /mnt/data/git/quantum/quantum/scheduler/dhcp_agent_scheduler.py:101
  2013-03-01 01:19:44.491 17363 DEBUG quantum.plugins.openvswitch.ovs_db_v2 [-] get_port_with_securitygroups() called:port_id=ce9af4bb-970c-4869-81fd-1dd70d754cba get_port_from_device /mnt/data/git/quantum/quantum/plugins/openvswitch/ovs_db_v2.py:309
  2013-03-01 01:20:14.914 17363 ERROR quantum.openstack.common.rpc.amqp [-] Exception during message handling
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp Traceback (most recent call last):
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp   File "/mnt/data/git/quantum/quantum/openstack/common/rpc/amqp.py", line 429, in _process_data
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp     rval = self.proxy.dispatch(ctxt, version, method, **args)
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp   File "/mnt/data/git/quantum/quantum/common/rpc.py", line 43, in dispatch
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp     quantum_ctxt, version, method, **kwargs)
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp   File "/mnt/data/git/quantum/quantum/openstack/common/rpc/dispatcher.py", line 133, in dispatch
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp     return getattr(proxyobj, method)(ctxt, **kwargs)
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp   File "/mnt/data/git/quantum/quantum/db/agents_db.py", line 167, in report_state
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp     plugin.create_or_update_agent(context, agent_state)
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp   File "/mnt/data/git/quantum/quantum/db/agents_db.py", line 145, in create_or_update_agent
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp     context, agent['agent_type'], agent['host'])
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp   File "/mnt/data/git/quantum/quantum/db/agents_db.py", line 121, in _get_agent_by_type_and_host
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp     Agent.host == host).one()
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2184, in one
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp     ret = list(self)
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2227, in __iter__
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp     return self._execute_and_instances(context)
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2240, in _execute_and_instances
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp     close_with_result=True)
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2231, in _connection_from_session
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp     **kw)
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 777, in connection
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp     close_with_result=close_with_result)
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 781, in _connection_for_bind
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp     return self.transaction._connection_for_bind(engine)
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 306, in _connection_for_bind
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp     conn = bind.contextual_connect()
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2489, in contextual_connect
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp     self.pool.connect(),
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 236, in connect
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp     return _ConnectionFairy(self).checkout()
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 401, in __init__
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp     rec = self._connection_record = pool._do_get()
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 738, in _do_get
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp     (self.size(), self.overflow(), self._timeout))
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp TimeoutError: QueuePool limit of size 5 overflow 10 reached, connection timed out, timeout 30
  2013-03-01 01:20:14.914 17363 TRACE quantum.openstack.common.rpc.amqp

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