WordPress database error: Commands out of sync

  • Resolved goldcakes

    (@lizgold)


    3 months, 2 weeks ago

    My site went down, and upon checking the debug log, I found a number of Jetpack errors, apparently due to attempts to update. Would appreciate some help.

    [17-Mar-2024 05:22:02 UTC] The jetpack_is_atomic_site function will be removed from the Jetpack plugin in version 10.9. [17-Mar-2024 05:22:03 UTC] Successfully loaded service schemas from server response. (fetch_service_schemas_from_connect_server) [17-Mar-2024 05:23:01 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 = ‘_transient_timeout_jetpack_update_remote_package_last_query’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Connection\Package_Version_Tracker->maybe_update_package_versions, Automattic\Jetpack\Connection\Package_Version_Tracker->is_rate_limiting, get_transient, get_option, QM_DB->query [17-Mar-2024 05:23:01 UTC]

    WordPress database error Commands out of sync; you can’t run this command now for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘_transient_timeout_jetpack_update_remote_package_last_query’, ‘1710653041’, ‘no’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Connection\Package_Version_Tracker->maybe_update_package_versions, Automattic\Jetpack\Connection\Package_Version_Tracker->is_rate_limiting, set_transient, add_option, QM_DB->query [17-Mar-2024 05:23:01 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, QM_DB->query [17-Mar-2024 05:23:01 UTC]

    WordPress database error Commands out of sync; you can’t run this command now for query SELECT count(*) FROM wp_options WHERE option_name LIKE ‘jpsq_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_Options->get_item_count, QM_DB->query [17-Mar-2024 05:23:01 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, QM_DB->query

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Stef (a11n)

    (@erania-pinnera)

    3 months, 2 weeks ago

    Hello @lizgold,

    Thanks for reporting this, and sorry for the trouble!

    The error messages seem to point to an issue with the Jetpack sync process. This kind of “Commands out of sync” error happens if previous database commands were not correctly closed before new commands were triggered.

    I checked your Jetpack connection, and it looks nice and healthy at the moment. Do you still see those errors at your end? If so, do let us know, and we’ll dig deeper.

    Plugin Support Joseph B. (a11n)

    (@tamirat22)

    3 months, 1 week ago

    Hello @lizgold,

    It’s been one week since this topic was last updated. I’m going to mark this thread as solved. If you have any further questions or need more help, you’re welcome to open another thread here. Cheers!

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.