• Resolved celin007

    (@celin007)


    Hi

    WordPress site is getting an error.

    Log shows as

    WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROMwp_optionsWHEREoption_name= '_transient_timeout_jetpack_sync_callables_await' 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, get_transient, delete_option, referer: mainsite/wp-cron.php?doing_wp_cron=1645574339.5235400199890136718750

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Stef (a11n)

    (@erania-pinnera)

    Hello @celin007!

    The error you reported usually appears when there’s an application that has locked the table as it didn’t finish updating a record in the DB. Because of this problem, Jetpack is not able to write to that specific table.

    Does that happen often on the site you’re referring to? If that’s so, it’s possible that there is a plugin or theme conflict happening.

    You can actually use the Health Check plugin to do some troubleshooting here. Health Check is a tool that can be useful for debugging, though it does require an official default theme like Twenty Twenty to be installed as well:

    https://www.ads-software.com/plugins/health-check/
    https://en-gb.www.ads-software.com/themes/twentytwenty/

    Once you’ve installed and activated the plugin, you can go to *Dashboard* → *Health Check* to see various details about your site and server. Select the *Troubleshooting* tab and then click **Enable Troubleshooting** to automatically disable all plugins and add a new *Troubleshooting Menu* item in the toolbar at the top of the wp-admin dashboard.?

    From here, you can enable and disable plugins and change the theme for you, but without affecting normal visitors to your site.?

    Could you try to use the Health Check plugin to enable only Jetpack and then run that test again? If those errors get cleared, then we’ll know that a conflict with another plugin is causing this.?

    You can then enable each plugin one at a time and try to replicate the error after each attempt.?

    If you can’t find a plugin, it may be the theme. Would you please try to switch the theme to one of the defaults to see if that helps? You’re welcome to use the Theme Switcha plugin to do that:

    https://www.ads-software.com/plugins/theme-switcha/

    This plugin lets you change themes without it affecting the way users see your site.

    Hope that helps! Let me know how you get on.

    Thread Starter celin007

    (@celin007)

    Thanks, Stef (a11n) for the quick reply.

    Yes, this error constantly appears in the error log.
    Is the plugin Health Check plugin different from the default Tools-> Site health from the WP dashboard? Also does the theme Twenty Twenty need to be the active theme or just need to be installed?

    Also, the Jetpack version installed is Version 9.8.1 and the WP version is 5.7.5. Will that cause an issue?

    Plugin Support lastsplash (a11n)

    (@lastsplash)

    Hi @celin007

    The Health Check plugin extends the default Site Health functionality. In this case, it will let you install the Twenty Twenty theme and test it without affecting the front end of the site. Similarly, you can disable plugins without affecting what visitors to your see.

    That said, I would recommend updating to the most recent version of Jetpack (v10.7) since you are running an out-of-date version.

    Let us know if you are able to resolve this using the suggestions above.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘JetPack error on site – Attention needed’ is closed to new replies.