• Resolved mattprojul

    (@mattprojul)


    Hi,

    We haven’t had any troubles with UpdraftPlus for years until a month ago we started noticing that the saved backups weren’t including the database anymore.

    Looking at the last backup log, it seems like everything is going as expected until it gets to trying to backup the wp_yoast_seo_meta table. After which the log just repeats these lines over and over until it looks like process times out.

    056559.909 (18) Table wp_yoast_seo_meta: Rows added in this batch (next record: -1): 75470 (uncompressed bytes in this segment=1178210) in 0.17 seconds
    56559.936 (18) Table wp_yoast_seo_meta: Total expected rows (via COUNT): 5190
    
    ... (repeated 10s of thousands of times)
    
    103893.121 (30) Table wp_yoast_seo_meta: Rows added in this batch (next record: -1): 75470 (uncompressed bytes in this segment=1178210) in 0.15 seconds
    103893.133 (30) Table wp_yoast_seo_meta: Total expected rows (via COUNT): 5190

    This is what the end of the log looks like

    0000.009 (31) UpdraftPlus WordPress backup plugin (https://updraftplus.com): 1.24.2 WP: 6.3.3 PHP: 7.4.22 (litespeed, ...) MySQL: 8.0.32 (max packet size=536870912) WPLANG: en_US Server: LiteSpeed safe_mode: 0 max_execution_time: 900 memory_limit: 2024M (used: 9.7M | 12M) multisite: N openssl: OpenSSL 1.1.1f  31 Mar 2020 mcrypt: N LANG:  ZipArchive::addFile: Y
    0000.015 (31) Free space on disk containing Updraft's temporary directory: 4267.1 MB
    0000.022 (31) Requesting backup semaphore lock (e7b9b6ce88e8)
    0000.037 (31) [Info] Lock (updraft_lock_e7b9b6ce88e8, wp_options) acquired
    0000.045 (31) This backup task (e7b9b6ce88e8) is either complete or began over 2 days ago: ending (1711526083.5326, ) (existing jobdata keys: )

    We’re using the latest version of UpdraftPlus to date (1.24.2).
    I’ve tried changing the “Split archives every” setting to 50mb, but the issue still happens.

    Any insight or direction you can give is greatly appreciated!

Viewing 8 replies - 1 through 8 (of 8 total)
  • Hello,

    You could try making some changes as described by Yoast support here to reduce the size of the table. I would also recommend optimizing your database with WP-Optimize, you may wish to take a manual export of your database before doing so as a backup.

    Thread Starter mattprojul

    (@mattprojul)

    Thanks for the quick reply!

    Unfortunately neither of those optimization options fixed the issue. It really just seems stuck on a loop when processing the wp_yoast_seo_meta table.
    Some more potentially useful info:

    • The wp_yoast_seo_meta table is the last table listed when I go to view the database size.
    • The wp_yoast_seo_meta table is not even close to being our largest table. It’s total size is only 272 KB. Our largest was 198 MB.
    Plugin Support vupdraft

    (@vupdraft)

    Hi,

    Could you post the full backup log using a tools such a pastebin.com?

    Thread Starter mattprojul

    (@mattprojul)

    Plugin Support vupdraft

    (@vupdraft)

    Hi,

    It looks like you are out of space on your hosting. You will need to make space in order for the backup to complete.

    Thread Starter mattprojul

    (@mattprojul)

    I don’t think that is the issue. We have since removed a full backup and tried to run a backup of just the database with the same result. And unless I misunderstand, that log file I sent says at the end how much available space is left when the process times out:

    0000.015 (31) Free space on disk containing Updraft's temporary directory: 4267.1 MB

    Additionally, we confirmed that our hosting has now 7+ gb of available space. We’re looking to upgrade, but that should be plenty to do a backup of just the db. Which UpdraftPlus says in total is only 228.94 MB.

    Plugin Support vupdraft

    (@vupdraft)

    Having looked at your logs again, it looks like you are out of space in your Vault. Backups are accumulating on your server causing you to run out of space there as well.

    As you are using Vault you are a Premium user and thus you will need to contact us through our support desk: https://updraftplus.com/paid-support-requests/

    Thread Starter mattprojul

    (@mattprojul)

    Ok, thank you!

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

The topic ‘Database backup times out’ is closed to new replies.