No need to fetch whole network object on port create

[Oleg Bondarev]

DB plugin checks for network existence during port create:
https://github.com/openstack/neutron/blob/cb64e3a19fdddb3eac593114a482c9dd69be68d5/neutron/db/db_base_plugin_v2.py#L1422

There is no need to fetch the whole net object (which leads to several heavy DB requests according to OSProfiler stats) when only need to check net existence.

[Oleg Bondarev (obondarev)]

Patch: https://review.opendev.org/c/openstack/neutron/+/778881

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

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

commit 29e36009bbb25a2e3d66b3746d590e4046626d2c
Author: Oleg Bondarev <email address hidden>
Date: Fri Mar 5 15:02:23 2021 +0400

    Check for existence instead of fetching the whole net object

    There is no need to fetch the whole net object
    (which leads to several heavy DB requests according
    to OSProfiler stats) when only need to check net existence

    This speeds up port creation up to 15%

    Closes-Bug: #1917866
    Change-Id: I75db7c713a17a0f1b1b5aecc6eec93e636a71827
    (cherry picked from commit 4bb3c92917cdf19b18c7481786050241218e8df7)

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/neutron/+/787482
Committed: https://opendev.org/openstack/neutron/commit/863a6d1f7c641c9aeaa7802bd64a314c3b970779
Submitter: "Zuul (22348)"
Branch: stable/train

commit 863a6d1f7c641c9aeaa7802bd64a314c3b970779
Author: Oleg Bondarev <email address hidden>
Date: Fri Mar 5 15:02:23 2021 +0400

    Check for existence instead of fetching the whole net object

    There is no need to fetch the whole net object
    (which leads to several heavy DB requests according
    to OSProfiler stats) when only need to check net existence

    This speeds up port creation up to 15%

    Closes-Bug: #1917866
    Change-Id: I75db7c713a17a0f1b1b5aecc6eec93e636a71827
    (cherry picked from commit 4bb3c92917cdf19b18c7481786050241218e8df7)

[OpenStack Infra (hudson-openstack)]

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

commit 5e4a8fbb0ee95239d1221726a559e40aaa290be5
Author: Oleg Bondarev <email address hidden>
Date: Fri Mar 5 15:02:23 2021 +0400

    Check for existence instead of fetching the whole net object

    There is no need to fetch the whole net object
    (which leads to several heavy DB requests according
    to OSProfiler stats) when only need to check net existence

    This speeds up port creation up to 15%

    Closes-Bug: #1917866
    Change-Id: I75db7c713a17a0f1b1b5aecc6eec93e636a71827
    (cherry picked from commit 4bb3c92917cdf19b18c7481786050241218e8df7)

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

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

[Rodolfo Alonso (rodolfo-alonso-hernandez)]

Fix merged and released.