[GitHub] [cloudstack] matheusfontes commented on issue #6717: Usage charging deleted volumes

[GitBox <gi...@apache.org>]

matheusfontes commented on issue #6717:
URL: https://github.com/apache/cloudstack/issues/6717#issuecomment-1243853217

   @DaanHoogland volumes expunged are always beeing charged.
   I saw some queries in database that I think they are wrong.
   When usage job is started and it's looking for a VOLUME.DELETE event it tries to search this volume in usage_volume table with that query:
   SELECT usage_volume.id, usage_volume.zone_id, usage_volume.account_id, usage_volume.domain_id, usage_volume.volume_id, usage_volume.disk_offering_id, usage_volume.template_id, usage_volume.size, usage_volume.created, usage_volume.deleted FROM usage_volume WHERE usage_volume.account_id = 9  AND **usage_volume.id = 110**  AND usage_volume.deleted IS NULL
   
   I think this **usage_volume.id** search criteria is wrong, it should search for a **usage_volume.volume_id** field.
   
   


-- 
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

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