How much do you want to get your hands dirty with this? The catalogue is just an SQL database and the queries Bacula uses to build the lists of files are in the source code so you should be able to have a look yourself for what Bacula is pulling from the database and why it is missing your files. If you aren't friends with SQL queries then this might be a bit of a hurdle though.
You could be hitting some limit in the database, although I think those problems were solved quite a while ago for the File table at least (eg like version 3.0.0), unless you are using something like sqlite3 (I don't know what size its data types are). Can you try the following from bconsole: sqlquery SELECT * FROM File ORDER BY FileId DESC LIMIT 1; SELECT * FROM Filename ORDER BY FilenameId DESC LIMIT 1; SELECT * FROM Path ORDER BY PathId DESC LIMIT 1; You'd need to have more than 4 billion unique filenames to overflow the Filename table, so it's unlikely that this is your problem but it will only take a few seconds to check. James > -----Original Message----- > From: dobbin [mailto:bacula-fo...@backupcentral.com] > Sent: Wednesday, 6 April 2011 01:25 > To: bacula-users@lists.sourceforge.net > Subject: [Bacula-users] what do you do when bacula stops working for no > goodreason? > > backup server is Debian lenny running bacula 5.02, client is debian sarge > running bacula 1.38.11. > > The server is a web server and on the 22nd a copy was made of the main site, > if you look at the backup job for that day, you can see an extra 4000 > files. We're running daily incrementals with a full at the start of the > month. > > Then a second copy was made on the 25th but the incrementals just show a few > dozen new files. > > So we've got the original and two copies, let's call them > > www.mysite.com > copy1.mysite.com > copy2.mysite.com > > Today we went to restore copy2.mysite.com, if we select "restore most recent > backup for client" or "restore before specified time" then we get back 43 > files out of 4000. If I just pick "restore" then I get 107 files out of > 4000. This is the same if I go back a few days. > We can restore copy1.mysite.com but that's no use to us > > A file verify ran on the 26th and it shows all the files from > copy2.mysite.com but not copy1.mysite.com > > Backups ran without any errors, I've checked the alert emails. I'm trying to > run bscan on the volumes to see if that produces any different results but > I'm having trouble with the syntax. > > Does anyone have any idea where the files are and how I can stop this > happening again? My first thought was that the directories weren't copied > but symlinked, I'm assured this is not the case. > ######################### > > Check the timestamps of the files for copy2 using the stat command. Maybe > they appear to be older than the 25th, so Bacula skipped them? > > Also, are you using the mtimeonly option in the fileset? > > __Martin > > Hi Martin, thought you were on to something there as the modify time probably > would have been older, but I've been unable to reproduce this in tests, even > when the mtime was several days older. Also, copy1 backed up ok despite having > the same stats. > > I'm pretty sure we're not using mtime only, I don't see it anywhere in the > config > > James - You're right, this is an ancient version of bacula, unfortunately we > have more than a few servers running it :/ I don't think it's anything to do > with DST, the backups didn't run until about 12 hours after the file changes > and the DST change didn't happen until two days later > > +---------------------------------------------------------------------- > |This was sent by tibus.supp...@gmail.com via Backup Central. > |Forward SPAM to ab...@backupcentral.com. > +---------------------------------------------------------------------- > > > > ------------------------------------------------------------------------ ------ > Xperia(TM) PLAY > It's a major breakthrough. An authentic gaming > smartphone on the nation's most reliable network. > And it wants your games. > http://p.sf.net/sfu/verizon-sfdev > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users ------------------------------------------------------------------------------ Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
