>70Million Scheduled actions? - Support

Resolved Maurice
4 years, 3 months ago

Rank Math free

After installing Rankmath (replaced YOAST), I have a DB table wp_actionscheduler_actions which is >60GB large.

It contains >70 million records.

ALL these records seem to be rank_math/analytics/flat_posts and are pending. (I didn’t check all of them)

We have a total of over 15K posts and >200k pageviews per day.

But 70 million pending actions is insane.

What are these?

Can I delete them via phpMyAdmin?

Regards,
Maurice

Viewing 9 replies - 1 through 9 (of 9 total)

Rank Math
4 years, 3 months ago

Hello

Thank you for contacting the support and sorry for any inconvenience that might have been caused due to that.

Can you please list the plugins installed on your website?

Looking forward to helping you.

Maurice
4 years, 3 months ago

Rank Math free

Hello,

Not sure what this has to do with it. But here’s the list:

Admin Columns Pro
Akismet Anti-Spam
Arqam
Cloudflare
Comet Cache
Custom Login Page Customizer
E-Mail Log
Featured Images in RSS for Mailchimp & Other Email
Google Language Translator
Gravitec.net – Web Push Notifications
Classic editor
mPress Image Refresh
Rank Math SEO
Really Simple SSL
Redis Object Cache
ShareThis Share Buttons
Simple Responsive Slider
SO Jetpack Stats Only
Sticky Menu (or Anything!) on Scroll
Sucuri Security – Auditing, Malware Scanner and Hardening
Text Spinner
ThirstyAffiliates
Thrive Architect
Thrive Comments
Thrive Leads
Thrive Product Manager
UsageDD
WP Mail SMTP
WP Missed Schedule
WPLinkTrade

Rank Math
4 years, 3 months ago

Hello,

It seems like the cron job got stuck and has created those many entries.

It should not have happened.

Yes, please delete all those tables after taking a backup of everything but that table.

Please let us know. Thank you.

Maurice
4 years, 2 months ago

Rank Math free

I cannot delete all those tables, because it’s a live site. I am now trying to delete all those records. In the meantime it grew to >80GB.

This is really a nightmare and I will have to disable Rank Math immediately. It’s completely destroying our website.

Balazs
4 years, 2 months ago

Hello,

This issue is caused by a third-party library included in Rank Math. We have contacted its authors and we’re working together to find a solution for this.

In the meantime, you have the following options:

Before doing any action, I recommend taking a backup of your database.

A. Turn off the Analytics module in Rank Math. That should stop the records from getting added to the table. You can also empty (truncate) those actionscheduler tables to free up space.

B. You can try our Repair Action Scheduler plugin that can fix this issue automatically on most sites: https://github.com/rankmath/_repair-action-scheduler On the Github page I linked, click on the green “Code” button and then on “Download ZIP”. Then upload that zip file to your site on this admin page: Plugins > Add New > Upload Plugin. Once you activate the plugin, it should do its thing and then deactivate itself automatically. Then you should be able to use Rank Math without any issue.

Hope that helps.

Maurice
4 years, 2 months ago

Rank Math free

Hi Balazs,

Thanks for responding quickly. I have asked our server admin to truncate the table. Then I will take the actions you suggested. Thank you!

Kind regards,
Maurice
Maurice
4 years, 2 months ago

Rank Math free
We were able to empty the wp_actionscheduler_actions table (>83GB) and the wp_ysqe_actionscheduler_logs table (>11GB).

I installed the plugin Repair Action Scheduler. After activating, it says that everything is fine and that no actions were taken. The plugin disabled itself when it was done. (almost immediately)

I re-enabled Rank Math and within 1 minute, we already had >50Mb of data in the wp_actionscheduler_actions table.

While this was happening I re-enabled the Repair Action Scheduler, while Rank math was running. Same result. It says that everything is fine and that no actions were taken. The plugin disabled itself again.

In the meantime the table was flooded with actions, so I had to disable Rank Math again. The Repair Action Scheduler plugin does not help in this case.

Deactivating logging is not an option. So I set it to 0. But that doesn’t do anything for these two tables. They still get flooded extremely fast as soon as Rank Math is enabled.

Kind regards,
Maurice
- This reply was modified 4 years, 2 months ago by Maurice.
Maurice
4 years, 2 months ago

Rank Math free
Maybe I am confused. Logging and Analytics. Where should I disable the Analytics module?

EDIT: Found it. Disabled SEO Analysis. This function apparently scanned the whole site in the background and flooded the tables.

Now, Rank Math is enabled and the tables don’t get flooded.
- This reply was modified 4 years, 2 months ago by Maurice. Reason: Edit
Balazs
4 years, 2 months ago

Hi Maurice,

I’m sorry the repair plugin didn’t work. We successfully used it in the past to fix a similar issue, where the logs table was getting filled up because of a wrong table structure.

Would it be possible for us to take a look at your database setup (with PhpMyAdmin)? This could be done through your host’s control panel, or by logging in to your site and installing a PhpMyAdmin plugin. Please share the WP login details (and optionally the cPanel login details) in the Sensitive Data field.

Thank you. Looking forward to helping you.

RankBot
4 years, 2 months ago

Hello,

Since we did not hear back from you for 15 days, we are assuming that you found the solution. We are closing this support ticket.

If you still need assistance or any other help, please feel free to open a new support ticket, and we will be more than happy to assist.

Thank you.

Viewing 9 replies - 1 through 9 (of 9 total)

The ticket ‘>70Million Scheduled actions?’ is closed to new replies.