Bug 1776950

Summary: [rhos-prio] StaleDataError: UPDATE statement on table 'standardattributes' expected to update 1 row(s); 0 were matched when creating a lot of security group rules through heat
Product: Red Hat OpenStack Reporter: ffernand <ffernand>
Component: openstack-neutronAssignee: ffernand <ffernand>
Status: CLOSED ERRATA QA Contact: Candido Campos <ccamposr>
Severity: urgent Docs Contact:
Priority: urgent    
Version: 13.0 (Queens)CC: amuller, bhaley, ccamposr, chrisw, coldford, dalvarez, dvd, fressi, jamsmith, jschluet, njohnston, scohen, skaplons, vkommadi
Target Milestone: z10Keywords: Triaged, ZStream
Target Release: 13.0 (Queens)   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: openstack-neutron-12.1.0-5.el7ost Doc Type: Bug Fix
Doc Text:
This update fixes a condition that sometimes generated error messages during rapid updates to certain resource types. The OpenStack database field that ensures ordered application of changes sometimes got out of sync, causing the generation of error messages such as "StaleDataError: UPDATE statement on table 'standardattributes' expected to update 1 row(s); 0 were matched." Updates are now made in bulk, so the error should not be generated even in extremely rapid update scenarios.
Story Points: ---
Clone Of: 1665239 Environment:
Last Closed: 2020-03-10 11:26:15 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On: 1665239, 1671406    
Bug Blocks: 1667257    

Comment 13 errata-xmlrpc 2020-03-10 11:26:15 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHBA-2020:0770