WordPress database error Commands out of sync (errors caused site suspension)
-
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
SEToption_value
= 'a:1:{i:0;s:25:\"{{WP_PLUGIN_DIR}}/jetpack\";}' WHEREoption_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 INTOwp_options
(option_name
,option_value
,autoload
) VALUES ('rank_math_notifications', 'a:0:{}', 'yes') ON DUPLICATE KEY UPDATEoption_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 UPDATEwp_options
SEToption_value
= 'a:1:{i:0;s:25:\"{{WP_PLUGIN_DIR}}/jetpack\";}' WHEREoption_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 INTOwp_options
(option_name
,option_value
,autoload
) VALUES ('rank_math_notifications', 'a:0:{}', 'yes') ON DUPLICATE KEY UPDATEoption_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_optionWhat 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]
- The topic ‘WordPress database error Commands out of sync (errors caused site suspension)’ is closed to new replies.