Support » Plugin: Yoast SEO » Disaster release Yoast 14.1 causes 504 Gateway Errors

  • Resolved Brian_Milnes

    (@brian_milnes)


    I have had to deactivate Yoast 14.1 due to it causing 504 Gateway errors.

    here, a clip from the error log:

    [15-May-2020 15:43:43 UTC] WordPress database error Lock wait timeout exceeded; try restarting transaction for query UPDATEwp_yoast_indexableSETpermalink= NULL,updated_at= '2020-05-15 15:42:52' WHEREid= '2575' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/ASD-STAN/404.php'), get_header, locate_template, load_template, require_once('/themes/ASD-STAN/header.php'), wp_title, apply_filters('wp_title'), WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Front_End_Integration->filter_title, Yoast\WP\SEO\Memoizers\Meta_Tags_Context_Memoizer->for_current_page, Yoast\WP\SEO\Repositories\Indexable_Repository->for_current_page, Yoast\WP\SEO\Repositories\Indexable_Repository->find_for_system_page, Yoast\WP\SEO\Repositories\Indexable_Repository->ensure_permalink, Yoast\WP\SEO\Models\Indexable->save, Yoast\WP\Lib\Model->save, Yoast\WP\Lib\ORM->save, Yoast\WP\Lib\ORM::_execute

    The page I need help with: [log in to see the link]

Viewing 13 replies - 1 through 13 (of 13 total)
  • vankaa

    (@vankaa)

    I have the same error. The plugin makes so many DB queries that it crashes the database server and the site goes into “504 Gateway Timeout”. I had to deactivate the plugin.

    Plugin Support Jerlyn

    (@jerparx)

    Hi @vankaa @brian_milnes ,

    We apologize for any inconvenience. We are sorry to know about these errors showing on your site. Can you please confirm if these errors started to show only after updating to Yoast SEO 14.1? Or are they present before that?

    kchal

    (@kchal)

    Yew i can confirm that too. minutes after the update my site crashed. Now showing “504 gateway time out”

    Plugin Support Suwash Kunwar

    (@suascat_wp)

    Hi @brian_milnes,

    We are sorry you are having an issue with the update to the Yoast SEO v14.1.

    504 Bad Gateway time out issue is most likely related to your server being unable to contact update server. You can find the server requirements for the plugin here. We do recommend that you have 256M of memory.

    While we are gathering more information about this error, can you please try manually install the plugin from SFTP/FTP? Activate the plugin from the dashboard.

    Next,

    – Install the Yoast Test Helper plugin
    – Go to the Tools → Yoast Test → Yoast SEO and click on the “Reset indexables tables & migrations” button
    – Go to SEO → Tools and run the “Start processing and speed up your site now” function again.

    Does this resolve the issue?

    We look forward to hearing from you.

    Thread Starter Brian_Milnes

    (@brian_milnes)

    So these problems started around the “major” upgrade to v 14.0

    Trying to index failed at every attempt (timing out or just sitting there, pretending to be doing something).

    The specific problem of timeout appears to be with 14.1

    And you say it’s because of the hosting server not being able to reach the update server, but I think that’s incorrect analysis

    These are all internal errors – the hosting site doesn’t have any connectivity problems.

    Plugin Support marcanor

    (@marcanor)

    Hi @brian_milnes , @vankaa , @kchal ,

    First, we want to apologize for any problems caused on your sites. We understand that having our update crash your site is annoying to say the least.

    Regarding this issue, can you please confirm if only installing the update is causing the error? Or is the error caused when you click the “Start processing and speed up your site now” button?

    The indexing process that starts when you click that button might cause additional server load depending on how big your site is, because it migrates data from some database tables to new ones we’ve created. You can find more information here.

    If you find that the indexing process increases your server load too much, you can also opt to dismiss the indexing button. The plugin will then slowly perform the migration as your site starts getting traffic. Any URL on your site that gets visited will be added to the indexables tables.

    Please let us know if you have any further information.

    Thread Starter Brian_Milnes

    (@brian_milnes)

    The Yoast installation had stopped displaying the “Do you want to re-index your website” message after it had failed and I had said don’t ask me again

    This Gateway error came from the site just sitting there minding it’s own business.

    Plugin Support Maybellyne

    (@maybellyne)

    Hello @brian_milnes,

    Can you please let us know if your website still experiences the ‘504 gateway time out’ issue?

    We look forward to hearing from you.

    Thread Starter Brian_Milnes

    (@brian_milnes)

    I have not re-activated the Yoast plugin, as it was continuing to cause these errors. I had previously told it not to actively index (so presumed it would have done this as a background task.)

    Obviously, I am unable to reactivate during working hours. But I am happy to test again after the end of European office hours and report back.

    Plugin Support Pcosta88

    (@pcosta88)

    If you are still experiencing the issue we suggest the following actions:

    1. If you have a large website with thousands of posts we suggest using WP-CLI to run the Indexable feature. This guide explains more: https://developer.yoast.com/customization/yoast-seo/indexables-cli/

    2. If you have a smaller site please make sure all your non-Yoast plugins are updated, you are using WordPress v5.4.1 and Yoast SEO v14.1.

    3. Verify your database has the: ALTER, CREATE, DELETE, INDEX, INSERT, SELECT, UPDATE, DROP permissions. These are required to create these tables in your database: wp_yoast_indexable, wp_yoast_indexable_hierarchy, wp_yoast_migrations, wp_yoast_primary_term. If you are not sure, your host provider can help.

    4. Can you confirm your server has all the right requirements?  If you are not sure, speak to your host provider. This guide explains more: https://kb.yoast.com/kb/plugin-requirements/.

    5. If you use the Yoast Helper Tool does the issue resolve? Please try the steps below:
    – i. Install & activate the Yoast Test Helper plugin: https://wordpress.org/plugins/yoast-test-helper/
    – ii. Go to Tools -> Yoast Test
    – iii. Locate the Yoast SEO section and select the “Reset indexables tables & migrations” button
    – iv. Click the “Click here to speed up your site now” button in the SEO->Tools section.

    Hi there,

    I want to share our experience with the issue.

    Yes, we still have the problem of the server crashing and every time we try to activate the plugin it takes a few minutes before the server crashes again.

    1. We did not try the WP-CLI solution, yet

    2. All plugins are updated.

    3. The DB user has all the DB rights.

    4. The site is hosted on a Cloud VPS hosting server. Site and server params:
    Server: Linux 4.18.0-147.8.1.el8_1.x86_64 x86_64 : Apache
    PHP: 7.3.18
    PHP memory limit: 512M
    PHP Post Max size: 128M
    DB: 10.4.11-MariaDB : mysqli
    DB Size: 548.95 MB

    5. We tried the Yoast Helper Tool and it did not work. The plugin still works a bit and crashes the server. With the activation of the Helper plugin this message is displayed in the admin:
    https://www.dropbox.com/s/ox404t7jxizf6vy/yoast-seo-error-message.png?dl=0

    For a while(more than 6 month) we had a long-running issue with “max_user_connections” on the same site. I can’t be sure where it comes from, but I want to share it with you because it may be related to your plugin.
    Here are couple of messages we have logged:
    [15-May-2020 15:21:53 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /path/to/public_html/wp-includes/wp-db.php on line 1658

    [15-May-2020 15:21:49 UTC] PHP Warning: mysqli_real_connect(): (HY000/1203): User pref_wp_db already has more than 'max_user_connections' active connections in /path/to/public_html/wp-includes/wp-db.php on line 1626

    Here is another message from a different website that uses the plugin as well. It does not have a reported server crash, but it has far fewer posts and data on it as well.
    2020-05-22T07:07:07+00:00 CRITICAL Uncaught PDOException: SQLSTATE[HY000] [1203] User pref_wp_db already has more than 'max_user_connections' active connections in /path/to/public_html/wp-content/plugins/wordpress-seo/src/orm/yoast-orm-wrapper.php:201

    Thanks for the help. If there is any further information you need from me, just let me know.

    Plugin Support Pcosta88

    (@pcosta88)

    @vankaa

    Depending on how large your specific site is we do know there are some issues running the Speed Up your Site button. The solution is to use WP-CLI.

    If you were to try that solution here https://developer.yoast.com/customization/yoast-seo/indexables-cli/ does the issue resolve?

    Plugin Support Jerlyn

    (@jerparx)

    Hi!

    We’re closing this thread because we haven’t heard back from you in a while. Should you have further questions, please open a new thread.

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Disaster release Yoast 14.1 causes 504 Gateway Errors’ is closed to new replies.