On Tue, Apr 06, 2010 at 12:59:49PM +0200, Matija Nalis wrote: > 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 ?
3239328 > 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 Thanks for that. A colleague of mine did exactly "start several jobs; very soon the query gets run and everything else stops" this morning. ------------------------------------------------------------------------------ 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
