nxsbi commented on issue #8540: URL: https://github.com/apache/cloudstack/issues/8540#issuecomment-1902903059
Thanks @DaanHoogland. I was able to query the snapshot and snapshot_store_ref and found the offending backups. Turned out these were backups from 2022. However, this may indicate potential bug - because in the snapshot table, those snapshots showed as Destroyed, but in the snapshot_store_ref table, they were "Ready". So these were not visible from the front end UI at all. Now I see another issue  I queried the template_store_ref using query below and found that there are 2 entries (updates from 2022) with state as 'DOWNLOAD_ERROR' - Note I have 3 Secondary Storage at this time - 1 will be retired. Whats the right way to clear this issue? select * from template_store_ref where download_state <> 'DOWNLOADED' and store_id = 1 -- this resulted in template id 238 and 253  -- 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]
