Backup stuck on metadata table
-
Hello,
updraftplus was really well working until now.
My backup stuck on the postmeta table. Too big?
See: https://tinyurl.com/ybwcu7m4I’m using the updraftplus free version. Do I have to pay to get support?
Regards
-
This topic was modified 4 years, 3 months ago by
Florent.
-
This topic was modified 4 years, 3 months ago by
Viewing 3 replies - 1 through 3 (of 3 total)
-
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)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
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.