[Bacula-users] MySQL "hangs", jobs hang. Well not really, but

MySQL process keeps on running at 100% CPU and is processing

SELECT Path.Path, Filename.Name, Temp.FileIndex, Temp.JobId, LStat, MD5
FROM ( SELECT FileId, Job.JobId AS JobId, FileIndex, File.PathId AS
PathId, File.FilenameId AS FilenameId, LStat, MD5 FROM Job, File, (
SELECT MAX(JobTDate) AS JobTDate, PathId, FilenameId FROM ( SELECT
JobTDate, PathId, FilenameId FROM File JOIN Job USING (JobId) WHERE
File.JobId IN (7088,7196,7204,7260) UNION ALL SELECT JobTDate, PathId,
FilenameId FROM BaseFiles JOIN File USING (FileId) JOIN Job  ON   
(BaseJobId = Job.JobId) WHERE BaseFiles.JobId IN (7088,7196,7204,7260) )
AS tmp GROUP BY PathId, FilenameId ) AS T1 WHERE (Job.JobId IN ( SELECT
DISTINCT BaseJobId FROM BaseFiles WHERE JobId IN (7088,7196,7204,7260))
OR Job.JobId IN (7088,7196,7204,7260)) 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 (Filename.FilenameId =
Temp.FilenameId) JOIN Path ON (Path.PathId = Temp.PathId) WHERE
FileIndex > 0 ORDER BY Temp.JobId, FileIndex ASC

My setup has worked flawlessly for years, and now suddenly this.

This is on CentOS 6.5 with Version: 5.0.0 (26 January 2010)

Any thoughts, what might cause this?

-- 
jarif.bit

signature.asc
Description: OpenPGP digital signature

------------------------------------------------------------------------------
Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users