Open Stack

Hi,

after an upgrade from Stein to Train, I hit an issue with negative value
during upgrade check for placement:

# placement-status upgrade
check+------------------------------------------------------------------+|
Upgrade Check Results
|+------------------------------------------------------------------+|
Check: Missing Root Provider IDs                                 ||
Result: Success                                                  ||
Details: None
|+------------------------------------------------------------------+|
Check: Incomplete Consumers                                      ||
Result: Warning                                                  ||
Details: There are -20136 incomplete consumers table records for ||
existing allocations. Run the "placement-manage db             ||
online_data_migrations" command.
|+------------------------------------------------------------------+


Seems that negative value is a result that I get such values from tables
consumer and allocations:

mysql> select count(id), consumer_id from allocations group by
consumer_id;...1035 rows in set (0.00 sec)

mysql> select count(*) from consumers;+----------+| count(*)
|+----------+|    21171 |+----------+1 row in set (0.04 sec)

Unfortunately such warning cannot be solved by execution of suggested
command( placement-manage db online_data_migrations) as it seems it adds
records to consumers table - not to allocations, which looks like to be a
problem here. I was following recommendations from this discussion:
http://lists.openstack.org/pipermail/openstack-discuss/2020-November/018536.html
but unfortunately it doesn't solve the issue(even not changing a negative
value). I'm just wondering if I skipped something important and you can
suggest some (obvious?) solution.

Thank you in advance for your time and help.
Best regards,
Jan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20220505/96ed0b46/attachment.htm>