Stuck in-progress

  • Resolved Majid

    (@majidempire)


    11 months, 2 weeks ago

    Hi,

    I am using some plugins like Automatewoo and Woocommerce and when I have many task to do in Q I get failed actions and this message

    2023-12-16 00:26:37 +0000
action created
2023-12-16 00:26:37 +0000
action started via Async Request
2023-12-16 00:32:00 +0000
action marked as failed after 300 seconds. Unknown error occurred. Check server, PHP and database error logs to diagnose cause

    I looked in the logs and I found that there is an error log in wordpress debug that maybe related and it is:

    WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' 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, ActionScheduler_OptionLock->get_existing_lock, QM_DB->query

    Can anyone help me to solve this

    Thanks

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

  • Hi Majid,

    This may be related to a caching issue: there are a few other responses that address this particular error, if the steps suggested here do not work, please let us know.

    The Commands out of sync error occurred in below three cases.
    1. If you are using the cache plugin.
    2. If the memory size is exhausted.
    3. Incomplete query is written in plugin or theme.

    Can you please try the below steps to identify the issue?

    – If you are using any cache plugin or server cache then please disable it and check it again.

    – Check if your site database memory size is exhausted or not.

    – Switch to another theme and disable all other plugins and check if the issue is resolved or not.

    Thread Starter Majid

    (@majidempire)

    It’s been quite a journey troubleshooting this issue. Despite numerous optimizations made to database variables, PHP, and the web server, I couldn’t pinpoint the root cause. Tasks were still getting stuck in progress. However, a breakthrough came when I decided to utilize WP CLI to execute the actionscheduler task. Miraculously, it seems to have resolved the problem. Its efficiency surpasses that of wp-cron.php, and thankfully, it worked seamlessly for me.

    Also, thank you for your reply to this thread!

    So great to hear you were able to resolve it. Our team did also flag it as a GitHub issue. If you can, please respond directly to our team there to continue investigation and give feedback on the issue.

    Thank you for reaching out!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Stuck in-progress’ is closed to new replies.