[Bacula-users] MySQL error when jobs run at the same time

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