On Четверг 05 февраля 2009, you wrote:
> >>>>> On Thu, 5 Feb 2009 12:21:31 +0300, Vladimir Vassiliev said:
> > 
> > I did a couple of tests with empty files: in job with 1,001,002 files it's
> > possible to select them but with 1,202,203 - is not.
> 
> Possibly the transaction and/or temporary tables used to insert the records is
> too large?  I suggest checking your database logs.

Thanks for suggestion.
I use Postgresql and have 

2009-02-05 14:29:57 MSK 18899  LOG:  checkpoints are occurring too frequently 
(3 seconds apart)
2009-02-05 14:29:57 MSK 18899  HINT:  Consider increasing the configuration 
parameter "checkpoint_segments".

in log. 
I'm not very experienced in Postgresql. Could this be the cause of the issue?
 
> __Martin
> 
> > 
> > > Hello,
> > > 
> > > In fact I don't have the solution for your problem as I am looking for
> > > it too ;)
> > > As far as I can see, your job has a lot of files (> 1 million). I have
> > > the same problem for a job with 1.3 million files. It seems that bacula
> > > doesn't write the file entries in the catalog (in the "files" table) for
> > > big jobs like that.
> > > The result is that you can't select individual files when restoring, you
> > > can just restore the whole job. Incremental job for this fileset is
> > > working ok and the files are present in catalog. That's why I think this
> > > is related with jobs with a lot of files.
> > > 
> > > I'm using Bacula 2.4.4 on Debian Etch (from backport.org) with
> > > PostgreSQL as backend for the catalog.
> > > 
> > > If someone has information on this problem...
> > > 
> > > Regards,
> > 
> > 
> > 
> > -- 
> > Vladimir Vassiliev <vova AT edu.yar DOT ru>
> 



-- 
Vladimir Vassiliev <vova AT edu.yar DOT ru>

------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users