On Tue, Apr 06, 2010 at 11:13:44AM +0100, Graham Keeling wrote: > I'm using bacula-5.0.1. > > At about Apr 6 10:00, I logged into mysql, and ran 'show full processlist;', > which gave the following. > > | 3033 | root | localhost | bacula | Query | 22464 | executing | SELECT > Path.P > ath, Filename.Name, Temp.FileIndex, Temp.JobId, LStat, MD5 FROM ( SELECT > FileId, > Job.JobId AS JobId, FileIndex, File.PathId AS PathId, File.FilenameId AS > Filena > meId, LStat, MD5 FROM Job, File, ( SELECT MAX(JobTDate) AS JobTDate, PathId, > Fil > enameId FROM ( SELECT JobTDate, PathId, FilenameId FROM File JOIN Job USING > (Job > Id) WHERE File.JobId IN (22,23,31,34,42,48,52) UNION ALL SELECT JobTDate, > PathId > , FilenameId FROM BaseFiles JOIN File USING (FileId) JOIN Job ON > (BaseJobId > = Job.JobId) WHERE BaseFiles.JobId IN (22,23,31,34,42,48,52) ) AS tmp GROUP > BY P > athId, FilenameId ) AS T1 WHERE (Job.JobId IN ( SELECT DISTINCT BaseJobId > FROM B > aseFiles WHERE JobId IN (22,23,31,34,42,48,52)) OR Job.JobId IN > (22,23,31,34,42, > 48,52)) AND T1.JobTDate = Job.JobTDate AND Job.JobId = File.JobId AND > T1.PathId > = File.PathId AND T1.FilenameId = File.FilenameId ) AS Temp JOIN Filename ON > (Fi > lename.FilenameId = Temp.FilenameId) JOIN Path ON (Path.PathId = Temp.PathId) > WH > ERE FileIndex > 0 ORDER BY Temp.JobId, FileIndex ASC | > > 'Time 22464' is equivalent to about 6 hours, so I presume that after > 'Bootstrap > records written', bacula has been waiting for this sql command, during which > time it could not do anything else. Backups of other clients were failing > because I had Max Wait Time set to something less than 6 hours.
Yes, it happens, especially with bigger File tables - what does "Select count(*) from File" returns for you ? This slowdown was not present in 3.0.3 but is new to 5.0.x series and has been documented on http://bugs.bacula.org/view.php?id=1472 which is in process of being debugged currently -- Matija Nalis Odjel racunalno-informacijskih sustava i servisa Hrvatska akademska i istrazivacka mreza - CARNet Josipa Marohnica 5, 10000 Zagreb tel. +385 1 6661 616, fax. +385 1 6661 766 www.CARNet.hr ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
