[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/1451492
Title:
DELETE /v2.0/ports/uuid.json causes SQL error in log
Status in neutron:
Expired
Bug description:
I'm running 20 tempest test_server_basic_ops scenario tests at same time and
after a few iterations it will fail during teardown with this stack:
2015-05-04 08:57:25.769 20904 ERROR neutron.api.v2.resource
[req-15065032-6513-4433-81b8-89bc53ea8c6a None] delete failed
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource Traceback (most
recent call last):
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/neutron/api/v2/resource.py", line 87, in
resource
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource result =
method(request=request, **args)
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/neutron/api/v2/base.py", line 476, in delete
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource
obj_deleter(request.context, id, **kwargs)
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/neutron/plugins/ml2/plugin.py", line 1019, in
delete_port
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource context, id,
do_notify=False)
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/neutron/db/l3_dvr_db.py", line 203, in
disassociate_floatingips
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource
do_notify=do_notify)
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/neutron/db/l3_db.py", line 1185, in
disassociate_floatingips
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource context,
port_id)
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/neutron/db/l3_db.py", line 915, in
disassociate_floatingips
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource 'router_id':
None})
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 470, in
__exit__
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource
self.rollback()
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in
__exit__
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource
compat.reraise(exc_type, exc_value, exc_tb)
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 467, in
__exit__
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource self.commit()
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 377, in
commit
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource
self._prepare_impl()
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 357, in
_prepare_impl
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource
self.session.flush()
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1919, in
flush
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource
self._flush(objects)
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2037, in
_flush
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource
transaction.rollback(_capture_exception=True)
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in
__exit__
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource
compat.reraise(exc_type, exc_value, exc_tb)
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2001, in
_flush
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource
flush_context.execute()
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 372, in
execute
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource
rec.execute(self)
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 526, in
execute
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource uow
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 60, in
save_obj
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource mapper,
table, update)
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 536, in
_emit_update_statements
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource
(table.description, len(update), rows))
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource StaleDataError:
UPDATE statement on table 'floatingips' expected to update 1 row(s); 0 were
matched.
2015-05-04 08:57:25.769 20904 TRACE neutron.api.v2.resource
2015-05-04 08:57:25.776 20905 INFO urllib3.connectionpool [-] Starting new
HTTP connection (1): 172.17.206.35
2015-05-04 08:57:25.778 20904 INFO neutron.wsgi
[req-15065032-6513-4433-81b8-89bc53ea8c6a None] 172.17.206.34 - - [04/May/2015
08:57:25] "DELETE /v2.0/ports/8b204abc-ac3d-46f3-886e-1688467f3a73.json
HTTP/1.1" 500 359 0.600022
To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1451492/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
