Hi! Is there anyone out there that has seen this problem or have any idea of what it could be?
I have rewritten all the configparts related to this job, I have copied and pasted from other configfiles that works and as you can see from earlier postings it selcts the correct files needed to do the job but then it just ignores the fullbackup and starts reading from the diffbackup and if I let it do the job it finishes happy, says that it worked fine but the size is that of a diffbackup. This problem is only for one backupjob all the others where I use VirtualFull is working great, unfortunatly this is my largest fullbackup so I would really want to make it work. /marcus -- /Marcus Hallberg Wimlet Consulting AB Gamla Varvsgatan 1 414 59 Göteborg Tel: 031-3107000 Direkt 031-3107010 e-post: mar...@wimlet.se hemsida: www.wimlet.se ----- Ursprungligt meddelande ----- Från: "Marcus Hallberg" <mar...@wimlet.se> Till: bacula-users@lists.sourceforge.net Skickat: måndag, 25 jul 2011 11:47:10 Ämne: Re: [Bacula-users] Virtual diff instead of full Hi! Thanks for the tip and sorry for the delay in feedback. I turned on logging and I have tried to sift through to find out where it goes wrong... I made a new Differential backup and I tried to make a new VirtualFull but with the same result. According to the logs it makes a query containing the four JobIds needed to complete a virtual full (42420,43284,43296,43332) SELECT Path.Path, Filename.Name, Temp.FileIndex, Temp.JobId, LStat, MD5 FROM ( SELECT FileId, Job.JobId AS JobId, FileIndex, File.PathId AS PathId, File.FilenameId AS FilenameId, LStat, MD5 FROM Job, File, ( SELECT MAX(JobTDate) AS JobTDate, PathId, FilenameId FROM ( SELECT JobTDate, PathId, FilenameId FROM File JOIN Job USING (JobId) WHERE File.JobId IN (42420,43284,43296,43332) UNION ALL SELECT JobTDate, PathId, FilenameId FROM BaseFiles JOIN File USING (FileId) JOIN Job ON (BaseJobId = Job.JobId) WHERE BaseFiles.JobId IN (42420,43284,43296,43332) ) AS tmp GROUP BY PathId, FilenameId ) AS T1 WHERE (Job.JobId IN ( SELECT DISTINCT BaseJobId FROM BaseFiles WHERE JobId IN (42420,43284,43296,43332)) OR Job.JobId IN (42420,43284,43296,43332)) AND T1.JobTDate = Job.JobTDate AND Job.JobId = File.JobId AND T1.PathId = File.PathId AND T1.FilenameId = File.FilenameId ) AS Temp JOIN Filename ON (Filename.FilenameId = Temp.FilenameId) JOIN Path ON (Path.PathId = Temp.PathId) WHERE FileIndex > 0 ORDER BY Temp.JobId, FileIndex ASC; If I query the database to make sure that this is the four jobbs needed I get the right result: mysql> select Job, Type, Level, ClientId, JobStatus from Job where JobId = 42420 or JobId = 43284 or JobId = 43296 or JobId = 43332; +--------------------------------+------+-------+----------+-----------+ | Job | Type | Level | ClientId | JobStatus | +--------------------------------+------+-------+----------+-----------+ | edstrom.2010-09-17_23.55.00_07 | B | F | 8 | T | | edstrom.2011-07-22_22.42.11_23 | B | D | 8 | T | | edstrom.2011-07-23_22.04.00_37 | B | I | 8 | T | | edstrom.2011-07-24_22.04.00_19 | B | I | 8 | T | +--------------------------------+------+-------+----------+-----------+ 4 rows in set (0.00 sec) After this I do not get another referens to the Fulljob not by JobId or by name but the Diffjob is referenced both by Id and by name. I'm not really sure where to go from here so if anyone has an Ideas I am willing to try it. /marcus -- ----- Ursprungligt meddelande ----- Från: "James Harper" <james.har...@bendigoit.com.au> Till: "Marcus Hallberg" <mar...@wimlet.se>, Bacula-users@lists.sourceforge.net Skickat: tisdag, 12 jul 2011 13:37:41 Ämne: RE: [Bacula-users] Virtual diff instead of full > Hi! > > I have problem with Virtual full on one set of backups where it does not give > me a virtual full but a virtual diff instead. > > The last fullbackup was about 125 GB and an new estimate says that a new full > would be about 200 GB. > > When I ask i to produce a new VirtualFull it starts reading from the last Diff > and gives me a virtual full file of about 50 GB wich is about the size of my > diffs. > > Does anyone have any pointers they would be greatly appressiated > If you want to get your hands dirty and like sifting through logfiles you can turn on mysql logging (assuming you are using mysql) and have a look at what queries are used to determine the volumes that make up the virtualfull. Regular bacula debug logging may help too. James ------------------------------------------------------------------------------ Storage Efficiency Calculator This modeling tool is based on patent-pending intellectual property that has been used successfully in hundreds of IBM storage optimization engage- ments, worldwide. Store less, Store more with what you own, Move data to the right place. Try It Now! http://www.accelacomm.com/jaw/sfnl/114/51427378/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users ------------------------------------------------------------------------------ uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
