[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.su
bnet_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
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
