<div dir="ltr"><div>Hello Melanie,</div><div><br></div><div>Thank you for your reply. It seems that everything is OK right now, after applying a patch I can see:</div><div>
<pre class="gmail-code gmail-highlight" lang="shell"><span class="gmail-line" id="gmail-LC1" lang="shell"># placement-status upgrade check</span>
<span class="gmail-line" id="gmail-LC2" lang="shell">+----------------------------------+</span>
<span class="gmail-line" id="gmail-LC3" lang="shell">| Upgrade Check Results            |</span>
<span class="gmail-line" id="gmail-LC4" lang="shell">+----------------------------------+</span>
<span class="gmail-line" id="gmail-LC5" lang="shell">| Check: Missing Root Provider IDs |</span>
<span class="gmail-line" id="gmail-LC6" lang="shell">| Result: Success                  |</span>
<span class="gmail-line" id="gmail-LC7" lang="shell">| Details: None                    |</span>
<span class="gmail-line" id="gmail-LC8" lang="shell">+----------------------------------+</span>
<span class="gmail-line" id="gmail-LC9" lang="shell">| Check: Incomplete Consumers      |</span>
<span class="gmail-line" id="gmail-LC10" lang="shell">| Result: Success                  |</span>
<span class="gmail-line" id="gmail-LC11" lang="shell">| Details: None                    |</span>
<span class="gmail-line" id="gmail-LC12" lang="shell">+----------------------------------+</span>
</pre>

</div><div>I've seen that zuul added -1 to review for this check, however I will apply my internal patch for it, additionally that you mentioned that such orphaned records shouldn't hurt me. Once again - thank you for your help. <br></div><div><br></div><div>Best regards,</div><div>Jan<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">czw., 5 maj 2022 o 19:05 melanie witt <<a href="mailto:melwittt@gmail.com">melwittt@gmail.com</a>> napisał(a):<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Thu May 05 2022 09:58:10 GMT-0700 (Pacific Daylight Time), melanie <br>
witt <<a href="mailto:melwittt@gmail.com" target="_blank">melwittt@gmail.com</a>> wrote:<br>
> You may still have orphaned consumers table records in the placement<br>
> database but they don't hurt anything. If you want/need to clean them<br>
> up, it has to be done manually, something like (disclaimer I did not<br>
> test this):<br>
> <br>
> delete from placement.consumers where placement.consumers.uuid not in<br>
> (select nova_api.instance_mappings.instance_uuid from<br>
> nova_api.instance_mappings where<br>
> nova_api.instance_mappings.queued_for_delete = true);<br>
<br>
Sorry I got the where condition backwards, it should be:<br>
<br>
delete from placement.consumers where placement.consumers.uuid not in<br>
(select nova_api.instance_mappings.instance_uuid from<br>
nova_api.instance_mappings where<br>
nova_api.instance_mappings.queued_for_delete != true);<br>
<br>
And you might have s/placement/nova_api/ if you did not break out the <br>
separate placement database.<br>
<br>
-melanie<br>
<br>
</blockquote></div>