[Bacula-users] bconsole slow during copyjobs

Hi,

we have bacula 3.0.3 in production environment with catalog on mysql  
5.1.40, engine innodb. During normal jobs bconsole is fast but during  
copyjobs is very slow. We noticed that bconsole is waiting for this  
query to complete:

SELECT DISTINCT DelCandidates.JobId,DelCandidates.PurgedFiles FROM  
Job,DelCandidates WHERE (Job.JobId=DelCandidates.JobId AND  
DelCandidates.JobStatus NOT IN ('T','W')) OR (Job.JobTDate>1262847609  
AND Job.ClientId=26 AND Job.Type='C')

(ClientId 26 is the fake client for copyjobs named "None" in bacula- 
dir.conf)

Do you have a suggestion or workaround for this issue?

Thank you.
Kindest regards.

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users