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-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] Baculum Restore Wizard Boxes are Empty

2023-05-27 Thread Chris Wilkinson
I answered my own question when I remembered an old post by Marcin on a similar issue. The answer there was to clear the bvfs cache with "clear_bvfs_cache yes" in bconsole. This had the desired effect. -Chris- On Fri, 26 May 2023, 20:45 Chris Wilkinson, wrote: > When I use the restore wizard

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 Phil Stracchino
On 5/27/23 08:17, Dr. Thorsten Brandau wrote: CHECK TABLE File ; +-+---+--+---+ | Table   | Op    | Msg_type | Msg_text  |