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