Bug 2130498

Summary: floating ip quotas are not in line with what's been allocated so far
Product: Red Hat OpenStack Reporter: David Hill <dhill>
Component: openstack-neutronAssignee: Rodolfo Alonso <ralonsoh>
Status: CLOSED ERRATA QA Contact: Eran Kuris <ekuris>
Severity: high Docs Contact:
Priority: unspecified    
Version: 16.2 (Train)CC: abhijadh, apevec, astupnik, bcafarel, chrisw, jlibosva, jpichon, lhh, lmartins, ralonsoh, ramishra, scohen, sukar
Target Milestone: ---Keywords: Reopened, Triaged
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2023-07-20 17:41:06 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description David Hill 2022-09-28 11:18:31 UTC 
floating ip quotas are not in line with what's been allocated so far:

(overcloud) [stack@director01 ~]$ openstack quota list --network --detail --project 4f629ec1efb1453d8a3f885ed3edfd98
+----------------------+--------+----------+-------+
| Resource             | In Use | Reserved | Limit |
+----------------------+--------+----------+-------+
| floating_ips         |      3 |        0 |     8 |
| networks             |      1 |        0 |    10 |
| ports                |     33 |        0 |    40 |
| rbac_policies        |      0 |        0 |    10 |
| routers              |      2 |        0 |    10 |
| subnets              |      1 |        0 |    10 |
| subnet_pools         |      0 |        0 |    -1 |
| security_group_rules |     28 |        0 |    30 |
| security_groups      |      5 |        0 |    10 |
+----------------------+--------+----------+-------+
(overcloud) [stack@director01 ~]$


(overcloud) [stack@director01 ~]$ openstack floating ip list --project 4f629ec1efb1453d8a3f885ed3edfd98
+--------------------------------------+---------------------+------------------+--------------------------------------+--------------------------------------+----------------------------------+
| ID                                   | Floating IP Address | Fixed IP Address | Port                                 | Floating Network                     | Project                          |
+--------------------------------------+---------------------+------------------+--------------------------------------+--------------------------------------+----------------------------------+
| 3bfcafce-f9db-4b16-b4cd-017c3ac2ddfb | 10.10.10.8          | 192.168.1.224  | 9a19e98f-129d-4e60-9133-4e399090fdb8 | 9bebcc14-bead-4e08-8f44-08b15d1ed931 | 4f629ec1efb1453d8a3f885ed3edfd98 |
| 3fdd5b8a-5a6e-4db0-a3b5-3efb4b4b1c58 | 10.10.12.20         | 192.168.1.240  | 153c43f8-75c1-4d0b-bab7-6bf3f3a4e721 | 9bebcc14-bead-4e08-8f44-08b15d1ed931 | 4f629ec1efb1453d8a3f885ed3edfd98 |
| 500e6915-2622-4bfd-b0eb-214136f96305 | 10.10.10.1          | 192.168.1.126  | e7a4cd12-e0ac-4222-bd3c-4ad9b24c4c81 | 9bebcc14-bead-4e08-8f44-08b15d1ed931 | 4f629ec1efb1453d8a3f885ed3edfd98 |
| a946ddac-8209-4188-babc-2bb3124b42c3 | 10.10.10.242        | 192.168.1.188  | 29c20004-0ed3-4610-83ff-58dde129d7e9 | 9bebcc14-bead-4e08-8f44-08b15d1ed931 | 4f629ec1efb1453d8a3f885ed3edfd98 |
| bbbc38aa-0558-4a91-88b1-d6864f1360d1 | 10.10.11.132      | 192.168.1.7    | 402d9ff8-c783-446c-a1b6-57b0b8219f00 | adfe19a4-7e25-4c38-b53f-66f7a53926b7 | 4f629ec1efb1453d8a3f885ed3edfd98 |
| d053f419-94a6-4542-9f15-ba9e5cc7881f | 10.10.13.62         | 192.168.1.115  | 7a866100-2893-4a81-ae53-d12051c6b8ab | 9bebcc14-bead-4e08-8f44-08b15d1ed931 | 4f629ec1efb1453d8a3f885ed3edfd98 |
| daee76c5-c946-4bfb-a4bf-6336f06aa3c9 | 10.10.11.116      | 192.168.1.224  | 9a19e98f-129d-4e60-9133-4e399090fdb8 | adfe19a4-7e25-4c38-b53f-66f7a53926b7 | 4f629ec1efb1453d8a3f885ed3edfd98 |
| e3b60a89-c2c8-4613-a248-fcbbdbd85056 | 10.250.2.89         | 192.168.1.123  | 5ec2ea9c-ad30-4020-a0ab-23030901e91f | 9bebcc14-bead-4e08-8f44-08b15d1ed931 | 4f629ec1efb1453d8a3f885ed3edfd98 |
+--------------------------------------+---------------------+------------------+--------------------------------------+--------------------------------------+----------------------------------+

so Horizon usage display if almost always wrong too because of the above situation.
Comment 2 Alex Stupnikov 2022-10-07 09:23:24 UTC 
I have reported similar bug #2132941. It could be duplicate, but I am not 100% sure.
Comment 3 Rodolfo Alonso 2022-10-11 08:07:41 UTC 
Hello David:

This is an issue on how the Neutron quota driver, using the new ``DbQuotaNoLockDriver`` class, retrieves the "quota --detail" (that is also used in the Horizon counters). This issue has been addressed in 16.2 [1] and will be ready in 16.2.4.

Regards.

[1]https://bugzilla.redhat.com/show_bug.cgi?id=2102147

*** This bug has been marked as a duplicate of bug 2102147 ***