GitHub user JoaoJandre added a comment to the discussion: DB table "vm_stats" is keeping data more than 4 months
It is most likely the same situation that led me to create #8740, where there's a timeout deleting the stats one day and since there's even more stuff to delete the next day... it just times out every day. In #8740 I created a configuration called `vm.stats.remove.batch.size` batch delete the data instead of trying to delete all of it in a single query. The configuration has since been renamed to `delete.batch.query.size` in #9283. You may try to set this configuration to a sane value and see if ACS is able to delete the stats. I would advise against truncating the table. If you do not set the configuration, it is likely that this behavior will come back. GitHub link: https://github.com/apache/cloudstack/discussions/11131#discussioncomment-13651697 ---- This is an automatically sent email for users@cloudstack.apache.org. To unsubscribe, please send an email to: users-unsubscr...@cloudstack.apache.org
