Failed Backup on Sophos Firewall 19.5.3 - Status 500 - Failed to take database dump

Hello wilsonS ,

Thank you for reaching out to the community, On the CLI, select option, the option 4. Device console. run the following command - console> system fsck-on-nextboot on
And then perform a reboot, once the appliance has successfully booted up, try taking the backup once again. And let us know if that has helped fix or not ?

I tried that just now and the issue persists. Same error when running # opcode system_backup -ds nosync. What's the database technology running under the hood? Can we look at logs there? Can a repair be done to the database alone or find out exactly why the database backup failed?

Hi,

I would suggest you have a corrupt disk.

Ian

Hey wilsonS , can you please DM me the support access, so that we can check...

Thanks for the suggestion Ian. The command system fsck-on-nextboot on and a reboot didn't show any issues on the console screen. Isn't it suppose to show an error given fsck is being run on the three partititions, if there was a corruption? I thought if it was a serious corruption with the underlying disk fsck would continually show an error everytime you run it.

Thanks for the suggestion Ian. The command system fsck-on-nextboot on and a reboot didn't show any issues on the console screen. Isn't it suppose to show an error given fsck is being run on the three partititions, if there was a corruption? I thought if it was a serious corruption with the underlying disk fsck would continually show an error everytime you run it.

Hey wilsonS , system fsck-on-nextboot will just repair one or more Linux file systems if there is any corruption...

Hi,

where is the backup stored and in which partition does fsck scan?

Ian

stored under var/conf/backupdata/
fsck scans file system under root partion and if there are any inconsistencies found, it tries to repair them...

Good question. Does that command scan /var where the backup goes. I think so but will leave it to experts to comment.

I remember seeing three lines during boot in the VM console that showed fsck running against three filesystems. No errors were displayed. I think /var is one of the filesystems which is scanned. Anyway, if you do a df -h from the advanced console/shell you get this below: /dev/var is the device which is mounted into /var where the backup goes.

If you check /var/conf/backupdata/device.backup you see a file called db.dump. It's a text file. Is this the backup dump file? If so is it complete or did it stop and drop out due to some logical error in the database. 

It looks like a postgres database is being used.

yes /, /usr, /var, and /tmp are file systems...