On Tuesday 08 January 2008 20:15, Martin Simmons wrote: > >>>>> On Sat, 5 Jan 2008 16:48:23 +0200, Silver Salonen said: > > > > On Friday 28 December 2007, Silver Salonen wrote: > > > On Tuesday 06 March 2007 22:01, Paul England wrote: > > > > Hi there, > > > > > > > > Yesterday I run bscan to update my bacula catalog database, > > > > > > > > The reason I did this was due to a configuration error on my behalf, > > > > even though my pool was set to 'AutoPrune = no', 'Volume Retention = > > > > 99y' and 'Recycle = no'... the client directive was set to 'AutoPrune = > > > > yes' and 'File Retention = 60d'. > > > > > > > > Because of this it seems that Bacula was pruning files from this job, > > > > when I went to restore files it wouldn't only show me about 10% of them. > > > > > > > > So I tried using bscan with the following parameters... > > > > > > > > bscan -s -m -c bacula-sd.conf -v -V Archive-1\|Archive-2\|Archive-3\| > > > > Archive-4\|Archive-5\|Archive-6\|Archive-7\|Archive-8 /dev/nst0 > > > > > > > > It took more than a day but after wards it said it had added 255000 > > > > records to my database (which sounds about right). > > > > > > > > Now it just doesn't want to work, when I try to restore it tells me that > > > > there is no full backup available. > > > > > > > > Any ideas? > > > > > > Any answers on this? I run Bacula 2.2.6 dir and sd on FreeBSD-6.3 and want > > to > > > restore some files from an old volume via bconsole, but there seem to be > > > something missing in database. > > > > > > I tested with SQL-queries taken from Bat: > > > ===== > > > SELECT DISTINCT Job.Jobid AS Id, Job.Name AS JobName, Client.Name AS > > Client, > > > Job.Starttime AS JobStart, Job.Type AS JobType, Job.Level AS BackupLevel, > > > Job.Jobfiles AS FileCount, Job.JobBytes AS Bytes, Job.JobStatus AS Status, > > > Status.JobStatusLong AS StatusLong, Job.PurgedFiles AS Purged, > > > FileSet.FileSet FROM Job JOIN Client ON (Client.ClientId=Job.ClientId) JOIN > > > Status ON (Job.JobStatus=Status.JobStatus) LEFT OUTER JOIN FileSet ON > > > (FileSet.FileSetId=Job.FileSetId) LEFT OUTER JOIN JobMedia ON > > > (JobMedia.JobId=Job.JobId) LEFT OUTER JOIN Media ON > > > (JobMedia.MediaId=Media.MediaId) WHERE > > > Media.VolumeName='ultrasoft-s2-full-0001' ORDER BY Job.Starttime DESC, > > > Job.JobId DESC > > > ===== > > > > > > This returned empty set, so I guess bscan isn't updating all the necessary > > > tables? > > > > > > bscan output: > > > ===== > > > # bscan -c /usr/local/etc/bacula-sd.conf -v -V ultrasoft-s2-full-0001 -h > > > localhost -P baculapasswd m -s /backup/bacula/ultrasoft-s2 > > > bscan: butil.c:282 Using device: "/backup/bacula/ultrasoft-s2" for reading. > > > 19-Dec 10:20 bscan JobId 0: Ready to read from > > volume "ultrasoft-s2-full-0001" > > > on device "device-ultrasoft-s2" (/backup/bacula/ultrasoft-s2). > > > bscan: bscan.c:288 Using Database: bacula, User: bacula > > > bscan: bscan.c:431 Pool record for pool-ultrasoft-s2-full found in DB. > > > bscan: bscan.c:445 Pool type "Backup" is OK. > > > bscan: bscan.c:455 Media record for ultrasoft-s2-full-0001 found in DB. > > > bscan: bscan.c:473 Media type "files-varukas" is OK. > > > bscan: bscan.c:483 VOL_LABEL: OK for Volume: ultrasoft-s2-full-0001 > > > bscan: bscan.c:501 SOS_LABEL: Found Job record for JobId: 7796 > > > bscan: bscan.c:683 32,768 file records. At file:blk=1:104,701 > > > bytes=6,750,689,534 > > > bscan: bscan.c:683 65,536 file records. At file:blk=1:106,565 > > > bytes=6,870,863,970 > > > bscan: bscan.c:683 98,304 file records. At file:blk=1:108,570 > > > bytes=7,000,108,099 > > > bscan: bscan.c:683 131,072 file records. At file:blk=2:144,874 > > > bytes=9,340,856,777 > > > bscan: bscan.c:683 163,840 file records. At file:blk=2:176,914 > > > bytes=11,406,665,320 > > > bscan: bscan.c:683 196,608 file records. At file:blk=2:194,509 > > > bytes=12,541,106,404 > > > bscan: bscan.c:995 Fileset "ultrasoft-s2" already exists. > > > bscan: bscan.c:1116 Updated Job termination record for JobId=7796 Level=Full > > > TermStat=T > > > bscan: bscan.c:1205 Created JobMedia record JobId 7796, MediaId 1376 > > > 19-Dec 10:34 bscan JobId 0: End of file 3 on device "device-ultrasoft-s2" > > > (/backup/bacula/ultrasoft-s2), Volume "ultrasoft-s2-full-0001" > > > 19-Dec 10:34 bscan JobId 0: End of Volume at file 3 on > > > device "device-ultrasoft-s2" (/backup/bacula/ultrasoft-s2), > > > Volume "ultrasoft-s2-full-0001" > > > bscan: bscan.c:318-0 ========== JobId=0 ======== > > > bscan: bscan.c:937 Updated Media record at end of Volume: > > > ultrasoft-s2-full-0001 > > > 19-Dec 10:34 bscan JobId 0: End of all volumes. > > > bscan: bscan.c:937 Updated Media record at end of Volume: > > > ultrasoft-s2-full-0001 > > > bscan: bscan.c:632 End of all Volumes. VolFiles=3 VolBlocks=0 > > > VolBytes=13,013,043,636 > > > Records added or updated in the catalog: > > > 1 Media > > > 1 Pool > > > 1 Job > > > 204810 File > > > ===== > > > > > > -- > > > Silver > > > > Hmm, no bscan experts? :) > > The bscan output looks OK to me. Maybe Bacula has pruned the volume again? > > If not, then I think you'll have to simplify the query to see why it doesn't > work. In particular > > - the Job table should contain the job > > - the JobMedia table should contain records for that job > > __Martin
Hi! I just queried MySQL for JobId 7796 and there's an entry for it in table 'Job' as well as 20 entries in table 'JobMedia'. The job doesn't still show up in Bat's JobList, so I still can't restore it :( -- Silver ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
