As you can see below, when I update NumVols to reflect the reality from 99 to 109, NumVols value is updated by Bacula : when it starts it's put back to 99. I really don't understand why Bacula rewrites the value of NumVols and so then generates errors about already existing volume Bacula tries to create !!!
Can someone tell me what's happening here ? I'm becoming really nervous about our backups that don't occur since a week now ! le dahut wrote : > I tried but : > [EMAIL PROTECTED] bacula]# /usr/lib/bacula/sqlite/sqlite /var/bacula/bacula.db > sqlite> select * from pool; > 1|Default|99|0|0|1|1|8640000|518400|0|0|2000000000|1|1|Backup|0|ScribeVolume|1|0|0|0|0|0|0 > > sqlite> UPDATE Pool SET NumVols=109 WHERE Name='Default'; > sqlite> select * from pool; > 1|Default|109|0|0|1|1|8640000|518400|0|0|2000000000|1|1|Backup|0|ScribeVolume|1|0|0|0|0|0|0 > > (here it has been correctly changed) > [EMAIL PROTECTED] bacula]# /etc/init.d/bacula-dir start > Starting the Bacula Director: [ OK ] > > *list pool > Automatically selected Catalog: MyCatalog > Using Catalog "MyCatalog" > +--------+---------+---------+---------+----------+--------------+ > | PoolId | Name | NumVols | MaxVols | PoolType | LabelFormat | > +--------+---------+---------+---------+----------+--------------+ > | 1 | Default | 99 | 0 | Backup | ScribeVolume | > +--------+---------+---------+---------+----------+--------------+ > > > Is there a limit on NumVols when using SQLITE ? > > K. > > > > Martin Simmons a écrit : >>>>>>> On Thu, 24 May 2007 09:35:18 +0200, le dahut said: >>> Here are some additional informations : >>> >>> *list volumes >>> Pool: Default >>> ... >>> | 108 | ScribeVolume0108 | Full | 1 | 1999949066 | 0 >>> | 5184000 | 1 | 0 | 0 | File | 2007-05-06 >>> 02:01:39 | >>> | 109 | ScribeVolume0109 | Full | 1 | 1999936408 | 0 >>> | 5184000 | 1 | 0 | 0 | File | 2007-05-13 >>> 02:20:23 | >>> ... >>> >>> *list pools >>> +--------+---------+---------+---------+----------+--------------+ >>> | PoolId | Name | NumVols | MaxVols | PoolType | LabelFormat | >>> +--------+---------+---------+---------+----------+--------------+ >>> | 1 | Default | 99 | 0 | Backup | ScribeVolume | >>> +--------+---------+---------+---------+----------+--------------+ >>> >>> *show pools >>> Pool: name=Default PoolType=Backup >>> use_cat=1 use_once=0 cat_files=1 >>> max_vols=0 auto_prune=1 VolRetention=3 months 10 days >>> VolUse=6 days recycle=1 LabelFormat=ScribeVolume >>> CleaningPrefix=*None* LabelType=0 >>> RecyleOldest=1 PurgeOldest=0 MaxVolJobs=0 MaxVolFiles=0 >>> MigTime=0 secs MigHiBytes=0 MigLoBytes=0 >>> >>> >>> This night, Bacula tried again to create those volumes, why ???! >> Because the NumVols is 99 in the catalog. You could try setting this to 109 >> using an sql command such as >> >> UPDATE Pool SET NumVols=109 WHERE Name='Default'; >> >> Do you have 109 volumes or did the Pool and Media tables get out-of-sync >> somehow? >> >> __Martin >> >> >>> K. >>> >>> >>> >>> le dahut wrote : >>>> Hello, >>>> >>>> I used bacula-1.38, since I updated it to 2.0.3, it backuped 4 times ok >>>> and then it errors with : >>>> """ >>>> 23-May 15:53 127.0.0.1-dir: Client1.2007-05-23_15.32.54 Warning: Wanted >>>> to create Volume "ScribeVolume0109", but it already exists. Trying >>>> again. >>>> 23-May 15:53 127.0.0.1-dir: Client1.2007-05-23_15.32.54 Error: Too many >>>> failures. Giving up creating Volume name. >>>> """ >>>> >>>> >>>> I noticed that that the concerned volumes are not always the same. For >>>> example today bacula errors about "ScribeVolume0100" to >>>> "ScribeVolume0109" and on may 20th it errored on "ScribeVolume0090 to >>>> ScribeVolume0097". >>>> >>>> Here's part of my SD configuration : >>>> Device { >>>> Name = FileStorage >>>> Media Type = File >>>> Archive Device = /var/sauvegardes >>>> LabelMedia = yes; # lets Bacula label unlabeled media >>>> Random Access = Yes; >>>> AutomaticMount = yes; # when device opened, read it >>>> RemovableMedia = no; >>>> AlwaysOpen = no; >>>> } >>>> >>>> the DIR conf : >>>> Pool { >>>> Name = Default >>>> Pool Type = Backup >>>> Recycle = yes >>>> AutoPrune = yes >>>> Volume Retention = 100 days >>>> LabelFormat = "ScribeVolume" >>>> Recycle Oldest Volume = yes >>>> Maximum Volume Bytes = 2 gb >>>> Volume Use Duration = 6 days >>>> } >>>> >>>> >>>> liste volumes shows all the concerned volumes in database ... what's >>>> happening ? >>>> >>>> >>>> K. >>>> >>>> ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users