On Thu, 9 May 2024 at 17:12, Phil Stracchino <ph...@caerllewys.net> wrote:
> 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. > Hello Phil, For the slow Bacula restore, BAT the same as Baculum and Bacularis uses Bacula Bvfs interface for doing restore. The Bvfs restore part responsible for preserving hardlinks causes this slowness. Some time ago I researched it a bit. The result together with a workaround you can find in this thread: https://sourceforge.net/p/bacula/mailman/message/58758531/ Traditional restore using the bconsole 'restore' command interface does not cause this problem (it does not use Bvfs). Best regards, Marcin Haba (gani) > -- > 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 > -- "Greater love hath no man than this, that a man lay down his life for his friends." Jesus Christ "Większej miłości nikt nie ma nad tę, jak gdy kto życie swoje kładzie za przyjaciół swoich." Jezus Chrystus
_______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
