Database error

  • Imagecandreu

    (@candreu)


    1 week, 5 days ago

    I have these errors almost every day:

    • 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
    • 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

    Is there any important problem?

    • This topic was modified 1 week, 5 days ago by Imagecandreu.
    • This topic was modified 1 week, 5 days ago by Imagecandreu.

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

Viewing 1 replies (of 1 total)
  • ImageJeff (a11n)

    (@jmills38)

    1 week ago

    Hi @candreu,

    These errors happen when another process on your site leaves a database query unfinished during shutdown, and then Jetpack Sync tries to run its own queries on that same connection. The errors look alarming in the log but they’re not causing data loss. They can prevent Jetpack Sync from completing though, which would affect features like Stats.

    We have a fix for this. You’ll need to add a small code snippet to your site that resets the database connection at the start of shutdown, before Sync runs. The snippet and instructions for how to add it are in our troubleshooting guide under “Database Errors from Jetpack Sync”: https://jetpack.com/support/getting-started-with-jetpack/fixing-jetpack-connection-issues/

    I also noticed you’re running LiteSpeed Cache alongside Jetpack. There are a few documented interactions between the two worth being aware of: https://jetpack.com/support/getting-started-with-jetpack/known-issues/

    Let us know if the snippet helps.

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.