Response time increasing on new subnets over same network

Bug #1977831 reported by Fernando Royo
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
neutron
Fix Released
Medium
Fernando Royo

Bug Description

After some subnets created over same network, response time for new ones is incresase linearly, if number of subnet is elevated (over 1000) timeout is triggered.

The issue can be easily reproduced by creating subnets in a loop and capture the time it takes to create as the total count increases.

Changed in neutron:
assignee: nobody → Fernando Royo (froyoredhat)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to neutron (master)

Fix proposed to branch: master
Review: https://review.opendev.org/c/openstack/neutron/+/844959

Changed in neutron:
status: New → In Progress
Changed in neutron:
importance: Undecided → Medium
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to neutron (master)

Reviewed: https://review.opendev.org/c/openstack/neutron/+/844959
Committed: https://opendev.org/openstack/neutron/commit/c25097b0b0da2af9021699036a69cd10e66533b1
Submitter: "Zuul (22348)"
Branch: master

commit c25097b0b0da2af9021699036a69cd10e66533b1
Author: Fernando Royo <email address hidden>
Date: Tue Jun 7 13:51:51 2022 +0200

    Optimize queries for port operations

    Port create/update are most time-consuming operations
    on subnet creation. As example, in those cases where
    several subnets are created over the same network the
    response time for those port operations is linearly
    increased as the total subnets increases.

    This patch improves the number of queries required on port
    operations in order to reduce the response time.

    Closes-Bug: #1977831
    Change-Id: I0fccf36a2035e8f6c2fa8dab0307358da600c8f7

Changed in neutron:
status: In Progress → Fix Released
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to neutron (stable/yoga)

Fix proposed to branch: stable/yoga
Review: https://review.opendev.org/c/openstack/neutron/+/845704

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to neutron (stable/xena)

Fix proposed to branch: stable/xena
Review: https://review.opendev.org/c/openstack/neutron/+/845705

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to neutron (stable/wallaby)

Fix proposed to branch: stable/wallaby
Review: https://review.opendev.org/c/openstack/neutron/+/845706

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to neutron (stable/victoria)

Fix proposed to branch: stable/victoria
Review: https://review.opendev.org/c/openstack/neutron/+/845707

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to neutron (stable/ussuri)

Fix proposed to branch: stable/ussuri
Review: https://review.opendev.org/c/openstack/neutron/+/846781

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to neutron (stable/yoga)

Reviewed: https://review.opendev.org/c/openstack/neutron/+/845704
Committed: https://opendev.org/openstack/neutron/commit/a57d47bcb2df76df81eed3ad44c8f49e7dbda0e8
Submitter: "Zuul (22348)"
Branch: stable/yoga

commit a57d47bcb2df76df81eed3ad44c8f49e7dbda0e8
Author: Fernando Royo <email address hidden>
Date: Tue Jun 7 13:51:51 2022 +0200

    Optimize queries for port operations

    Port create/update are most time-consuming operations
    on subnet creation. As example, in those cases where
    several subnets are created over the same network the
    response time for those port operations is linearly
    increased as the total subnets increases.

    This patch improves the number of queries required on port
    operations in order to reduce the response time.

    Closes-Bug: #1977831

    Change-Id: I0fccf36a2035e8f6c2fa8dab0307358da600c8f7
    (cherry picked from commit c25097b0b0da2af9021699036a69cd10e66533b1)

tags: added: in-stable-yoga
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to neutron (stable/xena)

Reviewed: https://review.opendev.org/c/openstack/neutron/+/845705
Committed: https://opendev.org/openstack/neutron/commit/2cf8b54346aedb7bbf56c1c196bf55beaa6ff605
Submitter: "Zuul (22348)"
Branch: stable/xena

commit 2cf8b54346aedb7bbf56c1c196bf55beaa6ff605
Author: Fernando Royo <email address hidden>
Date: Tue Jun 7 13:51:51 2022 +0200

    Optimize queries for port operations

    Port create/update are most time-consuming operations
    on subnet creation. As example, in those cases where
    several subnets are created over the same network the
    response time for those port operations is linearly
    increased as the total subnets increases.

    This patch improves the number of queries required on port
    operations in order to reduce the response time.

    Closes-Bug: #1977831
    Change-Id: I0fccf36a2035e8f6c2fa8dab0307358da600c8f7
    (cherry picked from commit c25097b0b0da2af9021699036a69cd10e66533b1)

tags: added: in-stable-xena
tags: added: in-stable-victoria
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to neutron (stable/victoria)

Reviewed: https://review.opendev.org/c/openstack/neutron/+/845707
Committed: https://opendev.org/openstack/neutron/commit/acd55bc4d0899a1bd43dec7602e0d9d93c1f7ba5
Submitter: "Zuul (22348)"
Branch: stable/victoria

commit acd55bc4d0899a1bd43dec7602e0d9d93c1f7ba5
Author: Fernando Royo <email address hidden>
Date: Tue Jun 7 13:51:51 2022 +0200

    Optimize queries for port operations

    Port create/update are most time-consuming operations
    on subnet creation. As example, in those cases where
    several subnets are created over the same network the
    response time for those port operations is linearly
    increased as the total subnets increases.

    This patch improves the number of queries required on port
    operations in order to reduce the response time.

    Closes-Bug: #1977831
    Change-Id: I0fccf36a2035e8f6c2fa8dab0307358da600c8f7
    (cherry picked from commit c25097b0b0da2af9021699036a69cd10e66533b1)

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to neutron (stable/wallaby)

Reviewed: https://review.opendev.org/c/openstack/neutron/+/845706
Committed: https://opendev.org/openstack/neutron/commit/0e26b251a44b55d49ab2839a7aaf1413a2b4932a
Submitter: "Zuul (22348)"
Branch: stable/wallaby

commit 0e26b251a44b55d49ab2839a7aaf1413a2b4932a
Author: Fernando Royo <email address hidden>
Date: Tue Jun 7 13:51:51 2022 +0200

    Optimize queries for port operations

    Port create/update are most time-consuming operations
    on subnet creation. As example, in those cases where
    several subnets are created over the same network the
    response time for those port operations is linearly
    increased as the total subnets increases.

    This patch improves the number of queries required on port
    operations in order to reduce the response time.

    Closes-Bug: #1977831
    Change-Id: I0fccf36a2035e8f6c2fa8dab0307358da600c8f7
    (cherry picked from commit c25097b0b0da2af9021699036a69cd10e66533b1)

tags: added: in-stable-wallaby
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to neutron (stable/ussuri)

Reviewed: https://review.opendev.org/c/openstack/neutron/+/846781
Committed: https://opendev.org/openstack/neutron/commit/c3b7f34388fc63cd3d3d5ab7c6548699e98f96e0
Submitter: "Zuul (22348)"
Branch: stable/ussuri

commit c3b7f34388fc63cd3d3d5ab7c6548699e98f96e0
Author: Fernando Royo <email address hidden>
Date: Tue Jun 7 13:51:51 2022 +0200

    Optimize queries for port operations

    Port create/update are most time-consuming operations
    on subnet creation. As example, in those cases where
    several subnets are created over the same network the
    response time for those port operations is linearly
    increased as the total subnets increases.

    This patch improves the number of queries required on port
    operations in order to reduce the response time.

    Closes-Bug: #1977831
    Change-Id: I0fccf36a2035e8f6c2fa8dab0307358da600c8f7
    (cherry picked from commit c25097b0b0da2af9021699036a69cd10e66533b1)

tags: added: in-stable-ussuri
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/neutron 18.5.0

This issue was fixed in the openstack/neutron 18.5.0 release.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/neutron 19.4.0

This issue was fixed in the openstack/neutron 19.4.0 release.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/neutron 20.2.0

This issue was fixed in the openstack/neutron 20.2.0 release.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to neutron (stable/train)

Fix proposed to branch: stable/train
Review: https://review.opendev.org/c/openstack/neutron/+/850735

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to neutron (stable/train)

Reviewed: https://review.opendev.org/c/openstack/neutron/+/850735
Committed: https://opendev.org/openstack/neutron/commit/3eed8f91941ad98953181aa32a2e44f0e41356fb
Submitter: "Zuul (22348)"
Branch: stable/train

commit 3eed8f91941ad98953181aa32a2e44f0e41356fb
Author: Fernando Royo <email address hidden>
Date: Tue Jun 7 13:51:51 2022 +0200

    Optimize queries for port operations

    Port create/update are most time-consuming operations
    on subnet creation. As example, in those cases where
    several subnets are created over the same network the
    response time for those port operations is linearly
    increased as the total subnets increases.

    This patch improves the number of queries required on port
    operations in order to reduce the response time.

    Closes-Bug: #1977831
    Change-Id: I0fccf36a2035e8f6c2fa8dab0307358da600c8f7
    (cherry picked from commit c25097b0b0da2af9021699036a69cd10e66533b1)

tags: added: in-stable-train
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/neutron 21.0.0.0rc1

This issue was fixed in the openstack/neutron 21.0.0.0rc1 release candidate.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/networking-ovn train-eol

This issue was fixed in the openstack/networking-ovn train-eol release.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/neutron train-eol

This issue was fixed in the openstack/neutron train-eol release.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/neutron ussuri-eol

This issue was fixed in the openstack/neutron ussuri-eol release.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/neutron victoria-eom

This issue was fixed in the openstack/neutron victoria-eom release.

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

Other bug subscribers

Remote bug watches

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