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