Title: Deadlock Error
Last modified: January 14, 2022

---

# Deadlock Error

 *  Resolved [tomfreeform](https://wordpress.org/support/users/tomfreeform/)
 * (@tomfreeform)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/deadlock-error/)
 * I am receiving the following Deadlock error relating to the ‘_transient_wpseo_total_unindexed_post_limited’
   option in the WP options table.
 * The error message in the debug log is:
 * > `WordPress database error Deadlock found when trying to get lock; try restarting
   > transaction for query DELETE FROM wp_options WHERE option_name= _transient_wpseo_total_unindexed_posts_limited
   > made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters,
   > Yoast\WP\SEO\Integrations\Admin\Indexing_Notification_Integration->maybe_create_notification,
   > Yoast\WP\SEO\Integrations\Admin\Indexing_Notification_Integration->should_show_notification,
   > Yoast\WP\SEO\Helpers\Indexing_Helper->get_limited_filtered_unindexed_count,
   > Yoast\WP\SEO\Helpers\Indexing_Helper->get_limited_unindexed_count, Yoast\WP\
   > SEO\Actions\Indexing\Abstract_Indexing_Action->get_limited_unindexed_count,
   > get_transient, delete_option`
 * I have run the
 * > ‘DELETE FROM wp_options WHERE option_name = _transient_wpseo_total_unindexed_posts_limited’
 * query but the problem persists.
    -  This topic was modified 4 years, 4 months ago by [tomfreeform](https://wordpress.org/support/users/tomfreeform/).
    -  This topic was modified 4 years, 4 months ago by [tomfreeform](https://wordpress.org/support/users/tomfreeform/).
    -  This topic was modified 4 years, 4 months ago by [tomfreeform](https://wordpress.org/support/users/tomfreeform/).

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

 *  Plugin Support [Michael Tiña](https://wordpress.org/support/users/mikes41720/)
 * (@mikes41720)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/deadlock-error/#post-15251102)
 * Hi [@tomfreeform](https://wordpress.org/support/users/tomfreeform/)
 * Could you check if you are using the latest version of WP 5.8.3, Yoast SEO 17.9,
   and the latest version of your other plugins and themes?
 * Can you please try resetting our indexables in the database tables by following
   the steps below?
    1. Install & activate the [Yoast Test Helper plugin](https://wordpress.org/plugins/yoast-test-helper/)
   2. Go to Tools > Yoast Test 3. Locate the Yoast SEO section and click on the ‘
   Reset indexables tables & migrations’, ‘Reset Prominent words calculation’, and‘
   Reset Internal link counter’ buttons. After each click, the page will reload 
   to confirm that each reset was successful. Note: Resetting the optimization doesn’t
   undo any of the hard work you’ve put into the plugin as the SEO data is also 
   stored in WordPress’ default tables. It’ll just reset the custom Yoast tables
   that contain the combined data pulled from those default tables. 4. Go to SEO
   > Tools, and under SEO data, click the “Start SEO data optimization” button to
   allow Yoast to rescan your content.
 * Could you please check if this helps resolve the issue?
 *  Thread Starter [tomfreeform](https://wordpress.org/support/users/tomfreeform/)
 * (@tomfreeform)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/deadlock-error/#post-15258768)
 * Hi Michael,
 * I have made these actions on the production site and the testing site as both
   were experiencing the Deadlock error intermittently.
 * I will follow up in 24/48 hours if there are no errors, I will mark this issue
   as
    resolved, otherwise, I will follow up with the related error message.
 * EDIT: Both WP Core & Yoast SEO were updated to the most current version.
    -  This reply was modified 4 years, 4 months ago by [tomfreeform](https://wordpress.org/support/users/tomfreeform/).
      Reason: Version of Core & Yoast SEO
 *  Thread Starter [tomfreeform](https://wordpress.org/support/users/tomfreeform/)
 * (@tomfreeform)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/deadlock-error/#post-15267691)
 * This seems to have fixed the issue.
    Thank you for your support.

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

The topic ‘Deadlock Error’ is closed to new replies.

 * ![](https://ps.w.org/wordpress-seo/assets/icon-256x256.gif?rev=3419908)
 * [Yoast SEO - Advanced SEO with real-time guidance and built-in AI](https://wordpress.org/plugins/wordpress-seo/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-seo/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordpress-seo/)
 * [Active Topics](https://wordpress.org/support/plugin/wordpress-seo/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-seo/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordpress-seo/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [tomfreeform](https://wordpress.org/support/users/tomfreeform/)
 * Last activity: [4 years, 4 months ago](https://wordpress.org/support/topic/deadlock-error/#post-15267691)
 * Status: resolved