neutron

[fwaas] Duplicate entry <uuid> for key default_firewall_groups.PRIMARY

Bug #2061883 reported by Lajos Katona
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
neutron
In Progress
High
ZhouHeng

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/

Tags: fwaas tempest
Elvira García Ruiz (elviragr)
tags: added: tempest
Changed in neutron:
status: New → Confirmed
importance: Undecided → High
Lajos Katona (lajos-katona)
summary: - [fwaas] Duplicate entry <uuid> for key default_firewall_groups.PRIMARY'
+ [fwaas] Duplicate entry <uuid> for key default_firewall_groups.PRIMARY
ZhouHeng (zhouhenglc)
Changed in neutron:
assignee: nobody → ZhouHeng (zhouhenglc)
OpenStack Infra (hudson-openstack)
Changed in neutron:
status: Confirmed → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Related fix proposed to neutron-tempest-plugin (master)

Related fix proposed to branch: master
Review: https://review.opendev.org/c/openstack/neutron-tempest-plugin/+/917935

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Related fix proposed to neutron-fwaas (master)

Related fix proposed to branch: master
Review: https://review.opendev.org/c/openstack/neutron-fwaas/+/917936

Revision history for this message
Lajos Katona (lajos-katona) wrote :

The fix proposed by ZhouHeng: https://review.opendev.org/c/openstack/neutron-fwaas/+/916968

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Change abandoned on neutron-fwaas (master)

Change abandoned by "Lajos Katona <email address hidden>" on branch: master
Review: https://review.opendev.org/c/openstack/neutron-fwaas/+/917936

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.