yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1611596] [NEW] recent routerports unique key change broke out-of-tree plugins

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: YAMAMOTO Takashi <yamamoto@xxxxxxxxxxxx>
Date: Wed, 10 Aug 2016 04:22:23 -0000
Reply-to: Bug 1611596 <1611596@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

recent change [1] broke out-of-tree plugins which uses surrounding transactions.
eg. networking-midonet

[1] I15be35689ec59ac02ed34abe5862fa4580c8587c

eg. http://logs.openstack.org/40/353140/1/check/gate-networking-midonet-
python35/4099ec1/testr_results.html.gz

Traceback (most recent call last):
  File "/tmp/openstack/neutron/neutron/api/v2/resource.py", line 79, in resource
    result = method(request=request, **args)
  File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/oslo_db/api.py", line 151, in wrapper
    ectxt.value = e.inner_exc
  File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/oslo_utils/excutils.py", line 220, in __exit__
    self.force_reraise()
  File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
    six.reraise(self.type_, self.value, self.tb)
  File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/six.py", line 686, in reraise
    raise value
  File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/oslo_db/api.py", line 139, in wrapper
    return f(*args, **kwargs)
  File "/tmp/openstack/neutron/neutron/db/api.py", line 74, in wrapped
    traceback.format_exc())
  File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/oslo_utils/excutils.py", line 220, in __exit__
    self.force_reraise()
  File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
    six.reraise(self.type_, self.value, self.tb)
  File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/six.py", line 686, in reraise
    raise value
  File "/tmp/openstack/neutron/neutron/db/api.py", line 69, in wrapped
    return f(*args, **kwargs)
  File "/tmp/openstack/neutron/neutron/api/v2/base.py", line 217, in _handle_action
    ret_value = getattr(self._plugin, name)(*arg_list, **kwargs)
  File "/home/jenkins/workspace/gate-networking-midonet-python35/midonet/neutron/plugin_v1.py", line 388, in add_router_interface
    context, router_id, interface_info)
  File "/tmp/openstack/neutron/neutron/db/l3_db.py", line 1766, in add_router_interface
    context, router_id, interface_info)
  File "/tmp/openstack/neutron/neutron/db/l3_db.py", line 807, in add_router_interface
    port_id=port['id']).one()
  File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/sqlalchemy/orm/query.py", line 2718, in one
    ret = list(self)
  File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/sqlalchemy/orm/query.py", line 2761, in __iter__
    return self._execute_and_instances(context)
  File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/sqlalchemy/orm/query.py", line 2774, in _execute_and_instances
    close_with_result=True)
  File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/sqlalchemy/orm/query.py", line 2765, in _connection_from_session
    **kw)
  File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 893, in connection
    execution_options=execution_options)
  File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 898, in _connection_for_bind
    engine, execution_options)
  File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 313, in _connection_for_bind
    self._assert_active()
  File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 218, in _assert_active
    "This Session's transaction has been rolled back "
sqlalchemy.exc.InvalidRequestError: This Session's transaction has been rolled back by a nested rollback() call.  To begin a new transaction, issue Session.rollback() first.
}}}

** Affects: networking-midonet
     Importance: Critical
     Assignee: YAMAMOTO Takashi (yamamoto)
         Status: New

** Affects: neutron
     Importance: Undecided
         Status: New


** Tags: gate-failure

** Also affects: networking-midonet
   Importance: Undecided
       Status: New

** Changed in: networking-midonet
   Importance: Undecided => Critical

** Changed in: networking-midonet
     Assignee: (unassigned) => YAMAMOTO Takashi (yamamoto)

** Tags added: gate-failure

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

Title:
  recent routerports unique key change broke out-of-tree plugins

Status in networking-midonet:
  New
Status in neutron:
  New

Bug description:
  recent change [1] broke out-of-tree plugins which uses surrounding transactions.
  eg. networking-midonet

  [1] I15be35689ec59ac02ed34abe5862fa4580c8587c

  eg. http://logs.openstack.org/40/353140/1/check/gate-networking-
  midonet-python35/4099ec1/testr_results.html.gz

  Traceback (most recent call last):
    File "/tmp/openstack/neutron/neutron/api/v2/resource.py", line 79, in resource
      result = method(request=request, **args)
    File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/oslo_db/api.py", line 151, in wrapper
      ectxt.value = e.inner_exc
    File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/oslo_utils/excutils.py", line 220, in __exit__
      self.force_reraise()
    File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
      six.reraise(self.type_, self.value, self.tb)
    File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/six.py", line 686, in reraise
      raise value
    File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/oslo_db/api.py", line 139, in wrapper
      return f(*args, **kwargs)
    File "/tmp/openstack/neutron/neutron/db/api.py", line 74, in wrapped
      traceback.format_exc())
    File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/oslo_utils/excutils.py", line 220, in __exit__
      self.force_reraise()
    File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
      six.reraise(self.type_, self.value, self.tb)
    File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/six.py", line 686, in reraise
      raise value
    File "/tmp/openstack/neutron/neutron/db/api.py", line 69, in wrapped
      return f(*args, **kwargs)
    File "/tmp/openstack/neutron/neutron/api/v2/base.py", line 217, in _handle_action
      ret_value = getattr(self._plugin, name)(*arg_list, **kwargs)
    File "/home/jenkins/workspace/gate-networking-midonet-python35/midonet/neutron/plugin_v1.py", line 388, in add_router_interface
      context, router_id, interface_info)
    File "/tmp/openstack/neutron/neutron/db/l3_db.py", line 1766, in add_router_interface
      context, router_id, interface_info)
    File "/tmp/openstack/neutron/neutron/db/l3_db.py", line 807, in add_router_interface
      port_id=port['id']).one()
    File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/sqlalchemy/orm/query.py", line 2718, in one
      ret = list(self)
    File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/sqlalchemy/orm/query.py", line 2761, in __iter__
      return self._execute_and_instances(context)
    File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/sqlalchemy/orm/query.py", line 2774, in _execute_and_instances
      close_with_result=True)
    File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/sqlalchemy/orm/query.py", line 2765, in _connection_from_session
      **kw)
    File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 893, in connection
      execution_options=execution_options)
    File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 898, in _connection_for_bind
      engine, execution_options)
    File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 313, in _connection_for_bind
      self._assert_active()
    File "/home/jenkins/workspace/gate-networking-midonet-python35/.tox/py35/lib/python3.5/site-packages/sqlalchemy/orm/session.py", line 218, in _assert_active
      "This Session's transaction has been rolled back "
  sqlalchemy.exc.InvalidRequestError: This Session's transaction has been rolled back by a nested rollback() call.  To begin a new transaction, issue Session.rollback() first.
  }}}

To manage notifications about this bug go to:
https://bugs.launchpad.net/networking-midonet/+bug/1611596/+subscriptions
Follow ups

[Bug 1611596] Re: recent routerports unique key change broke out-of-tree plugins
From: Armando Migliaccio, 2016-08-22