← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1681055] [NEW] delete network failed with ERROR ‘ DBError: Can't reconnect until invalid transaction is rolled back’

 

Public bug reported:

My env is Newton branch, i got a error when i delete a network, the
error log is below:

delete failed: Exception auto-deleting port 4213e9ef-2ea1-43f4-b0d4-ff54fce9031d
 Traceback (most recent call last):
   File "/usr/lib/python2.7/site-packages/neutron/api/v2/resource.py", line 79, in resource
     result = method(request=request, **args)
   File "/usr/lib/python2.7/site-packages/neutron/api/v2/base.py", line 555, in delete
     return self._delete(request, id, **kwargs)
   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 88, in wrapped
     setattr(e, '_RETRY_EXCEEDED', True)
   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
     self.force_reraise()
   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
     six.reraise(self.type_, self.value, self.tb)
   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 84, in wrapped
     return f(*args, **kwargs)
   File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 151, in wrapper
     ectxt.value = e.inner_exc
   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
     self.force_reraise()
   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
     six.reraise(self.type_, self.value, self.tb)
   File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 139, in wrapper
     return f(*args, **kwargs)
   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 124, in wrapped
     traceback.format_exc())
   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
     self.force_reraise()
   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
     six.reraise(self.type_, self.value, self.tb)
   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 119, in wrapped
     return f(*dup_args, **dup_kwargs)
   File "/usr/lib/python2.7/site-packages/neutron/api/v2/base.py", line 577, in _delete
     obj_deleter(request.context, id, **kwargs)
   File "/usr/lib/python2.7/site-packages/neutron/common/utils.py", line 756, in inner
     return f(self, context, *args, **kwargs)
   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 159, in wrapped
     return method(*args, **kwargs)
   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 88, in wrapped
     setattr(e, '_RETRY_EXCEEDED', True)
   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
     self.force_reraise()
   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
     six.reraise(self.type_, self.value, self.tb)
   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 84, in wrapped
     return f(*args, **kwargs)
   File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 151, in wrapper
     ectxt.value = e.inner_exc
   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
     self.force_reraise()
   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
     six.reraise(self.type_, self.value, self.tb)
   File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 139, in wrapper
     return f(*args, **kwargs)
   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 124, in wrapped
     traceback.format_exc())
   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
     self.force_reraise()
   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
     six.reraise(self.type_, self.value, self.tb)
   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 119, in wrapped
     return f(*dup_args, **dup_kwargs)
   File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 972, in delete_network
     self._delete_ports(context, port_ids)
   File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 878, in _delete_ports
     _LE("Exception auto-deleting port %s"), port_id)
   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
     self.force_reraise()
   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
     six.reraise(self.type_, self.value, self.tb)
   File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 869, in _delete_ports
     self.delete_port(context, port_id)
   File "/usr/lib/python2.7/site-packages/neutron/common/utils.py", line 756, in inner
     return f(self, context, *args, **kwargs)
   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 159, in wrapped
     return method(*args, **kwargs)
   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 88, in wrapped
     setattr(e, '_RETRY_EXCEEDED', True)
   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
     self.force_reraise()
   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
     six.reraise(self.type_, self.value, self.tb)
   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 84, in wrapped
     return f(*args, **kwargs)
   File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 151, in wrapper
     ectxt.value = e.inner_exc
   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
     self.force_reraise()
   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
     six.reraise(self.type_, self.value, self.tb)
   File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 139, in wrapper
     return f(*args, **kwargs)
   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 124, in wrapped
     traceback.format_exc())
   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
     self.force_reraise()
   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
     six.reraise(self.type_, self.value, self.tb)
   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 119, in wrapped
     return f(*dup_args, **dup_kwargs)
   File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 1628, in delete_port
     super(Ml2Plugin, self).delete_port(context, id)
   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 492, in __exit__
     self.rollback()
   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 419, in rollback
     transaction._rollback_impl()
   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 449, in _rollback_impl
     t[1].rollback()
   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1563, in rollback
     self._do_rollback()
   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1601, in _do_rollback
     self.connection._rollback_impl()
   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 662, in _rollback_impl
     self.dispatch.rollback(self)
   File "/usr/lib64/python2.7/site-packages/sqlalchemy/event/attr.py", line 256, in __call__
     fn(*args, **kw)
   File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/exc_filters.py", line 476, in pop_exc_tx
     conn.info.pop(ROLLBACK_CAUSE_KEY, None)
   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 425, in info
     return self.connection.info
   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 318, in connection
     self._handle_dbapi_exception(e, None, None, None, None)
   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
     util.raise_from_cause(newraise, exc_info)
   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
     reraise(type(exception), exception, tb=exc_tb, cause=cause)
   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 316, in connection
     return self._revalidate_connection()
   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 391, in _revalidate_connection
     "Can't reconnect until invalid "
 DBError: Can't reconnect until invalid transaction is rolled back

** Affects: neutron
     Importance: Undecided
         Status: New

** Description changed:

- My en is Newton branch, i got a error when i delete a network, the error
- log is below:
+ My env is Newton branch, i got a error when i delete a network, the
+ error log is below:
  
  delete failed: Exception auto-deleting port 4213e9ef-2ea1-43f4-b0d4-ff54fce9031d
-  Traceback (most recent call last):
-    File "/usr/lib/python2.7/site-packages/neutron/api/v2/resource.py", line 79, in resource
-      result = method(request=request, **args)
-    File "/usr/lib/python2.7/site-packages/neutron/api/v2/base.py", line 555, in delete
-      return self._delete(request, id, **kwargs)
-    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 88, in wrapped
-      setattr(e, '_RETRY_EXCEEDED', True)
-    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
-      self.force_reraise()
-    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
-      six.reraise(self.type_, self.value, self.tb)
-    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 84, in wrapped
-      return f(*args, **kwargs)
-    File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 151, in wrapper
-      ectxt.value = e.inner_exc
-    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
-      self.force_reraise()
-    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
-      six.reraise(self.type_, self.value, self.tb)
-    File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 139, in wrapper
-      return f(*args, **kwargs)
-    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 124, in wrapped
-      traceback.format_exc())
-    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
-      self.force_reraise()
-    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
-      six.reraise(self.type_, self.value, self.tb)
-    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 119, in wrapped
-      return f(*dup_args, **dup_kwargs)
-    File "/usr/lib/python2.7/site-packages/neutron/api/v2/base.py", line 577, in _delete
-      obj_deleter(request.context, id, **kwargs)
-    File "/usr/lib/python2.7/site-packages/neutron/common/utils.py", line 756, in inner
-      return f(self, context, *args, **kwargs)
-    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 159, in wrapped
-      return method(*args, **kwargs)
-    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 88, in wrapped
-      setattr(e, '_RETRY_EXCEEDED', True)
-    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
-      self.force_reraise()
-    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
-      six.reraise(self.type_, self.value, self.tb)
-    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 84, in wrapped
-      return f(*args, **kwargs)
-    File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 151, in wrapper
-      ectxt.value = e.inner_exc
-    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
-      self.force_reraise()
-    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
-      six.reraise(self.type_, self.value, self.tb)
-    File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 139, in wrapper
-      return f(*args, **kwargs)
-    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 124, in wrapped
-      traceback.format_exc())
-    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
-      self.force_reraise()
-    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
-      six.reraise(self.type_, self.value, self.tb)
-    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 119, in wrapped
-      return f(*dup_args, **dup_kwargs)
-    File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 972, in delete_network
-      self._delete_ports(context, port_ids)
-    File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 878, in _delete_ports
-      _LE("Exception auto-deleting port %s"), port_id)
-    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
-      self.force_reraise()
-    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
-      six.reraise(self.type_, self.value, self.tb)
-    File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 869, in _delete_ports
-      self.delete_port(context, port_id)
-    File "/usr/lib/python2.7/site-packages/neutron/common/utils.py", line 756, in inner
-      return f(self, context, *args, **kwargs)
-    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 159, in wrapped
-      return method(*args, **kwargs)
-    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 88, in wrapped
-      setattr(e, '_RETRY_EXCEEDED', True)
-    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
-      self.force_reraise()
-    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
-      six.reraise(self.type_, self.value, self.tb)
-    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 84, in wrapped
-      return f(*args, **kwargs)
-    File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 151, in wrapper
-      ectxt.value = e.inner_exc
-    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
-      self.force_reraise()
-    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
-      six.reraise(self.type_, self.value, self.tb)
-    File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 139, in wrapper
-      return f(*args, **kwargs)
-    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 124, in wrapped
-      traceback.format_exc())
-    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
-      self.force_reraise()
-    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
-      six.reraise(self.type_, self.value, self.tb)
-    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 119, in wrapped
-      return f(*dup_args, **dup_kwargs)
-    File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 1628, in delete_port
-      super(Ml2Plugin, self).delete_port(context, id)
-    File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 492, in __exit__
-      self.rollback()
-    File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 419, in rollback
-      transaction._rollback_impl()
-    File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 449, in _rollback_impl
-      t[1].rollback()
-    File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1563, in rollback
-      self._do_rollback()
-    File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1601, in _do_rollback
-      self.connection._rollback_impl()
-    File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 662, in _rollback_impl
-      self.dispatch.rollback(self)
-    File "/usr/lib64/python2.7/site-packages/sqlalchemy/event/attr.py", line 256, in __call__
-      fn(*args, **kw)
-    File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/exc_filters.py", line 476, in pop_exc_tx
-      conn.info.pop(ROLLBACK_CAUSE_KEY, None)
-    File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 425, in info
-      return self.connection.info
-    File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 318, in connection
-      self._handle_dbapi_exception(e, None, None, None, None)
-    File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
-      util.raise_from_cause(newraise, exc_info)
-    File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
-      reraise(type(exception), exception, tb=exc_tb, cause=cause)
-    File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 316, in connection
-      return self._revalidate_connection()
-    File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 391, in _revalidate_connection
-      "Can't reconnect until invalid "
-  DBError: Can't reconnect until invalid transaction is rolled back
+  Traceback (most recent call last):
+    File "/usr/lib/python2.7/site-packages/neutron/api/v2/resource.py", line 79, in resource
+      result = method(request=request, **args)
+    File "/usr/lib/python2.7/site-packages/neutron/api/v2/base.py", line 555, in delete
+      return self._delete(request, id, **kwargs)
+    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 88, in wrapped
+      setattr(e, '_RETRY_EXCEEDED', True)
+    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
+      self.force_reraise()
+    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
+      six.reraise(self.type_, self.value, self.tb)
+    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 84, in wrapped
+      return f(*args, **kwargs)
+    File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 151, in wrapper
+      ectxt.value = e.inner_exc
+    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
+      self.force_reraise()
+    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
+      six.reraise(self.type_, self.value, self.tb)
+    File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 139, in wrapper
+      return f(*args, **kwargs)
+    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 124, in wrapped
+      traceback.format_exc())
+    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
+      self.force_reraise()
+    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
+      six.reraise(self.type_, self.value, self.tb)
+    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 119, in wrapped
+      return f(*dup_args, **dup_kwargs)
+    File "/usr/lib/python2.7/site-packages/neutron/api/v2/base.py", line 577, in _delete
+      obj_deleter(request.context, id, **kwargs)
+    File "/usr/lib/python2.7/site-packages/neutron/common/utils.py", line 756, in inner
+      return f(self, context, *args, **kwargs)
+    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 159, in wrapped
+      return method(*args, **kwargs)
+    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 88, in wrapped
+      setattr(e, '_RETRY_EXCEEDED', True)
+    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
+      self.force_reraise()
+    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
+      six.reraise(self.type_, self.value, self.tb)
+    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 84, in wrapped
+      return f(*args, **kwargs)
+    File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 151, in wrapper
+      ectxt.value = e.inner_exc
+    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
+      self.force_reraise()
+    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
+      six.reraise(self.type_, self.value, self.tb)
+    File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 139, in wrapper
+      return f(*args, **kwargs)
+    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 124, in wrapped
+      traceback.format_exc())
+    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
+      self.force_reraise()
+    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
+      six.reraise(self.type_, self.value, self.tb)
+    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 119, in wrapped
+      return f(*dup_args, **dup_kwargs)
+    File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 972, in delete_network
+      self._delete_ports(context, port_ids)
+    File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 878, in _delete_ports
+      _LE("Exception auto-deleting port %s"), port_id)
+    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
+      self.force_reraise()
+    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
+      six.reraise(self.type_, self.value, self.tb)
+    File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 869, in _delete_ports
+      self.delete_port(context, port_id)
+    File "/usr/lib/python2.7/site-packages/neutron/common/utils.py", line 756, in inner
+      return f(self, context, *args, **kwargs)
+    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 159, in wrapped
+      return method(*args, **kwargs)
+    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 88, in wrapped
+      setattr(e, '_RETRY_EXCEEDED', True)
+    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
+      self.force_reraise()
+    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
+      six.reraise(self.type_, self.value, self.tb)
+    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 84, in wrapped
+      return f(*args, **kwargs)
+    File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 151, in wrapper
+      ectxt.value = e.inner_exc
+    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
+      self.force_reraise()
+    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
+      six.reraise(self.type_, self.value, self.tb)
+    File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 139, in wrapper
+      return f(*args, **kwargs)
+    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 124, in wrapped
+      traceback.format_exc())
+    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
+      self.force_reraise()
+    File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
+      six.reraise(self.type_, self.value, self.tb)
+    File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 119, in wrapped
+      return f(*dup_args, **dup_kwargs)
+    File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 1628, in delete_port
+      super(Ml2Plugin, self).delete_port(context, id)
+    File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 492, in __exit__
+      self.rollback()
+    File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 419, in rollback
+      transaction._rollback_impl()
+    File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 449, in _rollback_impl
+      t[1].rollback()
+    File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1563, in rollback
+      self._do_rollback()
+    File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1601, in _do_rollback
+      self.connection._rollback_impl()
+    File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 662, in _rollback_impl
+      self.dispatch.rollback(self)
+    File "/usr/lib64/python2.7/site-packages/sqlalchemy/event/attr.py", line 256, in __call__
+      fn(*args, **kw)
+    File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/exc_filters.py", line 476, in pop_exc_tx
+      conn.info.pop(ROLLBACK_CAUSE_KEY, None)
+    File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 425, in info
+      return self.connection.info
+    File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 318, in connection
+      self._handle_dbapi_exception(e, None, None, None, None)
+    File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
+      util.raise_from_cause(newraise, exc_info)
+    File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
+      reraise(type(exception), exception, tb=exc_tb, cause=cause)
+    File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 316, in connection
+      return self._revalidate_connection()
+    File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 391, in _revalidate_connection
+      "Can't reconnect until invalid "
+  DBError: Can't reconnect until invalid transaction is rolled back

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

Title:
  delete network  failed with ERROR ‘ DBError: Can't reconnect until
  invalid transaction is rolled back’

Status in neutron:
  New

Bug description:
  My env is Newton branch, i got a error when i delete a network, the
  error log is below:

  delete failed: Exception auto-deleting port 4213e9ef-2ea1-43f4-b0d4-ff54fce9031d
   Traceback (most recent call last):
     File "/usr/lib/python2.7/site-packages/neutron/api/v2/resource.py", line 79, in resource
       result = method(request=request, **args)
     File "/usr/lib/python2.7/site-packages/neutron/api/v2/base.py", line 555, in delete
       return self._delete(request, id, **kwargs)
     File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 88, in wrapped
       setattr(e, '_RETRY_EXCEEDED', True)
     File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
       self.force_reraise()
     File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
       six.reraise(self.type_, self.value, self.tb)
     File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 84, in wrapped
       return f(*args, **kwargs)
     File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 151, in wrapper
       ectxt.value = e.inner_exc
     File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
       self.force_reraise()
     File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
       six.reraise(self.type_, self.value, self.tb)
     File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 139, in wrapper
       return f(*args, **kwargs)
     File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 124, in wrapped
       traceback.format_exc())
     File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
       self.force_reraise()
     File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
       six.reraise(self.type_, self.value, self.tb)
     File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 119, in wrapped
       return f(*dup_args, **dup_kwargs)
     File "/usr/lib/python2.7/site-packages/neutron/api/v2/base.py", line 577, in _delete
       obj_deleter(request.context, id, **kwargs)
     File "/usr/lib/python2.7/site-packages/neutron/common/utils.py", line 756, in inner
       return f(self, context, *args, **kwargs)
     File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 159, in wrapped
       return method(*args, **kwargs)
     File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 88, in wrapped
       setattr(e, '_RETRY_EXCEEDED', True)
     File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
       self.force_reraise()
     File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
       six.reraise(self.type_, self.value, self.tb)
     File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 84, in wrapped
       return f(*args, **kwargs)
     File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 151, in wrapper
       ectxt.value = e.inner_exc
     File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
       self.force_reraise()
     File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
       six.reraise(self.type_, self.value, self.tb)
     File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 139, in wrapper
       return f(*args, **kwargs)
     File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 124, in wrapped
       traceback.format_exc())
     File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
       self.force_reraise()
     File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
       six.reraise(self.type_, self.value, self.tb)
     File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 119, in wrapped
       return f(*dup_args, **dup_kwargs)
     File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 972, in delete_network
       self._delete_ports(context, port_ids)
     File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 878, in _delete_ports
       _LE("Exception auto-deleting port %s"), port_id)
     File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
       self.force_reraise()
     File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
       six.reraise(self.type_, self.value, self.tb)
     File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 869, in _delete_ports
       self.delete_port(context, port_id)
     File "/usr/lib/python2.7/site-packages/neutron/common/utils.py", line 756, in inner
       return f(self, context, *args, **kwargs)
     File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 159, in wrapped
       return method(*args, **kwargs)
     File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 88, in wrapped
       setattr(e, '_RETRY_EXCEEDED', True)
     File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
       self.force_reraise()
     File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
       six.reraise(self.type_, self.value, self.tb)
     File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 84, in wrapped
       return f(*args, **kwargs)
     File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 151, in wrapper
       ectxt.value = e.inner_exc
     File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
       self.force_reraise()
     File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
       six.reraise(self.type_, self.value, self.tb)
     File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 139, in wrapper
       return f(*args, **kwargs)
     File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 124, in wrapped
       traceback.format_exc())
     File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
       self.force_reraise()
     File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
       six.reraise(self.type_, self.value, self.tb)
     File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 119, in wrapped
       return f(*dup_args, **dup_kwargs)
     File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 1628, in delete_port
       super(Ml2Plugin, self).delete_port(context, id)
     File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 492, in __exit__
       self.rollback()
     File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 419, in rollback
       transaction._rollback_impl()
     File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 449, in _rollback_impl
       t[1].rollback()
     File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1563, in rollback
       self._do_rollback()
     File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1601, in _do_rollback
       self.connection._rollback_impl()
     File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 662, in _rollback_impl
       self.dispatch.rollback(self)
     File "/usr/lib64/python2.7/site-packages/sqlalchemy/event/attr.py", line 256, in __call__
       fn(*args, **kw)
     File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/exc_filters.py", line 476, in pop_exc_tx
       conn.info.pop(ROLLBACK_CAUSE_KEY, None)
     File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 425, in info
       return self.connection.info
     File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 318, in connection
       self._handle_dbapi_exception(e, None, None, None, None)
     File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
       util.raise_from_cause(newraise, exc_info)
     File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
       reraise(type(exception), exception, tb=exc_tb, cause=cause)
     File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 316, in connection
       return self._revalidate_connection()
     File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 391, in _revalidate_connection
       "Can't reconnect until invalid "
   DBError: Can't reconnect until invalid transaction is rolled back

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


Follow ups