StaleDataError: UPDATE statement on table 'standardattributes' expected to update 1 row(s); 0 were matched.
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
neutron |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
I have manually setup an HA/DVR deployment of OpenStack Pike on Ubuntu 16.04. The neutron.log gives me periodallcy the following exception:
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api [req-ed871530-
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api Traceback (most recent call last):
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api return f(*args, **kwargs)
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api LOG.debug("Retry wrapper got retriable exception: %s", e)
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api self.force_
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api six.reraise(
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api return f(*dup_args, **dup_kwargs)
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api context, port_dbs_
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api ectx.reraise = bool(db.
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api self.force_
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api six.reraise(
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api context, port, status, host)
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api updated = True
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api self.gen.next()
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api yield resource
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api self.gen.next()
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api self.session.
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api self.force_
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api six.reraise(
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api self._end_
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api session.commit()
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api self.transactio
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api self._prepare_
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api self.session.
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api self._flush(
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api transaction.
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api compat.
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api flush_context.
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api rec.execute(self)
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api uow
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api mapper, table, update)
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api File "/usr/lib/
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api (table.description, len(records), rows))
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api StaleDataError: UPDATE statement on table 'standardattrib
2017-09-11 07:50:34.655 5830 ERROR oslo_db.api
2017-09-11 07:50:34.657 5830 ERROR neutron.
I am using MariaDB:
$ mysql --version
mysql Ver 15.1 Distrib 10.1.26-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
I can also offer you an abstract from the database showing that all relevant information is available:
INSERT INTO `ports` (`project_id`, `id`, `name`, `network_id`, `mac_address`, `admin_state_up`, `status`, `device_id`, `device_owner`, `standard_attr_id`, `ip_allocation`) VALUES ('ed2d2efd86dd4
INSERT INTO `standardattrib
Can someone please have a look on this issue.
I think there is a fix that was proposed by @kevinbenton for this.