Deadlock in Yoast with Flamingo

  • Resolved prehealthshadowing

    (@prehealthshadowing)


    4 years, 2 months ago

    When under load, we have been experiencing deadlocks that seem to be related to Yoast and other plugins, such as Flamingo (for Contact Form 7).

    [23-Dec-2020 00:54:25 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT INTO 5TO_yoast_seo_links (url, type, indexable_id, post_id, target_indexable_id, target_post_id, language, region) VALUES (‘https://www.prehealthshadowing.com/student-outreach/’, ‘internal’, ‘43321’, ‘133586’, ‘9543’, ‘16183’, NULL, NULL) made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, wpcf7_rest_create_feedback, WPCF7_ContactForm->submit, do_action(‘wpcf7_submit’), WP_Hook->do_action, WP_Hook->apply_filters, wpcf7_flamingo_submit, Flamingo_Inbound_Message::add, Flamingo_Inbound_Message->save, wp_insert_post, do_action(‘wp_insert_post’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Watchers\Indexable_Post_Watcher->build_indexable, Yoast\WP\SEO\Builders\Indexable_Link_Builder->build, Yoast\WP\SEO\Builders\Indexable_Link_Builder->update_related_indexables, Yoast\WP\Lib\Model->save, Yoast\WP\Lib\ORM->save, Yoast\WP\Lib\ORM::execute

    and

    [27-Dec-2020 23:46:25 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT INTO 5TO_yoast_seo_links (url, type, indexable_id, post_id) VALUES (‘https://www.instagram.com/prehealthshadowing/’, ‘external’, ‘49315’, ‘139277’) made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, wpcf7_rest_create_feedback, WPCF7_ContactForm->submit, WPCF7_Submission::get_instance, WPCF7_Submission->proceed, WPCF7_Submission->mail, WPCF7_Mail::send, WPCF7_Mail->compose, wp_mail, PostmanWpMail->send, PostmanWpMail->sendMessage, do_action(‘post_smtp_on_success’), WP_Hook->do_action, WP_Hook->apply_filters, PostmanEmailLogService->write_success_log, PostmanEmailLogService->writeSuccessLog, PostmanEmailLogService->writeToEmailLog, wp_insert_post, do_action(‘wp_insert_post’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Watchers\Indexable_Post_Watcher->build_indexable, Yoast\WP\SEO\Builders\Indexable_Link_Builder->build, Yoast\WP\SEO\Builders\Indexable_Link_Builder->update_related_indexables, Yoast\WP\Lib\Model->save, Yoast\WP\Lib\ORM->save, Yoast\WP\Lib\ORM::execute

    I’ve searched and cannot find any other instance of this. Any idea why this might be happening and what I could do to make it stop? The deadlock brings our site down for about 20 minutes when it happens. Can we unregister certain post types from Yoast indexing such as these that are irrelevent to SEO?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Md Mazedul Islam Khan

    (@mazedulislamkhan)

    We are sorry to hear that you are having trouble with our plugin. Can you please confirm whether the issue persists when all the 3rd party plugins are disabled except Yoast SEO? You can test this on a staging site if you rather not perform the test on the production website.

    That said, the issue mostly occurs when the server or database cannot handle all the requests correctly. Can you please confirm whether you have performed the SEO data optimization from the SEO → Tools page? If not, please run the SEO data optimization from the relevant page to see whether this resolves the issue for you.

    On the other hand, if you have certain custom post types that aren’t valuable to search engines and you want to exclude them from Yoast SEO Indexables, you can use the filter wpseo_indexable_excluded_post_types here. You can find more information about the implementation of the relevant filter here.

    Plugin Support devnihil

    (@devnihil)

    We are going ahead and marking this issue as resolved due to inactivity. If you require any further assistance please create a new issue.

    Thread Starter prehealthshadowing

    (@prehealthshadowing)

    We have disabled the plugin for the time being. We cannot reproduce on our staging environment because it does not get the same load that our production server gets, and we are hesitant to re-enable on production as this is a recurring issue.

    I don’t know if I should be reporting this to Flamingo/WPCF7 instead of Yoast – I can’t tell which plugin would be the source of the issue, except that it explicitly mentions 5TO_yoast_seo_links for the table that is deadlocked.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Deadlock in Yoast with Flamingo’ is closed to new replies.