Hi, Running that sql command confirmed the temp directory is /tmp
I looked at the mysqld log and couldn't see anything recent. There were space issues, but they were more than a year ago. I will look into increasing the logging level, but my concern would be that it would use more resources which may increase the problems. 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: 28 September 2018 17:34 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" 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
