On Thursday 07 December 2006 22:11, Benjamin Chambers wrote: > > Bacula version 1.38.9/1.38.11 with MySQL > > I would very much appreciate it if anyone could clarify an issue that has come > up while attempting to restore from a bootstrap file. > > The question is actually fundamentally quite simple...Can a BSR file be used to > perform a restore if you have the boostrap file and backup data...but have lost > the Catalog? The situation being, of course, failure of the server itself, > where Bacula runs. > > I have gone under the assumption for the last year or so that this was possible, > but with current testing over the last week, I'm starting to think this it is not.
In principle it was supposed to work without needing the catalog. It looks like at some point I wasn't thinking through all the consequences and added code to ensure that the SD updated the catalog with the read statistics, so I imagine that is what is going on. On thing that you might try is to add the Volume name(s) to the catalog by doing an add command before running the restore. The correct solution is for the SD during a restore to attempt to read the Volume data from the catalog, but instead of failing when the data is not there, it should complain and continue. > > The test is to save to a mounted file (Windows share) system. I had read in > prior posts where the MediaType must be unique or you get into some problems. I > have ensured to do this. > > Here's a short summary of test results: > > TEST 1 > ====== > 1. Perform a backup of the server > 2. Perform a 'run job=Restore' using 'mod' to specify the BSR file created > automatically in step 1. > > Result: Restore OK (the catalog still existed) > > TEST 2 > ====== > 1. Perform a backup of the server > 2. Run /drop_mysql_database, create_mysql_database, make_mysql_tables scripts > to simulate the loss of the server (Catalog). > 3. Perform a 'run job=Restore' using 'mod' to specify the BSR file created > automatically in step 1. > > Result: Restore FAILS > > I have provided some debug below. It looks as though the restore first tries to > match the VolumeName picked up from the BSR against the Catalog. Containing > no data (because the database was re-initialized between backup/restore), this > operation, of course, fails. At this point, I'm not certain what happens...if a > BSR restore with no Catalog is possible, one would think that the SD would see > if it could find the Volume specified in the BSR. I *think* this is happening, > but somewhere along the line, the VolumeName becomes nil. > > I know I can use bextract to do a successful restore in this case...but it's not > as convenient and it would be good to clear up the capabilities anyways, because > the section on "Disaster Recovery" doesn't (IMO) definitively say what I'm > trying to do is possible. > > Thanks in advance to anyone who has time and knowledge to shed some light. > > Cheers, > > Ben > > ******Job Report****** > 07-Dec 15:58 Server-sd: Restore.2006-12-07_15.58.46 Warning: acquire.c:82 Error > getting Volume info: 1997 Volume "2006-12-07-0" not in catalog. > 07-Dec 15:58 Server-sd: Restore.2006-12-07_15.58.46 Fatal error: acquire.c:109 > Read open device "_BensLaptop" (/var/bacula/mnt/file/_BensLaptop) Volume "" > failed: ERR=Could not open file device "_BensLaptop" > (/var/bacula/mnt/file/_BensLaptop). No Volume name given. > > 07-Dec 15:58 Server-dir: Restore.2006-12-07_15.58.46 Error: Bacula 1.38.11 > (28Jun06): 07-Dec-2006 15:58:50 > JobId: 1 > Job: Restore.2006-12-07_15.58.46 > Client: Server-fd > Start time: 07-Dec-2006 15:58:49 > End time: 07-Dec-2006 15:58:50 > Files Expected: 0 > Files Restored: 0 > Bytes Restored: 0 > Rate: 0.0 KB/s > FD Errors: 0 > FD termination status: OK > SD termination status: Error > Termination: *** Restore Error *** > > ******SD in DEBUG****** > Server-sd: parse_bsr.c:168 Leave parse_bsf() > Next : 0x0 > Root bsr : 0x91b72a8 > VolumeName : 2006-12-07-0 > MediaType : File-9353 > Device : > Slot : 0 > SessId : 1 > SessTime : 1165524894 > VolFile : 0-0 > VolBlock : 929920-1430482 > FileIndex : 1-468 > done : no > positioning : 1 > fast_reject : 1 > Server-sd: fd_cmds.c:135 <filed: read data 2 > Server-sd: fd_cmds.c:261 Read data: read data 2 > Server-sd: fd_cmds.c:263 <bfiled: read data 2 > Server-sd: read.c:46 Start read data. > Server-sd: parse_bsr.c:913 Added volume=2006-12-07-0 mediatype=File-9353 > Server-sd: read.c:62 Found 1 volumes names to restore. First=2006-12-07-0 > Server-sd: device.c:352 lock 0 from dev.c:697 > Server-sd: device.c:395 block set 3 from dev.c:698 > Server-sd: acquire.c:80 dir_get_volume_info > Server-sd: askdir.c:211 >dird: CatReq Job=Restore.2006-12-07_15.58.46 GetVolInfo > VolName=2006-12-07-0 write=0 > Server-sd: askdir.c:165 <dird 1997 Volume "2006-12-07-0" not in catalog. > Server-sd: askdir.c:177 Bad response from Dir fields=-1: 1997 Volume > "2006-12-07-0" not in catalog. > Server-sd: acquire.c:100 bstored: open vol= > Server-sd: dev.c:276 open dev: tape=0 dev_name="_BensLaptop" > (/var/bacula/mnt/file/_BensLaptop) vol= mode=OPEN_READ_ONLY > Server-sd: dev.c:285 call open_file_device mode=OPEN_READ_ONLY > Server-sd: acquire.c:195 Dec reserve=0 dev="_BensLaptop" > (/var/bacula/mnt/file/_BensLaptop) > Server-sd: device.c:408 unblock BST_DOING_ACQUIRE from dev.c:705 > Server-sd: acquire.c:200 jcr->dcr=(nil) > Server-sd: match_bsr.c:169 No nxt_bsr use_pos=1 repos=1 > Server-sd: device.c:352 lock 0 from acquire.c:353 > Server-sd: acquire.c:354 release_device device is disk > Server-sd: reserve.c:200 free_volume: no vol on dev "_BensLaptop" > (/var/bacula/mnt/file/_BensLaptop) > Server-sd: dev.c:1691 really close_dev "_BensLaptop" > (/var/bacula/mnt/file/_BensLaptop) > Server-sd: dvd.c:93 Enter unmount_dev > Server-sd: reserve.c:200 free_volume: no vol on dev "_BensLaptop" > (/var/bacula/mnt/file/_BensLaptop) > Server-sd: device.c:381 unlock from acquire.c:437 > Server-sd: read.c:83 Done reading. > Server-sd: dircmd.c:211 Command run requsts quit > Server-sd: mem_pool.c:363 garbage collect memory pool > > > > > > -- > Benjamin Chambers, P.Eng. > ClarkConnect Account Manager > Point Clark Networks > 1179 King Street West, Suite 211 > Toronto, ON > Canada, M6K 3C5 > > Tel: +1.416.977.0574 Ext. 111 > Fax: +1.416.946.1192 > Email: [EMAIL PROTECTED] > > ------------------------------------------------------------------------- > 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 > ------------------------------------------------------------------------- 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