[NSFW] WordPress database error Commands out of sync

  • Resolved athenaxstories

    (@athenaxstories)


    1 year, 6 months ago

    [21-May-2023 03:15:46 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp8j_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
    [21-May-2023 03:15:46 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT count() FROM wp8j_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 [21-May-2023 03:15:46 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp8j_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 [21-May-2023 04:35:58 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp8j_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 [21-May-2023 04:35:58 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT count() FROM wp8j_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
    [21-May-2023 04:35:58 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp8j_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

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

Viewing 5 replies - 1 through 5 (of 5 total)

  • I’ve got this too. What’s the impact been for you?

    One of my sites has been having database problems and it basically crashes the site. We’re not certain if it’s Jetpack causing it yet but have similar Jetpack queries in the logs.

    Also which PHP version are you on? Mine is 7.4.

    Thread Starter athenaxstories

    (@athenaxstories)

    high cpu load crashed my site got my shared hosting account suspended

    I don’t know if my database got problems or not but error only occur when jetpack is installed

    I’m using php 7.4

    Sounds similar. I manage a lot of sites and have never seen anything quite like this. The CPU and memory went to max due to all the database activity, and it is a small site in terms of users (but some quite heavy plugins) and just seemed to happen randomly when logged in as admin.

    We have had to upgrade our hosting account to double the resources (to 4GB memory), then I still saw this happen yesterday and it brought the site down for about 20 minutes saying could not connect to database. I think it only came back up when all the processes timed out.

    So far I haven’t found a way to trigger the issue in order to debug. We are also using a very limited set of the Jetpack modules: Asset CDN, Copy post, Extra Sidebar Widgets, VideoPress. I have had Jetpack support disable the VaultPress backups on their side to try and rule that out. From what I understand the ‘Sync’ activity in your log snippet is core Jetpack functionality that happens regardless of what modules are enabled, so it can probably happen randomly when Jetpack decides to sync.

    The other thing in the logs we were seeing was “WordPress database error Malformed packet for query” and “Waiting for table level lock” against regular WP queries when it was all getting backed up.

    The host said when they disabled Jetpack the queries stopped and the problem went away, but I need it as all our videos are hosted through Jetpack. Starting to regret this decision now.

    I do wonder if updating to PHP 8.1 would possibly help so I’m going to explore that soon. 7.4 is end of life so I’ve phased that out on most other sites now, and they haven’t had the same issue with Jetpack that I have seen.

    Plugin Support Bruce (a11n)

    (@bruceallen)

    Happiness Engineer

    Hi @athenaxstories

    Right now Jetpack is not connected to your site because your xmlrpc.php file is returning a 404 error.

    I’d ?suggest ?checking if ?you ?have ?any? security ?plugins ?activated that? might? be? blocking? our requests.? If ?not, ?try ?contacting ?your ?hosting ?provider ?and ?asking ?them? to ?check? their ?security ?logs ?to ?see ?if ?they ?are ?blocking? or ?otherwise ?limiting ?incoming ?and ?outgoing? connections ?over ?XML-RPC.?

    Jetpack? uses? this ?file ?to? communicate ?with ?your ?site, ?but ?some ?hosts ?block? connection ?requests ?to ?that ?file.

    Our? requests ?look ?like ?the ?following:

    • ?File:? ?http-//your-site.com/xmlrpc.php?
    • User-agent?header:? Jetpack ?by ?WordPress.com
    • IPs: ?https://jetpack.com/support/how-to-add-jetpack-ips-allowlist/

    Please ?ask ?them? to ?allowlist ?the ?IP ?addresses? listed? above. ?Note? that ?these ?IP ?addresses ?could? change ?(or ?more ?could ?be? added)? at ?any ?time,? which? could? break? your? connection ?to ?Jetpack. ?For ?this? reason, ?we ?actually ?discourage ?allowing ?specific ?IPs, ?although ?with? some? hosts ?it ?may ?be ?the? only ?option.

    Let ?us ?know ?how? that ?goes.

    Plugin Support Tamirat B. (a11n)

    (@tamirat22)

    Hello @athenaxstories.

    It’s been one week since this topic was last updated. I’m going to mark this thread as solved. If you have any further questions or need more help, you’re welcome to open another thread here. Cheers!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘[NSFW] WordPress database error Commands out of sync’ is closed to new replies.