• Resolved tanusree1984

    (@tanusree1984)


    Getting the following multiple error log :
    WordPress database error Deadlock found when trying to get lock; try restarting transaction for query UPDATE wp_actionscheduler_actions SET attempts = attempts+1, status=’in-progress’, last_attempt_gmt = ‘2020-10-05 09:42:59’, last_attempt_local = ‘2020-10-05 05:42:59’ WHERE action_id = 2101980 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_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_DBStore->log_execution

    Please help with the reason and solution

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Ron Rennick

    (@wpmuguru)

    @tanusree1984 Sorry to hear you are having those. The deadlocks delay but don’t prevent an action from being run. The next version of Action Scheduler will have a fix for the deadlocks https://github.com/woocommerce/action-scheduler/pull/535

    In the interim you can use the following filter to disable the Async runner:

    
    add_filter( 'action_scheduler_allow_async_request_runner', '__return_false' );
    
    Thread Starter tanusree1984

    (@tanusree1984)

    Thanks for the reply. I will check it by adding the following line in function.php and will let you know:
    add_filter( ‘action_scheduler_allow_async_request_runner’, ‘__return_false’ );

    • This reply was modified 4 years, 5 months ago by tanusree1984.
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Getting an error log’ is closed to new replies.