Over 100,000 queue items from "Freeform: Purging Unfinalized Assets"

[Coysh]

What happened?

Unsure how long this has been happening, but I have thousands of "Freeform: Purging Unfinalized Assets" in my queue.
It seems they are being processed, but not as fast as they're being added.

Even running queue/release all and then queue shows over 1,000 within seconds.

Errors and Stack Trace (if available)

How can we reproduce this?

1. Restart server
2. Do nothing
3. Look at queue manager

Freeform Edition

Pro

Freeform Version

5.8.7

Craft Version

4.13.10

When did this issue start?

Unsure

Previous Freeform Version

No response

[kjmartens]

Hi @Coysh,

I'm very sorry for the trouble you're experiencing.

Can you provide us with a screenshot of your Freeform Diagnostics page? I'm having a developer check into it shortly, but these details may help track the issue down quickly. 🙂

In the meantime, you can try disabling the Automatically Purge Unfinalized Assets setting (under General Settings) to stop this from overwhelming your server.

[Coysh]

@kjmartens @gustavs-gutmanis
There isn't a disable button - but it's already set to two weeks:

Diagnostics page:

[kjmartens]

Sorry about that @Coysh. This is actually a new setting in Freeform 5.9 (will be released today or tomorrow). I thought this was released earlier.

Thanks for the information about the asset purge setting, however. That may be a very helpful clue.

[Coysh]

Hi @kjmartens is there anything I can do before the release? My mysql process is running at 200% at significantly impacting the server.

[kjmartens]

@Coysh If you're okay with it, you could manually get the 5.9 version of Freeform now:
https://docs.solspace.com/craft/freeform/v5/setup/installing-updating/#getting-latest-unreleased-version

Please review the documentation instructions, but essentially, you would do the following:

1. BACK UP YOUR DATABASE
2. Update your site's main composer.json file to: "solspace/craft-freeform": "dev-feat/v5.9",
3. Run composer update
   • Keep in mind that composer update may update other packages if the versions are not locked.
4. Go to Freeform -> General Settings -> Disable the Automatically Purge Unfinalized Assets setting

[Coysh]

@kjmartens - Great thanks, that's done the job.

[kjmartens]

Awesome, thanks! 👍

We will still be looking into the root issue here. 🙂

[kjmartens]

This should now be resolved in Freeform 5.9. 🙂