Am 26.05.23 um 09:14 schrieb Dr. Thorsten Brandau:
Hi I have the following error when backing up the catalogue after my backup: 26-Mai 01:28 -dir JobId 220: shell command: run BeforeJob "/usr/libexec/bacula/make_catalog_backup.pl MyCatalog" 26-Mai 01:30 -dir JobId 220: BeforeJob: mysqldump: Error 1034: Index for table 'File' is corrupt; try to repair it when dumping table `File` at row: 0 26-Mai 01:30 -dir JobId 220: Error: Runscript: BeforeJob returned non-zero status=3. ERR=Child exited with code 3 26-Mai 01:30 -dir JobId 220: Error: Bacula -dir 11.0.6 (10Mar22): How can I repair this? Cheers T
Hello, Why is your database broken in the first place? RTM: https://dev.mysql.com/doc/refman/8.0/en/rebuilding-tables.html https://dev.mysql.com/doc/refman/8.0/en/alter-table.html#alter-table-index /etc/bacula/make_bacula_tables mysql use bacula; SHOW INDEXES FROM File; ALTER TABLE File ENGINE = InnoDB; If you need to drop and recreate single indexes: DROP INDEX JobId on File; DROP INDEX JobId_2 on File; CREATE INDEX JobId on File (JobId); CREATE INDEX JobId_2 on File (JobId, PathId, Filename(255)); Regards, Udo
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
