In the message dated: Thu, 22 Feb 2007 16:47:42 EST,
The pithy ruminations from David Romerstein on
<[Bacula-users] 'PURGE' command> were:
=> Well, I believe that I may have just done something terribly stupid.
=>
=> As stated before, I'm using bacula (2.0.0, RHEL 4) to archive a very large
=> amount of data to tape, so that I can remove it from our overloaded
filestore.
=>
=> While I was running a backup, another admin bounced the MySQL service,
=> which took less than a minute to come back up. In that time, 1600+ inserts
=> into table Filename failed. Once I realized what had happened, I thought
=> to myself, "No problem - I'll kill this job, recycle the tape so I don't
Hmmm...you must have a typo there. I'm almost certain you meant to say:
"No problem - I'll kill the other admin, then recycle the tape..."
=> have to drive to the colo and physically swap tapes, restart the job, and
=> all will be well".
Good plan.
=>
=> I grab the handy-dandy printout of TFM I that have here, and I look up
=> "Manually Recycling Volumes". I find that I need to run 'update volume' to
=> make sure that Recycle is set to 'yes', and then run the 'purge jobs
=> volume' command to mark the volume as purged. "OK", I think to myself, "no
=> problem". I run 'update volume', and I make sure the volume is set to
=> recycle. I then run 'purge'. I'm asked to choose to purge files, jobs, or
=> volume. Reading the line 'purge jobs volume' in the docs, I assume that
=> the proper choice here is 'jobs', so I choose that... and it appears that
=> it is now deleting all of the Jobs for the default client:
Yep.
=>
=> You have the following choices:
=> 1: files
=> 2: jobs
=> 3: volume
=> Choose item to purge (1-3): 2
=> Automatically selected Client: srv01-fd
=> Begin purging jobs from Client "srv01-fd"
=>
=> ... and 'mytop' tells me that the current running query is "DELETE from
=> File where JobID=28". JobID 28 just happens to be the first successful
=> large (18 million files, 300+GB) backup/archive I made.
Ouch.
=>
=> This... is a problem. There's no failsafe. Yep, there's a "This command
=> can be DANGEROUS!!!" warning, but no way to stop the action once it's
=> started.
=>
=> The main question here is "are all of my jobs going to disappear from the
=> db?" - if this is the case, question #2 is "am I going to end up running
=> bscan to restore my data?"
Yes. Maybe.
Do you run a backup catalog job?
if not...then RTFM for "bscan"
Where there any successful backups between the last catalog backup and the
"oops"?
If not, then think about dropping and restoring the backup catalog,
then overwrite the volume manually (ie., "dd if=/dev/zero of=/dev/tape")
and purge the volme from the database
If so...then RTFM for "bscan", but it may not be that bad...you can
still drop & restore the catalog, then run bscan to recover data from
the missing jobs--if they are significantly smaller than the 300GB
job from srv01, this may be an advantage
Do you keep the Bacula sql database dumps on-disk or remove them when the
backup catalog job is complete?
If the sql dump file is on disk...then it's all easy.
If not, then restore the dump file...
Note: these are rough ideas, off the top of my head. If Kern, Arno, or anyone
else has any suggestions, please listen to them!
Good luck,
Mark
=>
=> -- D
----
Mark Bergman [EMAIL PROTECTED]
System Administrator
Section of Biomedical Image Analysis 215-662-7310
Department of Radiology, University of Pennsylvania
http://pgpkeys.pca.dfn.de:11371/pks/lookup?search=mark.bergman%40.uphs.upenn.edu
The information contained in this e-mail message is intended only for the
personal and confidential use of the recipient(s) named above. If the reader of
this message is not the intended recipient or an agent responsible for
delivering it to the intended recipient, you are hereby notified that you have
received this document in error and that any review, dissemination,
distribution, or copying of this message is strictly prohibited. If you have
received this communication in error, please notify us immediately by e-mail,
and delete the original message.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
