WordPress database error / Rankmath database lock

#880726
  • Resolved Ewan Fleischmann

    1 year, 4 months ago

    Rank Math free

    Hi – the site has been locked for about a minute. In that time, the site was “dead”, i.e., not queries had been answered.

    Is this a known issue? (see log below)

    [23-Sep-2024 16:55:23 UTC] WordPress database error Lock wait timeout exceeded; try restarting transaction for query UPDATE wp_options SET option_value = ‘1’, autoload = ‘off’ WHERE option_name = ‘rank_math_viewed_seo_analyer’ made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\SEO_Analysis\SEO_Analyzer->set_url, update_option
    [23-Sep-2024 16:55:23 UTC] WordPress database error Lock wait timeout exceeded; try restarting transaction for query UPDATE wp_options SET option_value = ‘1’, autoload = ‘off’ WHERE option_name = ‘rank_math_viewed_seo_analyer’ made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\SEO_Analysis\SEO_Analyzer->set_url, update_option
    [23-Sep-2024 16:55:23 UTC] WordPress database error Lock wait timeout exceeded; try restarting transaction for query UPDATE wp_options SET option_value = ‘1’, autoload = ‘off’ WHERE option_name = ‘rank_math_viewed_seo_analyer’ made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\SEO_Analysis\SEO_Analyzer->set_url, update_option
    [23-Sep-2024 16:56:13 UTC] WordPress database error Lock wait timeout exceeded; try restarting transaction for query UPDATE wp_options SET option_value = ’66f19d7baa8388.65690089|1727110583′ WHERE option_name = ‘action_scheduler_lock_async-request-runner’ AND option_value = ’66f19d132a9298.54351260|1727110479′ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set
    [23-Sep-2024 16:56:13 UTC] WordPress database error Lock wait timeout exceeded; try restarting transaction for query UPDATE wp_options SET option_value = ’66f19d7ba9e242.52351553|1727110583′ WHERE option_name = ‘action_scheduler_lock_async-request-runner’ AND option_value = ’66f19d132a9298.54351260|1727110479′ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set
    [23-Sep-2024 16:56:13 UTC] WordPress database error Lock wait timeout exceeded; try restarting transaction for query UPDATE wp_options SET option_value = ’66f19d7baf6207.94354080|1727110583′ WHERE option_name = ‘action_scheduler_lock_async-request-runner’ AND option_value = ’66f19d132a9298.54351260|1727110479′ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set

    Best regards

Viewing 1 replies (of 1 total)
  • Reinelle

    1 year, 4 months ago

    Hello,

    Thank you for contacting Rank Math and bringing your concern to our attention. I’m sorry for any inconvenience this issue may have caused you.

    From the error log you shared, it seems that your database is getting a deadlock error.

    Deadlock errors occur when multiple functions try to update the same areas of the database at the same time. By looking at the logs, it seems like your ActionScheduler tables are getting filled with data and causing issues with the database server.

    ​​​​​​​In this case, you can get in touch with your hosting provider and ask them to increase the limits of the database server. If they’re unable to do that, the only other option might be to do a cleanup on those tables related to ActionScheduler so that the deadlock no longer exists.

    Let us know how this goes.

    RankBot

    1 year, 3 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 1 replies (of 1 total)

The ticket ‘WordPress database error / Rankmath database lock’ is closed to new replies.