On 5/9/24 04:39, Thomas Beierlein wrote:
Hi Phil,
On Wed, May 08, 2024 at 02:29:01PM -0400, Phil Stracchino wrote:
Just updated Bacula from 13.0.4 to 15.0.2 on Gentoo Linux. The update went
smoothly and without issues aside from the build not running the DB update
script, which I had to do manually.
I found several issues with that step.
First, update_mysql_tables simply complains:
The existing database is version 1024 !!
This script can only update an existing version 12-15 to version 16.
sound like you ran the script from /usr/libexec/bacula/updatedb directory.
The scripts there shows the mentioned problems.
There is a more actual version of the script in /usr/libexec/bacula directory
above. That
should handle all versions up to 1025 in a correct way.
Aaaah, yes, I might have done that. Glad it's just user error and not a
missed bug.
I did later in the day find myself looking at the execution plan for a
restore query, and I hate to say this but, dear gods it's become awful.
No wonder restore performance has become so slow. Ten minutes or longer
to build the file list for a restore, then the actual restore (263
files, off an all-flash array) is done before I can switch to the Jobs
Run tab in BAT. I think that query probably needs to be completely
refactored. About half of the steps in the execution plan are
completely un-indexed. I'm willing to bet performance could be improved
by multiple order of magnitude by breaking it up into pieces and using a
temporary table or two. By the time that query executes Bacula ALREADY
KNOWS what the job IDs are, it's just a matter of identifying the files.
It surely cannot **NEED** to be that slow.
--
Phil Stracchino
Fenian House Publishing
ph...@caerllewys.net
p...@co.ordinate.org
Landline: +1.603.293.8485
Mobile: +1.603.998.6958
_______________________________________________
Bacula-devel mailing list
Bacula-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-devel
