Error in the logs

  • Resolved ddayoverlordwebmaster

    (@ddayoverlordwebmaster)


    1 month ago

    I had to desactivate this plugin which is causing a recurring error. It appears in the logs (every 5 seconds or so), overloading my server.

    AH10131: FastCGI: server "/homez.487/website/www/wp-admin/admin-ajax.php" stderr: PHP message: WordPress database error Deadlock found when trying to get lock; try restarting transaction for query UPDATE website_actionscheduler_actions SET claim_id=2848946, last_attempt_gmt='2025-02-21 15:40:40', last_attempt_local='2025-02-21 17:40:40' WHERE claim_id = 0 AND scheduled_date_gmt <= '2025-02-21 15:40:40' AND status='pending' ORDER BY priority ASC, attempts ASC, scheduled_date_gmt ASC, action_id ASC LIMIT 25 made by do_action('wp_ajax_as_async_request_queue_runner'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Async_Request->maybe_handle, ActionScheduler_AsyncRequest_QueueRunner->handle, do_action('action_scheduler_run_queue'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_DBStore->stake_claim, ActionScheduler_DBStore->claim_actions

    It does not appear with other plugins, just this one.

    Thanks for your support.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Rank Math Support

    (@rankmathsupport)

    Hello @ddayoverlordwebmaster,
    ?
    Thank you for contacting Rank Math support.
    ?
    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.
    ?
    Please do not hesitate to let us know if you need our assistance with anything else.

    Thread Starter ddayoverlordwebmaster

    (@ddayoverlordwebmaster)

    Sorry but the only way for me to stop these recurring errors was to desactivate the plugin. Every time I activate this plugin, the same deadlock errors come back.

    Plugin Support Rank Math Support

    (@rankmathsupport)

    Hello @ddayoverlordwebmaster,
    ?
    Please check with your host and ask them to increase the limits of the database server. If that’s not possible, ask them to cleanup the actionscheduler tables to fix the issue.
    ?
    Let us know how that goes. Looking forward to helping you.

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.