• Resolved newzendesignnz

    (@newzendesignnz)


    Hello, we are getting the below error, but we do not even have jetpack installed, just wondering what it could be coming from
    
    
    [16-Nov-2023 09:07:40 UTC] WordPress database error Commands out of sync; you can't run this command now for query UPDATE wp_options SET option_value = 'a:0:{}' 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\jpf93d75411ac254bc7e8b67beb00ff064\Shutdown_Handler->__invoke, Automattic\Jetpack\Autoloader\jpf93d75411ac254bc7e8b67beb00ff064\Plugins_Handler->cache_plugins, set_transient, update_option
    [16-Nov-2023 21:32:55 UTC] Cron reschedule event error for hook: jetpack_sync_cron, Error code: could_not_set, Error message: The cron event list could not be saved., Data: {"schedule":"jetpack_sync_interval","args":[],"interval":300}
    [16-Nov-2023 21:33:25 UTC] Cron reschedule event error for hook: jetpack_sync_full_cron, Error code: could_not_set, Error message: The cron event list could not be saved., Data: {"schedule":"jetpack_sync_interval","args":[],"interval":300}
    [16-Nov-2023 22:32:59 UTC] Cron reschedule event error for hook: litespeed_task_lqip, Error code: could_not_set, Error message: The cron event list could not be saved., Data: {"schedule":"litespeed_filter","args":[],"interval":60}
    [16-Nov-2023 22:38:11 UTC] WordPress database error Commands out of sync; you can't run this command now for query UPDATE wp_options SET option_value = '1702766291' WHERE option_name = '_transient_timeout_woocommerce_blocks_asset_api_script_data_ssl' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Assets\Api->update_script_data_cache, set_transient, wp_cache_set, WP_Object_Cache->set, WP_Object_Cache->_transient_set, update_option
    [16-Nov-2023 22:38:11 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 = 'jp_sync_retry_after_sync' LIMIT 1 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\Sender->do_sync_and_set_delays, get_option
    [16-Nov-2023 22:38:11 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 = 'siteurl' LIMIT 1 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\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, do_action('jetpack_sync_before_send_queue_sync'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Modules\Callables->maybe_sync_callables, Automattic\Jetpack\Sync\Modules\Callables->get_all_callables, array_map, Automattic\Jetpack\Sync\Modules\Callables->get_callable, call_user_func, Automattic\Jetpack\Connection\Urls::site_url, Automattic\Jetpack\Connection\Urls::get_raw_or_filtered_url, Automattic\Jetpack\Connection\Urls::get_raw_url, Jetpack_Options::get_raw_option
    [16-Nov-2023 22:38:11 UTC] WordPress database error Commands out of sync; you can't run this command now for query UPDATE wp_options SET option_value = 'a:5:{i:0;s:5:\"https\";i:1;s:5:\"https\";i:2;s:5:\"https\";i:3;s:5:\"https\";i:4;s:0:\"\";}' WHERE option_name = 'jetpack_sync_https_history_site_url' 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\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, do_action('jetpack_sync_before_send_queue_sync'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Modules\Callables->maybe_sync_callables, Automattic\Jetpack\Sync\Modules\Callables->get_all_callables, array_map, Automattic\Jetpack\Sync\Modules\Callables->get_callable, call_user_func, Automattic\Jetpack\Connection\Urls::site_url, Automattic\Jetpack\Connection\Urls::get_raw_or_filtered_url, Automattic\Jetpack\Connection\Urls::get_protocol_normalized_url, update_option
    [16-Nov-2023 22:38:11 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 = 'home' LIMIT 1 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\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, do_action('jetpack_sync_before_send_queue_sync'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Modules\Callables->maybe_sync_callables, Automattic\Jetpack\Sync\Modules\Callables->get_all_callables, array_map, Automattic\Jetpack\Sync\Modules\Callables->get_callable, call_user_func, Automattic\Jetpack\Connection\Urls::home_url, Automattic\Jetpack\Connection\Urls::get_raw_or_filtered_url, Automattic\Jetpack\Connection\Urls::get_raw_url, Jetpack_Options::get_raw_option
    [16-Nov-2023 22:38:11 UTC] WordPress database error Commands out of sync; you can't run this command now for query UPDATE wp_options SET option_value = 'a:5:{i:0;s:5:\"https\";i:1;s:5:\"https\";i:2;s:5:\"https\";i:3;s:5:\"https\";i:4;s:0:\"\";}' WHERE option_name = 'jetpack_sync_https_history_home_url' 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\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, do_action('jetpack_sync_before_send_queue_sync'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Modules\Callables->maybe_sync_callables, Automattic\Jetpack\Sync\Modules\Callables->get_all_callables, array_map, Automattic\Jetpack\Sync\Modules\Callables->get_callable, call_user_func, Automattic\Jetpack\Connection\Urls::home_url, Automattic\Jetpack\Connection\Urls::get_raw_or_filtered_url, Automattic\Jetpack\Connection\Urls::get_protocol_normalized_url, update_option
    [16-Nov-2023 22:38:11 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 = '_site_transient_timeout_theme_roots' LIMIT 1 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\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, do_action('jetpack_sync_before_send_queue_sync'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Modules\Callables->maybe_sync_callables, Automattic\Jetpack\Sync\Modules\Callables->get_all_callables, array_map, Automattic\Jetpack\Sync\Modules\Callables->get_callable, call_user_func, Automattic\Jetpack\Sync\Functions::get_themes, wp_get_themes, search_theme_directories, get_site_transient, wp_cache_get, WP_Object_Cache->get, WP_Object_Cache->_transient_get, get_site_option, get_network_option, get_option
    [16-Nov-2023 22:38:11 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 = '_site_transient_theme_roots' LIMIT 1 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\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, do_action('jetpack_sync_before_send_queue_sync'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Modules\Callables->maybe_sync_callables, Automattic\Jetpack\Sync\Modules\Callables->get_all_callables, array_map, Automattic\Jetpack\Sync\Modules\Callables->get_callable, call_user_func, Automattic\Jetpack\Sync\Functions::get_themes, wp_get_themes, search_theme_directories, get_site_transient, wp_cache_get, WP_Object_Cache->get, WP_Object_Cache->_transient_get, get_site_option, get_network_option, get_option
    [16-Nov-2023 22:38:11 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 ('_site_transient_timeout_theme_roots', '1700176091', '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\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, do_action('jetpack_sync_before_send_queue_sync'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Modules\Callables->maybe_sync_callables, Automattic\Jetpack\Sync\Modules\Callables->get_all_callables, array_map, Automattic\Jetpack\Sync\Modules\Callables->get_callable, call_user_func, Automattic\Jetpack\Sync\Functions::get_themes, wp_get_themes, search_theme_directories, set_site_transient, wp_cache_set, WP_Object_Cache->set, WP_Object_Cache->_transient_set, add_site_option, add_network_option, add_option
    [16-Nov-2023 22:38:11 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 ('_site_transient_theme_roots', 'a:2:{s:5:\"astra\";s:7:\"/themes\";s:16:\"twentytwentyfour\";s:7:\"/themes\";}', '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\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, do_action('jetpack_sync_before_send_queue_sync'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Modules\Callables->maybe_sync_callables, Automattic\Jetpack\Sync\Modules\Callables->get_all_callables, array_map, Automattic\Jetpack\Sync\Modules\Callables->get_callable, call_user_func, Automattic\Jetpack\Sync\Functions::get_themes, wp_get_themes, search_theme_directories, set_site_transient, wp_cache_set, WP_Object_Cache->set, WP_Object_Cache->_transient_set, add_site_option, add_network_option, add_option
    [16-Nov-2023 22:38:11 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_sync_constants_await' LIMIT 1 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\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, do_action('jetpack_sync_before_send_queue_sync'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Modules\Constants->maybe_sync_constants, get_transient, wp_cache_get, WP_Object_Cache->get, WP_Object_Cache->_transient_get, get_option
    [16-Nov-2023 22:38:11 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_jetpack_sync_constants_await' LIMIT 1 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\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, do_action('jetpack_sync_before_send_queue_sync'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Modules\Constants->maybe_sync_constants, get_transient, wp_cache_get, WP_Object_Cache->get, WP_Object_Cache->_transient_get, get_option
    [16-Nov-2023 22:38:11 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_sync_constants_await', '1700177891', '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\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, do_action('jetpack_sync_before_send_queue_sync'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Modules\Constants->maybe_sync_constants, set_transient, wp_cache_set, WP_Object_Cache->set, WP_Object_Cache->_transient_set, add_option
    [16-Nov-2023 22:38:11 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_jetpack_sync_constants_await', '1700174291.4755', '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\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, do_action('jetpack_sync_before_send_queue_sync'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Modules\Constants->maybe_sync_constants, set_transient, wp_cache_set, WP_Object_Cache->set, WP_Object_Cache->_transient_set, add_option
    [16-Nov-2023 22:38:11 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\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, Automattic\Jetpack\Sync\Queue->size
    [16-Nov-2023 22:38:11 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
Viewing 1 replies (of 1 total)
  • Hi @newzendesignnz

    Thanks for reaching out!

    Based on the error log you’ve provided, it seems like there are some database queries that are out of sync. Even though you don’t have Jetpack installed, some of the error messages reference Jetpack because other plugins or themes on your site might be using Jetpack’s Autoloader package.

    The Commands out of sync error usually occurs when a previous query didn’t finish executing properly. There could be a number of reasons for this, including a plugin that’s not coded correctly or a server configuration issue.

    Can you please share with us what triggers this issue or error logs on your site?

    Meanwhile, for us to investigate this further, can you please try to switch to the default Storefront theme and only WooCommerce plugin is enabled and see if this works?

    If so, then this kind of problem is usually caused by your theme or a third-party plugin present on your site. We can run a conflict test to verify this. I’d recommend cloning your site to a staging environment and performing the tests described on this guide without modifying your live site or impacting customers. Many hosts provide staging facilities, so it’s worth checking in with them. It’s also possible to do it using the free WP Staging plugin.

    If this was caused by a third-party plugin present on your site, it would be best to reach out to the developers for further assistance here.

    If this did not resolve the issue, please share your System Status Report, that will help us further troubleshoot.

    You can find it via WooCommerce > Status. Select Get system report and then Copy for support. Once you’ve done that, you can paste it into your reply here.

    If you could also provide the fatal error logs (if any) under WooCommerce > Status > Logs.

    You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.

    Or, if you’d like someone else to do this work for you, our trusted partner, Codeable, has an offering where they will run this test for $150 USD. If there is time left, they will also fix the problems they found.

    Let us know how it goes!

Viewing 1 replies (of 1 total)
  • The topic ‘JetPack Database Sync Error’ is closed to new replies.