WordPress database error Commands out of sync

  • Resolved brad1st

    (@brad1st)


    7 months ago

    I had an issue with Third-party plugin on my website, also noticed mysql CPU usage increased on my dedicated server, so I decided to enable debug mode to check errors, i found these database errors written to the debug.log file

    [11-Jan-2024 21:58:48 UTC] 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 = 'jpsq_sync_checkout' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Dedicated_Sender::spawn_sync, Automattic\Jetpack\Sync\Queue->is_locked, Automattic\Jetpack\Sync\Queue->get_checkout_id
    [11-Jan-2024 21:58:48 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT count(*) FROM wp_jetpack_sync_queue WHERE queue_id = 'sync' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Dedicated_Sender::spawn_sync, Automattic\Jetpack\Sync\Queue->size, Automattic\Jetpack\Sync\Queue\Queue_Storage_Table->get_item_count
    [11-Jan-2024 21:58:48 UTC] 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 = 'jetpack_sync_full_status' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Sender->do_full_sync, Automattic\Jetpack\Sync\Modules\Full_Sync_Immediately->get_status, Jetpack_Options::get_raw_option

    now I suspect that mysql CPU usage increase is caused by Jet Pack plugin!

    WordPress version: 6.4.2
    Jetpack version: 13.0
    PHP: 8.1

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Dan (a11n)

    (@drawmyface)

    6 months, 2 weeks ago

    Hi there,

    The error messages you’ve provided indicate that there might be an issue with the Jetpack sync process. This kind of “Commands out of sync” error can happen if previous database commands were not properly closed before new commands were issued.

    Conflicting Plugin: Since you mentioned you had an issue with a third-party plugin, it would be beneficial to first ensure that there are no conflicts between that plugin and Jetpack. You can do this by temporarily deactivating other plugins and seeing if the problem persists.

    If that doesn’t help, could you please provide your website URL so that I can have a closer look at the issue? Additionally, if there have been any more recent error logs or other symptoms of the problem, please share those details as well.

    Thank you!

    Plugin Contributor Stef (a11n)

    (@erania-pinnera)

    6 months, 1 week ago

    Hi @brad1st,

    Do you have updates about that? We usually close inactive threads after one week of no movement, but we want to make sure we’re all set before marking it as solved. Thanks!

    Thread Starter brad1st

    (@brad1st)

    6 months, 1 week ago

    My apologies for responding late.
    I deactivated all other plugins even deleted the third-party plugin and the problem was persists.
    Now I have deleted Jetpack plugin on my website, after deleting the plugin everything went back to normal, CPU usage decreased no more database errors.
    since i no longer use the plugin you can close this thread. thanks!

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