Comment 4 for bug 1710589

Revision history for this message
Zachary Ma (mazengxie) wrote :

In my environment,
The neutron-server log also prints the following error message.
"UPDATE statement on table 'standardattributes' expected to update 1 row(s); 0 were matched."
[Logs]
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.