WordPress database error Commands out of sync; you can’t run this command

  • Resolved onurparlar

    (@onurparlar)


    1 year, 6 months ago

    Hello,

    After latest update I started to seeing this errors:

    WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp8i_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

    WordPress database error Commands out of sync; you can’t run this command now for query SELECT count(*) FROM wp8i_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

    WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp8i_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

    any fix or idea?

    thank you

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

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

  • Hi @onurparlar

    These errors can occur when a MySQL command is issued before the previous one has been fully processed. Here are some things you can try:

    • If you’re using an object caching plugin or have server-level caching enabled, clear the cache to ensure there are no stale or corrupt data causing the errors.
    • Temporarily deactivate and remove the Jetpack plugin and then reinstall and reactivate it to see if this resolves the issue. This process can help with reinitializing plugin settings and may clear up the issue.
    • Repair your WordPress database: Try repairing your WordPress database using the built-in repair tool. Add the following line to your wp-config.php file: define( 'WP_ALLOW_REPAIR', true );
      Then, navigate to https://yourdomain.com/wp-admin/maint/repair.php and select “Repair Database” or “Repair and Optimize Database”. Don’t forget to remove the line from wp-config.php after completing the repair.
    Thread Starter onurparlar

    (@onurparlar)

    Hello @ihenetudan

    In fact I tried that steps before than open this ticket ??

    Right now I tried again.

    I’ll wait if I see error again let you know…

    same error for me… seems to be something with jetpack. i only have 8 plugins and the website is pretty optimized, database is fine, no errors. Jetpack team should look more into this issue, seems to be poping up a lot in the last 3 months.

    Thread Starter onurparlar

    (@onurparlar)

    @ihenetudan

    This time I never see that error again…

    If you want you close this ticket.
    @ghostmaster maybe still need help cause of that I didn’t close it.

    Thread Starter onurparlar

    (@onurparlar)

    @ihenetudan

    Today I opened another ticket. I guess this two problems are related.

    Previous message I said errors are gone but couple minutes ago they came back. Jetpack give me two option on Safe Mode.
    I choose “Move my settings” then I saw this errors again.

    This is new topic:
    https://www.ads-software.com/support/topic/safe-mode-loop/

    Thank you

    Plugin Support Kellie (a11n)

    (@lavenderhaze)

    Hi there,

    It’s unlikely that these database errors are related to the issues you’re having with safe mode, so we’ll discuss that issue separately in the new thread you created. Thanks for doing that.

    In regards to the database errors, MySQL gives a “Commands out of sync” error when the client sends a new query before reading all of the data from a previous query. It’s not necessarily Jetpack that’s making a query and not reading all the data. Since all the traces quoted here are happening during a shutdown handler, it may be that some code somewhere is triggering an exit in the middle of reading data from the database.

    To determine whether the issue is actually being caused by the Jetpack plugin, I’d recommend that you temporarily deactivate all plugins besides Jetpack and see if the errors are still logged.

    Plugin Support Jay

    (@bluejay77)

    Hi there,

    It has been a while since we have heard from you, so I’m marking this topic as resolved.

    But if you have any further questions or need some more help, you’re welcome to reply here or open another thread.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘WordPress database error Commands out of sync; you can’t run this command’ is closed to new replies.