Re: [Bacula-users] bacula prunes files too early

2009-03-03 Thread Jérôme Schell
Vladimir Vassiliev a écrit : > Really UTF8. > However, tests I did was with simple filenames (1,2,3,4 etc)... > Whether or no, I also converted database and will supervise. > I can confirm that this conversion solved my problem. Files are now all inserted in the database (1,4 million, approx. 20

Re: [Bacula-users] bacula prunes files too early

2009-02-09 Thread Jérôme Schell
Vladimir Vassiliev a écrit : > Really UTF8. > However, tests I did was with simple filenames (1,2,3,4 etc)... > Whether or no, I also converted database and will supervise. > I can confirm that this conversion solved my problem. Files are now all inserted in the database (1,4 million, approx. 20

Re: [Bacula-users] bacula prunes files too early

2009-02-06 Thread Vladimir Vassiliev
Really UTF8. However, tests I did was with simple filenames (1,2,3,4 etc)... Whether or no, I also converted database and will supervise. > > Hello, > > Is your PostgreSQL database encoding is SQL_ASCII ? Do you see error in > postgres log like that : > ERROR: invalid byte sequence for encodin

Re: [Bacula-users] bacula prunes files too early

2009-02-05 Thread Jérôme Schell
Vladimir Vassiliev a écrit : > 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 transacti

Re: [Bacula-users] bacula prunes files too early

2009-02-05 Thread Vladimir Vassiliev
Yes, it's with --enable-batch-insert. > 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

Re: [Bacula-users] bacula prunes files too early

2009-02-05 Thread Martin Simmons
> 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 b

Re: [Bacula-users] bacula prunes files too early

2009-02-05 Thread Vladimir Vassiliev
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 tab

Re: [Bacula-users] bacula prunes files too early

2009-02-05 Thread Martin Simmons
> 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 sugg

Re: [Bacula-users] bacula prunes files too early

2009-02-05 Thread Vladimir Vassiliev
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. > 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 hav

Re: [Bacula-users] bacula prunes files too early

2009-02-04 Thread Jérôme Schell
Vladimir Vassiliev a écrit : > All retention periods in my config are more than 30 days. But at Feb, 3 I > tried to restore some files from job dated by Feb, 2 > I select necessary job but get: > > Building directory tree for JobId 1695 ... > There were no files inserted into the tree

[Bacula-users] bacula prunes files too early

2009-02-04 Thread Vladimir Vassiliev
All retention periods in my config are more than 30 days. But at Feb, 3 I tried to restore some files from job dated by Feb, 2 I select necessary job but get: Building directory tree for JobId 1695 ... There were no files inserted into the tree, so file selection is not p