Hello,
I concur with what Gary wrote, but would like to make it very clear --
Bacula does not need much disk to do restores except of course on the
client machine. On the other hand the catalog database server (normally
MySQL or PostgreSQL) will need disk in very large restores. If your SQL
engine runs out of disk space, it is really a SQL server problem. The
two solutions are to: give the server more disk space, give it more
memory (and configure it to use that memory). If your restore is
critical, I would suggest either swapping your disk out for a much
bigger one, or adding a second disk, or possibly adding a network device
(NFS) disk. A network disk will of course be slower. You might even be
able to plugin in a giant USB disk (1-2T USB disks are common and cheap
and smaller ones are very cheap) and configure the SQL server to use it.
Best regards,
Kern
On 12/19/18 12:42 AM, ad...@genome.arizona.edu wrote:
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
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
