Clearing orphans long time with error, but things seem OK. Is it safe to use DB?

  • Resolved wpmhweb

    (@wppit)


    4 years, 8 months ago

    I’m in the processes of transferring a wordpress website to a new server.

    On the new server, before making the site live, I used this plugin to maintain the database. When I checked the option to “Clear orphans” the analysis showed 58,000 orphans, when I clicked the option to delete them, the operation was taking a too long time, so I left it all night. In the morning, I checked and I saw a “There has been a critical error on your website. Please check your site admin email inbox for instructions.” message.

    But I don’t see any email with instructions, the site seems to be working. When I try to clear orphans again, it looks like that the previous process completed the clearing, because the plugin shows 0 orphans.

    I have optimized the mysql (InnoDB) database again through phpmyadmin, and everything seems to be working.

    However, I found this in the apache logs: [Sun?Jul?26?06:45:06.600134?2020]?[php7:error]?[pid?1078]?[client?1.1.1.1:51234]?PHP?Fatal?error:??Maximum?execution?time?of?14400?seconds?exceeded?in?/var/www/html/wp-includes/wp-db.php?on?line?2024,?referer:?https://website.com/wp-admin/tools.php?page=rvg-optimize-database&action=analyze_summary which I think is the reason of the dashboard error.

    The mysql logs shows a few “notes” during, but no errors. In addition, I have restarted the server, and things looks like are working.

    Questions:

    1. Is it safe to use the database after this happened?
    2. Should I be worried about error message?
    3. Is there anything else should I check or do to ensure everything is OK and nothing got corrupted?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor cageehv

    (@cageehv)

    Hey @wppit,

    Don’t worry about that error.

    If you run the plugin on a site that is bloated with orphans, transients and other stuff, it can take a while cleaning them.

    What you can do is clean your DB per item (for instance: first clean only the trashed items, then the spammed items, and so on…)

    BTW in this stadium it’s smart to make a backup before trying.

    Good luck!

    Rolf

    Thread Starter wpmhweb

    (@wppit)

    @cageehv thanks for clarification.

    And yes, that what I usually do, I clear one item at a time, but this time the orphans had close to 60K items, and it was taking a long time.

    Plugin Contributor cageehv

    (@cageehv)

    Hey @wppit,

    What you also can try is following the steps in the this article:
    https://scottnelle.com/648/clean-bloated-wp_term_relationships-table/

    After doing that, everything will be fine and my plugin will run smoothly ??

    peace,
    Rolf

    Thread Starter wpmhweb

    (@wppit)

    @cageehv unrelated, related question. Is it safe to do database maintenance when the site is live? Or there’s a standard process that is usually used like taking down the site momentarily or something else?

    Thanks,

    Plugin Contributor cageehv

    (@cageehv)

    Hey @wppit,

    I won’t hurt to do it on a live site.

    If you don’t trust it, you can put it in maintenance mode before you start and return to live mode after it’s done.

    peace,
    Rolf

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Clearing orphans long time with error, but things seem OK. Is it safe to use DB?’ is closed to new replies.

Tags