Backup Errors & Warnings – Table WP_Statpress

  • Resolved pravin310

    (@pravin310)


    9 years, 11 months ago

    Hi,

    I’m trying to take a backup using UpdraftPlus and it’s taking a lot of time (1 hour++) & there are multiple warnings & errors in log files.

    I think a lot of it has to do with WP_STATPRESS table which is related to the plugin NEW StatPress.

    The backup is constantly stopping at varios instances with this warning in the progress bar:
    Waiting until scheduled time to retry because of errors

    What should be done here to take proper backup?

    Any suggestions would be highly appreciated

    Here is my entire latest log
    http://pastebin.com/VnNLPLJd

    Some top warnings are as follows :

    Tue, June 21, 2016 21:29
    Warning: A very large file was encountered: uploads/db-backup/Long_Island_Eye_Doctor_2016_06_21_14664755787204_database.sql (size: 265.6 Mb)
    Warning: A very large file was encountered: uploads/db-backup/Long_Island_Eye_Doctor_2016_06_21_14664757553707_database.sql (size: 265.6 Mb)
    Warning: A very large file was encountered: uploads/db-backup/Long_Island_Eye_Doctor_2016_06_21_14665305943354_database.sql (size: 265.7 Mb)
    backup_2016-06-21-2129_Long_Island_Eye_Doctor_db51ab549288-plugins.zip: Failed to upload to Google Drive
    backup_2016-06-21-2129_Long_Island_Eye_Doctor_db51ab549288-uploads.zip: Failed to upload to Google Drive
    backup_2016-06-21-2129_Long_Island_Eye_Doctor_db51ab549288-uploads2.zip: Failed to upload to Google Drive

    https://ww.wp.xz.cn/plugins/updraftplus/

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

    (@dnutbourne)

    9 years, 11 months ago

    Hi,

    From the log, you are receiving a warning about a large file in the ‘uploads/db-backup’ directory, and a warning about the ‘wp_statpress’ table being very large.

    For the file warning, I would recommend adding the ‘uploads/db-backup’ directory to the Uploads exclusion list, as the backup files will not be necessary for a backup.

    If possible, I would recommend seeing if the wp_statpress can be cleared through the plugin, or limited in size, as UpdraftPlus is not able to process that table in the time allowed.

    Thread Starter pravin310

    (@pravin310)

    9 years, 11 months ago

    So I deleted the Plugin and the database and it still took very long with the same last 3 warnings as above!

    How do I add ‘uploads/db-backup’ directory to the Uploads exclusion list?

    Plugin Contributor DNutbourne

    (@dnutbourne)

    9 years, 11 months ago

    Hi,

    Under the ‘Include in files backup’ settings, you will find the ‘Uploads’ checkbox. Under this there is a text box labelled ‘Exclude these:’. Add the following to the end of the list in that text box (no spaces):

    ,db-backup
    Thread Starter pravin310

    (@pravin310)

    9 years, 11 months ago

    Thanks DNutbourne!

    I did that and the speed has become much better now.

    However, it still throws the following Error repeatedly:

    0186.074 (0) ERROR: Google Drive upload error: Operation timed out after 60 seconds with 0 bytes received (line: 117, file: /home/content/e/y/e/eyessociation/html/longislandeyedoctor.com/wp-content/plugins/updraftplus/includes/Google/IO/Curl.php)
    0186.081 (0) An error condition has occurred for the first time during this job

    Here is my entire log for your reference – it’s an ongoing log.
    http://pastebin.com/YVjVHABP

    Let me know if you have any suggestions on how to solve this time-out issue

    Plugin Contributor DNutbourne

    (@dnutbourne)

    9 years, 11 months ago

    Hi,

    This error means that there was no network connectivity to Google Drive at the time of the backup.

    We have an FAQ with more information on this error:
    https://updraftplus.com/faqs/what-does-the-error-operation-timed-out-after-number-milliseconds-with-0-bytes-received-mean/

    Could you try adding the following line to your wp-config.php file, just after the opening line:
    `define(‘UPDRAFTPLUS_IPV4_ONLY’, true);’

    This will force UpdraftPlus to use IPv4, which we have found can help in these cases.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Backup Errors & Warnings – Table WP_Statpress’ is closed to new replies.