Re: [Bacula-users] Index for Table File is corrupt

2023-05-28 Thread Phil Stracchino
On 5/28/23 02:38, Dr. Thorsten Brandau wrote: Well, thank you. I tried everything above, including going from -1 instead (tried different ranges). WHATEVER I DO, I only get ERROR 1034 (HY000): Index for table 'File' is corrupt; try to repair it back. And you'd already tried a

Re: [Bacula-users] Index for Table File is corrupt

2023-05-28 Thread Dr. Thorsten Brandau
Phil Stracchino schrieb am 27.05.23 um 20:22: On 5/27/23 08:17, Dr. Thorsten Brandau wrote: CHECK TABLE File ; +-+---+--+---+ | Table   | Op    | Msg_type | Msg_text  |

Re: [Bacula-users] Index for Table File is corrupt

2023-05-27 Thread Phil Stracchino
On 5/27/23 14:22, Phil Stracchino wrote: So first create a new empty table: CREATE TABLE `File_NEW` ( `FileId` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `FileIndex` int(11) DEFAULT 0, `JobId` int(10) unsigned NOT NULL, `PathId` int(10) unsigned NOT NULL, `Filename` blob

Re: [Bacula-users] Index for Table File is corrupt

2023-05-27 Thread Phil Stracchino
On 5/27/23 08:17, Dr. Thorsten Brandau wrote: CHECK TABLE File ; +-+---+--+---+ | Table   | Op    | Msg_type | Msg_text  |

Re: [Bacula-users] Index for Table File is corrupt

2023-05-27 Thread Dr. Thorsten Brandau
Dr. Thorsten Brandau schrieb am 27.05.23 um 09:36: Phil Stracchino schrieb am 26.05.23 um 18:57: On 5/26/23 11:39, Dr. Thorsten Brandau wrote: When I use mysqlcheck I get Warning  : InnoDB: The B-tree of index PRIMARY is corrupted. mysqlcheck -r bacula returns "storage engine does not

Re: [Bacula-users] Index for Table File is corrupt

2023-05-27 Thread Dr. Thorsten Brandau
Phil Stracchino schrieb am 26.05.23 um 18:57: On 5/26/23 11:39, Dr. Thorsten Brandau wrote: When I use mysqlcheck I get Warning  : InnoDB: The B-tree of index PRIMARY is corrupted. mysqlcheck -r bacula returns "storage engine does not support repair" So, the B-Tree is still corrup on

Re: [Bacula-users] Index for Table File is corrupt

2023-05-26 Thread Phil Stracchino
On 5/26/23 11:39, Dr. Thorsten Brandau wrote: When I use mysqlcheck I get Warning  : InnoDB: The B-tree of index PRIMARY is corrupted. mysqlcheck -r bacula returns "storage engine does not support repair" So, the B-Tree is still corrup on PRIMARY. OK. If that is the only problem, and

Re: [Bacula-users] Index for Table File is corrupt

2023-05-26 Thread Dr. Thorsten Brandau
Udo Kaune schrieb am 26.05.23 um 17:08: Am 26.05.23 um 13:45 schrieb Dr. Thorsten Brandau: Udo Kaune schrieb am 26.05.23 um 13:22: 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:

Re: [Bacula-users] Index for Table File is corrupt

2023-05-26 Thread Udo Kaune
Am 26.05.23 um 13:45 schrieb Dr. Thorsten Brandau: Udo Kaune schrieb am 26.05.23 um 13:22: 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

Re: [Bacula-users] Index for Table File is corrupt

2023-05-26 Thread Dr. Thorsten Brandau
Udo Kaune schrieb am 26.05.23 um 13:22: 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

[Bacula-users] Index for Table File is corrupt

2023-05-26 Thread Udo Kaune
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:

[Bacula-users] Index for Table File is corrupt

2023-05-26 Thread Udo Kaune
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:

[Bacula-users] Index for Table File is corrupt

2023-05-26 Thread 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