GitHub user andrijapanicsb added a comment to the discussion: Usage Server - Cleanup database and start fresh new
stop all usage and mgmt servers: TRUNCATE TABLE cloud_usage.cloud_usage; Or even better, if historical data is of no importance - uninstalll usage server, mysql: drop database cloud_usage; (don't drop "cloud") As for the duplicate otherwise the only supported way is API to remove raw usage records (stupid name - since it's the resulting records in cloud_usage.cloud_usage - and all this API does is "delete from cloud_usage table where start (or maybe end date) > xxxxxx ensure your agregation period was not changed from daily (1440 to 60min) - you will have 24x more records in the cloud_usage table. GitHub link: https://github.com/apache/cloudstack/discussions/14252#discussioncomment-19298957 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
