Understanding errors and warnings from command line backup

  • Resolved meatbrain

    (@meatbrain)


    8 years, 3 months ago

    I am working to set up a backup using the server’s own cron system, rather than relying on wp-cron. I am following the instructions in this FAQ: https://updraftplus.com/faqs/can-i-run-backups-from-the-shell/

    For my first tests, I chose to back up just the database. I ran these backups from the command line, without setting up a cron job. Backup was successful both to server storage and to Google Drive.

    I just ran a full backup (again, from the command line, no cron job). The uploads directory on this site is about 1.3 GB, so backup took about 2.5 hours. The log indicates “The backup apparently succeeded and is now complete.” Uploads to Google Drive were completed successfully. However, there are items in the log file that worry me.

    I have posted the log file here: https://pastebin.com/ZUf6TTrG

    Specifically, at lines 87 & 88:

    0085.304 (0) Binary zip: error (code: 9 - look it up in the Diagnostics section of the zip manual at http://www.info-zip.org/mans/zip.html for interpretation... and also check that your hosting account quota is not full)
0085.307 (0) The attempt to close the zip file returned an error (). List of files we were trying to add follows (check their permissions).

    There are other instances of this sort in the log file. The instance above listed a number of files in the plugins directory. I downloaded the plugins .zip file and spot checked it for a few of the files that the error log listed in the “list of files we were trying to add”, and found every file I looked for.

    So, question #1: Are these “code 9” errors something I should be worried about at this stage? If not now, then when does a code 9 raise a red flag?

    Next, at line 2728:
    7404.360 (24) [Warning] Table wp_login_security_solution_fail has very many rows (165700) - we hope your web hosting company gives you enough resources to dump out that table in the backup If not, you will need to either remove data from this table, or contact your hosting company to request more resources.

    I downloaded the database .zip file and browsed it. It shows exported values for rows up to and including 165700 in that table.

    Question #2: Does this indicate a successful export of this table?

    Question #2a: The log suggests asking the hosting company for more resources. What resources, specifically, would I request?

    Version info
    WordPress 4.9.2
    UpdraftPlus 1.14.2
    PHP 7.0.27
    MySQL 10.0.33-MariaDB
    Server OS: Linux

    Thanks in advance for your assistance.

    JGB

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor bcrodua

    (@bcrodua)

    8 years, 3 months ago

    Hi JGB,

    That URL says that error code 9 means:
    9 – the user aborted zip prematurely with control-C (or similar)

    So, someone killed the zip process – either manually, or perhaps there is something automated on your server that does that.

    If you’re not sure how to prevent that, then switch to a different zip engine by adding this to your wp-config.php: define(‘UPDRAFTPLUS_NO_BINZIP’, true);

    However, the log shows that UpdraftPlus was able to complete the backup successfully after trying several times.

    Best Wishes,
    Bryle

    Thread Starter meatbrain

    (@meatbrain)

    8 years, 3 months ago

    Bryle:

    Thanks for the info. Subsequent tests have gone well… but I had issues with a backup this morning that I will ask about in another thread.

    JGB

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

The topic ‘Understanding errors and warnings from command line backup’ is closed to new replies.