Hello, On 6/1/21 05:50, Phil Stracchino wrote: > Actually, there is no point to that DROP INDEX operation, because the > entire table is going to be dropped after its replacement is rebuilt anyway. > > What you can (and probably should) do is find the following two lines: > > DROP INDEX IF EXISTS JobId on File; > DROP INDEX IF EXISTS JobId_2 on File; > > And, frankly, just delete them. They serve no purpose.
As I wrote previously, this major catalog update will consume a very large amount of disk space, and these commands are here to drop the biggest indexes of the database. This is useful for most users. > If you prefer to have those indexes dropped anyway in the script, then > just delete the words 'IF EXISTS' from these two lines ONLY. The reason > they are there is probably a copy-paste error on my part. > So, what is the correct syntax? Or maybe it is not available on all recent MySQL & co distribution? I'm almost ready to release 11.0.5, and such kind of fixes would be helpful. I can drop the IF EXISTS and add a comment for users that want to run the procedure multiple times. Best Regards, Eric _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
