WC Database Update progress STUCK

Update. I checked what was the issue by sorting hooks by numbers.
It seems that there is an issue with WP Rocket plugin and preload URL.

To solve the issue, on my staging site:
Disabled “link preloading” in the plugin and deleted all the complete & pending tasks with this.
Does it solve the issue? Do you think of anything else?
Thank you for your help.

• This reply was modified 2 years, 2 months ago by GW2Rewards.
• This reply was modified 2 years, 2 months ago by GW2Rewards.

Hi @gw2rewards

I’m glad you were able to find the culprit of your issue here.

To solve the issue, on my staging site:
Disabled “link preloading” in the plugin and deleted all the complete & pending tasks with this.
Does it solve the issue? Do you think of anything else?

You can try to run the same solution you did on the staging site to your live site and see if this resolves the issue.

Let us know how it goes!

Thank you @xue28

For now I excluded all the translated URLs from Preloading on WP Rocket (with /fr/ /de/ /es/ /pt/) and seeing if the problem is still there (I deleted all the pending/completed/failed “rocket_preload_job_preload_url”)

Right now after a few hours I see there are approximately +200 tasks with 74 pending. Does it seem normal to you? Are they supposed to stay pending like this? That does not seem normal to me ??

Will check tomorrow if it’s the same.
And I will try LiteSpeed instead of WP Rocket as Hostinger support told me it was better (is it real or just for partnership purposes?)