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.
In my environment, utes' expected to update 1 row(s); 0 were matched." efbf-45b0- ae65-3af84f6aae 2c - - - - -] DB exceeded retry limit.: StaleDataError: UPDATE statement on table 'standardattrib utes' expected to update 1 row(s); 0 were matched. python2. 7/site- packages/ oslo_db/ api.py" , line 138, in wrapper python2. 7/site- packages/ neutron/ db/api. py", line 128, in wrapped python2. 7/site- packages/ oslo_utils/ excutils. py", line 220, in _exit_ reraise( ) python2. 7/site- packages/ oslo_utils/ excutils. py", line 196, in force_reraise self.type_ , self.value, self.tb) python2. 7/site- packages/ neutron/ db/api. py", line 124, in wrapped python2. 7/site- packages/ neutron/ plugins/ ml2/plugin. py", line 1702, in update_ port_statuses by_id[port_ id], status, host) python2. 7/site- packages/ neutron/ plugins/ ml2/plugin. py", line 1714, in _safe_update_ individual_ port_db_ status get_port( context, port_id)) python2. 7/site- packages/ oslo_utils/ excutils. py", line 220, in _exit_ reraise( ) python2. 7/site- packages/ oslo_utils/ excutils. py", line 196, in force_reraise self.type_ , self.value, self.tb) python2. 7/site- packages/ neutron/ plugins/ ml2/plugin. py", line 1710, in _safe_update_ individual_ port_db_ status python2. 7/site- packages/ neutron/ plugins/ ml2/plugin. py", line 1769, in _update_ individual_ port_db_ status binding_ levels( context, port_id, host) python2. 7/site- packages/ oslo_db/ sqlalchemy/ enginefacade. py", line 979, in wrapper python2. 7/site- packages/ neutron/ plugins/ ml2/db. py", line 100, in get_binding_levels models. PortBindingLeve l.level) . python2. 7/site- packages/ sqlalchemy/ orm/query. py", line 2703, in all python2. 7/site- packages/ sqlalchemy/ orm/query. py", line 2854, in _iter_ _autoflush( ) python2. 7/site- packages/ sqlalchemy/ orm/session. py", line 1397, in _autoflush python2. 7/site- packages/ sqlalchemy/ orm/session. py", line 2171, in flush objects) python2. 7/site- packages/ sqlalchemy/ orm/session. py", line 2291, in _flush rollback( _capture_ exception= True) python2. 7/site- packages/ sqlalchemy/ util/langhelper s.py", line 66, in _exit_ reraise( exc_type, exc_value, exc_tb) python2. 7/site- packages/ sqlalchemy/ orm/session. py", line 2255, in _flush execute( ) python2. 7/site- packages/ sqlalchemy/ orm/unitofwork. py", line 389, in execute python2. 7/site- packages/ sqlalchemy/ orm/unitofwork. py", line 548, in execute python2. 7/site- packages/ sqlalchemy/ orm/persistence .py", line 177, in save_obj python2. 7/site- packages/ sqlalchemy/ orm/persistence .py", line 760, in _emit_update_ statements utes' expected to update 1 row(s); 0 were matched. plugins. ml2.rpc [req-3a38738f- efbf-45b0- ae65-3af84f6aae 2c - - - - -] Failed to update device 4bd345c4- c8bd-43ff- 9525-dbf3e4656c 40 up: StaleDataError: UPDATE statement on table 'standardattrib utes' expected to update 1 row(s); 0 were matched.
The neutron-server log also prints the following error message.
"UPDATE statement on table 'standardattrib
[Logs]
4124:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api [req-3a38738f-
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/
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/
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/
4131:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api self.force_
4132:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api File "/usr/lib/
4133:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api six.reraise(
4134:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api File "/usr/lib/
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/
4137:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api context, port_dbs_
4138:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api File "/usr/lib/
4139:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api ectx.reraise = bool(db.
4140:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api File "/usr/lib/
4141:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api self.force_
4142:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api File "/usr/lib/
4143:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api six.reraise(
4144:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api File "/usr/lib/
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/
4147:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api levels = db.get_
4148:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api File "/usr/lib/
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/
4151:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api order_by(
4152:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api File "/usr/lib64/
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/
4155:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api self.session.
4156:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api File "/usr/lib64/
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/
4159:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api self._flush(
4160:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api File "/usr/lib64/
4161:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api transaction.
4162:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api File "/usr/lib64/
4163:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api compat.
4164:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api File "/usr/lib64/
4165:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api flush_context.
4166:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api File "/usr/lib64/
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/
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/
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/
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 'standardattrib
4175:2017-09-19 17:10:15.211 10600 ERROR oslo_db.api
4176:2017-09-19 17:10:15.216 10600 ERROR neutron.