Re: [Bacula-users] Purged volumes not getting used

2006-10-04 Thread novosirj
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Francisco Reyes wrote: > Ryan Novosielski writes: > >> I would like some input on the script from those that are having the >> problem. Most specifically, I'd like to know pool configs and retention >> periods. I think my setup is working OK, so I'd l

Re: [Bacula-users] Purged volumes not getting used

2006-09-23 Thread Ryan Novosielski
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jo Rhett wrote: > On Wed, Sep 20, 2006 at 10:31:33AM -0400, Ryan Novosielski wrote: >> I would like some input on the script from those that are having the >> problem. Most specifically, I'd like to know pool configs and retention >> periods. I think

Re: [Bacula-users] Purged volumes not getting used

2006-09-22 Thread Jo Rhett
> > Jo Rhett writes: > >> Sorry, Kern, but this isn't true. Recycling DOES work properly, but > >> "create a new volume" is happening earlier in the decision process > >> than the recycling. You have to hit max volumes to make recycling happen. On Wed, Sep 20, 2006 at 11:16:49AM +0100, Alan Bro

Re: [Bacula-users] Purged volumes not getting used

2006-09-22 Thread Jo Rhett
On Wed, Sep 20, 2006 at 10:31:33AM -0400, Ryan Novosielski wrote: > I would like some input on the script from those that are having the > problem. Most specifically, I'd like to know pool configs and retention > periods. I think my setup is working OK, so I'd like to see what might not. It doesn

Re: [Bacula-users] Purged volumes not getting used

2006-09-20 Thread Ryan Novosielski
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kern Sibbald wrote: > On Wednesday 20 September 2006 00:29, Francisco Reyes wrote: >> Kern Sibbald writes: >> >>> - Your version of Bacula >>> - What database (MySQL, ...) you are using and its version. I see you > mention >>> that it is PostgreSQL.

Re: [Bacula-users] Purged volumes not getting used

2006-09-20 Thread Kern Sibbald
On Wednesday 20 September 2006 12:16, Alan Brown wrote: > On Tue, 19 Sep 2006, Francisco Reyes wrote: > > > Jo Rhett writes: > > > >> Sorry, Kern, but this isn't true. Recycling DOES work properly, but > >> "create a new volume" is happening earlier in the decision process > >> than the recycling

Re: [Bacula-users] Purged volumes not getting used

2006-09-20 Thread Alan Brown
On Tue, 19 Sep 2006, Francisco Reyes wrote: > Jo Rhett writes: > >> Sorry, Kern, but this isn't true. Recycling DOES work properly, but >> "create a new volume" is happening earlier in the decision process >> than the recycling. You have to hit max volumes to make recycling happen. > > Sometimes

Re: [Bacula-users] Purged volumes not getting used

2006-09-19 Thread Kern Sibbald
On Wednesday 20 September 2006 00:29, Francisco Reyes wrote: > Kern Sibbald writes: > > > - Your version of Bacula > > - What database (MySQL, ...) you are using and its version. I see you mention > > that it is PostgreSQL. > > - A list of all the volumes in the pool. > > - An "llist pool=xxx" >

Re: [Bacula-users] Purged volumes not getting used

2006-09-19 Thread Francisco Reyes
Kern Sibbald writes: > - Your version of Bacula > - What database (MySQL, ...) you are using and its version. I see you mention > that it is PostgreSQL. > - A list of all the volumes in the pool. > - An "llist pool=xxx" > - An "llist volume=yyy" where you pick one representative volume, which >

Re: [Bacula-users] Purged volumes not getting used

2006-09-19 Thread Francisco Reyes
Jo Rhett writes: > Sorry, Kern, but this isn't true. Recycling DOES work properly, but > "create a new volume" is happening earlier in the decision process > than the recycling. You have to hit max volumes to make recycling happen. Sometimes it does happen. Just not every time. :-( I am going t

Re: [Bacula-users] Purged volumes not getting used

2006-09-19 Thread Dan Langille
On 19 Sep 2006 at 12:02, Ryan Novosielski wrote: > Dan Langille wrote: > > On 19 Sep 2006 at 10:02, Ryan Novosielski wrote: > > > >> Kern Sibbald wrote: > >>> On Tuesday 19 September 2006 15:50, Ryan Novosielski wrote: > Jo Rhett wrote: > > >> - The complete output of a job where re

Re: [Bacula-users] Purged volumes not getting used

2006-09-19 Thread Ryan Novosielski
Dan Langille wrote: > On 19 Sep 2006 at 10:02, Ryan Novosielski wrote: > >> Kern Sibbald wrote: >>> On Tuesday 19 September 2006 15:50, Ryan Novosielski wrote: Jo Rhett wrote: >> - The complete output of a job where recycling failed. > > I can't do this without increasing m

Re: [Bacula-users] Purged volumes not getting used

2006-09-19 Thread Dan Langille
On 19 Sep 2006 at 10:02, Ryan Novosielski wrote: > Kern Sibbald wrote: > > On Tuesday 19 September 2006 15:50, Ryan Novosielski wrote: > >> Jo Rhett wrote: > >> > - The complete output of a job where recycling failed. > >>> > >>> I can't do this without increasing maximum volumes, which I c

Re: [Bacula-users] Purged volumes not getting used

2006-09-19 Thread Ryan Novosielski
Kern Sibbald wrote: > On Tuesday 19 September 2006 15:50, Ryan Novosielski wrote: >> Jo Rhett wrote: >> - The complete output of a job where recycling failed. >>> >>> I can't do this without increasing maximum volumes, which I can't do right >>> now. But I could set up a test environment fo

Re: [Bacula-users] Purged volumes not getting used

2006-09-19 Thread Kern Sibbald
On Tuesday 19 September 2006 15:50, Ryan Novosielski wrote: > Jo Rhett wrote: > > >> - The complete output of a job where recycling failed. > > > > I can't do this without increasing maximum volumes, which I can't do right > > now. But I could set up a test environment for you if you want ... >

Re: [Bacula-users] Purged volumes not getting used

2006-09-19 Thread Ryan Novosielski
Jo Rhett wrote: >> - The complete output of a job where recycling failed. > > I can't do this without increasing maximum volumes, which I can't do right > now. But I could set up a test environment for you if you want ... I already have one running 1.39.22 if testing would be helpful. I'll try

Re: [Bacula-users] Purged volumes not getting used

2006-09-18 Thread Jo Rhett
On Mon, Sep 18, 2006 at 09:13:51AM +0200, Kern Sibbald wrote: > - Your version of Bacula 1.38.5 > - What database (MySQL, ...) you are using and its version. I see you mention > that it is PostgreSQL. mysql-4.1.20 > - A list of all the volumes in the pool. *list volumes Pool: clients_Pool +--

Re: [Bacula-users] Purged volumes not getting used

2006-09-18 Thread Jo Rhett
On Sun, Sep 17, 2006 at 10:21:38PM +0200, Kern Sibbald wrote: > The algorithm is very clearly described in the manual at: > http:/www.bacula.org/dev-manual/Automatic_Volume_Recycling.html#SECTION000243000 This is the description, * If the request is for an Autochanger device, lo

Re: [Bacula-users] Purged volumes not getting used

2006-09-18 Thread Francisco Reyes
Martin Simmons writes: > With some versions of PostgreSQL, you might find it useful to reindex all the > file table indexes regularly too, i.e. > > file_filenameid_idx > file_jobid_idx > file_jpfid_idx > file_pathid_idx > file_pkey Will give that a try, but I thought reindexing was not needed on

Re: [Bacula-users] Purged volumes not getting used

2006-09-18 Thread Martin Simmons
> On Sun, 17 Sep 2006 20:27:37 -0400, Francisco Reyes said: > > My postgresql DB for bacula is 30GB with daily vacuum analyze and > autovacuum.. have lots of small files.. and have not even finished adding > all our servers to be managed by Bacula. With some versions of PostgreSQL, you migh

Re: [Bacula-users] Purged volumes not getting used

2006-09-18 Thread Kern Sibbald
On Monday 18 September 2006 02:27, Francisco Reyes wrote: > Kern Sibbald writes: > > > The algorithm is very clearly described in the manual at: > > http:/www.bacula.org/dev-manual/Automatic_Volume_Recycling.html#SECTION000243000 > > In that url I see: > Try recycling any purged Volu

Re: [Bacula-users] Purged volumes not getting used

2006-09-17 Thread Francisco Reyes
Kern Sibbald writes: > The algorithm is very clearly described in the manual at: > http:/www.bacula.org/dev-manual/Automatic_Volume_Recycling.html#SECTION000243000 In that url I see: Try recycling any purged Volumes Does this meet the criteria? recycle = 1 Difference of current time

Re: [Bacula-users] Purged volumes not getting used

2006-09-17 Thread Kern Sibbald
On Sunday 17 September 2006 21:02, Jo Rhett wrote: > > Bruno Savioli writes: > > > If I am not mistaken, you need to have a "Maximum Volumes" in your Pool > > > directives. Bacula first tries a new volume, if there isn't one, it will > > > look for the purged ones to recycle. > > On Sun, Sep 17,

Re: [Bacula-users] Purged volumes not getting used

2006-09-17 Thread Jo Rhett
> Bruno Savioli writes: > > If I am not mistaken, you need to have a "Maximum Volumes" in your Pool > > directives. Bacula first tries a new volume, if there isn't one, it will > > look for the purged ones to recycle. On Sun, Sep 17, 2006 at 01:22:08PM -0400, Francisco Reyes wrote: > Will have to

Re: [Bacula-users] Purged volumes not getting used

2006-09-17 Thread Francisco Reyes
Francisco Reyes writes: > Francisco Reyes writes: > >> Using Bacula 1.38.11 in FreeBSD 6.1 >> Using disk volumes. >> >> I have a pool with a large set of Purged volumes, yet Bacula continues to >> make new volumes in the pool. > > Better queries. > > To get count. > > select count(*) > from

Re: [Bacula-users] Purged volumes not getting used

2006-09-17 Thread Francisco Reyes
Bruno Savioli writes: > If I am not mistaken, you need to have a "Maximum Volumes" in your Pool > directives. Bacula first tries a new volume, if there isn't one, it will > look for the purged ones to recycle. Will have to try that, but I thought the behavior was supposed to be: 1- See if any vol

Re: [Bacula-users] Purged volumes not getting used

2006-09-16 Thread Francisco Reyes
Francisco Reyes writes: > Using Bacula 1.38.11 in FreeBSD 6.1 > Using disk volumes. > > I have a pool with a large set of Purged volumes, yet Bacula continues to > make new volumes in the pool. Better queries. To get count. select count(*) from media where volstatus = 'Purged' and recycle =