AH01071: Got error ‘PHP message: WordPress database error Deadlock found

  • Resolved fixtura1976

    (@fixtura1976)


    1 year, 2 months ago

    Hello,

    After latest update of Woo core plugin, get the following error continuesly:

    AH01071: Got error ‘PHP message: WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM Gf0bhTk78R_actionscheduler_actions WHERE action_id = 11694675 made by do_action(‘wp_ajax_nopriv_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_Abstract_QueueRunner->run_cleanup, ActionScheduler_QueueCleaner->clean, ActionScheduler_QueueCleaner->delete_old_actions, ActionScheduler_QueueCleaner->clean_actions, ActionScheduler_QueueCleaner->delete_actions, ActionScheduler_HybridStore->delete_action, ActionScheduler_DBStore->delete_action; PHP message: WordPress database error Lock wait timeout exceeded; try restarting transaction for query DELETE FROM Gf0bhTk78R_actionscheduler_actions WHERE action_id = 11694676 made by do_action(‘wp_ajax_nopriv_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_Abstract_QueueRunner->run_cleanup, ActionScheduler_QueueCleaner->clean, ActionScheduler_QueueCleaner->delete_old_actions, ActionScheduler_QueueCleaner->clean_actions, ActionScheduler_QueueCleaner->delete_actions, ActionScheduler_HybridStore->delete_action, ActionScheduler_DBStore->delete_action; PHP message: WordPress database error Lock wait timeout exceeded; try restarting transaction for query DELETE FROM Gf0bhTk78R_actionscheduler_actions WHERE action_id = 11694677 made by do_action(‘wp_ajax_nopriv_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_Abstract_QueueRunner->run_cleanup, ActionScheduler_QueueCleaner->clean, ActionScheduler_QueueCleaner->delete_old_actions, ActionScheduler_QueueCleaner->clean_actions, ActionScheduler_QueueCleaner->delete_actions, ActionScheduler_HybridStore->delete_action, ActionScheduler_DBStore->delete_action’

    Also see the following Warning on Woo / Status page in admin panel:

    Action Scheduler migration in progress. The list of scheduled actions may be incomplete.

    Noticed READ disk server system traffic considerable increase.

    Site is working but was slowing till getting not responsive unless cache was reduced to 10 hours… Now seems work, no visual issues found so far

    ?

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter fixtura1976

    (@fixtura1976)

    Solved using wp-optimize plugin, cleaned up the database.

    Hi @fixtura1976

    Solved using wp-optimize plugin, cleaned up the database.

    It’s fantastic to hear that you managed to fix the problem you had with the Woo core plugin after its latest update. We really value your proactive stance and the details you’ve provided about employing the WP-Optimize plugin to tidy up the database.

    Your experience and solution could potentially help other users who may encounter the same issue, and we’re grateful for your contribution to the WooCommerce community.

    I’ll go ahead and mark this thread as resolved. However, if you ever have more questions or issues in the future, don’t hesitate to kick off a new topic.

    Hope you have a fantastic day!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘AH01071: Got error ‘PHP message: WordPress database error Deadlock found’ is closed to new replies.