• Resolved Josivandro Avelar

    (@josivandroavelar)


    Despite the error being very similar to the same topic opened today, I decided to open a new one to show the problem in question in a more specific way, and which in our case is resulting in inconvenience.

    Some errors began to appear frequently on the onibusetransporte.com website, until on Friday the company responsible for hosting the website suspended the service for having exceeded the limits established by it, and this being a dedicated hosting. I contacted the company and the owner of the site, and they sent me an error log where these lines appear several times, and the vast majority related to Jetpack:

    [06-Jul-2023 15:26:56 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
    [06-Jul-2023 15:26:56 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
    [06-Jul-2023 15:26:56 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
    [06-Jul-2023 15:26:57 UTC] WordPress database error Commands out of sync; you can't run this command now for query UPDATE wp_options SET option_value = 'a:1:{i:0;s:25:\"{{WP_PLUGIN_DIR}}/jetpack\";}' WHERE option_name = '_transient_jetpack_autoloader_plugin_paths' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Autoloader\jpf11009ded9fc4592b6a05b61ce272b3c_jetpack?12_3\Shutdown_Handler->__invoke, Automattic\Jetpack\Autoloader\jpf11009ded9fc4592b6a05b61ce272b3c_jetpack?12_3\Plugins_Handler->cache_plugins, set_transient, wp_cache_set, WP_Object_Cache->set, WP_Object_Cache->_transient_set, update_option
    [06-Jul-2023 15:26:57 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 ('rank_math_notifications', 'a:0:{}', 'yes') 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, MyThemeShop\Notification_Center->update_storage, update_option, add_option
    [06-Jul-2023 15:26:57 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
    [06-Jul-2023 15:26:57 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
    [06-Jul-2023 15:26:57 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
    [06-Jul-2023 15:26:57 UTC] WordPress database error Commands out of sync; you can't run this command now for query UPDATE wp_options SET option_value = 'a:1:{i:0;s:25:\"{{WP_PLUGIN_DIR}}/jetpack\";}' WHERE option_name = '_transient_jetpack_autoloader_plugin_paths' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Autoloader\jpf11009ded9fc4592b6a05b61ce272b3c_jetpack?12_3\Shutdown_Handler->__invoke, Automattic\Jetpack\Autoloader\jpf11009ded9fc4592b6a05b61ce272b3c_jetpack?12_3\Plugins_Handler->cache_plugins, set_transient, wp_cache_set, WP_Object_Cache->set, WP_Object_Cache->_transient_set, update_option
    [06-Jul-2023 15:26:57 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 ('rank_math_notifications', 'a:0:{}', 'yes') 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, MyThemeShop\Notification_Center->update_storage, update_option, add_option
    [06-Jul-2023 15:26:57 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
    [06-Jul-2023 15:26:57 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
    [06-Jul-2023 15:26:57 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

    What happens is that these errors generated spikes in consumption of hosting resources that resulted in the suspension of the site, which I was able to revert with the company, but which would be definitive in an eventual second time. I ended up disabling wp-cron, which in a way eased the problems, but in a few hours, you can see that the peaks are back. I wanted a definitive resolution of the problem so that the customer no longer has problems with the hosting, after all something is wrong.

    Thank you in advance for the answers to be given.

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Bruce (a11n)

    (@bruceallen)

    Happiness Engineer

    Hi @josivandroavelar

    Thanks for the details. I just refreshed the sync on the site and it the Jetpack connection seems better now. Can you keep an eye on it and see if things improve?

    Thread Starter Josivandro Avelar

    (@josivandroavelar)

    Apparently yes, but I had to disable wp-cron and create a custom cron job to control the spikes.

    That’s good to know. Thanks for letting us know.

    Note that disabling wp-cron might also disable background syncing for other plugins and services, which may not be ideal. I suppose you took all of that into consideration.

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