yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1738337] Re: [neutron-db] neutron-server report error "UPDATE statement on table 'standardattributes' expected to update 1 row(s); 0 were matched'. It will be caused the ovs flow miss

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Brian Haley <1738337@xxxxxxxxxxxxxxxxxx>
Date: Fri, 06 Jan 2023 22:42:29 -0000
Reply-to: Bug 1738337 <1738337@xxxxxxxxxxxxxxxxxx>
Sender: noreply@xxxxxxxxxxxxx
*** This bug is a duplicate of bug 1716321 ***
    https://bugs.launchpad.net/bugs/1716321

** This bug has been marked a duplicate of bug 1716321
   StaleDataError: UPDATE statement on table 'standardattributes' expected to update 1 row(s); 0 were matched.

-- 
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'. It
  will be caused the ovs flow miss

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
References

[Bug 1738337] [NEW] [neutron-db] neutron-server report error "UPDATE statement on table 'standardattributes' expected to update 1 row(s); 0 were matched'
From: Zachary Ma, 2017-12-15