I also had a similar problem (one Job was working out very long).
Temporary tables do not have to create with the same name.
Possibly may need a patch for bacula.
2008/9/15 Andy Shellam <andy-lists AT networkmail DOT eu>:
> Hi,
>
> I'm running Bacula 2.4.2 which is backing up 4 servers incrementally
> during the week, starting at 4:00. Two of the servers are virtually
> identical and the backup jobs complete at around the same time.
>
> This results in the following error:
>
> 15-Sep 04:08 sydney-dir JobId 395: Query failed: CREATE TEMPORARY TABLE
> DelCandidates (JobId INTEGER UNSIGNED NOT NULL, PurgedFiles TINYINT,
> FileSetId INTEGER UNSIGNED, JobFiles INTEGER UNSIGNED, JobStatus BINARY(1)):
> ERR=Table 'DelCandidates' already exists
>
> My questions are:
>
> 1. Is this a problem? I'm guessing it's part of the clean-up of
> previous jobs, so is it possible to restrict the clean-ups to a
> particular job (e.g. at the end of the week when the jobs are likely to
> take longer and finish at different times.)
>
> 2. Would it be better to only let the director run one job at a time?
> This seems a rather limited option, though, as if I was backing up 30
> servers I would need to schedule the total time to back them all up,
> instead of just the time of the longest backup job.
>
> Thanks,
>
> Andy
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
--
with best regards
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
