You can find the actual tmpdir by running the sql command show variables like 'tmpdir';
The missing error message is very strange. Is there anything in the mysqld logs? Turning up the mysqld query logging level might help to narrow it down (sorry I don't know how to do that). __Martin >>>>> On Fri, 28 Sep 2018 14:35:30 +0000, Christopher Sluman said: > > Hi, > > Bacula was not compiled with batch insert enabled. > > The OS partition has 13 GB available. I ran the command "mysqld --verbose > --help | grep tmp" and got the following: > max_tmp_tables 32 > slave-load-tmpdir /tmp > tmpdir (No default value) > tmp_table_size 16777216 > > I was also hoping for an error message. Below is the full output from the > point of loading the last tape. > > 26-Sep 10:36 bacula-sd JobId 17477: New volume "100614L5" mounted on device > "Drive-1" (/dev/nst0) at 26-Sep-2018 10:36. > 26-Sep 10:47 bacula-sd JobId 17477: Elapsed time=108:12:56, Transfer > rate=47.41 M Bytes/second 26-Sep 10:47 bacula-sd JobId 17477: Sending spooled > attrs to the Director. Despooling 10,459,807,492 bytes ... > 26-Sep 10:52 bacula-dir JobId 17477: Fatal error: catreq.c:507 Attribute > create error: ERR=26-Sep 10:52 bacula-dir JobId 17477: Error: Bacula > bacula-dir 9.0.2 (24Jul17): > Build OS: x86_64-pc-linux-gnu redhat > JobId: 17477 > Job: mnemosyne_hestia1_set.2018-09-21_22.05.00_03 > Backup Level: Full > Client: "mnemosyne" 9.0.2 (24Jul17) > x86_64-pc-linux-gnu,redhat, > FileSet: "mnemosyne hestia1 set" 2016-01-27 14:03:41 > Pool: "Backup-Weekly" (From Run Pool override) > Catalog: "MyCatalog" (From Client resource) > Storage: "LTO-5" (From Job resource) > Scheduled time: 21-Sep-2018 22:05:00 > Start time: 21-Sep-2018 22:05:00 > End time: 26-Sep-2018 10:52:39 > Elapsed time: 4 days 12 hours 47 mins 39 secs > Priority: 10 > FD Files Written: 33,683,815 > SD Files Written: 0 > FD Bytes Written: 18,466,482,123,784 (18.46 TB) > SD Bytes Written: 0 (0 B) > Rate: 47149.4 KB/s > Software Compression: 100.0% 1.0:1 > Comm Line Compression: None > Snapshot/VSS: no > Encryption: no > Accurate: no > Volume name(s): > 100408L5|100407L5|100416L5|100415L5|100405L5|100406L5|100400L5|100403L5|100420L5|100401L5|100402L5|100465L5|100398L5|100399L5|100419L5|100609L5|100456L5|100453L5|100457L5|100056L5|100614L5 > Volume Session Id: 2 > Volume Session Time: 1537539607 > Last Volume Bytes: 82,517,348,352 (82.51 GB) > Non-fatal FD errors: 1 > SD Errors: 0 > FD termination status: OK > SD termination status: SD despooling Attributes > Termination: *** Backup Error *** > > Regards, > Chris Sluman > IT Technician > Structural Genomics Consortium > University of Oxford > Old Road Campus Research Building > Roosevelt Drive > Oxford > OX3 7DQ > > T: 01865 617577 > > > -----Original Message----- > From: Martin Simmons <mar...@lispworks.com> > Sent: 27 September 2018 18:10 > To: Christopher Sluman <christopher.slu...@sgc.ox.ac.uk> > Cc: bacula-users@lists.sourceforge.net; David Damerell > <david.damer...@sgc.ox.ac.uk>; Brian Marsden <brian.mars...@sgc.ox.ac.uk> > Subject: Re: [Bacula-users] Bacula 9 "Attribute create error" > > Is this the complete unedited output? There should at least be a newline > after "ERR=" and I would expect an error message too. > > Is Bacula compiled with "batch insert" enabled? > > Does the mysql temp directory have enough free space? > > __Martin > > >>>>> On Thu, 27 Sep 2018 15:26:17 +0000, Christopher Sluman said: > > > > Hi, > > > > I am running Bacula 9.0.2 and have started getting consistent backup > > failures with following message: > > > > 26-Sep 10:47 bacula-sd JobId 17477: Elapsed time=108:12:56, Transfer > > rate=47.41 M Bytes/second 26-Sep 10:47 bacula-sd JobId 17477: Sending > > spooled attrs to the Director. Despooling 10,459,807,492 bytes ... > > 26-Sep 10:52 bacula-dir JobId 17477: Fatal error: catreq.c:507 Attribute > > create error: ERR=26-Sep 10:52 bacula-dir JobId 17477: Error: Bacula > > bacula-dir 9.0.2 (24Jul17): > > FD Files Written: 33,683,815 > > SD Files Written: 0 > > FD Bytes Written: 18,466,482,123,784 (18.46 TB) > > > > Other jobs can then write to the same tape so it is not a physical issue > > with tape or changer. I have run mysqlcheck and dbcheck on the database, > > but without any issues being identified/repaired. > > > > Has anyone come across this issue and been able to resolve it? > > > > Regards, > > Chris Sluman > > IT Technician > > Structural Genomics Consortium > > University of Oxford > > Old Road Campus Research Building > > Roosevelt Drive > > Oxford > > OX3 7DQ > > > > T: 01865 617577 > _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
