SDN journal and maintenance threads use SELECT FOR UPDATE

Bug #1797118 reported by Mark Goddard
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mellanox backend integration with Neutron (networking-mlnx)
New
Undecided
Unassigned

Bug Description

The SDN journal and maintenance threads perform DB queries using the 'SELECT FOR UPDATE' SQL syntax, generated via the sqlalchemy .with_for_update() method [1]. This type of query can have negative consequences when used with a multi-writer Galera cluster, see [2].

[1] https://docs.sqlalchemy.org/en/latest/orm/query.html#sqlalchemy.orm.query.Query.with_for_update
[2] http://www.joinfu.com/2015/01/understanding-reservations-concurrency-locking-in-nova/

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.