Deadlock Error

  • Resolved tomfreeform

    (@tomfreeform)


    4 years, 4 months ago

    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.
    • This topic was modified 4 years, 4 months ago by tomfreeform.
    • This topic was modified 4 years, 4 months ago by tomfreeform.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Michael Tiña

    (@mikes41720)

    4 years, 4 months ago

    Hi @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
    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

    (@tomfreeform)

    4 years, 4 months ago

    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. Reason: Version of Core & Yoast SEO
    Thread Starter tomfreeform

    (@tomfreeform)

    4 years, 4 months ago

    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.