[I] False positive in UsageSanityChecker [cloudstack]

["DaanHoogland (via GitHub)" <gi...@apache.org>]

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 &gt; 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: commits-unsubscribe@cloudstack.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org