On Monday 26 September 2005 14:41, Anthony Dodson wrote: > What does the NumVols field represent?
The number of volumes in the Pool. > What are the implications of it > being incorrect? Sorry, I have no idea without doing a lot of research. > How can I determine what it should be? Count the number of volumes actually in the Pool. The list can help you with that if you don't know how -- probably SQL: "select count(*) from Pool;" NumVols is no longer used (though it is still set) in version 1.37.x > > Thanks, > Anthony > > > -----Original Message----- > From: Kern Sibbald [mailto:[EMAIL PROTECTED] > Sent: Friday, September 23, 2005 11:35 AM > To: bacula-users@lists.sourceforge.net > Cc: Graham David Purcocks M.A.(Oxon.); Anthony Dodson > Subject: Re: [Bacula-users] ERROR: integer out of range > > On Friday 23 September 2005 16:35, Graham David Purcocks M.A.(Oxon.) wrote: > > Isn't it the NumVols field? this is bigger than an int32. > > > > Question is why would NumVols be that big? > > It looks like Bacula decremented it when it was already zero, giving -1 or > a very large positive number depending on how the binary bits are > interpreted/edited. > > > On Fri, 2005-09-23 at 15:15, Anthony Dodson wrote: > > > Hello all: > > > > > > I had an installation running 1.34 for a long time using a PostgreSQL > > > database. I recently upgraded to 1.36. Backups seem to be working > > > fine. I have a multi-drive autochanger, and have been using pools to > > > keep the tapes and drives separated. Often I need to move purged tapes > > > from one pool to the other depending on what I have available in the > > > changer. > > > > > > I think this is the first time I have done this since the upgrade. > > > When I move a tape from one pool to the other, I get this error. > > > > > > ################## > > > Select parameter to modify (1-14): 11 > > > Current Pool is: 2tape > > > Enter new Pool name: 0tape > > > New Pool is: 0tape > > > sql_update.c:246 update UPDATE Pool SET > > > NumVols=4294967295,MaxVols=0,UseOnce=0,UseCatalog=1,AcceptAnyVolume=1,V > > >ol > > > Retention='31536000',VolUseDuration='0',MaxVolJobs=0,MaxVolFiles=0,MaxV > > >olB ytes=0,Recycle=1,AutoPrune=1,LabelFormat='*' WHERE PoolId=3 failed: > > > ERROR: integer out of range > > > > > > ################## > > > > > > The volume appears to have moved. It is now listed in the new pool. I > > > am concerned about what this error might indicate. I did find an old > > > bug report with a similar error posted here: > > > http://article.gmane.org/gmane.comp.bacula.user/4938 > > > > > > It's probably not related, but I do also use File media on this system. > > > I checked, and none of the File volumes are larger than 1.5GB. > > > > > > > > > Thank you, > > > > > > Anthony Dodson > > > > > > IMPORTANT WARNING: > > > This e-mail is intended for the use of the person to whom it is > > > addressed and may contain information that is privileged and > > > confidential, the disclosure of which is governed by applicable law. > > > Dissemination, distribution or copying of this information in an > > > unauthorized manner is strictly prohibited. Sender accepts no liability > > > for any damage caused by any virus transmitted by this e-mail. If you > > > receive this in error, please notify the sender. > > > ======================================================================= > > >== ===== > > > > > > > > > > > > ------------------------------------------------------- > > > SF.Net email is sponsored by: > > > Tame your development challenges with Apache's Geronimo App Server. > > > Download it for free - -and be entered to win a 42" plasma tv or your > > > very own Sony(tm)PSP. Click here to play: > > > http://sourceforge.net/geronimo.php > > > _______________________________________________ > > > Bacula-users mailing list > > > Bacula-users@lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/bacula-users -- Best regards, Kern ("> /\ V_V ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
