Problems with the database after updating the plugin

  • Resolved MaTam

    (@matam)


    3 years ago

    After updating WooCommerce to 5.9.0, there were problems working with the site:
    * It was not possible to update automatically, the error “Updating the plugin is not possible. Access rights are probably incorrectly configured.” Updated the plugin manually by copying the new version of the WooCommerce plugin folder. The site suggested updating the database. Clicked refresh. There were several operations, one failed “‘update_callback’ => ‘wc_update_560_create_refund_returns_page'”. Error text “2021-11-26 12:34:09 +0000 emergency shutdown: Critical error PHP Cannot redeclare filter_created_pages() (previously declared in /wp-content/plugins/woocommerce/includes/wc-update-functions.php:2281) at /wp-content/plugins/woocommerce/includes/wc-update-functions.php in line 2281”
    ? After upgrading the site was unavailable for a few minutes with the error “unable to connect to database”. After the site started working.
    * Exactly 3 days later, the site became unavailable again with a similar error. The unavailability was about 3 o’clock. MySQL did not start. The sysadmin unsuccessfully tried to reanimate the database all the time. At some point it worked when the line max_open_files=16384″ was commented out. Although it may be a coincidence, because before that it was also removed and the site did not work.
    ? When trying to deploy a duplicate copy of the site on a virtual hosting, the site could not be deployed, error: Unable to connect with the following parameters.. Host… user … database … Error: Too many connections.
    ? I checked the experiment. On the test site located on the same VDS on a fresh copy of the working site made by the Duplicator, the WooCommerce and database updates went smoothly without any problems, everything works there.
    Obviously, there is still some problem with the plugin and the database. How to understand what the problem is and fix it?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Mirko P.

    (@rainfallnixfig)

    Hi @matam,

    Sorry to hear about the issues you’re experiencing.

    As a first step, you will want to do a conflict test to see if the errors are caused by a plugin/theme conflict with WooCommerce.

    You can read more about plugin and theme conflicts in our Self-Service Guide.

    If you’re seeing the same errors with WordPress, WooCommerce and a default theme enabled, then we’d need to take a closer look.

    Please share a copy of your site’s System Status. You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.

    Thanks.

    Thread Starter MaTam

    (@matam)

    There is no conflict with the plugin/theme. I have a test site (a copy of the working one) on the same VDS – the update went correctly there.

    I updated manually by replacing the WooCommerce folder with FTP. I made a mistake – the user “nginx” for all WordPress folders, the user “root” for the WooCommerce folder. The site was working, so I didn’t notice until an error occurred three days later, I already started checking and saw it. I have now specified the correct user. Could it have affected?

    Report of System Status: https://drive.google.com/file/d/1xa9prYfVNUnMcSRxYw8ih3Ata9ig3zZR/view?usp=sharing

    Mirko P.

    (@rainfallnixfig)

    Hi again,

    the user “nginx” for all WordPress folders, the user “root” for the WooCommerce folder

    I’m not sure I understand what you’ve done here, can you please elaborate a bit more so that we have more context to assist you?

    Also, you should update your WC Database Version to 5.9.0 as you’re running an outdated version (5.6.0). Before doing this make sure you have a full backup in place.

    I would also change these values, increasing the PHP Post Max Size and PHP Max Input Vars. PHP time limit 0 doesn’t seem right, it’s the amount of time (in seconds) that your site will spend on a single operation before timing out.

    PHP Post Max Size: 64 МБ
PHP Time Limit: 0
PHP Max Input Vars: 1000

    Kindly reach out to your host that can assist you to change these parameters.

    Thanks.

    Mirko P.

    (@rainfallnixfig)

    Hi there,

    We haven’t heard from you in a while, so I’m going to mark this as resolved. Feel free to start a new thread if you have any more questions.

    Cheers.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Problems with the database after updating the plugin’ is closed to new replies.