Jetpack not installed, but error log full of warnings

  • Resolved ireeps

    (@ireeps)


    10 months, 3 weeks ago

    I’m seeing a whole heap of errors in the logs.. I tried to install and remove jetpack, but made no difference. Can anyone help troubleshoot this?

    [06-Jan-2024 16:33:29 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_options 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, update_option
    [06-Jan-2024 16:33:29 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-Jan-2024 16:33:29 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-Jan-2024 16:33:29 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-Jan-2024 16:33:29 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_options 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, update_option [06-Jan-2024 16:33:29 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-Jan-2024 16:33:29 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-Jan-2024 16:33:29 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-Jan-2024 16:33:29 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_options 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, update_option
    [06-Jan-2024 16:33:29 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-Jan-2024 16:33:29 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-Jan-2024 16:33:29 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-Jan-2024 16:33:30 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_options 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, update_option [06-Jan-2024 16:33:30 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-Jan-2024 16:33:30 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-Jan-2024 16:33:30 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 15 replies - 1 through 15 (of 18 total)

  • Hi @ireeps, my website experiences a similar issue since a few days. Have you found a solution?

    Plugin Support lastsplash (a11n)

    (@lastsplash)

    Hi @wabetainfo –

    I see you opened a separate thread here:

    We will assist you over there.

    Plugin Support lastsplash (a11n)

    (@lastsplash)

    Hi @ireeps –

    It looks like you are using WooCommerce on your site, is this correcT? Could you please post your site URL here so that we can have a look?

    If you want it to remain private, you can also contact us via this contact form:

    https://jetpack.com/contact-support/?rel=support&hpi=1

    If you choose to reach out directly, please include a link to this thread.

    Thanks!

    Thread Starter ireeps

    (@ireeps)

    Yes, the site is running woocommerce.
    site url is lawnaddicts.com.au

    thanks

    Plugin Support lastsplash (a11n)

    (@lastsplash)

    Hi @ireeps –

    Thanks for sharing the URL and confirming your use of WooCommerce.

    I have made an adjustment to how we communicate with your site that may fix the issue.

    Please let us know if you continue to see issues, and if so, post an updated log here.

    Thread Starter ireeps

    (@ireeps)

    I cleared the php error log this morning, and have checked it just now… I’ve had a few instances of this showing up:

    [25-Jan-2024 21:57:53 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_options 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, update_option
    [25-Jan-2024 21:57:53 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
    [25-Jan-2024 21:57:53 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
    [25-Jan-2024 21:57:53 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
    [25-Jan-2024 21:58:00 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_options 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, update_option

    Thread Starter ireeps

    (@ireeps)

    I’ve just had another look, and it doesnt appear to have come back, so maybe it is sorted! ?? I’ll keep an eye on it over the next few days and report back.

    Thread Starter ireeps

    (@ireeps)

    Im still seeing errors unfortunately..

    [27-Jan-2024 06:32:59 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
    [27-Jan-2024 06:32:59 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
    [27-Jan-2024 06:32:59 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

    Plugin Contributor Dan (a11n)

    (@drawmyface)

    Hey there

    These errors suggest that some code somewhere is triggering an exit in the middle of reading data from the database. That is likely to be caused by a conflict with another plugin.

    Would you be able to test this by disabling all of your plugins except Jetpack, and see if you still get those errors? If you do, it would help if you can get some SQL logs from your hosting provider, and then send those to us via this contact form and mention this thread.

    Thanks

    Thread Starter ireeps

    (@ireeps)

    It is a live site, so not able to turn everything off… What I’m trying to figure out is why this is happening in the first place? We don’t use jetpack, don’t have it installed, so what exactly is syncing and to where and why?

    Can it just be turned off completely? From my end or your end?

    Hi @ireeps,

    Those errors are related to some database query, so it’s hard to know what’s causing it unless plugins are disabled one by one (although you mentioned Jetpack isn’t installed in the first place).

    Can you try cleaning the database and expired transients just to see if it affects it? You can use both of these plugins for that:

    Let us know how this goes.

    Thread Starter ireeps

    (@ireeps)

    Hi Mehdi.

    It still happens after optimising and deleting transients.

    Plugin Contributor Stef (a11n)

    (@erania-pinnera)

    Hi @ireeps,

    Thanks for trying that out even if it didn’t get the result we expected.

    I dug a little in our records, and I can still see your site being connected to Jetpack, with URL being www.lawnaddicts.com.au.

    You said Jetpack is not installed, but since I see the opposite, I wonder if that’s okay for you if we disconnect the site from our end completely and see if the issue persists.

    Another option I’d like you to consider is ti set a staging site that mirrors your current site, and use it to perform the tests we wanted you to do in order to pinpoint the root of the issue – which are theme and plugins conflict tests.

    We can pursue both options at the same time, and see if we can find some clues to sort that out. Let me know how you’d like to proceed, and if you have any questions about that.

    Thread Starter ireeps

    (@ireeps)

    I’d be happy for you to disconnect from your end and if it persists, then I will look at setting up a staging site.

    Plugin Contributor Stef (a11n)

    (@erania-pinnera)

    Hey @ireeps!

    I disconnected Jetpack from here. Give your site and browser a cache flush, and let us know how it goes.

    Hopefully that would solve the issue and we won’t need any staging site ??

Viewing 15 replies - 1 through 15 (of 18 total)
  • The topic ‘Jetpack not installed, but error log full of warnings’ is closed to new replies.