Bug 2016340 - port creation failed: Transaction causes multiple rows in "Port_Group" table to have identical values (neutron_pg_drop) for index on column "name"
Summary: port creation failed: Transaction causes multiple rows in "Port_Group" table ...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: python-networking-ovn
Version: 16.2 (Train)
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: z5
: 16.2 (Train on RHEL 8.4)
Assignee: Jakub Libosvar
QA Contact: Eran Kuris
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2021-10-21 10:34 UTC by Eduardo Olivares
Modified: 2023-04-26 12:17 UTC (History)
6 users (show)

Fixed In Version: python-networking-ovn-7.4.2-2.20220409154869.el8ost
Doc Type: No Doc Update
Doc Text:
Clone Of:
Environment:
Last Closed: 2023-04-26 12:16:45 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker OSP-10509 0 None None None 2021-11-15 12:34:45 UTC
Red Hat Product Errata RHBA-2023:1763 0 None None None 2023-04-26 12:17:07 UTC

Description Eduardo Olivares 2021-10-21 10:34:48 UTC
Description of problem:
Rally tests reproduced this issue.

Job:
https://rhos-ci-jenkins.lab.eng.tlv2.redhat.com/view/DFG/view/network/view/networking-ovn/job/DFG-network-networking-ovn-16.2_director-rhel-virthost-3cont_2comp-ipv6-geneve-dvr-rally/3/

Rally logs:
http://rhos-ci-logs.lab.eng.tlv2.redhat.com/logs/rcj/DFG-network-networking-ovn-16.2_director-rhel-virthost-3cont_2comp-ipv6-geneve-dvr-rally/3/infrared/.workspaces/workspace_2021-10-20_13-36-00/rally_results/results-20211020T153213.html#/NeutronNetworks.create_and_list_ports/failures
neutronclient.common.exceptions.InternalServerError: Request Failed: internal server error while processing your request.
Neutron server returns request_ids: ['req-5fb0a385-ac5b-42ae-ba6e-a61722f6b958']

Neutron server logs:
http://rhos-ci-logs.lab.eng.tlv2.redhat.com/logs/rcj/DFG-network-networking-ovn-16.2_director-rhel-virthost-3cont_2comp-ipv6-geneve-dvr-rally/3/controller-2/var/log/containers/neutron/server.log.3.gz
2021-10-20 15:41:01.170 18 ERROR neutron.plugins.ml2.managers RuntimeError: OVSDB Error: {"details":"Transaction causes multiple rows in \"Port_Group\" table to have identical values (neutron_pg_drop) for index on column \"name\".  First row, with UUID 86fd7a65-c013-4cf0-8435-49396b18ea63, was inserted by this transaction.  Second row, with UUID fe1b1a93-f6ae-4270-bc5e-98471bd3cb2c, existed in the database before this transaction and was not modified by the transaction.","error":"constraint violation"}


A similar issue was reported 1.5 years ago: BZ1809088.
The bug was closed because OSP15 was EOL, but a patch was merged upstream:
https://review.opendev.org/c/openstack/neutron/+/711404/
This patch was merged on May 2020, so it should be included in latest OSP16.2 builds.


Version-Release number of selected component (if applicable):
RHOS-16.2-RHEL-8-20211013.n.1


How reproducible:
Reproduced only once

Comment 11 errata-xmlrpc 2023-04-26 12:16:45 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 (Red Hat OpenStack Platform 16.2.5 (Train) bug fix and enhancement 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-2023:1763


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