yahoo-eng-team team mailing list archive

Thread
Date

[Bug 2061883] [NEW] [fwaas] Duplicate entry <uuid> for key default_firewall_groups.PRIMARY'

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Lajos Katona <2061883@xxxxxxxxxxxxxxxxxx>
Date: Tue, 16 Apr 2024 17:44:52 -0000
Reply-to: Bug 2061883 <2061883@xxxxxxxxxxxxxxxxxx>
Sender: noreply@xxxxxxxxxxxxx

Public bug reported:

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/

** Affects: neutron
     Importance: Undecided
         Status: New


** Tags: fwaas

-- 
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:
  New

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