Re: [Bacula-users] Bacula 5.0.1, CentOS5.4 and BAT...not working
MoreDakka wrote: Thanks, However I'm somewhat of a newb to linux (only working with it for a couple years) and building RPMs a beyond me. If that's the case I'd recommend sticking with existing packages availible in your distro's repository. Anything else is asking for pain if you're not handy with the tools. I'd say give it a try, you can only learn ... but no, not with backup software. You don't want that to be experimental. If you really want to build your own, read the configure output to see what's missing and install appropriate development packages to provide the missing dependencies. -- Craig Ringer Tech-related writing: http://soapyfrogs.blogspot.com/ -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Warning about setting File/Job Retentions in Pool resource!
Thank you for reply. What retentions are for my task? Can Bacula give me this not so difficult functionality? Situation is next: 1) Bacula can't set Job and Files Retentions for Job resource - only for Pool and Client resources. 2) I can't define Job and Files Retentions in Client Resource, because I have 1 Client, that backups on some Pools with different Volume Retention (It will purge all jobs for all pools - I describe this problem in main question) 3) We found out that I can't define Job and Files Retentions in Pool Resource, because it applied to jobs in other Pools too. Volume, Jobs, and Files retention must be defined only for one Pool and don't applied to other pools. Or Jobs and File Retention can be not defined anywhere, but then bacula do volume purging for pool, bacula must do job and file retention for this pool. I don't uderstand: If bacula did volume retention - what reason to keep records about jobs and files from this volume in catalog Stephen Thompson wrote: For more clarity: What actually happens is that when writing to the Pool where the File/Job Retentions are specified, the retentions will apply to any File/Job's that were ALSO written to another Pool, thus overriding the Client resource regardless of Pool. On 04/26/2010 11:52 AM, Stephen Thompson wrote: My, possibly mistaken, understanding of having File/Job Retention directives in a Pool resource was to be able to deviate from File/Job Retentions set by the Client resource AND to confine those retentions to the Pool where they are specified. What actually happens is that when using the Pool where the File/Job Retentions are specified, the retentions will apply to any File/Job's that were written to another Pool, overriding the Client resource. Real life example: The Job Retention for all my clients defaults to 1 year and I have monthly full Pools that I keep for a year. I also have an incremental/differential pool that I recycle on a 60-90 day basis. When I set the File/Job Retention to 90 days for my incremental/differential Pool and ran a complete set of incrementals, the 90 day retention was then applied to all of those jobs, not just for the incremental/differential Pool where the 90 day period was set, but for all of my monthly full Pools as well! This effectively purged 9 months of my Catalog records. :( Yes, I had a backup of the Catalog and yet it took 12 hours to restore. But, please note that it can be dangerous to use File/Job retentions in a Pool resource. thanks, Stephen -- Stephen Thompson Berkeley Seismological Laboratory step...@seismo.berkeley.edu215 McCone Hall # 4760 404.538.7077 (phone) University of California, Berkeley 510.643.5811 (fax) Berkeley, CA 94720-4760 -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- View this message in context: http://old.nabble.com/Job-Retention-for-concrete-Pool-purge-jobs-in-other-pools%21-tp28362535p28374125.html Sent from the Bacula - Users mailing list archive at Nabble.com. -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] appending to a full tape?
hi all. i'm running bacula 2.4.4 in a debian/etch environment (i know that it is a bit outdated; but there is even one debian/sarge host that i cannot really update...) bacula is doing a nightly backup (full every 3 months or so, diff every week, and incr every night) onto an autochanger (Quantum SuperLoader3, btw) due to some scsi resets, 2 of my daily pool tapes have been flagged as Full even though they are virtually empty (e.g. 4% fill state). my tape pool has settled nicely, to use (almost) all tapes in the changer, and having to add a new tape just because two empty tapes are flagged as full seems to be a waste of ressources. since the tape in question are part of the incremental strategy, i'd rather not purge them. is there a way to manually force a tape to be appendable again? in bat i see that i could change the volum status to anything, even Append, but i want to make sure that this is a good idea. thanks in advance. -- IEM - network operation center mailto:n...@iem.at -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] appending to a full tape?
On Tue, Apr 27, 2010 at 10:43:44AM +0200, IEM - network operating center (IOhannes m zmoelnig) wrote: i'm running bacula 2.4.4 in a debian/etch environment (i know that it is a bit outdated; but there is even one debian/sarge host that i cannot really update...) No worries, 2.4.4 is also the one in Lenny :) And it seems to me that is about the most stable version ATM (although the Branch-5.0 GIT seems to be rapidly fixing the remaining bugs). So for this once Debian long sta(b)le policy is for the good! bacula is doing a nightly backup (full every 3 months or so, diff every week, and incr every night) onto an autochanger (Quantum SuperLoader3, btw) due to some scsi resets, 2 of my daily pool tapes have been flagged as Full even though they are virtually empty (e.g. 4% fill state). Strange, I would expect them to be marked Error (but I have not run 2.4.4 for long)... in bat i see that i could change the volum status to anything, even Append, but i want to make sure that this is a good idea. You may want to look at: http://www.bacula.org/5.0.x-manuals/en/problems/problems/Tips_Suggestions.html#SECTION0036 (or http://tinyurl.com/33jhblm if your MUA breaks the link) There may be issue with number of files written (which would lead to tape being marked as error again when bacula tries to write next job to it) -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] File volumes doesnt reach Maximun volumes
Hello,
I'm having problems backing up to files in a hard drive.
I'm using 3 pools: full, differential and incremental. All of the with:
maximum volume jobs = 1
Volume Retention = 1 month
AutoPrune = yes
Recycle = yes
MaximumVolumeJobs = 1
RecycleOldestVolume = yes
Full Pool (1st of each month): Maximum volumes = 2
Differential Pool (15th of each month):Maximum volumes = 2
Incremental Pool (not 1st or 15th): Maximun Volumes = 45
My problem is that the incremental pool does not grow above 30 volumes. As I
have read the number of volumes should be increasing till Maximum volumes limit
is reached, right?
Incremental pool:
# show pool=XXXIncremental
Pool: name=XXXIncremental PoolType=Backup
use_cat=1 use_once=0 cat_files=1
max_vols=48 auto_prune=1 VolRetention=1 month 1 day
VolUse=0 secs recycle=1
LabelFormat=${Job}_Inc_${Day:p/2/0/r}-${Month:p/2/0/r}-${Year}
CleaningPrefix=*None* LabelType=0
RecyleOldest=1 PurgeOldest=0
MaxVolJobs=1 MaxVolFiles=0 MaxVolBytes=0
MigTime=0 secs MigHiBytes=0 MigLoBytes=0
Thanks.
--
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] File volumes doesnt reach Maximun volumes
Jorge Cabello wrote:
Hello,
I'm having problems backing up to files in a hard drive.
I'm using 3 pools: full, differential and incremental. All of the
with:
maximum volume jobs = 1
Volume Retention = 1 month
AutoPrune = yes
Recycle = yes
MaximumVolumeJobs = 1
RecycleOldestVolume = yes
Full Pool (1st of each month): Maximum volumes = 2
Differential Pool (15th of each month):Maximum volumes = 2
Incremental Pool (not 1st or 15th): Maximun Volumes = 45
My problem is that the incremental pool does not grow above 30
volumes. As I
have read the number of volumes should be increasing till Maximum
volumes limit
is reached, right?
Incremental pool:
# show pool=XXXIncremental
Pool: name=XXXIncremental PoolType=Backup
use_cat=1 use_once=0 cat_files=1
max_vols=48 auto_prune=1 VolRetention=1 month 1 day
VolUse=0 secs recycle=1
LabelFormat=${Job}_Inc_${Day:p/2/0/r}-${Month:p/2/0/r}-${Year}
CleaningPrefix=*None* LabelType=0
RecyleOldest=1 PurgeOldest=0
MaxVolJobs=1 MaxVolFiles=0 MaxVolBytes=0
MigTime=0 secs MigHiBytes=0 MigLoBytes=0
Thanks.
If I read that right, you have retention set to 1 month as well, so
it will recycle after one month! Recycling happens at the first
limit reached, so 1 month happens before 45 volumes.
--
Mike Holden
http://www.by-ang.com - the place to shop
for all manner of hand crafted items,
including Jewellery, Greetings Cards and Gifts
--
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] File volumes doesnt reach Maximun volumes
Do you change some Pool parameters without update pool from bconsole?
this : max_vols=48 differs your Incremental pool config.
2010/4/27 Jorge Cabello jo...@aspl.es:
Hello,
I'm having problems backing up to files in a hard drive.
I'm using 3 pools: full, differential and incremental. All of the with:
maximum volume jobs = 1
Volume Retention = 1 month
AutoPrune = yes
Recycle = yes
MaximumVolumeJobs = 1
RecycleOldestVolume = yes
Full Pool (1st of each month): Maximum volumes = 2
Differential Pool (15th of each month):Maximum volumes = 2
Incremental Pool (not 1st or 15th): Maximun Volumes = 45
My problem is that the incremental pool does not grow above 30 volumes. As I
have read the number of volumes should be increasing till Maximum volumes
limit
is reached, right?
Incremental pool:
# show pool=XXXIncremental
Pool: name=XXXIncremental PoolType=Backup
use_cat=1 use_once=0 cat_files=1
max_vols=48 auto_prune=1 VolRetention=1 month 1 day
VolUse=0 secs recycle=1
LabelFormat=${Job}_Inc_${Day:p/2/0/r}-${Month:p/2/0/r}-${Year}
CleaningPrefix=*None* LabelType=0
RecyleOldest=1 PurgeOldest=0
MaxVolJobs=1 MaxVolFiles=0 MaxVolBytes=0
MigTime=0 secs MigHiBytes=0 MigLoBytes=0
Thanks.
--
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
_
Francisco Javier Funes Nieto [esen...@gmail.com]
CANONIGOS
Servicios Informáticos para PYMES.
Cl. Cruz 2, 1º Oficina 7
Tlf: 958.536759 / 661134556
Fax: 958.521354
GRANADA - 18002
--
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] File volumes doesnt reach Maximun volumes
On Tue, Apr 27, 2010 at 11:36:34AM +0200, Jorge Cabello wrote: I'm using 3 pools: full, differential and incremental. All of the with: Volume Retention = 1 month RecycleOldestVolume = yes Full Pool (1st of each month): Maximum volumes = 2 Differential Pool (15th of each month):Maximum volumes = 2 Incremental Pool (not 1st or 15th): Maximun Volumes = 45 My problem is that the incremental pool does not grow above 30 volumes. As I have read the number of volumes should be increasing till Maximum volumes limit is reached, right? If I'm correct, it is probably due to volume retention of 1 month - after one month, the oldest volume will be recycled. It will never go *above* 45, even if you increase retention (in that case it will stop and ask operator to insert/label new empty volumes) Note that retention does not directly influence data on tape, but just the catalog database; so you could still bscan(8) old tapes and get data back in the catalog - it is only when those volumes finally get used again that the old data will be destroyed. -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Ubuntu Lucid
Hi folks, looks like lucid comes with bacula v5 which seemingly is unable to talk to our server running bacula 2.4.x: bacula-fd -c /etc/bacula/bacula-fd.conf -d 99 -f bacula-fd: filed_conf.c:452-0 Inserting director res: lotus-mon lotus-fd: filed.c:275-0 filed: listening on port 9102 lotus-fd: cram-md5.c:73-0 send: auth cram-md5 1993776720.1272363...@lotus-fd ssl=0 lotus-fd: cram-md5.c:152-0 sending resp to challenge: XXX following that, there's a client rejected hello command message on the server. Is there any way to turn on 2.x client compatibility in a 5.0.1 client? Thanks much in advance, Uwe -- NIONEX ist ein Unternehmen der DirectGroup Germany www.directgroupgermany.de -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula Using Incr. Vol. instead of Full Vol.
On Mon, 26 Apr 2010 13:54:07 -0400, ikkysleepy said: A Full Backup was run... How did you run it? If you used then console, then you will need to set the pool manually by using mod at the OK to run? prompt. __Martin -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] File volumes doesnt reach Maximun volumes
I thought new files were created until Maximum volumes limit was reached.
I will modify the volume retention.
Thanks.
On Martes, 27 de Abril de 2010 12:04:03 Mike Holden wrote:
Jorge Cabello wrote:
Hello,
I'm having problems backing up to files in a hard drive.
I'm using 3 pools: full, differential and incremental. All of the
with:
maximum volume jobs = 1
Volume Retention = 1 month
AutoPrune = yes
Recycle = yes
MaximumVolumeJobs = 1
RecycleOldestVolume = yes
Full Pool (1st of each month): Maximum volumes = 2
Differential Pool (15th of each month):Maximum volumes = 2
Incremental Pool (not 1st or 15th): Maximun Volumes = 45
My problem is that the incremental pool does not grow above 30
volumes. As I
have read the number of volumes should be increasing till Maximum
volumes limit
is reached, right?
Incremental pool:
# show pool=XXXIncremental
Pool: name=XXXIncremental PoolType=Backup
use_cat=1 use_once=0 cat_files=1
max_vols=48 auto_prune=1 VolRetention=1 month 1 day
VolUse=0 secs recycle=1
LabelFormat=${Job}_Inc_${Day:p/2/0/r}-${Month:p/2/0/r}-${Year}
CleaningPrefix=*None* LabelType=0
RecyleOldest=1 PurgeOldest=0
MaxVolJobs=1 MaxVolFiles=0 MaxVolBytes=0
MigTime=0 secs MigHiBytes=0 MigLoBytes=0
Thanks.
If I read that right, you have retention set to 1 month as well, so
it will recycle after one month! Recycling happens at the first
limit reached, so 1 month happens before 45 volumes.
--
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] File volumes doesnt reach Maximun volumes
On Tue, Apr 27, 2010 at 12:39:58PM +0200, Jorge Cabello wrote: I thought new files were created until Maximum volumes limit was reached. They were. But the old files were at the same time deleted according to retention period, so you you maximum volume limit was never actually reached. -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Backup Catalog Error
On Mon, 26 Apr 2010 05:31:46 -0400, cuongth1981 said: Dear All I have problem with backup Catalog on bacula 5.0.1. Client use windows 2003. Error : 26-Apr 15:54 fw.giaydepviet.com-dir JobId 2: shell command: run BeforeJob /build/bacula/scripts/make_catalog_backup.pl MyCatalog 26-Apr 15:54 fw.giaydepviet.com-dir JobId 2: Start Backup JobId 2, Job=BackupCatalog.2010-04-26_15.53.11_04 26-Apr 15:54 fw.giaydepviet.com-dir JobId 2: Using Device FileStorage 26-Apr 15:54 fw.giaydepviet.com-sd JobId 2: Volume File00_26-4-2010 previously written, moving to end of data. 26-Apr 15:54 fw.giaydepviet.com-sd JobId 2: Ready to append to end of Volume File00_26-4-2010 size=106703417 26-Apr 15:55 adc00-fd JobId 2: No drive letters found for generating VSS snapshots. 26-Apr 15:55 adc00-fd JobId 2: Could not stat /build/bacula/working/bacula.sql: ERR=The system cannot find the path specified. The Catalog Backup job must be run on the Director, but it looks like you are running it on the Windows client. You need two client definitions in the config, one for the Windows client and one for the machine that runs the Director. __Martin -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Ubuntu Lucid
On Tue, Apr 27, 2010 at 12:27:11PM +0200, Uwe Schuerkamp wrote: Hi folks, looks like lucid comes with bacula v5 which seemingly is unable to talk to our server running bacula 2.4.x: Your other clients are all 2.4.x I guess. following that, there's a client rejected hello command message on the server. Is there any way to turn on 2.x client compatibility in a 5.0.1 client? No. So your options are either to downgrade the client on Lucid (maybe there can be found a package for 2.4.x version ? If not, you may need to build it yourself) Or you can upgrade your director and SDs (it is usually possible to have a newer directory/SD talk to older FD client; but not the other way around. However 5.0 to 2.4 might be quite a stretch). -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Ubuntu Lucid
On Tue, Apr 27, 2010 at 12:50:08PM +0200, Matija Nalis wrote: On Tue, Apr 27, 2010 at 12:27:11PM +0200, Uwe Schuerkamp wrote: Hi folks, looks like lucid comes with bacula v5 which seemingly is unable to talk to our server running bacula 2.4.x: Your other clients are all 2.4.x I guess. following that, there's a client rejected hello command message on the server. Is there any way to turn on 2.x client compatibility in a 5.0.1 client? No. So your options are either to downgrade the client on Lucid (maybe there can be found a package for 2.4.x version ? If not, you may need to build it yourself) Or you can upgrade your director and SDs (it is usually possible to have a newer directory/SD talk to older FD client; but not the other way around. However 5.0 to 2.4 might be quite a stretch). Thanks for the info, Matija. I'll do a client-only compile from source using version 2.4.x then. All the best, Uwe -- NIONEX ist ein Unternehmen der DirectGroup Germany www.directgroupgermany.de -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Ubuntu Lucid
Uwe Schuerkamp schrieb: Hi folks, looks like lucid comes with bacula v5 which seemingly is unable to talk to our server running bacula 2.4.x: bacula-fd -c /etc/bacula/bacula-fd.conf -d 99 -f bacula-fd: filed_conf.c:452-0 Inserting director res: lotus-mon lotus-fd: filed.c:275-0 filed: listening on port 9102 lotus-fd: cram-md5.c:73-0 send: auth cram-md5 1993776720.1272363...@lotus-fd ssl=0 lotus-fd: cram-md5.c:152-0 sending resp to challenge: XXX following that, there's a client rejected hello command message on the server. Is there any way to turn on 2.x client compatibility in a 5.0.1 client? nope client version must be = server version Ralf -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Upgrade path from 2.4.x to 5.0.x
On Mon, 26 Apr 2010 20:06:43 +0200, Martin Simmons mar...@lispworks.com wrote: I suggest checking your current db version by select * from version; Version 10. Is Bacula 2.4.4 dir/sd compatible with a newer database layout (11, 12, whatever?) or do I need to update the dir/sd executables at the same time? and then running the appropriate scripts from the updatedb directory of the source code (not the compiled packages) and then the one from 5.0.1 (which is not the updatedb directory). I see some .in files which look like template scripts, I presume I need to 'make' before these are filled in? --8-- On Mon, 26 Apr 2010 15:57:53 +0200, Matija Nalis mnalis+bac...@carnet.hr wrote: Also, can I expect problems if I added some extra indexes for speed and whatever tables/indexes were added by webacula? yes, you can expect problems :) For example, http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_mysql_catalog http://wiki.bacula.org/doku.php?id=faq#jobs_with_accurate_filesets_take_forever_deprecated http://bugs.bacula.org/view.php?id=1472 Thanks, I'll see what I can remove. Can't access the last link though. The indexes did help a lot with dbcheck though, without them it takes days to complete instead of minutes, will this speed up in 3.x/5.x or has dbcheck been updated, is it not necessary anymore, or is this something that needs to be fixed in a future release? I have the following indexes on File currently: Non_unique Seq_in_index || Key_name | | | Column_name | Cardinality |++ | +-+ 0| PRIMARY| 1 | FileId | 6387461 1| JobId | 1 | JobId |2750 1| JobId | 2 | PathId | 638746 1| JobId | 3 | FilenameId | 6387461 1| File_JobId_idx | 1 | JobId |2750 1| File_PathId_idx| 1 | PathId | 206047 1| File_FilenameId_idx| 1 | FilenameId | 912494 1| File_FilenameId_PathId_idx | 1 | FilenameId | 912494 1| File_FilenameId_PathId_idx | 2 | PathId | 2129153 Collation are all A, Sub_part, Packed are all NULL, Null and Comment are all empty, Index_type is all BTREE Which of these can be deleted exactly? (and how, I'm not a DBA :) -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Upgrade path from 2.4.x to 5.0.x
On Tue, 27 Apr 2010 14:15:35 +0200, Foo said: On Mon, 26 Apr 2010 20:06:43 +0200, Martin Simmons mar...@lispworks.com wrote: I suggest checking your current db version by select * from version; Version 10. Is Bacula 2.4.4 dir/sd compatible with a newer database layout (11, 12, whatever?) or do I need to update the dir/sd executables at the same time? They are incompatible so you must do it at the same time. I suggest making a dump of the database first, because there is no way to undo the update scripts. and then running the appropriate scripts from the updatedb directory of the source code (not the compiled packages) and then the one from 5.0.1 (which is not the updatedb directory). I see some .in files which look like template scripts, I presume I need to 'make' before these are filled in? I think you need to run configure with the appropriate args, rather than make. It might be easier to do it by hand, replacing @SQL_BINDIR@ and @db_name@ by the appropriate values (something like /usr/bin and bacula). __Martin -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] show pool command does not display correct Job/File Retention
Show pool command does not display correct value for Job and File Retention even they are defined in a pool resource. I took a look at a source file (dird_conf.c ) of both 5.0.0 and 5.0.1, and it seemed that the retention periods referred directives of a client resource. Or am I missing ? -yuji -- View this message in context: http://old.nabble.com/show-pool-command-does-not-display-correct-Job-File-Retention-tp28377222p28377222.html Sent from the Bacula - Users mailing list archive at Nabble.com. -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Upgrade path from 2.4.x to 5.0.x
On Tue, Apr 27, 2010 at 02:15:35PM +0200, Foo wrote: On Mon, 26 Apr 2010 15:57:53 +0200, Matija Nalis mnalis+bac...@carnet.hr Also, can I expect problems if I added some extra indexes for speed and whatever tables/indexes were added by webacula? yes, you can expect problems :) For example, http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_mysql_catalog http://wiki.bacula.org/doku.php?id=faq#jobs_with_accurate_filesets_take_forever_deprecated http://bugs.bacula.org/view.php?id=1472 Thanks, I'll see what I can remove. Can't access the last link though. You may need to create account in Mantis for that last one (there is a link below login form to which you get redirected) The indexes did help a lot with dbcheck though, without them it takes days to complete instead of minutes, will this speed up in 3.x/5.x or has dbcheck been updated, is it not necessary anymore, or is this something that needs to be fixed in a future release? The issue is in MySQL, as its algorithm sometimes chooses terribly wrong index, so SELECT times go up easily from 5 minutes to more than 20 hours. If they make MySQL choose good index every time, the problem will go away. Nowdays it is recommended to go with PostgreSQL instead AFAICT. As for dbcheck(8), if I recall correctly if indexes are not present, it will create indexes on start and drop them on finish (after asking). You can automate it with: yes no | dbcheck -b -f -c /etc/bacula/bacula-dir.conf if you do not want it to create indexes... (if you want it to create indexes on the fly, you modify that... probably something like yes yes instead of yes no, but I haven't checked it) I have the following indexes on File currently: Non_unique Seq_in_index || Key_name | | | Column_name | Cardinality |++ | +-+ 0| PRIMARY| 1 | FileId | 6387461 1| JobId | 1 | JobId |2750 1| JobId | 2 | PathId | 638746 1| JobId | 3 | FilenameId | 6387461 1| File_JobId_idx | 1 | JobId |2750 1| File_PathId_idx| 1 | PathId | 206047 1| File_FilenameId_idx| 1 | FilenameId | 912494 1| File_FilenameId_PathId_idx | 1 | FilenameId | 912494 1| File_FilenameId_PathId_idx | 2 | PathId | 2129153 Collation are all A, Sub_part, Packed are all NULL, Null and Comment are all empty, Index_type is all BTREE You need to retaint only primary key, and two indexes: one on column JobId and one on composite JobId,PathId,FilenameId. All other indexes should be dropped on MySQL table File. Which of these can be deleted exactly? (and how, I'm not a DBA :) drop index File_PathId_idx on File; drop index File_FilenameId_idx on File; drop index File_FilenameId_PathId_idx on File; I'm not sure about other tables; if you modified Job table that might also slow you down, but probably much less (it needs only primary key, and index on Name). -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Ubuntu Lucid
Am 4/27/10 12:50 PM, schrieb Matija Nalis: So your options are either to downgrade the client on Lucid (maybe there can be found a package for 2.4.x version ? You may try to install the Ubuntu package for Karmic Koala or Hardy Heron, which both are 2.4.4. Cheerz, - Dan -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] File volumes doesnt reach Maximun volumes
OK. Thanks. On Martes, 27 de Abril de 2010 12:45:45 Matija Nalis wrote: On Tue, Apr 27, 2010 at 12:39:58PM +0200, Jorge Cabello wrote: I thought new files were created until Maximum volumes limit was reached. They were. But the old files were at the same time deleted according to retention period, so you you maximum volume limit was never actually reached. -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] limit volume size
hello, I'd like to know it will be possible to limit the volume size, I mean, when it grows to a limit, bacula should generate a nother volume... Thanks -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] limit volume size
I'd like to know it will be possible to limit the volume size, I mean, when it grows to a limit, bacula should generate a nother volume... Yes. http://bacula.org/5.0.x-manuals/en/main/main/Automatic_Volume_Recycling.html You are mainly interested in the following: Use Volume Once = yes Volume Use Duration = ttt Maximum Volume Jobs = nnn Maximum Volume Bytes = mmm John -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] BAT?
This may be so obvious that I can't find it.. but where do I find BAT? I'm compiling from source, and thought it would be in bacula-gui. But this appears to be mostly for web applications. I've been using bconsole for everything, but from what I read and saw in screenshots BAT looks a bit simpler. Thanks! -- ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
