Jetpack issue with website

Hi @cheekymate06 –

It looks like the Sync issues have been resolved on your site and the Jetpack Connection is functioning properly.

Are you still receiving this error as of 14:39 UTC?

yep got it today (it happens once daily)

[01-Feb-2023 01:11:38 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM ptakf_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
[01-Feb-2023 01:11:38 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT count(*) FROM ptakf_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
[01-Feb-2023 01:11:38 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM ptakf_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

well every few days

Hi @cheekymate06

These errors could be caused by a few different things.

I see you have W3-Total-Cache – can you trying clearing the cache on your site? Sometimes the error is caused by when a plugin leaves a mess in database queries or does not close properly. You can try clearing the cache and see if it helps.

Could you be hitting the limits of your server’s memory? If the log file is showing any memory-related errors then this could be the reason for the error. Running a large database of products and especially importing them may make the database get out of sync.

Another reason for this error could be that a theme or a plugin is running a query but it’s not completing it. In such a scenario, you can check if another plugin is not causing this problem by creating a staging site where you only have Jetpack active. You may also try disabling the security plugins on your WordPress site and check whether that solves the issue.