Website crashes after trying to update.

  • Resolved vagelis_artware

    (@vagelis_artware)


    4 years, 10 months ago

    SEO Yoast asked me to make some SQL updates in order to operate better. I pressed OK and the website crashed.

    This is the debug information:
    DeleteDuplicateIndexables – Error executing ‘query’ with: DELETE wyi FROM wp_yoast_indexable wyi INNER JOIN wp_yoast_indexable wyi2 WHERE wyi2.object_id = wyi.object_id AND wyi2.object_type = wyi.object_type AND wyi2.id < wyi.id; Reason: Lock wait timeout exceeded; try restarting transaction

    “Your site will continue to work normally, but won’t take full advantage of Yoast SEO.” this isn’t true.

    How can I retry to make the SQL update? I “killed” the processes in MySQL because that was the reason of the crash – website was bloated and wouldn’t open.

    Is there any “safe” way to do this without crashing websites?

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

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter vagelis_artware

    (@vagelis_artware)

    More info on the matter:

    After contacting the Hosting company, they said that the user already has the privileges needed (ALL).

    I activated / deactivated plugin and website crashed again.

    Hi @vagelis_artware,

    Sorry for the trouble that a new update has caused and thanks for providing us info from your WebHost.

    The DeleteDuplicateIndexables error occurs when Yoast SEO plugin cannot complete the relevant MySQL query to remove the duplicate indexables objects from database and as such, it throws the relevant error. Can you please try the steps below and let us know if the problem resolves?

    – 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.

    We look forward to hearing from you.

    Thread Starter vagelis_artware

    (@vagelis_artware)

    Hello,

    I did what you said, but website isn’t responding after pressing “Reset indexables tables & migrations”. It is loading forever.

    Update:
    The site crashed again.

    Plugin Support devnihil

    (@devnihil)

    @vagelis_artware We apologize for the difficulties that you are experiencing with the plugin.

    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.

    Plugin Support Md Mazedul Islam Khan

    (@mazedulislamkhan)

    This thread has been marked as resolved due to a lack of activity. You’re always welcome to re-open this topic.

    Thanks for understanding!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Website crashes after trying to update.’ is closed to new replies.