Hello,
Bacula should do a better job of printing an error message, but from
what you show, it looks to me like your SQL instance ran out of storage
space. With the size of your backup, you really should be running
PostgreSQL rather than MySQL. It will probably be 20-30% faster
(possibly more considering the number of files you are backing up).
Best regards,
Kern
On 09/28/2018 04:35 PM, Christopher Sluman wrote:
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
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
