WordPress database error Commands out of sync;

  • Resolved UmbrellaWeb

    (@umbrellaweb)


    1 year, 12 months ago

    Hello,

    So on a fresh clean install with NO issues at all with any functionality we installed this plugin and did a test…

    First, it doesnt even show and data on the recoverable screen after we did our test.

    Waitied 15 mins thinking it would populate but nothing. Then checked server logs and we have wordpress debug enabled. Basically this is whats getting logged:

    [28-Apr-2022 16:13:18 UTC] WordPress database error Commands out of sync; you can't run this command now for query UPDATEoptionsSEToption_value= '1651162458' WHEREoption_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, update_option
    [28-Apr-2022 16:13:18 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT COUNT(DISTINCT claim_id) FROM actionscheduler_actions WHERE claim_id != 0 AND status IN ( ‘pending’, ‘in-progress’) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_AsyncRequest_QueueRunner->maybe_dispatch, ActionScheduler_AsyncRequest_QueueRunner->allow, ActionScheduler_Abstract_QueueRunner->has_maximum_concurrent_batches, ActionScheduler_DBStore->get_claim_count
    [28-Apr-2022 16:13:18 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT a.action_id FROM actionscheduler_actions a WHERE 1=1 AND a.status IN (‘pending’) AND a.scheduled_date_gmt <= ‘2022-04-28 16:13:18’ LIMIT 0, 5 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_AsyncRequest_QueueRunner->maybe_dispatch, ActionScheduler_AsyncRequest_QueueRunner->allow, ActionScheduler_Store->has_pending_actions_due, ActionScheduler_DBStore->query_actions`

    Tested a few times and each time around 15 mins has passed no email is sent BUT the above is recorded in the debug log.

    No other plugins have any issues. ALso tested on a fresh install with default storefront theme and woo and this plugin. Same issue. the only thing we have enabled is the postsmtp plugin which is required as wpmail fuction on the server is diabled.

    Everything seems to point to your plugin being poorly coded…

    Can you advise and fix?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support CartFlows Team

    (@cartflows)

    1 year, 12 months ago

    Hello @umbrellaweb,

    Thank you for reaching out to us.

    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.

    If you still facing the same issue then please contact our dev team by submitting the contact form on our website. Please refer to the below link for the same.
    – https://wordpress.org/support/topic/read-this-first-42/

    Thread Starter UmbrellaWeb

    (@umbrellaweb)

    1 year, 12 months ago

    Hello,

    NO cache plugin is installed at all.
    DB size is not exhausted its only 19MB in size
    Theme being used is flatsome PLUS tested on storefront with same issue

    Incomplete query… well YES its your plugin thats the issue with the incomplete query as per the log I shared:
    `WHERE claim_id != 0 AND status IN ( pending, in-progress) made by shutdown_action_hook’

    claim_id is your record is it not?

    FYI way to go copying and answer and sligthly editing and posting as a reply. Not professional at all.

    CLearly an issue with your plugin and code error. As stated happens on a stock WP site with NO additional plugins etc…

    Plugin Support CartFlows Team

    (@cartflows)

    1 year, 11 months ago

    Hello @umbrellaweb,

    The plugin does not have any record or query for the claim_id. Our developers tried to replicate the same at our end but it’s not replicated.

    Can you please contact our developers by submitting the contact form on our website?
    Please refer to the below link for the same.
    – https://wordpress.org/support/topic/read-this-first-42/

    Thread Starter UmbrellaWeb

    (@umbrellaweb)

    1 year, 11 months ago

    Hello,

    Thanks for the update. After invesigating and testing for a few days we have moved away from your plugin and are using a different better on which doesnt have this issue.

    We may come back to yours in the future if and when its fixed/updated and has more features.

    thanks.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WordPress database error Commands out of sync;’ is closed to new replies.