Borg suddenly fails to start

[DougBain]

Borg suddenly fails to start

[mikeberger]

Your database file has been corrupted. Usual causes are running out of disk space, improper machine shutdown due to power failure or crash, disk drive failure, running the database on an NFS shared drive.

Your options are to either try to run the H2 recover tool and see what is restored, restore from your latest BORG backup, or restore a good copy of the .borg_db folder if you are backup up your disk.

To restore from either type of backup, first move the database folder to somewhere safe - i.e. mv /home/doug/.borg_db /home/doug/borg_save.

To restore from a disk backup (if you have one), just restore the .borg_db folder from your backup.

To restore from a BORG backup (a backup zip file created by BORG), start BORG, which creates a new, empty db. then use the Import option in BORG to import your latest backup zip file.

I'll continue in a new post....

[mikeberger]

To attempt using the H2 recover tool you have to run a java program. I'm on windows now. For the actual command lines on Linux, I'd have to switch over to Linux.

In general, you run a program that tries to extract whatever it can from the borgdb.mv.db file into an SQL file. Then you run a second program to recreate the db file from the SQL file. This may be able to recover the entire DB or maybe nothing. It depends what the failure was.

If you need me to get on linux to get the actual commands, let me know. You'd have to have Java installed on your linux machine.

[DougBain]

Thanks. I restored a good copy of the .borg_db folder after deleting all .borg files and folders, and it's now OK

…

On 26/07/2024 19:37, Mike Berger wrote: Your database file has been corrupted. Usual causes are running out of disk space, improper machine shutdown due to power failure or crash, disk drive failure, running the database on an NFS shared drive. Your options are to either try to run the H2 recover tool and see what is restored, restore from your latest BORG backup, or restore a good copy of the .borg_db folder if you are backup up your disk. To restore from either type of backup, first move the database folder to somewhere safe - i.e. mv /home/doug/.borg_db /home/doug/borg_save. To restore from a disk backup (if you have one), just restore the .borg_db folder from your backup. To restore from a BORG backup (a backup zip file created by BORG), start BORG, which creates a new, empty db. then use the Import option in BORG to import your latest backup zip file. I'll continue in a new post.... — Reply to this email directly, view it on GitHub <#216 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACF2QX55HX4J5L7RG3BNA5DZOKJQLAVCNFSM6AAAAABLQ6LJVOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDENJTGI3TSNJZGY>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[mikeberger]

Good to hear.