WARNING: Job restarts due to inactivity for more than 5 minutes

  • Resolved Sina Saeedi

    (@melodymag)


    4 years, 10 months ago

    Hi there.
    I have a huge amount of users, about 1 million registered users that made my wp_usersmeta table very large, about 5.6 million records and 3.2 GB in MySQL.

    Backing up the database always got me an error, so I made two jobs: one for all the tables except wp_usersmeta and one for only wp_usersmeta.

    Still I get the error below on the wp_usersmeta job:

    [INFO] BackWPup 3.8.0; A project of Inpsyde GmbH
    [INFO] WordPress 5.7.1 on XXX
    [INFO] Log Level: Normal
    [INFO] BackWPup job: Users Meta DB Backup – Every Day
    [INFO] Logfile is: XXX.html
    [INFO] Backup file is: 2021-04-24_03-25-05_XXX.tar.gz
    [24-Apr-2021 03:25:05] 1. Try to backup database …
    [24-Apr-2021 03:25:05] Connected to database XXX on localhost
    [24-Apr-2021 03:35:05] WARNING: Job restarts due to inactivity for more than 5 minutes.
    [24-Apr-2021 03:35:05] 1. Try to backup database …
    [24-Apr-2021 03:35:05] Connected to database XXX on localhost
    [24-Apr-2021 03:36:34] Added database dump “XXX.sql.gz” with 402,74 MB to backup file list
    [24-Apr-2021 03:36:34] Database backup done!
    [24-Apr-2021 03:36:34] 1. Trying to generate a manifest file …
    [24-Apr-2021 03:36:34] Added manifest.json file with 5,78 KB to backup file list.
    [24-Apr-2021 03:36:34] 1. Trying to create backup archive …
    [24-Apr-2021 03:36:34] Compressing files as TarGz. Please be patient, this may take a moment.
    [24-Apr-2021 03:36:56] Backup archive created.
    [24-Apr-2021 03:36:56] Archive size is 414,83 MB.
    [24-Apr-2021 03:36:56] 3 Files with 402,75 MB in Archive.
    [24-Apr-2021 03:37:00] 1. Try to send backup file to an FTP server …
    [24-Apr-2021 03:37:00] Connected to FTP server: 192.168.1.11:21
    [24-Apr-2021 03:37:00] FTP client command: USER XXX
    [24-Apr-2021 03:37:00] FTP server response: User XXX logged in.
    [24-Apr-2021 03:37:00] FTP client command: SYST
    [24-Apr-2021 03:37:00] FTP server reply: Windows_NT
    [24-Apr-2021 03:37:00] FTP current folder is: /XXX/db-users-meta/
    [24-Apr-2021 03:37:00] FTP client command: PASV
    [24-Apr-2021 03:37:00] FTP server reply: Entering passive mode
    [24-Apr-2021 03:37:00] Starting upload to FTP …
    [24-Apr-2021 03:37:12] Backup transferred to FTP server: /XXX/db-users-meta/2021-04-24_03-25-05_XXX.tar.gz
    [24-Apr-2021 03:37:12] One old log deleted
    [24-Apr-2021 03:37:12] Job done in 727 seconds.
    [24-Apr-2021 03:45:44] ERROR: Aborted by user!
    [24-Apr-2021 03:45:44] ERROR: Job has ended with errors in 1239 seconds. You must resolve the errors for correct execution.`</strong>
    `

    Are the generated file complete and OK now? Or it’s partial and unusable?
    How can I get rid of the warnings and errors?

    By the way, thanks for your great plugin.
    Regards

Viewing 8 replies - 1 through 8 (of 8 total)
  • Andreas W.

    (@aweissinpsyde)

    4 years, 10 months ago

    Hello @melodymag

    can you please follow these steps here: https://backwpup.com/docs/job-restarts-due-to-inactivity-for-more-than-5-minutes/

    Thank you
    Best regards
    Andreas

    Thread Starter Sina Saeedi

    (@melodymag)

    4 years, 10 months ago

    Thanks for your reply @aweissinpsyde.
    I tried it again, but still the same.
    Any other solution?

    Plugin Support happyAnt

    (@duongcuong96)

    4 years, 10 months ago

    Hello @melodymag
    Backup transferred to FTP server: /XXX/db-users-meta/2021-04-24_03-25-05_XXX.tar.gz
    I saw the job has been transferred to your FTP server, could you please check?
    Thank you!

    Thread Starter Sina Saeedi

    (@melodymag)

    4 years, 10 months ago

    @duongcuong96 yes it’s done. But Every time I receive an email containing the message above. Is there any solution?
    The email on errors feature is very handy and should be turned on but It’s really annoying to receive an email says that there was a restarted job but it was successful, every night.

    Plugin Support happyAnt

    (@duongcuong96)

    4 years, 10 months ago

    Hello @melodymag
    The warning [24-Apr-2021 03:35:05] WARNING: Job restarts due to inactivity for more than 5 minutes. mostly caused by server issue, you can try to make some tweak in BackWPUp as a workaround:
    – BackWPUp -> Settings -> Job tab -> Reduce server load -> choose medium
    – BackWPUp -> Settings -> Maximum script execution time -> maybe 20 or 25
    – change backup file to Tar(Tar use fewer server resource, so usually the hoster will not kill the backup process)

    Or you can simply create an email filter to ignore those warnings 😅😅

    Thread Starter Sina Saeedi

    (@melodymag)

    4 years, 10 months ago

    Hi @duongcuong96
    Thanks for your reply but still no luck.
    Regsrds.

    Plugin Support happyAnt

    (@duongcuong96)

    4 years, 9 months ago

    @melodymag
    yeah so I think you could create an email filter for the case ^^

    Thread Starter Sina Saeedi

    (@melodymag)

    4 years, 9 months ago

    @duongcuong96
    I was thinking the backup file is OK as you mentioned earlier:

    Backup transferred to FTP server: /XXX/db-users-meta/2021-04-24_03-25-05_XXX.tar.gz
    I saw the job has been transferred to your FTP server, could you please check?
    Thank you!

    So for testing purpose, I downloaded one of the files from FTP and WOW, the file even couldn’t be extracted! The extraction fails because there is a problem with the compressed file.

    All these times I thought even there is some warnings and errors, the backup-ed file is OK and it’s ready to be used, but I was absolutely wrong!

    I don’t know what to do. I feel all these times I had no backup!

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

The topic ‘WARNING: Job restarts due to inactivity for more than 5 minutes’ is closed to new replies.