<div dir="ltr"><div>Hi,</div><div><br></div><div>after an upgrade from Stein to Train, I hit an issue with negative value during upgrade check for placement: <br></div><div>
<pre class="gmail-code gmail-highlight" lang="plaintext"><span id="gmail-LC1" class="gmail-line" lang="plaintext"># placement-status upgrade check</span>
<span id="gmail-LC2" class="gmail-line" lang="plaintext">+------------------------------------------------------------------+</span>
<span id="gmail-LC3" class="gmail-line" lang="plaintext">| Upgrade Check Results                                            |</span>
<span id="gmail-LC4" class="gmail-line" lang="plaintext">+------------------------------------------------------------------+</span>
<span id="gmail-LC5" class="gmail-line" lang="plaintext">| Check: Missing Root Provider IDs                                 |</span>
<span id="gmail-LC6" class="gmail-line" lang="plaintext">| Result: Success                                                  |</span>
<span id="gmail-LC7" class="gmail-line" lang="plaintext">| Details: None                                                    |</span>
<span id="gmail-LC8" class="gmail-line" lang="plaintext">+------------------------------------------------------------------+</span>
<span id="gmail-LC9" class="gmail-line" lang="plaintext">| Check: Incomplete Consumers                                      |</span>
<span id="gmail-LC10" class="gmail-line" lang="plaintext">| Result: Warning                                                  |</span>
<span id="gmail-LC11" class="gmail-line" lang="plaintext">| Details: There are -20136 incomplete consumers table records for |</span>
<span id="gmail-LC12" class="gmail-line" lang="plaintext">|   existing allocations. Run the "placement-manage db             |</span>
<span id="gmail-LC13" class="gmail-line" lang="plaintext">|   online_data_migrations" command.                               |</span>
<span id="gmail-LC14" class="gmail-line" lang="plaintext">+------------------------------------------------------------------+</span>
</pre>

</div><div><br></div><div>Seems that negative value is a result that I get such values from tables consumer and allocations:</div><div>
<pre class="gmail-code gmail-highlight" lang="plaintext"><span class="gmail-line" id="gmail-LC1" lang="plaintext">mysql> select count(id), consumer_id from allocations group by consumer_id;</span>
<span class="gmail-line" id="gmail-LC2" lang="plaintext">...</span>
<span class="gmail-line" id="gmail-LC3" lang="plaintext">1035 rows in set (0.00 sec)</span>
</pre>

</div><div>
<pre class="gmail-code gmail-highlight" lang="plaintext"><span class="gmail-line" id="gmail-LC1" lang="plaintext">mysql> select count(*) from consumers;</span>
<span class="gmail-line" id="gmail-LC2" lang="plaintext">+----------+</span>
<span class="gmail-line" id="gmail-LC3" lang="plaintext">| count(*) |</span>
<span class="gmail-line" id="gmail-LC4" lang="plaintext">+----------+</span>
<span class="gmail-line" id="gmail-LC5" lang="plaintext">|    21171 |</span>
<span class="gmail-line" id="gmail-LC6" lang="plaintext">+----------+</span>
<span class="gmail-line" id="gmail-LC7" lang="plaintext">1 row in set (0.04 sec)</span><br><br></pre><div>Unfortunately such warning cannot be solved by execution of suggested command(
<code>placement-manage db online_data_migrations</code>)

 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: <a href="http://lists.openstack.org/pipermail/openstack-discuss/2020-November/018536.html">http://lists.openstack.org/pipermail/openstack-discuss/2020-November/018536.html</a> 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.</div><div><br></div><div>Thank you in advance for your time and help.</div><div>Best regards,</div><div>Jan<br></div></div></div>