WordPress.org

Ready to get started?Download WordPress

Forums

Online Backup for WordPress
Getting an error when backing up (32 posts)

  1. LKR
    Member
    Posted 1 year ago #

    Hi, I'm getting this error. I recently moved hosts - though everything was moved along with the site - I think.

    Here's the error:

    A filesystem operation failed while processing 'Database/OBFW_Database.sql' for backup.
    If the following error message is not clear as to the problem and the issue persists, please contact support providing the complete event log for the activity. Diagnostic information follows:

    Failed at: 304(/home/lakerhol/public_html/wp-content/plugins/wponlinebackup/include/tables.php)
    Attempt to compress to file /tmp/obfw1V9kmP only partially succeeded. Only 1884160 of 4194304 bytes were written. (243269632 bytes already written.)PHP last error: An error happened at: wp-db.php(1222)
    mysql_fetch_object(): supplied argument is not a valid MySQL result resource

    More info:

    Online Backup for WordPress Plugin Version 2.2.15
    WordPress Version: 3.5.1
    PHP Version: 5.3.22
    MySQL Server Version: 5.1.68-cll
    MySQL Client Version: 1.0
    Mem: 256M; Post: 16M; Upload: 30M; Timeout: 30
    End of Information

    http://wordpress.org/extend/plugins/wponlinebackup/

  2. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Hi LKR,

    Your database looks to be very very big.
    I think the backup is getting too big for the server /tmp partition and then failing, because the database backup is so big (243MB so far in that error)

    What is the progress message just before it fails? Which table is it backing up and how many rows are in it (if lots of rows, it should say progress as it backs it up). Are there some tables you could exclude that would reduce it down?

    I wonder if there are some cache tables or otherwise from some cache plugins you could possibly exclude.

    Regards,

    Jason

  3. LKR
    Member
    Posted 1 year ago #

    Thanks for the reply!

    The error before that is:

    Table 'wp_translations' has no PRIMARY or UNIQUE key! Backup of this table may be inconsistent; some rows could get missed. See FAQ for more information.

    then

    Table 'wp_translations_log' has no PRIMARY or UNIQUE key! Backup of this table may be inconsistent; some rows could get missed. See FAQ for more information.

  4. LKR
    Member
    Posted 1 year ago #

    I did use to have a translations plugin I think...did the database not erase? Is that the issue? Thanks.

  5. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Hi LKR,

    I meant the message on the progress bar before it then fails. It will say which table it is backing up at that time and how many rows etc.

    Or, you can try use this version instead:
    https://wordpress.backup-technology.com/wponlinebackup-577-tracing.zip
    It will generate a trace.log file. You can find a link to it on the Help & Support tab at the bottom - right-click that link and Save Target As... / Save Linked File As...
    Then compress the file (right-click Compress or right-click SendTo->CompressedZIP)
    And email it to support "at" backup-technology.co.uk and put in the email a link to this forum post so we know who it's from.

    Thanks,

    Jason

  6. LKR
    Member
    Posted 1 year ago #

    Thanks Jason! I've sent the log to the email address provided.

    Regards,
    Ross.

  7. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Hi LKR,

    Can you try this one now:
    https://wordpress.backup-technology.com/wponlinebackup-584-tracing.zip

    I've improved memory usage during the database backup so it will run much quicker for you and fail quicker. It won't fix the problem though, but it will tell us which table is giving the problem and an idea of how big it is. If you can email trace.log again that will be great.

    Once we exclude the problematic table it should work fine then.

    Regards,

    Jason

  8. LKR
    Member
    Posted 1 year ago #

    Thanks Jason! Sent another email.

    Regards,
    Ross.

  9. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Hi Ross,

    On General settings you'll need to exclude wp_translations and wp_translations_log database tables, they are the big ones making everything massive.

    I also notice your server is acting strange and the backup gets killed randomly. Can you let me know your host so I can see what config they might be doing? Or is it your own server? You can email me if you don't want to post it here. Knowing how they set up their PHP will help me improve the backup on their servers so its quicker and doesn't stall randomly.

    Thanks,

    Jason

  10. LKR
    Member
    Posted 1 year ago #

    Thanks, I'm still getting an error, though. This time upon completion, it seems:

    A filesystem operation failed while processing 'Filesystem/public_html/switch2dvd.co.uk/wp-content/plugins/wordpress-move/backup/Backup-13637253251.zip' (Size unknown) for backup.
    If the following error message is not clear as to the problem and the issue persists, please contact support providing the complete event log for the activity. Diagnostic information follows:

    Failed at: 1027(/home/lakerhol/public_html/wp-content/plugins/wponlinebackup-2/include/files.php)
    Attempt to compress to file /tmp/obfwfXjrtH only partially succeeded. Only 1589248 of 4194304 bytes were written. (0 bytes already written.)PHP last error: No error message was logged.

    Also, I'm with DownTownHost. Thanks.

  11. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Hi LKR,

    Try excluding
    wp-content/plugins/wordpress-move/backup

    Looks like we're ending up backing up a backup file!

    Jason.

  12. LKR
    Member
    Posted 1 year ago #

    Is that done by putting wp-content/plugins/wordpress-move/backup in the excludes box in the settings? It didn't do the trick, if so.

  13. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    My bad LKR,

    The path would be:
    switch2dvd.co.uk/wp-content/plugins/wordpress-move/backup

    It's sitting within a subsite with the looks of it.
    Yes, it would be done by placing it in the excludes box in the settings.

    Jason.

  14. LKR
    Member
    Posted 1 year ago #

    Thanks Jason, but still getting the error.

  15. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Did you use the new exclude?

    Is it failing on the same file or different file this time? Just want to check that exclude actually works.

  16. LKR
    Member
    Posted 1 year ago #

    Hi, yes, I used the new exclude. I'm now getting this error: The backup cannot proceed any further due to an unknown problem. Please visit the Help & Support section for information on where to find help.

    Thanks for your help!

  17. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Does it do that after "Filesystem backup complete"? Check the event log to see what the last event is before it fails

  18. LKR
    Member
    Posted 1 year ago #

    Hi, here's what it says:

    Backup starting...

    Initialisation completed.

    (then over 4 hours later)

    The backup cannot proceed any further due to an unknown problem. Please visit the Help & Support section for information on where to find help.

  19. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Hi LKR,

    Thanks. Can you uninstall and install this version:
    https://wordpress.backup-technology.com/wponlinebackup-638-tracing.zip

    Will need to configure the plugin again but it will produce a trace file. If you reproduce problem until backup fails, you can go to Help & Support. If you can provide information there, and also right-click "Download trace.log file here:" link and "Save Target As / Download linked File" etc. it will download the trace.log to your computer.

    Please then right-click the downloaded file and "Send to -> Compressed zip file" (Windows) or right-click "Compress" (Mac). Then please email that compressed file to support "at" backup-technology.co.uk

    We'll then investigate the cause.

    Thanks,

    Jason

  20. LKR
    Member
    Posted 1 year ago #

    Hi, do you mean uninstall the existing tracing plugin I have or uninstall every back-up plugin that's installed? 

  21. Online Backup
    Member
    Plugin Author

    Posted 1 year ago #

    Hi, I mean to uninstall the existing tracing plugin and use this newer one.

    Thanks.

  22. LKR
    Member
    Posted 12 months ago #

    Hi, I tried doing this - sent the email - but was referred back to here.

    Regards,
    Ross.

  23. BackupTechnology
    Member
    Plugin Author

    Posted 12 months ago #

    Hi Ross,

    It's probably because you didn't put anything in the email to say what it was.

    I've found it though and I think I've plugged the problem. Can you try this version?
    http://wordpress.org/plugins/wponlinebackup/developers/

    It's safe to keep using this version too and it doesn't generate any log files (it will become 3.0.5 in due time). If we get any other issues we can investigate separately, using a newer log file version if we need to.

    Regards,

    Jason

  24. LKR
    Member
    Posted 12 months ago #

    Thanks Jason, gave that a go but still not completing; how can I get the new error log to you?

    Regards,
    Ross.

  25. Online Backup
    Member
    Plugin Author

    Posted 11 months ago #

    Hi Ross,

    Please try this newer one and get a log again to me:
    https://wordpress.backup-technology.com/plugin/wponlinebackup-719-tracing.zip

    Mention "Jason" and drop a link to this topic. It'll get through then.

    Thanks,

    Jason

  26. LKR
    Member
    Posted 11 months ago #

    Thanks Jason, getting a 403 when I click the link, though.

    Regards,
    Ross.

  27. Online Backup
    Member
    Plugin Author

    Posted 11 months ago #

    Sorry Ross, you should be able to download it now.

  28. LKR
    Member
    Posted 11 months ago #

    Thanks, email sent, Jason.

  29. Online Backup
    Member
    Plugin Author

    Posted 11 months ago #

    Hi,

    The trace log you sent shows a Filesystem operation failed. Maybe due to space (the database was 92MB dump and it needed to compress it, and that's when it failed). It tries to compress to a tmp folder and I think it was too big to do it.

    Did you get the unknown error at all because I couldn't see that in the log?

    Jason

  30. LKR
    Member
    Posted 11 months ago #

    Hi Jason,

    No, I didn't catch the error - where can I find it?

    Regards,
    Ross.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.