josephs8 Posted December 9 Posted December 9 I enabled archiving to offload some of the posts in our forums_posts table as it has gotten quite large and these topics are not actively used anymore. Before enabling archiving, I ran a query to check the size of the tables, and after letting a few hours go by the size has not changed and none of the posts appear to have been archived even though it shows that 90% of the posts should be archived. I looked at the scheduled task and it is running every 5 minutes and no errors are being reported in the log. What do I need to do to get archiving working or any other ideas on what could be going wrong? Thanks!
Jim M Posted December 9 Posted December 9 Archiving is designed to be a slow process in order to not take over the resources of your server. The % in the forum archiving settings is not what has been archived but will be or has been archived per your settings. Your community currently is set to be offline and run background tasks via Traffic. Thus, it likely has not been processing if it has been offline since you have made the change to archive.
josephs8 Posted December 9 Author Posted December 9 Thanks Jim for the response. I’m sorry I wasn’t more clear I didn’t assume the percentage in the archiving was the process rather the amount of posts that would be archived. Meaning I would expect my forums_posts table to shrink significantly. The site has not been offline the entire time so the tasks are running. I also went and verified that the archive posts task is running every 5 minutes and ran several minutes before the last time I checked it. Yet no progress has been made, the size of the table forums_archive_posts has not changed at all.
Jim M Posted December 9 Posted December 9 Thanks for the clarification. Running the task manually, it seems to run without issue. Your server is running a little on the slow side so things are hard for me to troubleshoot. I would recommend downgrading to PHP 8.1 as 8.2 is not supported. I would also check to see if the archive table now in your database has any entries. As simply comparing size doesn't necessarily mean anything till MySQL garbage collection has cleared and recalculated the size of the database.
Recommended Posts