Corrupted Backup from Server [localhost]

backup
Tags: #<Tag:0x00007fafc75558d8>

(pham) #1

No errors up to this point.
November 5, 2019, 1:00 am - Backup Lock acquired!
November 5, 2019, 1:00 am - Running pre-backup hooks…
November 5, 2019, 1:00 am - Adding items…
November 5, 2019, 1:03 am - Building manifest…
November 5, 2019, 1:03 am - Creating backup…
November 5, 2019, 1:10 am - Storing backup…
November 5, 2019, 1:10 am - Running post-backup hooks…
November 5, 2019, 1:10 am - Backup successfully completed!

The night of Nov 5th, we created a scheduled backup on the spare asterisk server using this tutorial: https://wiki.freepbx.org/display/F2/Warm+Spare+Setup
Primary Asterisk was never been touched other than creating ssh key between primary and secondary servers.

November 6, 2019, 1:00 am - Backup failed dumping SQL database [asteriskcdrdb] to file [/var/spool/asterisk/tmp/backup-2/mysql-3.sql.gz], you have a corrupted backup from server [localhost].
November 6, 2019, 1:00 am - Building manifest…
November 6, 2019, 1:00 am - Creating backup…
November 6, 2019, 1:06 am - Storing backup…
November 6, 2019, 1:06 am - Running post-backup hooks…
November 6, 2019, 1:06 am - Backup successfully completed!

Storage is not over 25% full.
I found a similar issue and repairing database is suggested, is this still the case?


(pham) #2

Ran mysqlcheck --repair --all-database and then manually ran a backup without error.
However the scheduled backup is still getting the same error.


(system) closed #3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.