Bug 1491815 - DBReferenceError: 'Cannot add or update a child row: a foreign key constraint fails
Summary: DBReferenceError: 'Cannot add or update a child row: a foreign key constraint...
Keywords:
Status: CLOSED WORKSFORME
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: python-networking-odl
Version: 12.0 (Pike)
Hardware: Unspecified
OS: Unspecified
low
low
Target Milestone: ga
: 12.0 (Pike)
Assignee: Itzik Brown
QA Contact: Itzik Brown
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-09-14 18:21 UTC by Sai Sindhur Malleni
Modified: 2020-08-04 12:34 UTC (History)
4 users (show)

Fixed In Version: python-networking-odl-11.0.1-0.20171017155938.a0cb8d9.el7ost
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
N/A
Last Closed: 2017-12-13 12:50:04 UTC
Target Upstream Version:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Launchpad 1713447 0 None None None 2017-10-15 13:43:46 UTC
OpenStack gerrit 498881 0 None MERGED Fix: retry journal.record on dependency deleted 2020-11-30 07:25:27 UTC
Red Hat Product Errata RHEA-2017:3462 0 normal SHIPPED_LIVE Red Hat OpenStack Platform 12.0 Enhancement Advisory 2018-02-16 01:43:25 UTC

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
Note You need to log in before you can comment on or make changes to this bug.