DaanHoogland opened a new issue, #13446:
URL: https://github.com/apache/cloudstack/issues/13446
<p>The bug we're hitting is in a <strong>different subsystem</strong>: the
Usage Sanity Check (<code>UsageSanityChecker.java</code>). Specifically the
"snapshot after removed" check, whose query is roughly:</p>
<pre><code class="language-sql">SELECT count(*)
FROM cloud_usage.cloud_usage cu
JOIN cloud.snapshots s ON cu.usage_id = s.id
WHERE cu.usage_type = 9
AND cu.start_date > s.removed;
</code></pre>
<p>i.e. <strong>usage records in <code>cloud_usage.cloud_usage</code> with a
<code>start_date</code> AFTER the snapshot was already soft-deleted in
<code>cloud.snapshots</code></strong>. This drives the <code>Usage Sanity Check
failed</code> mailer and feeds our Prometheus exporter.</p>
<p>On the running <code>4.22.1.0</code> (which includes 83ce006) we
<strong>still see</strong>:</p>
check | count
-- | --
snapshot_after_removed | 160
volume_after_removed | 36
template_after_removed | 0
vm_after_destroyed | 0
_Originally posted by @PPisz in
https://github.com/apache/cloudstack/discussions/13398#discussioncomment-17321658_
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
