Repair actionscheduler_actions does not solve issue

#972264
  • Resolved Regio Online

    6 months, 2 weeks ago

    Rank Math free

    Hi,

    I read a few post about this issue. On our Apache VPS server we get a notice from Plesk after a backup that it can be restored but that there is a minor issue. This issue states (not using our real db name ofcourse):

    Unable to make database dump. Error: Failed to exec mysqldump: Exit code: 3: mysqldump: Error 1034: Index for table ‘WP_actionscheduler_actions’ is corrupt; try to repair it when dumping table WP_actionscheduler_actions at row: 0

    Clicking on the table for more info it states #1034 wrong search key file for table.

    We also use WP Rocket and Site Kit from Google that might have an effect on this table, but can not reproduce that. All our themes and plugins are updated to their latest versions.

    I read about a bug in RankMath possible relating to this. Our current version is Versie 1.0.238

    I have tried REPAIR TABLE wp_actionscheduler_actions;

    That gives an operation failed

    Is this a bug that wille be resolved in your next realease a stated somewhere else or do I have use one of your other suggested solutions:
    1. install and run plugin ‘repair-action-scheduler-master.zip’
    2. install and run plugin ‘action -scheduler.3.9.2.zip’

    At two moments (after update of WordPress, our tagdiv theme Newspaper and plugin RankMath) our VPS gave databaseerrors, both on our website and our Plesk VPS (500 db error). The server had to be rebooted twice since.

    Making a dump of our database fails due to the error in action-schedule table.

    Can you give any advice what would be the right aproach fix that table?

    Thanks in advace for you time and efforts!

Viewing 3 replies - 1 through 3 (of 3 total)
  • RankBot

    6 months, 2 weeks ago

    Hello,

    We apologize for the issue you are facing with the actionscheduler_actions table. It seems like a complex situation involving database corruption, and we appreciate you providing detailed information about the errors you’re encountering.

    Given the error messages and the steps you’ve already taken, here are a few suggestions:

    1. Backup Your Database: Before proceeding with any further actions, ensure you have a complete backup of your database. This is crucial to avoid any data loss.

    2. Repair Action Scheduler Plugin: Since you mentioned trying to repair the table using SQL commands without success, we recommend using our Repair Action Scheduler plugin. You can download it from here and follow the instructions to install it. This plugin is designed to fix issues with the Action Scheduler tables automatically.
      Repair Action Scheduler Error Plugin

    3. Check for Conflicts: Since you are using WP Rocket and Site Kit, consider temporarily deactivating these plugins to see if they might be causing any conflicts with the Action Scheduler.

    4. Recreate Database Tables: If the above steps do not resolve the issue, you may want to try recreating the database tables for Rank Math. You can do this by navigating to Rank Math SEO → Status & Tools → Database Tools in your WordPress dashboard and selecting the option to "Re-create Tables".
      recreate tables

    5. Contact Hosting Provider: Since this issue also affects your VPS and Plesk, it might be beneficial to reach out to your hosting provider for assistance. They may have tools or insights that can help resolve database corruption issues.

    6. Monitor for Updates: Keep an eye on future updates from Rank Math, as we are continuously working on improvements and bug fixes that may address underlying issues related to the Action Scheduler.

    If you continue to experience problems after trying these solutions, please reply to this ticket with your site URL and any additional details, and a human agent from our support team will assist you further.

    Thank you for your patience, and we hope this helps resolve your issue!

    Regio Online

    6 months, 2 weeks ago

    Rank Math free

    Hi,

    We resolved the issue by exporting the [name]-actionscheduler_actions table from another wp site, importing it into our database, delete the old wp-actionscheduler_actions table and replace the prefix wp from that specific table to [name].

    Completly different data inside but it works.

    Ike

    6 months, 2 weeks ago

    Hello,

    We’re delighted to hear that this issue has been resolved. We appreciate your feedback.

    This ticket will be closed now, but if you ever have another question or need any help in the future, please don’t hesitate to create a new forum topic. We’ll be more than happy to assist you.

    Thank you.

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

The ticket ‘Repair actionscheduler_actions does not solve issue’ is closed to new replies.