← Back to team overview

yahoo-eng-team team mailing list archive

  1. yahoo-eng-team team
  2. Mailing list archive
  3. Message #69930

[Bug 1738337] [NEW] [neutron-db] neutron-server report error "UPDATE statement on table 'standardattributes' expected to update 1 row(s); 0 were matched'

  Thread Previous • Date Previous • • Thread Next 
Public bug reported:

4124:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api [req-3a38738f-efbf-45b0-ae65-3af84f6aae2c - - - - -] DB exceeded retry limit.: StaleDataError: UPDATE statement on table 'standardattributes' expected to update 1 row(s); 0 were matched.
4125:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api Traceback (most recent call last):
4126:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 138, in wrapper
4127:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     return f(*args, **kwargs)
4128:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 128, in wrapped
4129:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     LOG.debug("Retry wrapper got retriable exception: %s", e)
4130:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
4131:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     self.force_reraise()
4132:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
4133:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     six.reraise(self.type_, self.value, self.tb)
4134:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 124, in wrapped
4135:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     return f(*dup_args, **dup_kwargs)
4136:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 1702, in update_port_statuses
4137:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     context, port_dbs_by_id[port_id], status, host)
4138:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 1714, in _safe_update_individual_port_db_status
4139:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     ectx.reraise = bool(db.get_port(context, port_id))
4140:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
4141:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     self.force_reraise()
4142:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
4143:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     six.reraise(self.type_, self.value, self.tb)
4144:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 1710, in _safe_update_individual_port_db_status
4145:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     context, port, status, host)
4146:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 1769, in _update_individual_port_db_status
4147:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     levels = db.get_binding_levels(context, port_id, host)
4148:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 979, in wrapper
4149:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     return fn(*args, **kwargs)
4150:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/db.py", line 100, in get_binding_levels
4151:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     order_by(models.PortBindingLevel.level).
4152:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2703, in all
4153:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     return list(self)
4154:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2854, in __iter__
4155:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     self.session._autoflush()
4156:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 1397, in _autoflush
4157:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     self.flush()
4158:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2171, in flush
4159:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     self._flush(objects)
4160:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2291, in _flush
4161:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     transaction.rollback(_capture_exception=True)
4162:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__
4163:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     compat.reraise(exc_type, exc_value, exc_tb)
4164:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2255, in _flush
4165:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     flush_context.execute()
4166:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 389, in execute
4167:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     rec.execute(self)
4168:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 548, in execute
4169:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     uow
4170:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 177, in save_obj
4171:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     mapper, table, update)
4172:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 760, in _emit_update_statements
4173:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     (table.description, len(records), rows))
4174:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api StaleDataError: UPDATE statement on table 'standardattributes' expected to update 1 row(s); 0 were matched.
4175:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api 
4176:2017-09-19 17:10:15.216 10600 ERROR neutron.plugins.ml2.rpc [req-3a38738f-efbf-45b0-ae65-3af84f6aae2c - - - - -] Failed to update device 4bd345c4-c8bd-43ff-9525-dbf3e4656c40 up: StaleDataError: UPDATE statement on table 'standardattributes' expected to update 1 row(s); 0 were matched.

** Affects: neutron
     Importance: Undecided
         Status: New


** Tags: db

** Tags added: db

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

Title:
  [neutron-db] neutron-server report error "UPDATE statement on table
  'standardattributes' expected to update 1 row(s); 0 were matched'

Status in neutron:
  New

Bug description:
  4124:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api [req-3a38738f-efbf-45b0-ae65-3af84f6aae2c - - - - -] DB exceeded retry limit.: StaleDataError: UPDATE statement on table 'standardattributes' expected to update 1 row(s); 0 were matched.
  4125:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api Traceback (most recent call last):
  4126:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 138, in wrapper
  4127:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     return f(*args, **kwargs)
  4128:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 128, in wrapped
  4129:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     LOG.debug("Retry wrapper got retriable exception: %s", e)
  4130:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
  4131:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     self.force_reraise()
  4132:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
  4133:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     six.reraise(self.type_, self.value, self.tb)
  4134:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 124, in wrapped
  4135:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     return f(*dup_args, **dup_kwargs)
  4136:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 1702, in update_port_statuses
  4137:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     context, port_dbs_by_id[port_id], status, host)
  4138:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 1714, in _safe_update_individual_port_db_status
  4139:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     ectx.reraise = bool(db.get_port(context, port_id))
  4140:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
  4141:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     self.force_reraise()
  4142:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
  4143:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     six.reraise(self.type_, self.value, self.tb)
  4144:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 1710, in _safe_update_individual_port_db_status
  4145:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     context, port, status, host)
  4146:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 1769, in _update_individual_port_db_status
  4147:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     levels = db.get_binding_levels(context, port_id, host)
  4148:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 979, in wrapper
  4149:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     return fn(*args, **kwargs)
  4150:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/db.py", line 100, in get_binding_levels
  4151:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     order_by(models.PortBindingLevel.level).
  4152:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2703, in all
  4153:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     return list(self)
  4154:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2854, in __iter__
  4155:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     self.session._autoflush()
  4156:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 1397, in _autoflush
  4157:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     self.flush()
  4158:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2171, in flush
  4159:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     self._flush(objects)
  4160:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2291, in _flush
  4161:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     transaction.rollback(_capture_exception=True)
  4162:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__
  4163:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     compat.reraise(exc_type, exc_value, exc_tb)
  4164:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2255, in _flush
  4165:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     flush_context.execute()
  4166:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 389, in execute
  4167:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     rec.execute(self)
  4168:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 548, in execute
  4169:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     uow
  4170:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 177, in save_obj
  4171:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     mapper, table, update)
  4172:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 760, in _emit_update_statements
  4173:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api     (table.description, len(records), rows))
  4174:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api StaleDataError: UPDATE statement on table 'standardattributes' expected to update 1 row(s); 0 were matched.
  4175:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api 
  4176:2017-09-19 17:10:15.216 10600 ERROR neutron.plugins.ml2.rpc [req-3a38738f-efbf-45b0-ae65-3af84f6aae2c - - - - -] Failed to update device 4bd345c4-c8bd-43ff-9525-dbf3e4656c40 up: StaleDataError: UPDATE statement on table 'standardattributes' expected to update 1 row(s); 0 were matched.

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

Follow ups

  Thread Previous • Date Previous • • Thread Next