Zitat von Uwe Schuerkamp <uwe.schuerkamp AT nionex DOT net>:

> Hi folks,
>
> I'm having a problem understanding job priorities. We don't allow
> mixed jobs to run concurrently, so based on that I've set up my
> catalog backup at the lowest priority (25) while regular backups run
> at 10, some at prio 15 to assure the catalog backup won't start before
> all regular backups are finished.
>
> This works ok on the end of the backup run, but as our database is
> quite large (170GB), the backup job itself can run well into the
> incrementals start time (usually 17.00), and here's the problem:
>
> Instead of waiting for the backupcatalog job to finish, bacula (5.2.12
> compiled from source on centos 6) happily fires off the prio 10 level
> incrementals.
>
> As we shut down the mysql database for the duration of the backup (via
> runbeforejob), this of course leads to havoc with bacula being unable
> to select / insert stuff from and into the database resulting in all
> backup jobs to fail ungracefully.
>
> Question: Shouldn't bacula wait for the prio25 job to finish before
> firing off the prio10 incrementals when mixed prio runs are not
> allowed?

Hello

from my knowledge the jobs are created but take on hold as long as  
other jobs with different priority are running. So it looks like the  
catalog connections are established as part of the job creation. That  
said you should not need to stop the catalog database for the dump, in  
fact i wonder that it works at all to backup the catalog this way. If  
you are in doubt about taking online dumps you can also use PostgreSQL  
which might be a good choice at that scale anyway ;-)

Regards

Andreas



------------------------------------------------------------------------------
LogMeIn Central: Instant, anywhere, Remote PC access and management.
Stay in control, update software, and manage PCs from one command center
Diagnose problems and improve visibility into emerging IT issues
Automate, monitor and manage. Do more in less time with Central
http://p.sf.net/sfu/logmein12331_d2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users