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 like to

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 my

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't

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 Brown wrote:

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

2006-09-20 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 - An llist

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 it does

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. You have to

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. - A list of

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 to

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 ... I

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 for you if you want

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 can't do right now.

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 maximum volumes, which I can'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 recycling failed. I

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 to

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 should

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 might find

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 the

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,

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-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 volume

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 media where

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 try

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, 2006 at

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-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 = 1