yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1198799] Re: Neutron add_router_interface Error, SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Launchpad Bug Tracker <1198799@xxxxxxxxxxxxxxxxxx>
Date: Sun, 29 Nov 2015 04:17:38 -0000
Reply-to: Bug 1198799 <1198799@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/1198799

Title:
  Neutron add_router_interface Error, SELECT FOR UPDATE/SHARE cannot be
  applied to the nullable side of an outer join

Status in neutron:
  Expired

Bug description:
  2013-07-08 12:30:46.514 23374 ERROR quantum.api.v2.resource [-] add_router_interface failed
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource Traceback (most recent call last):
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource   File "/home/trystack/quantum/quantum/api/v2/resource.py", line 82, in resource
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource     result = method(request=request, **args)
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource   File "/home/trystack/quantum/quantum/api/v2/base.py", line 184, in _handle_action
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource     return getattr(self._plugin, name)(*arg_list, **kwargs)
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource   File "/home/trystack/quantum/quantum/db/l3_db.py", line 382, in add_router_interface
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource     'name': ''}})
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource   File "/home/trystack/quantum/quantum/plugins/openvswitch/ovs_quantum_plugin.py", line 522, in create_port
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource     port = super(OVSQuantumPluginV2, self).create_port(context, port)
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource   File "/home/trystack/quantum/quantum/db/db_base_plugin_v2.py", line 1344, in create_port
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource     ips = self._allocate_ips_for_port(context, network, port)
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource   File "/home/trystack/quantum/quantum/db/db_base_plugin_v2.py", line 723, in _allocate_ips_for_port
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource     ips = self._allocate_fixed_ips(context, network, configured_ips)
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource   File "/home/trystack/quantum/quantum/db/db_base_plugin_v2.py", line 658, in _allocate_fixed_ips
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource     context, fixed['subnet_id'], fixed['ip_address'])
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource   File "/home/trystack/quantum/quantum/db/db_base_plugin_v2.py", line 511, in _allocate_specific_ip
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource     for (range, pool) in results:
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2227, in __iter__
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource     return self._execute_and_instances(context)
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2242, in _execute_and_instances
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource     result = conn.execute(querycontext.statement, self._params)
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource     params)
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource     compiled_sql, distilled_params
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource     context)
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource     context)
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource     cursor.execute(statement, parameters)
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource NotSupportedError: (NotSupportedError) SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource  'SELECT ipavailabilityranges.allocation_pool_id AS ipavailabilityranges_allocation_pool_id, ipavailabilityranges.first_ip AS ipavailabilityranges_first_ip, ipavailabilityranges.last_ip AS ipavailabilityranges_last_ip, ipallocationpools.id AS ipallocationpools_id, ipallocationpools.subnet_id AS ipallocationpools_subnet_id, ipallocationpools.first_ip AS ipallocationpools_first_ip, ipallocationpools.last_ip AS ipallocationpools_last_ip, ipavailabilityranges_1.allocation_pool_id AS ipavailabilityranges_1_allocation_pool_id, ipavailabilityranges_1.first_ip AS ipavailabilityranges_1_first_ip, ipavailabilityranges_1.last_ip AS ipavailabilityranges_1_last_ip \nFROM ipavailabilityranges JOIN ipallocationpools ON ipallocationpools.id = ipavailabilityranges.allocation_pool_id LEFT OUTER JOIN ipavailabilityranges AS ipavailabilityranges_1 ON ipallocationpools.id = ipavailabilityranges_1.allocation_pool_id \nWHERE ipallocationpools.subnet_id = %(subnet_id_1)s FOR UPDATE' {'subnet_id_1': u'e6d8bc42-533f-4f0e-808e-ce58fec3738f'}
  2013-07-08 12:30:46.514 23374 TRACE quantum.api.v2.resource

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