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-forum AT backupcentral DOT com]
> Sent: Wednesday, 6 April 2011 01:25
> To: bacula-users AT lists.sourceforge DOT 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.support AT gmail DOT com via Backup Central.
> |Forward SPAM to abuse AT backupcentral DOT 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 AT lists.sourceforge DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users