hubwoo_ecomm_deal_upsert (past due)

Hello,

I hope you are doing well!

I wanted to inform you that we are going to release an update within 3 days which will resolve the scheduler issue if you want to resolve this issue in urgency, then please connect with our support team.

Best Regards,

Hi,

When is when release date?

@makewebbetter any updates?

Hi, I have the same problem. What I can do? I currently also have more than 300k of pending scheduled actions hubwoo_ecomm_deal_upsert

Thanks.

This isn’t resolved, not sure why it’s been marked as as such.

Seems to happen when it attempts to create HubSpot deal from a WooCommerce order that doesn’t exist.

Had to uninstall the plugin.

Hi,

I came across the same issue. There are 390,000+ pending hooks hubwoo_ecomm_deal_upsert even after I uninstalled the plugin. It happened with one order that was in auto-draft status.

Any idea how to clear those pending hooks?

Hey Mark,

I’ve been dealing with this issue for months, so I decided to suspend this plugin until a solution is provided. In the meantime, you can clean the scheduled events with this SQL solution:

SELECT hook, args, count(*) FROM wp_actionscheduler_actions WHERE status = 'pending' GROUP BY hook, args HAVING COUNT(*) > 5;

The script above will give you the hook(s) that is causing issues and the count of those entries. What you need to do next is anotate the args value, and based on that value, run the following next:

DELETE FROM wp_actionscheduler_actions WHERE status = 'pending' AND args in ('[21780]')
DELETE FROM wp_actionscheduler_actions WHERE status = 'complete' AND args in ('[21780]')

NOTE: In my case, the args value was ‘[21780]’, which is the order id value.

And to the MakeWebBetter team, I can see that an update was released a few days ago, but the release notes doesn’t give much info. Was this fixed in this version?

Looking forward to hearing from you,
AlbertoR

Its so sad!
Hope you’ll find the solution and re-animate this perfect in a past plugin.

Good luck!