yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1451492] Re: DELETE /v2.0/ports/uuid.json causes SQL error in log

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Launchpad Bug Tracker <1451492@xxxxxxxxxxxxxxxxxx>
Date: Mon, 17 Oct 2016 04:19:50 -0000
Reply-to: Bug 1451492 <1451492@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/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
References

[Bug 1451492] [NEW] DELETE /v2.0/ports/uuid.json causes SQL error in log
From: jason bishop, 2015-05-04