>>>>> On Thu, 21 Dec 2023 19:40:57 +0000, Tom Hodder via Bacula-users said: > > inspecting the bacula and mysql server during the slow jobs, I can see > no particularly high io or cpu, except that the mysql server has 1 CPU > stuck at 100% and there is a long running query: > > SELECT Path.Path, File.Filename FROM File JOIN Path USING (PathId) > JOIN b21197077 AS T ON (File.JobId = T.JobId AND File.FileIndex = > T.FileIndex) WHERE File.Filename LIKE ':component_info_%' AND > File.JobId IN (103,419);
This query looks like something related to restores or the .bvfs_get_bootstrap bconsole command, not the backups. Were you running some front end or GUI that was querying about jobids 103 and 419? __Martin _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
