WordPress database error Commands out of syn

  • rohitjain5195

    (@rohitjain5195)


    3 years, 3 months ago

    When I install this pluggin, I start getitng the below error and i had to uninstall this to resolve the issue.

    WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_name FROM wp_options WHERE option_name LIKE ‘jpsq_sync-%’ ORDER BY option_name ASC LIMIT 1 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\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, do_action(‘jetpack_sync_before_send_queue_sync’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Modules\Callables->maybe_sync_callables, do_action(‘jetpack_sync_callable’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Listener->action_handler, Automattic\Jetpack\Sync\Listener->enqueue_action, Automattic\Jetpack\Sync\Listener->can_add_to_queue, Automattic\Jetpack\Sync\Queue->lag

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Karen Attfield

    (@wpkaren)

    3 years, 3 months ago

    Hi there,

    We’d be happy to help troubleshoot what could have caused the database errors if you are still interested in trying out Jetpack.

    The error you saw may occur when the MySQL data is left in an inconsistent state – and that may be due to another plugin running a query and never fully completing / clearing it.

    What may help us is to see a list of the plugins active on your site.

    Alternatively you can try disabling any caching or security plugins on your site and installing Jetpack again to see if that makes any difference.

    Thread Starter rohitjain5195

    (@rohitjain5195)

    3 years, 3 months ago

    Thanks for reply.

    Sure…there are lot of other plugging but due to this, you need full list?, I had to remove jetpack and after that error is not coming, This error directly get my website user impacted and they have to refresh or some leavs website,

    Thanks

    Plugin Support MadHatter (a11n)

    (@madhattersez)

    3 years, 3 months ago

    Hello,

    Without Jetpack active and connected, we are unable to see what other plugins you are using, so yes, we would need a full list to look for clues.

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

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

    Thanks!

    Thread Starter rohitjain5195

    (@rohitjain5195)

    3 years, 3 months ago

    okay..sure. I will enable it back today and report you as soon as I see that error again.

    Thanks

    ltbmak

    (@ltbmak)

    3 years, 3 months ago

    hi
    actually I have been strugling with the same error.
    now I cant even open my page.
    what should I do?

    Plugin Contributor Dan (a11n)

    (@drawmyface)

    3 years, 2 months ago

    Hi @ltbmak

    Could you please start your own thread, as per the Forum Welcome?
    https://ww.wp.xz.cn/support/plugin/jetpack#new-post

    Thank you!

    Thread Starter rohitjain5195

    (@rohitjain5195)

    3 years, 2 months ago

    Hi
    I had installed the jetpack again in my dev env website which is clone of prodcution.
    and after installing getting the issue again but little different error.
    One Question is : while keeping jetpack activated, how many DB quesries it fires? as hostinger says they support max 15 parallel queeries and seems jetpack is taking most causing this issue.

    Error…
    WordPress database error Commands out of sync; you can’t run this command now for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘_transient_timeout_jetpack_sync_last_checked_queue_state_sync’, ‘1611937205’, ‘no’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) 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\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, do_action(‘jetpack_sync_before_send_queue_sync’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Modules\Callables->maybe_sync_callables, do_action(‘jetpack_sync_callable’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Listener->action_handler, Automattic\Jetpack\Sync\Listener->enqueue_action, Automattic\Jetpack\Sync\Listener->can_add_to_queue, set_transient, add_option

    Dev site
    https://cloudcertified.online/

    Thanks

    ltbmak

    (@ltbmak)

    3 years, 2 months ago

    I deleted it and life back to normal.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘WordPress database error Commands out of syn’ is closed to new replies.