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
have to drive to the colo and physically swap tapes, restart the job, and
all will be well".
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:
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.
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?"
-- D
-------------------------------------------------------------------------
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
