On 12/18/18 10:38 PM, Gary R. Schmidt wrote: > On 2018-12-19 10:42, 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 > [SNIP] > > That's a very small OS partition in this day and age. > >> ERR=database or disk is full > > 99.9999% this is that you have run out of temporary file space, most > likely space needed by your database server to complete the query.
More specific: Do not use system /tmp as your DB engine's tmpdir. Allocate a separate DB tmpdir somewhere there is plenty of storage. IDEALLY it should be on a separate physical device from both the OS itself and the DB data. -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
