yahoo-eng-team team mailing list archive

[OpenStack Infra <2061883@xxxxxxxxxxxxxxxxxx>]

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