[nova][placement] Incomplete Consumers return negative value after upgrade

Jan Wasilewski finarffin at gmail.com
Thu May 5 09:31:16 UTC 2022


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

# placement-status upgrade
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:
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,
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20220505/96ed0b46/attachment.htm>

More information about the openstack-discuss mailing list