Try putting the attached file in your scripts directory, then do in
bconsole:
query
16
(jobid)
/uno/notesdata/ravarino/
mmonesi.nsf
(jobid)
(jobid)
(jobid)
where you replace (jobid) with the jobid of the backup
job where /uno/notesdata/ravarino/mmonesi.nsf was saved
Then send me the output. That will tell us where mmonesi.nsf was
on the backup.
On Monday 28 November 2005 16:00, Ferdinando Pasqualetti wrote:
> Hello list,
>
> sorry I sent the original message with a wrong sender address, it is here
> anyway. Again I was impressed by the restore performance during a massive
> restore. Trying to restore single files it seemed to me that positioning
> performance in disk files was less efficient than using tapes. Doing
> "status storage=.." during the restore it seems that positioning in the
> volume is done by subsequent readings of data blocks, while on a tape this
> is done by skip-files and or skip blocks. This could be kept unimportant
> using small volume size (I remember a Kern advice about that), but I would
> like to keep disk volume sizes in a 1:1 ratio with tape ones, in order to
> move them if necessary. I know that on a disk file you cannot write EOF, as
> on tapes, and probably disk media are considered tapes that cannot skip
> files or blocks, but tapes anyway, so they cannot fseek, but a
> consideration about this behavior I think should be done.
>
> Regards,
>
> --------------------------------------------------------------------------
> Ferdinando Pasqualetti
> G.T.Dati srl
> Tel. 0557310862 - 3356172731 - Fax 055720143
>
> [EMAIL PROTECTED] wrote on 28/11/2005 11.21.42:
> > Hello list,
> > this is to show the (for me) impressive throughput in restoring
> > files. Client and server are two HP Proliant G3 with 3 Gb RAM and
> > mirrored SCSI disks, connected with a gigabit link.
> > There is a problem in restoring one file (I think it is the last
> > one), which resulted truncated. I tried to repeat the restore for
> > that file only, but I got the same problem.
> > Happy backup and restore to everybody and many thanks to people
> > providing this exceptional tool.
> >
> >
> > 26-Nov 12:31 domino2: RestoreFiles.2005-11-26_11.00.27 Error:
> > attribs.c:339 File size of restored file
> > /uno/notesdata/ravarino/mmonesi.nsf not correct. Original
> > 1132986368, restored 715489280.
> > 26-Nov 12:31 bacula-sd: End of all volumes.
> > 26-Nov 12:31 bacula-dir: RestoreFiles.2005-11-26_11.00.27 Error:
> > Bacula 1.36.3 (22Apr05): 26-Nov-2005 12:31:04
> > JobId: 3060
> > Job: RestoreFiles.2005-11-26_11.00.27
> > Client: domino2
> > Start time: 26-Nov-2005 11:00:29
> > End time: 26-Nov-2005 12:31:04
> > Files Expected: 8,510
> > Files Restored: 8,510
> > Bytes Restored: 255,108,659,471
> > Rate: 46938.1 KB/s
> > FD Errors: 2
> > FD termination status: Error
> > SD termination status: OK
> > Termination: *** Restore Error ***
> >
> > Ferdinando Pasqualetti
> > ------------------------------------------------------- This SF.net
> > email is sponsored by: Splunk Inc. Do you grep through log files for
> > problems? Stop! Download the new AJAX search engine that makes
> > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
> > http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> > _______________________________________________ Bacula-users mailing
> > list Bacula-users@lists.sourceforge.net https://lists.sourceforge.
> > net/lists/listinfo/bacula-users
> > ------------------------------------------------------- This SF.net
> > email is sponsored by: Splunk Inc. Do you grep through log files for
> > problems? Stop! Download the new AJAX search engine that makes searching
> > your log files as easy as surfing the web. DOWNLOAD SPLUNK!
> > http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> > _______________________________________________ Bacula-users mailing
> > list Bacula-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Best regards,
Kern
(">
/\
V_V
:List Job totals:
SELECT count(*) AS Jobs,sum(JobFiles) AS Files,
sum(JobBytes) AS Bytes,Name AS Job
FROM Job
GROUP BY Name;
SELECT max(JobId) AS Jobs,sum(JobFiles) AS Files,sum(JobBytes) As Bytes
FROM Job;
# 2
:List up to 20 places where a File is saved regardless of the directory:
*Enter Filename (no path):
SELECT DISTINCT Job.JobId as JobId, Client.Name as Client,
Path.Path,Filename.Name,StartTime,Level,JobFiles,JobBytes
FROM Client,Job,File,Filename,Path WHERE Client.ClientId=Job.ClientId
AND JobStatus='T' AND Job.JobId=File.JobId
AND Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId
AND Filename.Name='%1'
ORDER BY Job.StartTime LIMIT 20;
# 3
:List where the most recent copies of a file are saved:
*Enter path with trailing slash:
*Enter filename:
*Enter Client name:
SELECT DISTINCT Job.JobId,StartTime AS JobStartTime,VolumeName,Client.Name AS
ClientName
FROM Job,File,Path,Filename,Media,JobMedia,Client
WHERE File.JobId=Job.JobId
AND Path.Path='%1'
AND Filename.Name='%2'
AND Client.Name='%3'
AND Path.PathId=File.PathId
AND Filename.FilenameId=File.FilenameId
AND JobMedia.JobId=Job.JobId
AND JobMedia.MediaId=Media.MediaId
AND Client.ClientId=Job.ClientId
ORDER BY Job.StartTime DESC LIMIT 5;
# 4
:List last 20 Full Backups for a Client:
*Enter Client name:
SELECT DISTINCT Job.JobId,Client.Name AS Client,StartTime,JobFiles,JobBytes,
JobMedia.StartFile as VolFile,VolumeName
FROM Client,Job,JobMedia,Media
WHERE Client.Name='%1'
AND Client.ClientId=Job.ClientId
AND Level='F' AND JobStatus='T'
AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
ORDER BY Job.StartTime DESC LIMIT 20;
# 5
:List all backups for a Client after a specified time
*Enter Client Name:
*Enter time in YYYY-MM-DD HH:MM:SS format:
SELECT DISTINCT Job.JobId,Client.Name as
Client,Level,StartTime,JobFiles,JobBytes,VolumeName
FROM Client,Job,JobMedia,Media
WHERE Client.Name='%1'
AND Client.ClientId=Job.ClientId
AND JobStatus='T'
AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
AND Job.StartTime >= '%2'
ORDER BY Job.StartTime;
# 6
:List all backups for a Client
*Enter Client Name:
SELECT DISTINCT Job.JobId as JobId,Client.Name as Client,
FileSet.FileSet AS FileSet,Level,StartTime,
JobFiles,JobBytes,VolumeName
FROM Client,Job,JobMedia,Media,FileSet
WHERE Client.Name='%1'
AND Client.ClientId=Job.ClientId
AND JobStatus='T' AND Job.FileSetId=FileSet.FileSetId
AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
ORDER BY Job.StartTime;
# 7
:List Volume Attributes for a selected Volume:
*Enter Volume name:
SELECT Slot,MaxVolBytes,VolCapacityBytes,VolStatus,Recycle,VolRetention,
VolUseDuration,MaxVolJobs,MaxVolFiles
FROM Media
WHERE VolumeName='%1';
# 8
:List Volumes used by selected JobId:
*Enter JobId:
SELECT DISTINCT Job.JobId,VolumeName
FROM Job,JobMedia,Media
WHERE Job.JobId=%1
AND Job.JobId=JobMedia.JobId
AND JobMedia.MediaId=Media.MediaId;
# 9
:List Volumes to Restore All Files:
*Enter Client Name:
!DROP TABLE temp;
!DROP TABLE temp2;
CREATE TABLE temp (JobId BIGINT NOT NULL,
JobTDate BIGINT,
ClientId BIGINT,
Level CHAR,
StartTime TEXT,
VolumeName TEXT,
StartFile BIGINT,
VolSessionId BIGINT,
VolSessionTime BIGINT );
CREATE TABLE temp2 (JobId BIGINT NOT NULL,
StartTime TEXT,
VolumeName TEXT,
Level CHAR,
StartFile BIGINT,
VolSessionId BIGINT,
VolSessionTime BIGINT);
# Select last Full save
INSERT INTO temp SELECT Job.JobId,JobTDate,Job.ClientId,Job.Level,
StartTime,VolumeName,JobMedia.StartFile,VolSessionId,VolSessionTime
FROM Client,Job,JobMedia,Media WHERE Client.Name='%1'
AND Client.ClientId=Job.ClientId
AND Level='F' AND JobStatus='T'
AND JobMedia.JobId=Job.JobId
AND JobMedia.MediaId=Media.MediaId
ORDER BY Job.JobTDate DESC LIMIT 1;
# Copy into temp 2 getting all volumes of Full save
INSERT INTO temp2 SELECT Job.JobId,Job.StartTime,Media.VolumeName,Job.Level,
JobMedia.StartFile,Job.VolSessionId,Job.VolSessionTime
FROM temp,Job,JobMedia,Media WHERE temp.JobId=Job.JobId
AND Job.Level='F' AND Job.JobStatus='T'
AND JobMedia.JobId=Job.JobId
AND JobMedia.MediaId=Media.MediaId;
# Now add subsequent incrementals
INSERT INTO temp2 SELECT DISTINCT Job.JobId,Job.StartTime,Media.VolumeName,
Job.Level,JobMedia.StartFile,Job.VolSessionId,Job.VolSessionTime
FROM Job,temp,JobMedia,Media
WHERE Job.JobTDate>temp.JobTDate
AND Job.ClientId=temp.ClientId
AND Job.Level IN ('I','D') AND JobStatus='T'
AND JobMedia.JobId=Job.JobId
AND JobMedia.MediaId=Media.MediaId;
# list results
SELECT DISTINCT VolumeName from temp2;
!DROP TABLE temp;
!DROP TABLE temp2;
# 10
:List Pool Attributes for a selected Pool:
*Enter Pool name:
SELECT Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes
FROM Pool
WHERE Name='%1';
# 11
:List total files/bytes by Job:
SELECT count(*) AS Jobs,sum(JobFiles) AS Files,sum(JobBytes) AS Bytes,Name AS
Job
FROM Job GROUP by Name;
# 12
:List total files/bytes by Volume:
SELECT count(*) AS Jobs,sum(JobFiles) AS Files,sum(JobBytes) AS Bytes,VolumeName
FROM Job,JobMedia,Media
WHERE JobMedia.JobId=Job.JobId
AND JobMedia.MediaId=Media.MediaId
GROUP by VolumeName;
# 13
:List Files for a selected JobId:
*Enter JobId:
SELECT Path.Path,Filename.Name FROM File,Filename,Path WHERE File.JobId=%1
AND Filename.FilenameId=File.FilenameId
AND Path.PathId=File.PathId ORDER BY
Path.Path,Filename.Name;
# 14
:List Jobs stored in a selected MediaId:
*Enter MediaId:
SELECT DISTINCT Job.JobId,Job.Name,Job.StartTime,Job.Type,
Job.Level,Job.JobFiles,Job.JobBytes,Job.JobStatus
FROM JobMedia,Job
WHERE JobMedia.JobId=Job.JobId
AND JobMedia.MediaId=%1
ORDER by Job.StartTime;
# 15
:List Jobs stored for a given Volume name:
*Enter Volume name:
SELECT DISTINCT Job.JobId as JobId,Job.Name as Name,Job.StartTime as StartTime,
Job.Type as Type,Job.Level as Level,Job.JobFiles as Files,
Job.JobBytes as Bytes,Job.JobStatus as Status
FROM Media,JobMedia,Job
WHERE Media.VolumeName='%1'
AND Media.MediaId=JobMedia.MediaId
AND JobMedia.JobId=Job.JobId
ORDER by Job.StartTime;
# 16
:List File record for given Job and File
*Enter JobId:
*Enter Full path (no filename) with trailing slash:
*Enter Filename:
SELECT File.JobId AS JobId,FileIndex FROM File,Path,Filename
WHERE File.JobId=%1 AND
Path.Path='%2' AND Filename.Name='%3' AND
File.PathId=Path.PathId AND File.FilenameId=Filename.FilenameId;
SELECT JobId,Name,VolSessionId,VolsessionTime,JobFiles FROM Job WHERE JobId=%1;
SELECT JobId,MediaId,FirstIndex,LastIndex,StartFile,EndFile,StartBlock,EndBlock,
VolIndex FROM JobMedia WHERE JobId=%1;
SELECT VolumeName FROM Media,JobMedia WHERE JobMedia.JobId=%1 AND
Media.MediaId=JobMedia.MediaId;
