← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 2116930] [NEW] limit api does not return all limits

 

Public bug reported:

Greetings,

we implemented unified limits for nova and have limit api problems that
we are not able to list all created limits.

Here is a list of limits that we created for specific projects from the db point of view:
select * from `limit`;
+----------------------------------+----------------------------------+----------------+-------------+-------------+----------------------------------+-----------+
| id                               | project_id                       | resource_limit | description | internal_id | registered_limit_id              | domain_id |
+----------------------------------+----------------------------------+----------------+-------------+-------------+----------------------------------+-----------+
| 94abb5603f9f4f83a690b709d1af1f55 | ccb16549f8694a6dbfe618a31cceeb00 |             -1 | NULL        |          20 | 64a8a6a79ce943a8b95d8dbeaefcae70 | NULL      |
| 7d5a62ce7e7d476d8fdb5ce6187228f4 | ccb16549f8694a6dbfe618a31cceeb00 |             -1 | NULL        |          30 | b4782b3c19844f0ca06e89d0f73da7ba | NULL      |
| 095929916f744d3e9f3f196aa7251392 | ccb16549f8694a6dbfe618a31cceeb00 |             -1 | NULL        |          35 | 338c611d6982417cae9338b65053565d | NULL      |
| 1c3966cd31e444d98a3d88180bab0f39 | ccb16549f8694a6dbfe618a31cceeb00 |             -1 | NULL        |          40 | 622b1c88be354028a7831272b320f5a7 | NULL      |
| fe4e4f4d6cd7422183535f78f41c9dc7 | ccb16549f8694a6dbfe618a31cceeb00 |             -1 | NULL        |          45 | d0fab219f2864abb8a703f3774c92fa9 | NULL      |
| d8d3179ee8e04d73af4fbcdbad47f464 | 36a72ce6ca87481bb911a50f6ae259d8 |           1000 | NULL        |          49 | 707568b0c13e4afbade398f17ad13ea5 | NULL      |
| a1424e6943364b0186430c21a696af16 | 36a72ce6ca87481bb911a50f6ae259d8 |        2097152 | NULL        |          54 | 327fa4b3ab6a46c09fc71b9bac197dfe | NULL      |
| adee7610155143d9bb7a19b02285c8ef | 36a72ce6ca87481bb911a50f6ae259d8 |          10000 | NULL        |          59 | 988025c0422342a7bdf21e4b0ae62d25 | NULL      |
| a8a9a114b848485683692f357727b770 | 8b9a03f7e78b4644a15b41d75f31f542 |           1000 | NULL        |          64 | 707568b0c13e4afbade398f17ad13ea5 | NULL      |
| 0d6679dd917d40d4a104312da7b82e4f | 8b9a03f7e78b4644a15b41d75f31f542 |        4194304 | NULL        |          69 | 327fa4b3ab6a46c09fc71b9bac197dfe | NULL      |
| 072329989815445799baab16908fdc8c | 8b9a03f7e78b4644a15b41d75f31f542 |          10000 | NULL        |          74 | 988025c0422342a7bdf21e4b0ae62d25 | NULL      |
| 7f2276a6f4bb4ec0b55fad73c7a3e1ae | 36a72ce6ca87481bb911a50f6ae259d8 |           1000 | NULL        |          79 | 04d5791fcc714408a25c6f944a50086a | NULL      |
| bf6cc20f77364f828074a5eda1cec6fe | 8b9a03f7e78b4644a15b41d75f31f542 |           1000 | NULL        |          84 | 04d5791fcc714408a25c6f944a50086a | NULL      |
| 8fe4e47c13b04423a9bcb8095a0b914d | ccb16549f8694a6dbfe618a31cceeb00 |     2147483647 | NULL        |          89 | 108fea16911e45d782853230fffd9cc7 | NULL      |
| 2d7c7930fdfb413dae25ef257216575d | ccb16549f8694a6dbfe618a31cceeb00 |     2147483647 | NULL        |          94 | 707568b0c13e4afbade398f17ad13ea5 | NULL      |
| 9610a5187320450e8cb8729da08e5adc | ccb16549f8694a6dbfe618a31cceeb00 |     2147483647 | NULL        |          99 | 327fa4b3ab6a46c09fc71b9bac197dfe | NULL      |
| 33e8f7683adf4911ae9c7a10c93b235d | ccb16549f8694a6dbfe618a31cceeb00 |     2147483647 | NULL        |         104 | 988025c0422342a7bdf21e4b0ae62d25 | NULL      |
| 6c0af5e680bb4afb995214bf168d6f33 | 4d382c3097a5423396f434e7e8d612b6 |           1500 | NULL        |         109 | 108fea16911e45d782853230fffd9cc7 | NULL      |
| 1102fe54443e4e76884847675f9e3976 | 4d382c3097a5423396f434e7e8d612b6 |           3600 | NULL        |         114 | 707568b0c13e4afbade398f17ad13ea5 | NULL      |
| 5438298578f841778a1ba69b4a7a4152 | 4d382c3097a5423396f434e7e8d612b6 |        7864320 | NULL        |         119 | 327fa4b3ab6a46c09fc71b9bac197dfe | NULL      |
| 9049e24ffb254c9aa664241ff70811ec | 4d382c3097a5423396f434e7e8d612b6 |          20000 | NULL        |         124 | 988025c0422342a7bdf21e4b0ae62d25 | NULL      |
+----------------------------------+----------------------------------+----------------+-------------+-------------+----------------------------------+-----------+

Using the openstack limit command as an admin user only returns limits related to the admin project:
openstack limit list
+----------------------------------+----------------------------------+----------------------------------+-----------------+----------------+-------------+------------+
| ID                               | Project ID                       | Service ID                       | Resource Name   | Resource Limit | Description | Region ID  |
+----------------------------------+----------------------------------+----------------------------------+-----------------+----------------+-------------+------------+
| d8d3179ee8e04d73af4fbcdbad47f464 | 36a72ce6ca87481bb911a50f6ae259d8 | ecd56230f05848e6a3bae263374c25ce | class:VCPU      |           1000 | None        | de-west-01 |
| a1424e6943364b0186430c21a696af16 | 36a72ce6ca87481bb911a50f6ae259d8 | ecd56230f05848e6a3bae263374c25ce | class:MEMORY_MB |        2097152 | None        | de-west-01 |
| adee7610155143d9bb7a19b02285c8ef | 36a72ce6ca87481bb911a50f6ae259d8 | ecd56230f05848e6a3bae263374c25ce | class:DISK_GB   |          10000 | None        | de-west-01 |
| 7f2276a6f4bb4ec0b55fad73c7a3e1ae | 36a72ce6ca87481bb911a50f6ae259d8 | ecd56230f05848e6a3bae263374c25ce | class:PCPU      |           1000 | None        | de-west-01 |
+----------------------------------+----------------------------------+----------------------------------+-----------------+----------------+-------------+------------+

Even specifying a project that is clearly inside the limit db table results in no output:
openstack limit list --project ccb16549f8694a6dbfe618a31cceeb00 --debug
RESP BODY: {"limits": [], "links": {"next": null, "self": "https://identity.openstack.***/v3/limits?project_id=ccb16549f8694a6dbfe618a31cceeb00";, "previous": null}}

I tested the same with a token and curl where I have the exact same
result, I have no way to list all existing limits.

We are running keystone 2025.1 (27.0.0)

Thanks in advance!

EDIT:
Forgot to tell that using openstack limit show on a specific id out of the db works and shows the limit:
openstack limit show 94abb5603f9f4f83a690b709d1af1f55                                                                                  
+----------------+----------------------------------+
| Field          | Value                            |
+----------------+----------------------------------+
| description    | None                             |
| domain_id      | None                             |
| id             | 94abb5603f9f4f83a690b709d1af1f55 |
| project_id     | ccb16549f8694a6dbfe618a31cceeb00 |
| region_id      | de-west-01                       |
| resource_limit | -1                               |
| resource_name  | server_injected_files            |
| service_id     | ecd56230f05848e6a3bae263374c25ce |
+----------------+----------------------------------+

** Affects: keystone
     Importance: Undecided
         Status: New

** Description changed:

  Greetings,
  
  we implemented unified limits for nova and have limit api problems that
  we are not able to list all created limits.
  
  Here is a list of limits that we created for specific projects from the db point of view:
  select * from `limit`;
  +----------------------------------+----------------------------------+----------------+-------------+-------------+----------------------------------+-----------+
  | id                               | project_id                       | resource_limit | description | internal_id | registered_limit_id              | domain_id |
  +----------------------------------+----------------------------------+----------------+-------------+-------------+----------------------------------+-----------+
  | 94abb5603f9f4f83a690b709d1af1f55 | ccb16549f8694a6dbfe618a31cceeb00 |             -1 | NULL        |          20 | 64a8a6a79ce943a8b95d8dbeaefcae70 | NULL      |
  | 7d5a62ce7e7d476d8fdb5ce6187228f4 | ccb16549f8694a6dbfe618a31cceeb00 |             -1 | NULL        |          30 | b4782b3c19844f0ca06e89d0f73da7ba | NULL      |
  | 095929916f744d3e9f3f196aa7251392 | ccb16549f8694a6dbfe618a31cceeb00 |             -1 | NULL        |          35 | 338c611d6982417cae9338b65053565d | NULL      |
  | 1c3966cd31e444d98a3d88180bab0f39 | ccb16549f8694a6dbfe618a31cceeb00 |             -1 | NULL        |          40 | 622b1c88be354028a7831272b320f5a7 | NULL      |
  | fe4e4f4d6cd7422183535f78f41c9dc7 | ccb16549f8694a6dbfe618a31cceeb00 |             -1 | NULL        |          45 | d0fab219f2864abb8a703f3774c92fa9 | NULL      |
  | d8d3179ee8e04d73af4fbcdbad47f464 | 36a72ce6ca87481bb911a50f6ae259d8 |           1000 | NULL        |          49 | 707568b0c13e4afbade398f17ad13ea5 | NULL      |
  | a1424e6943364b0186430c21a696af16 | 36a72ce6ca87481bb911a50f6ae259d8 |        2097152 | NULL        |          54 | 327fa4b3ab6a46c09fc71b9bac197dfe | NULL      |
  | adee7610155143d9bb7a19b02285c8ef | 36a72ce6ca87481bb911a50f6ae259d8 |          10000 | NULL        |          59 | 988025c0422342a7bdf21e4b0ae62d25 | NULL      |
  | a8a9a114b848485683692f357727b770 | 8b9a03f7e78b4644a15b41d75f31f542 |           1000 | NULL        |          64 | 707568b0c13e4afbade398f17ad13ea5 | NULL      |
  | 0d6679dd917d40d4a104312da7b82e4f | 8b9a03f7e78b4644a15b41d75f31f542 |        4194304 | NULL        |          69 | 327fa4b3ab6a46c09fc71b9bac197dfe | NULL      |
  | 072329989815445799baab16908fdc8c | 8b9a03f7e78b4644a15b41d75f31f542 |          10000 | NULL        |          74 | 988025c0422342a7bdf21e4b0ae62d25 | NULL      |
  | 7f2276a6f4bb4ec0b55fad73c7a3e1ae | 36a72ce6ca87481bb911a50f6ae259d8 |           1000 | NULL        |          79 | 04d5791fcc714408a25c6f944a50086a | NULL      |
  | bf6cc20f77364f828074a5eda1cec6fe | 8b9a03f7e78b4644a15b41d75f31f542 |           1000 | NULL        |          84 | 04d5791fcc714408a25c6f944a50086a | NULL      |
  | 8fe4e47c13b04423a9bcb8095a0b914d | ccb16549f8694a6dbfe618a31cceeb00 |     2147483647 | NULL        |          89 | 108fea16911e45d782853230fffd9cc7 | NULL      |
  | 2d7c7930fdfb413dae25ef257216575d | ccb16549f8694a6dbfe618a31cceeb00 |     2147483647 | NULL        |          94 | 707568b0c13e4afbade398f17ad13ea5 | NULL      |
  | 9610a5187320450e8cb8729da08e5adc | ccb16549f8694a6dbfe618a31cceeb00 |     2147483647 | NULL        |          99 | 327fa4b3ab6a46c09fc71b9bac197dfe | NULL      |
  | 33e8f7683adf4911ae9c7a10c93b235d | ccb16549f8694a6dbfe618a31cceeb00 |     2147483647 | NULL        |         104 | 988025c0422342a7bdf21e4b0ae62d25 | NULL      |
  | 6c0af5e680bb4afb995214bf168d6f33 | 4d382c3097a5423396f434e7e8d612b6 |           1500 | NULL        |         109 | 108fea16911e45d782853230fffd9cc7 | NULL      |
  | 1102fe54443e4e76884847675f9e3976 | 4d382c3097a5423396f434e7e8d612b6 |           3600 | NULL        |         114 | 707568b0c13e4afbade398f17ad13ea5 | NULL      |
  | 5438298578f841778a1ba69b4a7a4152 | 4d382c3097a5423396f434e7e8d612b6 |        7864320 | NULL        |         119 | 327fa4b3ab6a46c09fc71b9bac197dfe | NULL      |
  | 9049e24ffb254c9aa664241ff70811ec | 4d382c3097a5423396f434e7e8d612b6 |          20000 | NULL        |         124 | 988025c0422342a7bdf21e4b0ae62d25 | NULL      |
  +----------------------------------+----------------------------------+----------------+-------------+-------------+----------------------------------+-----------+
  
- 
  Using the openstack limit command as an admin user only returns limits related to the admin project:
- openstack limit list                                                                                                                      
+ openstack limit list
  +----------------------------------+----------------------------------+----------------------------------+-----------------+----------------+-------------+------------+
  | ID                               | Project ID                       | Service ID                       | Resource Name   | Resource Limit | Description | Region ID  |
  +----------------------------------+----------------------------------+----------------------------------+-----------------+----------------+-------------+------------+
  | d8d3179ee8e04d73af4fbcdbad47f464 | 36a72ce6ca87481bb911a50f6ae259d8 | ecd56230f05848e6a3bae263374c25ce | class:VCPU      |           1000 | None        | de-west-01 |
  | a1424e6943364b0186430c21a696af16 | 36a72ce6ca87481bb911a50f6ae259d8 | ecd56230f05848e6a3bae263374c25ce | class:MEMORY_MB |        2097152 | None        | de-west-01 |
  | adee7610155143d9bb7a19b02285c8ef | 36a72ce6ca87481bb911a50f6ae259d8 | ecd56230f05848e6a3bae263374c25ce | class:DISK_GB   |          10000 | None        | de-west-01 |
  | 7f2276a6f4bb4ec0b55fad73c7a3e1ae | 36a72ce6ca87481bb911a50f6ae259d8 | ecd56230f05848e6a3bae263374c25ce | class:PCPU      |           1000 | None        | de-west-01 |
  +----------------------------------+----------------------------------+----------------------------------+-----------------+----------------+-------------+------------+
- 
  
  Even specifying a project that is clearly inside the limit db table results in no output:
  openstack limit list --project ccb16549f8694a6dbfe618a31cceeb00 --debug
  RESP BODY: {"limits": [], "links": {"next": null, "self": "https://identity.openstack.***/v3/limits?project_id=ccb16549f8694a6dbfe618a31cceeb00";, "previous": null}}
  
  I tested the same with a token and curl where I have the exact same
  result, I have no way to list all existing limits.
  
  We are running keystone 2025.1 (27.0.0)
  
  Thanks in advance!
+ 
+ EDIT:
+ Forgot to tell that using openstack limit show on a specific id out of the db works and shows the limit:
+ openstack limit show 94abb5603f9f4f83a690b709d1af1f55                                                                                  
+ +----------------+----------------------------------+
+ | Field          | Value                            |
+ +----------------+----------------------------------+
+ | description    | None                             |
+ | domain_id      | None                             |
+ | id             | 94abb5603f9f4f83a690b709d1af1f55 |
+ | project_id     | ccb16549f8694a6dbfe618a31cceeb00 |
+ | region_id      | de-west-01                       |
+ | resource_limit | -1                               |
+ | resource_name  | server_injected_files            |
+ | service_id     | ecd56230f05848e6a3bae263374c25ce |
+ +----------------+----------------------------------+

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Identity (keystone).
https://bugs.launchpad.net/bugs/2116930

Title:
  limit api does not return all limits

Status in OpenStack Identity (keystone):
  New

Bug description:
  Greetings,

  we implemented unified limits for nova and have limit api problems
  that we are not able to list all created limits.

  Here is a list of limits that we created for specific projects from the db point of view:
  select * from `limit`;
  +----------------------------------+----------------------------------+----------------+-------------+-------------+----------------------------------+-----------+
  | id                               | project_id                       | resource_limit | description | internal_id | registered_limit_id              | domain_id |
  +----------------------------------+----------------------------------+----------------+-------------+-------------+----------------------------------+-----------+
  | 94abb5603f9f4f83a690b709d1af1f55 | ccb16549f8694a6dbfe618a31cceeb00 |             -1 | NULL        |          20 | 64a8a6a79ce943a8b95d8dbeaefcae70 | NULL      |
  | 7d5a62ce7e7d476d8fdb5ce6187228f4 | ccb16549f8694a6dbfe618a31cceeb00 |             -1 | NULL        |          30 | b4782b3c19844f0ca06e89d0f73da7ba | NULL      |
  | 095929916f744d3e9f3f196aa7251392 | ccb16549f8694a6dbfe618a31cceeb00 |             -1 | NULL        |          35 | 338c611d6982417cae9338b65053565d | NULL      |
  | 1c3966cd31e444d98a3d88180bab0f39 | ccb16549f8694a6dbfe618a31cceeb00 |             -1 | NULL        |          40 | 622b1c88be354028a7831272b320f5a7 | NULL      |
  | fe4e4f4d6cd7422183535f78f41c9dc7 | ccb16549f8694a6dbfe618a31cceeb00 |             -1 | NULL        |          45 | d0fab219f2864abb8a703f3774c92fa9 | NULL      |
  | d8d3179ee8e04d73af4fbcdbad47f464 | 36a72ce6ca87481bb911a50f6ae259d8 |           1000 | NULL        |          49 | 707568b0c13e4afbade398f17ad13ea5 | NULL      |
  | a1424e6943364b0186430c21a696af16 | 36a72ce6ca87481bb911a50f6ae259d8 |        2097152 | NULL        |          54 | 327fa4b3ab6a46c09fc71b9bac197dfe | NULL      |
  | adee7610155143d9bb7a19b02285c8ef | 36a72ce6ca87481bb911a50f6ae259d8 |          10000 | NULL        |          59 | 988025c0422342a7bdf21e4b0ae62d25 | NULL      |
  | a8a9a114b848485683692f357727b770 | 8b9a03f7e78b4644a15b41d75f31f542 |           1000 | NULL        |          64 | 707568b0c13e4afbade398f17ad13ea5 | NULL      |
  | 0d6679dd917d40d4a104312da7b82e4f | 8b9a03f7e78b4644a15b41d75f31f542 |        4194304 | NULL        |          69 | 327fa4b3ab6a46c09fc71b9bac197dfe | NULL      |
  | 072329989815445799baab16908fdc8c | 8b9a03f7e78b4644a15b41d75f31f542 |          10000 | NULL        |          74 | 988025c0422342a7bdf21e4b0ae62d25 | NULL      |
  | 7f2276a6f4bb4ec0b55fad73c7a3e1ae | 36a72ce6ca87481bb911a50f6ae259d8 |           1000 | NULL        |          79 | 04d5791fcc714408a25c6f944a50086a | NULL      |
  | bf6cc20f77364f828074a5eda1cec6fe | 8b9a03f7e78b4644a15b41d75f31f542 |           1000 | NULL        |          84 | 04d5791fcc714408a25c6f944a50086a | NULL      |
  | 8fe4e47c13b04423a9bcb8095a0b914d | ccb16549f8694a6dbfe618a31cceeb00 |     2147483647 | NULL        |          89 | 108fea16911e45d782853230fffd9cc7 | NULL      |
  | 2d7c7930fdfb413dae25ef257216575d | ccb16549f8694a6dbfe618a31cceeb00 |     2147483647 | NULL        |          94 | 707568b0c13e4afbade398f17ad13ea5 | NULL      |
  | 9610a5187320450e8cb8729da08e5adc | ccb16549f8694a6dbfe618a31cceeb00 |     2147483647 | NULL        |          99 | 327fa4b3ab6a46c09fc71b9bac197dfe | NULL      |
  | 33e8f7683adf4911ae9c7a10c93b235d | ccb16549f8694a6dbfe618a31cceeb00 |     2147483647 | NULL        |         104 | 988025c0422342a7bdf21e4b0ae62d25 | NULL      |
  | 6c0af5e680bb4afb995214bf168d6f33 | 4d382c3097a5423396f434e7e8d612b6 |           1500 | NULL        |         109 | 108fea16911e45d782853230fffd9cc7 | NULL      |
  | 1102fe54443e4e76884847675f9e3976 | 4d382c3097a5423396f434e7e8d612b6 |           3600 | NULL        |         114 | 707568b0c13e4afbade398f17ad13ea5 | NULL      |
  | 5438298578f841778a1ba69b4a7a4152 | 4d382c3097a5423396f434e7e8d612b6 |        7864320 | NULL        |         119 | 327fa4b3ab6a46c09fc71b9bac197dfe | NULL      |
  | 9049e24ffb254c9aa664241ff70811ec | 4d382c3097a5423396f434e7e8d612b6 |          20000 | NULL        |         124 | 988025c0422342a7bdf21e4b0ae62d25 | NULL      |
  +----------------------------------+----------------------------------+----------------+-------------+-------------+----------------------------------+-----------+

  Using the openstack limit command as an admin user only returns limits related to the admin project:
  openstack limit list
  +----------------------------------+----------------------------------+----------------------------------+-----------------+----------------+-------------+------------+
  | ID                               | Project ID                       | Service ID                       | Resource Name   | Resource Limit | Description | Region ID  |
  +----------------------------------+----------------------------------+----------------------------------+-----------------+----------------+-------------+------------+
  | d8d3179ee8e04d73af4fbcdbad47f464 | 36a72ce6ca87481bb911a50f6ae259d8 | ecd56230f05848e6a3bae263374c25ce | class:VCPU      |           1000 | None        | de-west-01 |
  | a1424e6943364b0186430c21a696af16 | 36a72ce6ca87481bb911a50f6ae259d8 | ecd56230f05848e6a3bae263374c25ce | class:MEMORY_MB |        2097152 | None        | de-west-01 |
  | adee7610155143d9bb7a19b02285c8ef | 36a72ce6ca87481bb911a50f6ae259d8 | ecd56230f05848e6a3bae263374c25ce | class:DISK_GB   |          10000 | None        | de-west-01 |
  | 7f2276a6f4bb4ec0b55fad73c7a3e1ae | 36a72ce6ca87481bb911a50f6ae259d8 | ecd56230f05848e6a3bae263374c25ce | class:PCPU      |           1000 | None        | de-west-01 |
  +----------------------------------+----------------------------------+----------------------------------+-----------------+----------------+-------------+------------+

  Even specifying a project that is clearly inside the limit db table results in no output:
  openstack limit list --project ccb16549f8694a6dbfe618a31cceeb00 --debug
  RESP BODY: {"limits": [], "links": {"next": null, "self": "https://identity.openstack.***/v3/limits?project_id=ccb16549f8694a6dbfe618a31cceeb00";, "previous": null}}

  I tested the same with a token and curl where I have the exact same
  result, I have no way to list all existing limits.

  We are running keystone 2025.1 (27.0.0)

  Thanks in advance!

  EDIT:
  Forgot to tell that using openstack limit show on a specific id out of the db works and shows the limit:
  openstack limit show 94abb5603f9f4f83a690b709d1af1f55                                                                                  
  +----------------+----------------------------------+
  | Field          | Value                            |
  +----------------+----------------------------------+
  | description    | None                             |
  | domain_id      | None                             |
  | id             | 94abb5603f9f4f83a690b709d1af1f55 |
  | project_id     | ccb16549f8694a6dbfe618a31cceeb00 |
  | region_id      | de-west-01                       |
  | resource_limit | -1                               |
  | resource_name  | server_injected_files            |
  | service_id     | ecd56230f05848e6a3bae263374c25ce |
  +----------------+----------------------------------+

To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/2116930/+subscriptions