[bug] GET Metric measurements returns an empty list

Before reporting an issue on Gnocchi, please be sure to provide all necessary information.

Which version of Gnocchi are you using

4.4.2

How to reproduce your problem


date; openstack metric measures show vcpus --resource-id 9d724023-b9d8-48ab-9f18-0007e101a888
Thu Oct 12 13:19:59 UTC 2023

date; openstack metric measures show vcpus --resource-id 9d724023-b9d8-48ab-9f18-0007e101a888
Thu Oct 12 13:20:01 UTC 2023

 date; openstack metric measures show vcpus --resource-id 9d724023-b9d8-48ab-9f18-0007e101a888
Thu Oct 12 13:20:03 UTC 2023
 timestamp                 | granularity | value |
 2023-05-23T16:05:00+00:00 |       300.0 |   3.0 |
 2023-05-23T17:00:00+00:00 |       300.0 |   3.0 |
 2023-05-23T18:00:00+00:00 |       300.0 |   3.0 |
 2023-05-23T19:00:00+00:00 |       300.0 |   3.0 |
 2023-05-23T20:00:00+00:00 |       300.0 |   3.0 |

 date; openstack metric measures show vcpus --resource-id 9d724023-b9d8-48ab-9f18-0007e101a888
Thu Oct 12 13:20:06 UTC 2023

date; openstack metric measures show vcpus --resource-id 9d724023-b9d8-48ab-9f18-0007e101a888
Thu Oct 12 13:20:08 UTC 2023

What is the result that you get

Sometimes a HTTP 200 with an empty list as result. Sometimes a HTTP 200 with the actual populated list of measurements as result.

 REQ: curl -g -i -X GET "https://metering.mycloud.example/v1/resource/generic/9d724023-b9d8-48ab-9f18-0007e101a888/metric/vcpus/measures?start=None&stop=None&aggregation=None&granularity=None&refresh=False&resample=None" -H "Accept: application/json" -H "User-Agent: openstacksdk/1.4.0 keystoneauth1/5.2.1 python-requests/2.31.0 CPython/3.8.10" -H "X-Auth-Token: {SHA256}6d3bf4686691966144012c5dac900000000000000000000000"
Starting new HTTPS connection (1): metering.mycloud.example:443
https://metering.mycloud.example:443 "GET /v1/resource/generic/9d724023-0000-48ab-9f18-0007e101a888/metric/vcpus/measures?refresh=False HTTP/1.1" 200 2
RESP: [200] Connection: keep-alive Content-Length: 2 Content-Type: application/json Date: Thu, 12 Oct 2023 13:20:37 GMT Front-End-Https: on Server: nginx
RESP BODY: []

What is result that you expected

Always a HTTP 200 with the actual populated list of measurements as result.

Things i've tried

Restart all Redis processes/containers.
Restart all Gnocchi processes/containers on all nodes.
Make sure that Gnocchi DB is upgraded using gnocchi-upgrade
Use the refresh parameter (same results)

Additional info

I'm using Kolla and Kolla-ansible to deploy Gnocchi.
Multiple instance resources tested.

Noteworthy configuration

[incoming]
driver = redis
redis_url = REDACTED

[storage]
driver = file
file_basepath = /var/lib/gnocchi

gnocchixyz / gnocchi

[bug] GET Metric measurements returns an empty list #1346