Hi all,
We are having an error of our disk running out of space while trying to
build the directory tree for a restore job. We have an older server
with only 16GB OS disk and that only has about 8GB free. I notice the
free space will fill up while the directory tree is being built and then
the error is output below. We did have a similar error before with
spool data filling up the disk, so I did move /var/lib/bacula to our
volume storage device which is on the same server.
I couldn't figure out what is filling up the disk, I guess there is
another directory/file that is filling up with data? Do you know which
one? We could just mount this location on our volume storage device as
well?
Thanks
+-------+-------+----------+---------------+---------------------+----------------------+
| JobId | Level | JobFiles | JobBytes | StartTime |
VolumeName |
+-------+-------+----------+---------------+---------------------+----------------------+
| 19406 | F | 25068910 | 3459126598047 | 2018-12-03 19:00:14 |
Pac-wing2-user1-2758 |
| 19507 | I | 625628 | 16116488523 | 2018-12-07 19:00:22 |
Pac-wing2-user1-2982 |
| 19539 | I | 212478 | 6456352368 | 2018-12-08 19:03:17 |
Pac-wing2-user1-2985 |
| 19564 | I | 214199 | 7256961776 | 2018-12-09 19:04:07 |
Pac-wing2-user1-2988 |
| 19589 | I | 277296 | 41375685395 | 2018-12-10 19:00:22 |
Pac-wing2-user1-2991 |
| 19614 | I | 315986 | 10145548827 | 2018-12-11 19:00:39 |
Pac-wing2-user1-2994 |
| 19639 | I | 265282 | 10025498752 | 2018-12-12 19:02:14 |
Pac-wing2-user1-2997 |
| 19664 | I | 597578 | 11810773912 | 2018-12-13 19:00:01 |
Pac-wing2-user1-3001 |
| 19691 | I | 622812 | 11744357702 | 2018-12-14 19:00:16 |
Pac-wing2-user1-3005 |
+-------+-------+----------+---------------+---------------------+----------------------+
You have selected the following JobIds:
19406,19507,19539,19564,19589,19614,19639,19664,19691
Building directory tree for JobId(s)
19406,19507,19539,19564,19589,19614,19639,19664,19691 ... Query failed:
SELECT Path.Path, Filename.Name, T1.FileIndex, T1.JobId, LStat, DeltaSeq
FROM ( SELECT FileId, Job.JobId AS JobId, FileIndex, File.PathId
AS PathId, File.FilenameId AS FilenameId, LStat , File.DeltaSeq AS
DeltaSeq, Job.JobTDate AS JobTDate FROM Job, File, ( SELECT
MAX(JobTDate) AS JobTDate, PathId, FilenameId, DeltaSeq FROM ( SELECT
JobTDate, PathId, FilenameId, DeltaSeq FROM File JOIN Job USING (JobId)
WHERE File.JobId IN
(19406,19507,19539,19564,19589,19614,19639,19664,19691) UNION ALL SELECT
JobTDate, PathId, FilenameId, DeltaSeq FROM BaseFiles JOIN File USING
(FileId) JOIN Job ON (BaseJobId = Job.JobId) WHERE BaseFiles.JobId
IN (19406,19507,19539,19564,19589,19614,19639,19664,19691) ) AS tmp
GROUP BY PathId, FilenameId, DeltaSeq ) AS T1 WHERE (Job.JobId IN (
SELECT DISTINCT BaseJobId FROM BaseFiles WHERE JobId IN
(19406,19507,19539,19564,19589,19614,19639,19664,19691)) OR Job.JobId IN
(19406,19507,19539,19564,19589,19614,19639,19664,19691)) AND T1.JobTDate
= Job.JobTDate AND Job.JobId = File.JobId AND T1.PathId = File.PathId
AND T1.FilenameId = File.FilenameId ) AS T1 JOIN Filename ON
(Filename.FilenameId = T1.FilenameId) JOIN Path ON (Path.PathId =
T1.PathId) WHERE FileIndex > 0 ORDER BY T1.JobTDate, FileIndex ASC:
ERR=database or disk is full
--
Chandler / Systems Administrator
Arizona Genomics Institute
University Of Arizona
www.genome.arizona.edu
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users