>>>>> On Thu, 5 Feb 2009 14:39:05 +0300, Vladimir Vassiliev said: > > 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?
This is a hint about performance problems, but I think they are just warnings so shouldn't cause it to fail. Is the Director configured to use batch insert? You could try with --enable-batch-insert or --disable-batch-insert to see if that affects it. __Martin > > > __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 <v...@edu.yar.ru> > > > > > > -- > Vladimir Vassiliev <v...@edu.yar.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
