Backup failure – log below.

  • Resolved markhartmann

    (@markhartmann)


    3 years ago

    [WARN] [2022-03-08 01:31:11] PHP CLI is disabled manually, plugin will omit all PHP CLI steps.
    [WARN] [2022-03-08 01:31:11] PHP CLI file cannot be executed due to unknown reason.
    [STEP] [2022-03-08 01:31:11] Initializing backup…
    [INFO] [2022-03-08 01:31:11] Backup & Migration version: 1.1.9
    [INFO] [2022-03-08 01:31:11] Site which will be backed up: ***site_url***
    [INFO] [2022-03-08 01:31:11] PHP Version: 8.0.16
    [INFO] [2022-03-08 01:31:11] WP Version: 5.8.2
    [INFO] [2022-03-08 01:31:11] Web server: LiteSpeed
    [INFO] [2022-03-08 01:31:11] Max execution time (in seconds): 259200
    [INFO] [2022-03-08 01:31:11] Max rows per query (this site): 300
    [INFO] [2022-03-08 01:31:11] Checking if backup dir is writable…
    [INFO] [2022-03-08 01:31:11] Initializing custom error handler
    [SUCCESS] [2022-03-08 01:31:11] Yup it is writable…
    [STEP] [2022-03-08 01:31:11] Scanning files…
    [WARN] [2022-03-08 01:31:13] This file is quite big consider to exclude it, if backup fails: *****.zip (263.61 MB)
    [STEP] [2022-03-08 01:31:13] Checking free space, reserving…
    [INFO] [2022-03-08 01:31:13] Requires at least 1568700445 bytes. [1.46 GB]
    [INFO] [2022-03-08 01:31:13] Disk free space function is not disabled – using it…
    [INFO] [2022-03-08 01:31:13] Checking this path/partition: ***ABSPATH***/wp-content/***backup_path***/backups
    [SUCCESS] [2022-03-08 01:31:13] There is 299,101.90 MB free. [292.09 GB]
    [SUCCESS] [2022-03-08 01:31:13] Great! We have enough space.
    [SUCCESS] [2022-03-08 01:31:13] Confirmed, there is more than enough space, checked: 1568700445 bytes
    [INFO] [2022-03-08 01:31:13] Scanning done – found 30459 files…
    [SUCCESS] [2022-03-08 01:31:13] Backup initialized…
    [STEP] [2022-03-08 01:31:13] Initializing archiving system…
    [SUCCESS] [2022-03-08 01:31:13] Archive system initialized…
    [STEP] [2022-03-08 01:31:13] Preparing map of files…
    [SUCCESS] [2022-03-08 01:31:13] Files prepared.
    [INFO] [2022-03-08 01:31:13] Starting compression process…
    [STEP] [2022-03-08 01:31:13] Smart memory calculation…
    [INFO] [2022-03-08 01:31:13] There is 1024 MBs of memory to use
    [INFO] [2022-03-08 01:31:13] WordPress memory limit: 1024 MBs
    [SUCCESS] [2022-03-08 01:31:13] Setting the safe limit to 230 MB
    [STEP] [2022-03-08 01:31:13] Making database backup (using V2 engine, requires at least v1.1.0 to restore)
    [INFO] [2022-03-08 01:31:13] Iterating database…
    [INFO] [2022-03-08 01:31:13] Memory usage after initialization: 93.33 MB
    [INFO] [2022-03-08 01:31:13] Scan found 46 tables (27576 rows), estimated total size: 130.39 MB.
    [INFO] [2022-03-08 01:31:13] Memory usage after getting table names: 93.35 MB
    [INFO] [2022-03-08 01:31:13] Getting table recipes…
    [INFO] [2022-03-08 01:31:13] Table recipes have been exported.
    [INFO] [2022-03-08 01:31:13] Memory usage after loading recipes: 93.39 MB
    [INFO] [2022-03-08 01:31:13] Saving recipes…
    [INFO] [2022-03-08 01:31:16] Recipes saved.
    [INFO] [2022-03-08 01:31:16] Memory usage after recipe off-load: 93.36 MB
    [INFO] [2022-03-08 01:31:16] Exporting table data…
    [INFO] [2022-03-08 01:31:16] Getting data of table: 1638510711_wp_commentmeta (0.05 MB)
    [INFO] [2022-03-08 01:31:16] Table: 1638510711_wp_commentmeta cloned, operation took: 0.00076 ms
    [INFO] [2022-03-08 01:31:16] Getting data of table: 1638510711_wp_comments (0.09 MB)
    [INFO] [2022-03-08 01:31:16] Table: 1638510711_wp_comments cloned, operation took: 0.00154 ms
    [INFO] [2022-03-08 01:31:16] Getting data of table: 1638510711_wp_e_submissions (0.28 MB)
    [INFO] [2022-03-08 01:31:16] Table: 1638510711_wp_e_submissions cloned, operation took: 0.00230 ms
    [INFO] [2022-03-08 01:31:16] Getting data of table: 1638510711_wp_e_submissions_actions_log (0.13 MB)
    [INFO] [2022-03-08 01:31:16] Table: 1638510711_wp_e_submissions_actions_log cloned, operation took: 0.00165 ms
    [INFO] [2022-03-08 01:31:16] Getting data of table: 1638510711_wp_e_submissions_values (0.05 MB)
    [INFO] [2022-03-08 01:31:16] Table: 1638510711_wp_e_submissions_values cloned, operation took: 0.00290 ms
    [INFO] [2022-03-08 01:31:16] Getting data of table: 1638510711_wp_links (0.03 MB)
    [INFO] [2022-03-08 01:31:16] Table: 1638510711_wp_links cloned, operation took: 0.00063 ms
    [INFO] [2022-03-08 01:31:16] Getting data of table: 1638510711_wp_options (2.55 MB)
    [INFO] [2022-03-08 01:31:16] Table: 1638510711_wp_options cloned, operation took: 0.08687 ms
    [INFO] [2022-03-08 01:31:16] Getting data of table: 1638510711_wp_postmeta (63.22 MB)
    [INFO] [2022-03-08 01:31:43] Table: 1638510711_wp_postmeta cloned, operation took: 26.68789 ms
    [INFO] [2022-03-08 01:31:43] Getting data of table: 1638515274_wp_commentmeta (0.05 MB)
    [INFO] [2022-03-08 01:31:43] Table: 1638515274_wp_commentmeta cloned, operation took: 0.00764 ms
    [INFO] [2022-03-08 01:31:43] Getting data of table: 1638515274_wp_comments (0.09 MB)
    [INFO] [2022-03-08 01:31:43] Table: 1638515274_wp_comments cloned, operation took: 0.00182 ms
    [INFO] [2022-03-08 01:31:43] Getting data of table: 1638515274_wp_e_submissions (0.28 MB)
    [INFO] [2022-03-08 01:31:43] Table: 1638515274_wp_e_submissions cloned, operation took: 0.00156 ms
    [INFO] [2022-03-08 01:31:43] Getting data of table: 1638515274_wp_e_submissions_actions_log (0.13 MB)
    [INFO] [2022-03-08 01:31:43] Table: 1638515274_wp_e_submissions_actions_log cloned, operation took: 0.00120 ms
    [INFO] [2022-03-08 01:31:43] Getting data of table: 1638515274_wp_e_submissions_values (0.05 MB)
    [INFO] [2022-03-08 01:31:43] Table: 1638515274_wp_e_submissions_values cloned, operation took: 0.00293 ms
    [INFO] [2022-03-08 01:31:43] Getting data of table: 1638515274_wp_links (0.03 MB)
    [INFO] [2022-03-08 01:31:43] Table: 1638515274_wp_links cloned, operation took: 0.00048 ms
    [INFO] [2022-03-08 01:31:43] Getting data of table: 1638515274_wp_options (2.55 MB)
    [INFO] [2022-03-08 01:31:44] Table: 1638515274_wp_options cloned, operation took: 0.91134 ms
    [INFO] [2022-03-08 01:31:44] Getting data of table: 1638515274_wp_postmeta (40.00 MB)
    [INFO] [2022-03-08 01:31:58] Table: 1638515274_wp_postmeta cloned, operation took: 14.17645 ms
    [INFO] [2022-03-08 01:31:58] Getting data of table: wp_commentmeta (0.00 MB)
    [INFO] [2022-03-08 01:31:58] Table: wp_commentmeta cloned, operation took: 0.00063 ms
    [INFO] [2022-03-08 01:31:58] Getting data of table: wp_comments (0.02 MB)
    [INFO] [2022-03-08 01:31:58] Table: wp_comments cloned, operation took: 0.00537 ms
    [INFO] [2022-03-08 01:31:58] Getting data of table: wp_links (0.00 MB)
    [INFO] [2022-03-08 01:31:58] Table: wp_links cloned, operation took: 0.00238 ms
    [INFO] [2022-03-08 01:31:58] Getting data of table: wp_options (2.49 MB)
    [INFO] [2022-03-08 01:31:59] Table: wp_options cloned, operation took: 0.87842 ms
    [INFO] [2022-03-08 01:31:59] Getting data of table: wp_postmeta (12.32 MB)
    [INFO] [2022-03-08 01:32:04] Table: wp_postmeta cloned, operation took: 5.08009 ms
    [INFO] [2022-03-08 01:32:04] Getting data of table: wp_posts (5.05 MB)
    [INFO] [2022-03-08 01:32:08] Table: wp_posts cloned, operation took: 4.25387 ms
    [INFO] [2022-03-08 01:32:08] Getting data of table: wp_revslider_css (0.10 MB)
    [INFO] [2022-03-08 01:32:08] Table: wp_revslider_css cloned, operation took: 0.01170 ms
    [INFO] [2022-03-08 01:32:08] Getting data of table: wp_revslider_css_bkp (0.09 MB)
    [INFO] [2022-03-08 01:32:08] Table: wp_revslider_css_bkp cloned, operation took: 0.01321 ms
    [INFO] [2022-03-08 01:32:08] Getting data of table: wp_revslider_layer_animations (0.00 MB)
    [INFO] [2022-03-08 01:32:08] Table: wp_revslider_layer_animations cloned, operation took: 0.00068 ms
    [INFO] [2022-03-08 01:32:08] Getting data of table: wp_revslider_layer_animations_bkp (0.00 MB)
    [INFO] [2022-03-08 01:32:08] Table: wp_revslider_layer_animations_bkp cloned, operation took: 0.00080 ms
    [INFO] [2022-03-08 01:32:08] Getting data of table: wp_revslider_navigations (0.00 MB)
    [INFO] [2022-03-08 01:32:08] Table: wp_revslider_navigations cloned, operation took: 0.00071 ms
    [INFO] [2022-03-08 01:32:08] Getting data of table: wp_revslider_navigations_bkp (0.00 MB)
    [INFO] [2022-03-08 01:32:08] Table: wp_revslider_navigations_bkp cloned, operation took: 0.00067 ms
    [INFO] [2022-03-08 01:32:08] Getting data of table: wp_revslider_sliders (0.01 MB)
    [INFO] [2022-03-08 01:32:08] Table: wp_revslider_sliders cloned, operation took: 0.00167 ms
    [INFO] [2022-03-08 01:32:08] Getting data of table: wp_revslider_sliders_bkp (0.01 MB)
    [INFO] [2022-03-08 01:32:08] Table: wp_revslider_sliders_bkp cloned, operation took: 0.00163 ms
    [INFO] [2022-03-08 01:32:08] Getting data of table: wp_revslider_slides (0.01 MB)
    [INFO] [2022-03-08 01:32:08] Table: wp_revslider_slides cloned, operation took: 0.00180 ms
    [INFO] [2022-03-08 01:32:08] Getting data of table: wp_revslider_slides_bkp (0.02 MB)
    [INFO] [2022-03-08 01:32:08] Table: wp_revslider_slides_bkp cloned, operation took: 0.00200 ms
    [INFO] [2022-03-08 01:32:08] Getting data of table: wp_revslider_static_slides (0.00 MB)
    [INFO] [2022-03-08 01:32:08] Table: wp_revslider_static_slides cloned, operation took: 0.00229 ms
    [INFO] [2022-03-08 01:32:08] Getting data of table: wp_revslider_static_slides_bkp (0.00 MB)
    [INFO] [2022-03-08 01:32:08] Table: wp_revslider_static_slides_bkp cloned, operation took: 0.00196 ms
    [INFO] [2022-03-08 01:32:08] Getting data of table: wp_term_relationships (0.01 MB)
    [INFO] [2022-03-08 01:32:08] Table: wp_term_relationships cloned, operation took: 0.00340 ms
    [INFO] [2022-03-08 01:32:08] Getting data of table: wp_term_taxonomy (0.01 MB)
    [INFO] [2022-03-08 01:32:08] Table: wp_term_taxonomy cloned, operation took: 0.00410 ms
    [INFO] [2022-03-08 01:32:08] Getting data of table: wp_termmeta (0.00 MB)
    [INFO] [2022-03-08 01:32:08] Table: wp_termmeta cloned, operation took: 0.00071 ms
    [INFO] [2022-03-08 01:32:08] Getting data of table: wp_terms (0.01 MB)
    [INFO] [2022-03-08 01:32:08] Table: wp_terms cloned, operation took: 0.00260 ms
    [INFO] [2022-03-08 01:32:08] Getting data of table: wp_usermeta (0.02 MB)
    [INFO] [2022-03-08 01:32:08] Table: wp_usermeta cloned, operation took: 0.00891 ms
    [INFO] [2022-03-08 01:32:08] Getting data of table: wp_users (0.01 MB)
    [INFO] [2022-03-08 01:32:08] Table: wp_users cloned, operation took: 0.00161 ms
    [INFO] [2022-03-08 01:32:08] Getting data of table: wp_yoast_indexable (0.39 MB)
    [INFO] [2022-03-08 01:32:10] Table: wp_yoast_indexable cloned, operation took: 1.35486 ms
    [INFO] [2022-03-08 01:32:10] Getting data of table: wp_yoast_indexable_hierarchy (0.06 MB)
    [INFO] [2022-03-08 01:32:10] Table: wp_yoast_indexable_hierarchy cloned, operation took: 0.00338 ms
    [INFO] [2022-03-08 01:32:10] Getting data of table: wp_yoast_migrations (0.03 MB)
    [INFO] [2022-03-08 01:32:10] Table: wp_yoast_migrations cloned, operation took: 0.00164 ms
    [INFO] [2022-03-08 01:32:10] Getting data of table: wp_yoast_primary_term (0.05 MB)
    [INFO] [2022-03-08 01:32:10] Table: wp_yoast_primary_term cloned, operation took: 0.00252 ms
    [INFO] [2022-03-08 01:32:10] Getting data of table: wp_yoast_seo_links (0.08 MB)
    [INFO] [2022-03-08 01:32:10] Table: wp_yoast_seo_links cloned, operation took: 0.06672 ms
    [INFO] [2022-03-08 01:32:10] Getting data of table: wp_yoast_seo_meta (0.02 MB)
    [INFO] [2022-03-08 01:32:10] Table: wp_yoast_seo_meta cloned, operation took: 0.00307 ms
    [INFO] [2022-03-08 01:32:10] Table data exported.
    [INFO] [2022-03-08 01:32:10] Memory usage after data export: 93.36 MB
    [INFO] [2022-03-08 01:32:10] Entire process took: 56.8873 s
    [SUCCESS] [2022-03-08 01:32:10] Database backup finished
    [STEP] [2022-03-08 01:32:10] Making archive
    [INFO] [2022-03-08 01:32:10] Compressing…
    [INFO] [2022-03-08 01:32:10] Using PclZip module to create the backup
    [INFO] [2022-03-08 01:32:10] Legacy setting: Using default modules depending on user server
    [WARN] [2022-03-08 01:32:10] Backup will run as single-request, may be unstable…
    [INFO] [2022-03-08 01:32:10] Chunks contain 8000 files.
    [DOWNLOAD GENERATED] File downloaded on (server time): 2022-03-08 01:33:40
    [DOWNLOAD GENERATED] Last update (seconds): 149 seconds ago
    [DOWNLOAD GENERATED] Last update (date): 2022-03-08 01:31:11

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author iClyde

    (@iclyde)

    Hi @markhartmann

    A) Adjust the database:
    Please install “Advanced DB Cleanup” plugin and enter its settings.
    1. Firstly enter “Tables” tab and remove all tables with “1638510711_” prefix.
    – They seems to be part of failed migration.

    2. Then go to “General clean-up” tab and perform bulk clean-up on all entries.
    3. Back to “Tables” tab and optimize all tables.

    Once you do that, you can remove the plugin or keep it, it’s up to you.

    B) Adjust settings of our plugin
    As now your database should be small enough, please follow these steps:
    1. Use these settings in the first section: https://prnt.sc/1s1ocpa
    2. Save first section
    3. Now, go to “Other options” section
    4. Change backup method: https://prnt.sc/1s1ofpa
    5. Disable PHP CLI checking: https://prnt.sc/1sljr31
    6. Modify query output: https://prnt.sc/1trxucl (set this value to 100)
    7. Save “Other options” section
    8. Force stop both processes: https://prnt.sc/1trv1tm

    Then you can try to run the process again.

    Let me know if that worked for you ??
    Thank you!

    Plugin Author iClyde

    (@iclyde)

    As we didn’t hear any reply in last days.
    I can assume that you resolved the issue.

    Feel free to open new topic if I am wrong!
    Thank you ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Backup failure – log below.’ is closed to new replies.