yahoo-eng-team team mailing list archive
-
yahoo-eng-team team
-
Mailing list archive
-
Message #94044
[Bug 2061883] Re: [fwaas] Duplicate entry <uuid> for key default_firewall_groups.PRIMARY
Reviewed: https://review.opendev.org/c/openstack/neutron-fwaas/+/916968
Committed: https://opendev.org/openstack/neutron-fwaas/commit/e578839fcaa84f266f6f04b927b8633ffda43423
Submitter: "Zuul (22348)"
Branch: master
commit e578839fcaa84f266f6f04b927b8633ffda43423
Author: zhouhenglc <zhouhenglc@xxxxxxxxxx>
Date: Thu Apr 25 14:21:15 2024 +0800
create default security group using an independent context
The current method of creating a default security group may be under
an upper level context. If there is an exception of creating a
duplicate primary key for the default security group, it will cause
the context to need to be rolled back, but not rolled back, which
will affect subsequent database operations.
Through the submission of patch8, a default security group was
created every time. Upon reviewing the [1] log "Default FWG
was concurrently created", it was determined that duplicate primary keys
were actually triggered and the issue(#2061883) was fixed.
Closes-Bug: #2061883
[1] https://storage.bhs.cloud.ovh.net/v1/AUTH_dcaab5e32b234d56b626f72581e3644c/zuul_opendev_logs_94a/916968/8/check/neutron-tempest-plugin-fwaas/94a09c8/controller/logs/screen-q-svc.txt
Change-Id: Ib2e412ed5e5d4c4fcb4f0abe71d4750fb78bce27
** Changed in: neutron
Status: In Progress => Fix Released
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/2061883
Title:
[fwaas] Duplicate entry <uuid> for key default_firewall_groups.PRIMARY
Status in neutron:
Fix Released
Bug description:
In periodic neutron-tempest-plugin-fwaas job there are sporadic failures with internal server error (see [1]):
Apr 13 08:51:56.167863 np0037278106 neutron-server[59018]: ERROR neutron.api.v2.resource oslo_db.exception.DBDuplicateEntry: (pymysql.err.IntegrityError) (1062, "Duplicate entry '802cc07da18040609dc5772f1d4149b9' for key 'default_firewall_groups.PRIMARY'")
802cc07da18040609dc5772f1d4149b9 is the uuid of the project/tenant in
the above exception.
Opensearch link:
https://opensearch.logs.openstack.org/_dashboards/app/discover/?security_tenant=global#/?_g=(filters:!(),refreshInterval:(pause:!t,value:0),time:(from:now-30d,to:now))&_a=(columns:!(_source),filters:!(),index:'94869730-aea8-11ec-9e6a-83741af3fdcd',interval:auto,query:(language:kuery,query:'message:%22line%20269,%20in%20test_create_show_delete_firewall_group%22'),sort:!())
[1]: https://paste.opendev.org/show/bIwAbuJ88F8IPdTCJjYN/
To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/2061883/+subscriptions
References