Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.
Bug 1491815 - DBReferenceError: 'Cannot add or update a child row: a foreign key constraint fails [NEEDINFO]
DBReferenceError: 'Cannot add or update a child row: a foreign key constraint...
Status: CLOSED WORKSFORME
Product: Red Hat OpenStack
Classification: Red Hat
Component: python-networking-odl (Show other bugs)
12.0 (Pike)
Unspecified Unspecified
low Severity low
: ga
: 12.0 (Pike)
Assigned To: Itzik Brown
Itzik Brown
: Triaged
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2017-09-14 14:21 EDT by Sai Sindhur Malleni
Modified: 2018-10-25 01:22 EDT (History)
4 users (show)

See Also:
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 07:50:04 EST
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---
itbrown: needinfo? (smalleni)


Attachments (Terms of Use)


External Trackers
Tracker ID Priority Status Summary Last Updated
Launchpad 1713447 None None None 2017-10-15 09:43 EDT
OpenStack gerrit 498881 None None None 2017-10-31 03:38 EDT
Red Hat Product Errata RHEA-2017:3462 normal SHIPPED_LIVE Red Hat OpenStack Platform 12.0 Enhancement Advisory 2018-02-15 20:43:25 EST

  None (edit)
Description Sai Sindhur Malleni 2017-09-14 14:21:35 EDT
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 09:43:46 EDT
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 02:39:47 EST
Hi,
Can you please suggest how to verify? 
What rally test and what spec have you used?
Comment 5 Itzik Brown 2017-12-13 07:50:04 EST
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

Note You need to log in before you can comment on or make changes to this bug.