Bacula Infrastructure SOP

From FedoraProject

(Difference between revisions)
Jump to: navigation, search
(add note about the fatal mysql issue)
(redirect page to new infra-docs)
 
(One intermediate revision by one user not shown)
Line 2: Line 2:
 
{{shortcut|ISOP:BACULA}}
 
{{shortcut|ISOP:BACULA}}
  
Bacula is our backup solution.  Our backups run to backup01 and ultimately to a tape robot
+
This SOP has moved to the fedora Infrastructure SOP git repo. Please see the current document at: http://infrastructure.fedoraproject.org/infra/docs/bacula.txt
  
== Contact Information ==
+
For changes, questions or comments, pleasecontact anyone in the Fedora Infrastructure team.  
Owner: Fedora Infrastructure Team
+
 
+
Contact: #fedora-admin, sysadmin-main
+
 
+
Location: Phoenix
+
 
+
Servers: backup01
+
 
+
Purpose: Our backup solution
+
 
+
== Troubleshooting and Resolution ==
+
 
+
You can get to the bacula management console with:
+
 
+
<code>
+
sudo /usr/sbin/bconsole
+
</code>
+
 
+
From there you can get a overview status with:
+
 
+
<code>
+
status dir
+
</code>
+
 
+
Or a more specific status on the tape drive with:
+
 
+
<code>
+
status
+
2
+
2
+
</code>
+
 
+
=== Intervention Required ===
+
If the tapes fill up, it may be required to purge the oldest volume.  This is done with the purge command.  Select volume, then a list of volumes comes up.  Pick the oldest volume that has not already been purged or recycled.
+
 
+
<code>
+
list volumes
+
</code>
+
 
+
then
+
 
+
<code>
+
purge
+
</code>
+
 
+
It will ask you for the media-id or volume -id. Enter the one from the <b>oldest</b> tape listed above in list volumes.
+
 
+
After that the oldest tape will be purged, but bacula may not resume on it yet. You need to load the tape to make sure it realizes it can go on:
+
 
+
<code>
+
mount
+
</code>
+
 
+
It will ask for the device (say tape), then ask for the slot id. Enter the number from above in list volumes.
+
 
+
== Mysql insert failures ==
+
 
+
Sometimes backups will fail with a:
+
 
+
<code>
+
Fatal error: Can't fill File table Query failed: INSERT INTO File (FileIndex, JobId, PathId, FilenameId, LStat, MD5)SELECT batch.FileIndex, batch.JobId, Path.PathId, Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON (batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name): ERR=Lock wait timeout exceeded; try restarting transaction
+
</code>
+
 
+
This error is a issue with the old bacula and mysql we have, and there's not much to be done about it. Start a new backup if one is needed or wait for the next backup to complete.  
+
  
  
 
[[Category:Infrastructure SOPs]]
 
[[Category:Infrastructure SOPs]]

Latest revision as of 10:36, 18 December 2011

Infrastructure InfrastructureTeamN1.png
Shortcut:
ISOP:BACULA

This SOP has moved to the fedora Infrastructure SOP git repo. Please see the current document at: http://infrastructure.fedoraproject.org/infra/docs/bacula.txt

For changes, questions or comments, pleasecontact anyone in the Fedora Infrastructure team.