• Resolved Florent

    (@inoxys)


    Hello,

    updraftplus was really well working until now.

    My backup stuck on the postmeta table. Too big?
    See: https://tinyurl.com/ybwcu7m4

    I’m using the updraftplus free version. Do I have to pay to get support?

    Regards

    • This topic was modified 2 years, 9 months ago by Florent.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter Florent

    (@inoxys)

    The backup succeed after few minutes (is it normal?).
    See logs below :

    0604.990 (2) Table ErAoFod_postmeta: Total expected rows (approximate): 27968
    0604.994 (2) Last successful resumption was 2 runs ago; fetch_rows will thus be: 500 (allow_further_reductions=1, is_first_fetch=1, known_bigger_than_table=)
    0920.738 (3) Opened log file at time: Sun, 20 Feb 2022 14:45:00 +0000 on https://agiliste.fr
    0920.750 (3) UpdraftPlus WordPress backup plugin (https://updraftplus.com): 1.22.4 WP: 5.9 PHP: 8.0.15 (fpm-fcgi, Linux calypsov4.agiliste.fr 5.11.0-1022-aws #23~20.04.1-Ubuntu SMP Mon Nov 15 14:03:19 UTC 2021 x86_64) MySQL: 10.3.32-MariaDB-0ubuntu0.20.04.1 (max packet size=16777216) WPLANG: fr_FR Server: Apache safe_mode: 0 max_execution_time: 900 memory_limit: 256M (used: 25.9M | 28M) multisite: N openssl: OpenSSL 1.1.1f  31 Mar 2020 mcrypt: N LANG:  ZipArchive::addFile: Y
    0920.756 (3) PHP event: code E_WARNING: is_dir(): open_basedir restriction in effect. File(/usr/local/cpanel) is not within the allowed path(s): (/var/www/vhosts/agiliste.fr/:/tmp/) (line 380, wp-content/plugins/updraftplus/class-updraftplus.php)
    0920.763 (3) Free space on disk containing Updraft's temporary directory: 22088.2 MB
    0920.772 (3) Requesting backup semaphore lock (2dfe391fece6)
    0920.790 (3) [Info] Lock (updraft_lock_2dfe391fece6, ErAoFod_options) acquired
    0920.803 (3) Backup run: resumption=3, nonce=2dfe391fece6, file_nonce=2dfe391fece6 begun at=1645367379 (921s ago), job type=backup
    0920.815 (3) Scheduling a resumption (4) after 300 seconds (1645368600) in case this run gets aborted
    0920.829 (3) PHP event: code E_WARNING: file_exists(): open_basedir restriction in effect. File(/proc/user_beancounters) is not within the allowed path(s): (/var/www/vhosts/agiliste.fr/:/tmp/) (line 140, wp-content/plugins/updraftplus/backup.php)
    0920.837 (3) Checking if we have a zip executable available
    0920.845 (3) Creation of backups of directories: already finished
    0920.859 (3) Saving backup status to database (elements: 8)
    0920.868 (3) Resuming creation of database dump (WordPress DB)
    0920.873 (3) SQL compatibility mode is: ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
    0920.910 (3) Table ErAoFod_options: corresponding file already exists; moving on
    0920.917 (3) Table ErAoFod_users: corresponding file already exists; moving on
    0920.922 (3) Table ErAoFod_usermeta: corresponding file already exists; moving on
    0920.927 (3) Table ErAoFod_actionscheduler_actions: corresponding file already exists; moving on
    0920.932 (3) Table ErAoFod_actionscheduler_claims: corresponding file already exists; moving on
    0920.932 (3) Table ErAoFod_actionscheduler_groups: corresponding file already exists; moving on
    0920.932 (3) Table ErAoFod_actionscheduler_logs: corresponding file already exists; moving on
    0920.932 (3) Table ErAoFod_commentmeta: corresponding file already exists; moving on
    0920.932 (3) Table ErAoFod_comments: corresponding file already exists; moving on
    0920.932 (3) Table ErAoFod_imagify_files: corresponding file already exists; moving on
    0920.932 (3) Table ErAoFod_imagify_folders: corresponding file already exists; moving on
    0920.932 (3) Table ErAoFod_links: corresponding file already exists; moving on
    0920.939 (3) Table ErAoFod_postmeta: Total expected rows (approximate): 27968
    0920.945 (3) Last successful resumption was 3 runs ago; fetch_rows will thus be: 250 (allow_further_reductions=1, is_first_fetch=1, known_bigger_than_table=)
    0927.922 (3) Table ErAoFod_postmeta: Rows added in this batch (next record: 120694): 22750 (uncompressed bytes in this segment=135612748) in 6.98 seconds
    0928.062 (3) Table ErAoFod_postmeta: Total expected rows (via COUNT): 26177
    0930.042 (3) Table ErAoFod_postmeta: Rows added in this batch (next record: 125398): 3427 (uncompressed bytes in this segment=55330985) in 2.01 seconds
    0930.058 (3) Table ErAoFod_postmeta: finishing file(s) (3, 24059.9 KB)
    Plugin Author David Anderson

    (@davidanderson)

    If it succeeded, then all is fine. UpdraftPlus has various strategies for dealing with hosting setups that kill the process or don’t provide enough resources the first time.

    David

    Thread Starter Florent

    (@inoxys)

    Hi and thank you for your reply David!
    Regards,
    Florent

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Backup stuck on metadata table’ is closed to new replies.