too many mollie_woocommerce_cancel_unpaid_orders

Hi @djrgr,

Are you using the expiry date setting for any of your Mollie payment gateways?
With version 7.2.0 does this behavior not persist for you? This part of the code was not touched for the latest update, so I’m not sure why it would suddenly cause a change.

When this setting is turned off, no mollie_woocommerce_cancel_unpaid_orders scheduled actions should be created.
New scheduled actions may be created in the specified interval when the setting is enabled. But 116236 actions sound quite excessive, even if you were to set all gateways to check every minute.
Can you reproduce this behavior on a separate staging site with all plugins except for WooCommerce and Mollie disabled?

Deleting these entries should not be a major problem and could be done with an SQL query like this. This may need adjustments according to your database table prefix. Before you execute any code in your database, please create a full backup to be on the safe side.
Thanks!

Kind regards,
Niklas

Hi Niklas, thank you for your response.

I tried removing the mollie plugin but it wouldn’t stop creating the scheduled actions.

Even with the mollie plugin installed it keeps on creating these actions.

I think that I have found a solution to this.

Let me try to describe this for you.

For a couple of days I had a problem with mollie_woocommerce_cancel_unpaid_orders rising to alarming levels in the Scheduled actions option in woocommerce.

if I would navigate to mysite.com/wp-admin/admin.php?page=wc-status&tab=action-scheduler

I would see that the mollie_woocommerce_cancel_unpaid_orders would rise to alarming levels.

I would for example see

All (301309) | Complete (280131) | Pending (21160) | In-progress (1) | Failed (2) | Canceled (15)

and the list would be flooded with mollie_woocommerce_cancel_unpaid_orders.
And it would rise continuously and go higher and higher.

I have no idea what would create this flood and avelanche of mollie_woocommerce_cancel_unpaid_orders in scheduled actions and the actions (pending, completed and such) would constantly increase.

but I think I have solved this.

What you should do when you encounter this problem is go to the advanced settings tab in the mollie settings (your site.com/wp-admin/admin.php?page=wc-settings&tab=mollie_settings&section=advanced) and look for a checkbox that says:
(dutch) Verwijder opties en geplande acties uit de database bij het de?nstalleren van de plugin. (clear now)

(english): Remove options and scheduled actions from database when you are deinstalling the plugin. (clear now)
I have no idea what the English translation is of this option.

Check this box and reinstall the mollie plugin.

This should slowly decrease the scheduled actions for the mollie_woocommerce_cancel_unpaid_orders thing.

I hope this helps.

Also, when you do this you should see a notification in the scheduled actions part that says

(dutch) Migratie van Action Scheduler wordt uitgevoerd. De lijst met geplande acties kan onvolledig zijn.

(English) migrating action scheduler, the list of scheduled actions can be incomplete.

I hope that these things are migrated to an tropical island half way across the planet.

Hi @djrgr,

Thanks for the feedback.
Our QA has checked the report but we couldn’t find a way to cause a scenario where excess scheduled actions are created.
Since removing the settings appears to have solved the problem for you, maybe the settings got corrupted somehow, though it’s not quite clear how.
Can you confirm now that after resetting the Mollie settings no more scheduled actions are created?
If at all, these actions should only be created when the gateway expiry feature has been enabled for at least one Mollie gateway. And when it’s disabled, no actions should be created.
Thank you!

Kind regards,
Niklas

Thank you for your response.

And you are right, the scheduled actions stopped being created.

As a matter of fact, the total amount of scheduled actions is constantly declining as the system is deleting old actions.

Thanks for confirming, @djrgr!
A while back, there was an (unrelated) issue that caused too many actions to be created, and since then, the plugin should be extra careful in creating these. So there should be certain safeguards to prevent behavior like the one you reported.
If there are still thousands of these actions, the remaining ones could also be manually removed, or via the SQL query linked above.
Bbefore making any database adjustments, a new database backup should first be made.
Otherwise, WooCommerce continues to delete them in small batches.

Kind regards,
Niklas

By now, there are multiple mechanisms in the plugin that should prevent problems with scheduled actions and we are confident that everything in this regard should be working reliably.
If anything suggests otherwise for you, please do not hesitate to let us know.
Thank you!

Kind regards,
Niklas