Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1491815

Summary:	DBReferenceError: 'Cannot add or update a child row: a foreign key constraint fails
Product:	Red Hat OpenStack	Reporter:	Sai Sindhur Malleni <smalleni>
Component:	python-networking-odl	Assignee:	Itzik Brown <itbrown>
Status:	CLOSED WORKSFORME	QA Contact:	Itzik Brown <itbrown>
Severity:	low	Docs Contact:
Priority:	low
Version:	12.0 (Pike)	CC:	mkolesni, nyechiel, smalleni, tvignaud
Target Milestone:	ga	Keywords:	Triaged
Target Release:	12.0 (Pike)
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	python-networking-odl-11.0.1-0.20171017155938.a0cb8d9.el7ost	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:	N/A
Last Closed:	2017-12-13 12:50:04 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Sai Sindhur Malleni 2017-09-14 18:21:35 UTC

Description of problem:

We see stack trace as following https://gist.github.com/smalleni/a6eb01825e708c8e9d6974537444170a when running some performance and scale tests of creating neutron resources.

Version-Release number of selected component (if applicable):
python-networking-odl-11.0.0-0.20170806093629.2e78dca.el7ost.noarch
OSP 12

How reproducible:
100%

Steps to Reproduce:
1. Create bunch of neutron resources
2.
3.

Actual results:
DBReferenceErrors on logs

Expected results:
No errors

Additional info:

Comment 1 Michel Peterson 2017-10-15 13:43:46 UTC

This was fixed in https://review.openstack.org/#/c/498881/ and backported on Sep-13. Once a new package that includes the backport is used, this should not appear anymore.

Comment 3 Itzik Brown 2017-11-19 07:39:47 UTC

Hi,
Can you please suggest how to verify? 
What rally test and what spec have you used?

Comment 5 Itzik Brown 2017-12-13 12:50:04 UTC

I don't see DBReferenceError when running tempest tests.
If you experience such errors again please supply information how to reproduce it.

Checked with:
python-networking-odl-11.0.0-2.el7ost.noarch