Re: [Bacula-users] backup policies ?

2005-09-08 Thread Alan Brown
On Wed, 7 Sep 2005, Kern Sibbald wrote: The _only_ thing that I can see which might be affecting things is a ctime/mtime update on the parent directory, but only 100-200 files (out of several thousand) are actually changing, however it looks like the entire dircetory is being backed up. Kern, i

Re: [Bacula-users] Problem with SLR tapes

2005-09-08 Thread Alan Brown
On Thu, 8 Sep 2005, Matthias F. Brandstetter wrote: SLR100" SCSI tape drive, which is capable of storing 50GB or 100GB (compressed) onto SLR tapes. Note that 100Gb is compressed and the raw capacity is 50Gb. Now I have a bunch of newly bought SLR tapes, but there I get an "out of space" erro

Re: [Bacula-users] DDS3 streamer spits out tape time and again (offtopic)

2005-09-12 Thread Alan Brown
On Sun, 11 Sep 2005, Christoph Haas wrote: First I assumed a broken tape. But then I discovered that half of the tapes in my pool are spit out again without being read. However sometimes it helps to push the tape back in a dozen times and with a little luck the tape gets accepted. Has anyone se

Re: [Bacula-users] DDS3 streamer spits out tape time and again (offtopic)

2005-09-12 Thread Alan Brown
On Mon, 12 Sep 2005, Christoph Haas wrote: Thanks both for your comments. The drive will be replaced ASAP. I hope that doesn't mean that DDS3 is generally discouraged because it may be less reliable though. To be blunt: It _is_ less unreliable, all 4mm formats seem to be and I feel this is r

Re: AW: [Bacula-users] Big problems with my Bacula.....

2005-09-14 Thread Alan Brown
On Tue, 13 Sep 2005, Arno Lehmann wrote: backup-server is a P4 2,8GHz on a Fujitsu-Siemens Mainboard, Is this based on the Intel 915G chipset by any chance? (or any other intel set incorporating the ICH6 IDE/SATA controller...) --- SF.Net

Re: [Bacula-users] Prefer Tapes in AutoChanger? (Modified by Bill McGonigle)

2005-09-14 Thread Alan Brown
On Tue, 13 Sep 2005, Arno Lehmann wrote: You're using 1.36.3 or lower, right? The see the directive "Accept Any Volume" in the pool definition chapter in the manual. http://www.bacula.org/rel-manual/Configuring_Director.html#SECTION000141 It should do what you want, if you've

Re: [Bacula-users] Tape error

2005-09-14 Thread Alan Brown
On Tue, 13 Sep 2005, Arunav Mandal wrote: I understand this is a known bug, fixed in CVS. What happens when I change the error to Append manually will the tape be used again? I've tried this, it errors again. Switch the tape to used and let it expire, or purge it if the incomplete backup i

Re: [Bacula-users] Backup Strategies

2005-09-14 Thread Alan Brown
On Wed, 14 Sep 2005, Russell Howe wrote: I don't understand why you *MUST* use alternate sets of 5 tapes each week... People who "don't understand" this, don't use magazine based loaders. Changing out individual tapes every day or every other day defeats the whole purpose of their existance

Re: [Bacula-users] Tape error

2005-09-15 Thread Alan Brown
On Wed, 14 Sep 2005, Kern Sibbald wrote: I've tried this, it errors again. Switch the tape to used and let it expire, or purge it if the incomplete backup is the only thing on the tape. This is good advice. It avoids the possibility of having an unreadable tape. If you can repeat the exact co

Re: [Bacula-users] how to speed up directory tree building?

2005-09-16 Thread Alan Brown
On Thu, 15 Sep 2005, Daniel Weuthen wrote: I had the same problems with Jobs which have more than 68 files and mysql as database. After putting an index on JobId in the File table I got an enormous speed up: I just tried this and the speedup is amazing. Getting to selection of individual

Re: [Bacula-users] how to speed up directory tree building?

2005-09-16 Thread Alan Brown
On Fri, 16 Sep 2005, Daniel Weuthen wrote: This is surprising because I always understood that a multiple index (JobId, PathId, FilenameId) was equivalent (actually better) than one only on JobId. It should be Could you tell me what DB you are using MySQL, ...? mysql Ver 12.22 Distrib

Re: [Bacula-users] how to speed up directory tree building?

2005-09-16 Thread Alan Brown
On Fri, 16 Sep 2005, Kern Sibbald wrote: Are you running on 1.36.3? If so, this is strange since the default table setup for 1.36.3 includes an index on JobId in the File table. But not on upgrades from previous versions, right? --- SF.N

Re: [Bacula-users] how to speed up directory tree building?

2005-09-16 Thread Alan Brown
On Fri, 16 Sep 2005, Kern Sibbald wrote: But not on upgrades from previous versions, right? On most upgrades, the index should not be lost, because generally an upgrade adds new columns or new tables. But does an uipgrade form previous version of bacula database format add new indexing too?

Re: [Bacula-users] how to speed up directory tree building?

2005-09-16 Thread Alan Brown
On Fri, 16 Sep 2005, Kern Sibbald wrote: Gee, it looks like I really need to document checking/adding/deleting indexes to the manual so that users can easily check and correct any problems. This would probably be a nice mini-project for a script jockey. Probably. What are the recommended inde

Re: [Bacula-users] how to speed up directory tree building?

2005-09-16 Thread Alan Brown
On Fri, 16 Sep 2005, Kern Sibbald wrote: For the File table in MySQL it was: PRIMARY KEY(FileId), INDEX (JobId, PathId, FilenameId) For PostgreSQL it was: primary key (fileid) create index file_jobid_idx on file (jobid); create index file_fp_idx on file (filenameid, pathid); The dif

Re: [Bacula-users] HD image

2005-09-17 Thread Alan Brown
On Fri, 16 Sep 2005, Karl Cunningham wrote: Some months ago I had occasion to backup and restore a disk image of a Windows system using Bacula. The situation was a hard disk on a Windows system that had suddenly developed a loud whine and we wanted to replace it ASAP. There are lots of argume

Re: [Bacula-users] Volume config problem

2005-09-20 Thread Alan Brown
On Tue, 20 Sep 2005, Florian Schnabel wrote: that's why the maximum use duration is set .. No. Maximum use duration sets the maximum period that a tape will be used for backing up before being toggled from "append" into "used" mode. This is useful for ensuring tapes are changed out weekly, e

Re: [Bacula-users] new bacula install

2005-09-21 Thread Alan Brown
On Wed, 21 Sep 2005, Baldur Norddahl wrote: I did not try spooling for two reasons. First is that the backup server only has about 70 GB diskspace (two SATA disks in a mirror configuration). Many of the servers have more data to backup than this, and the total backup set is several times this.

Re: [Bacula-users] new bacula install

2005-09-21 Thread Alan Brown
On Wed, 21 Sep 2005, Arno Lehmann wrote: That's not a problem, although for your setup I would recommend something much larger... when the spool space is smaller than the data you need to backup, bacula first fills the spool space, writes that to tape, and continues reading from the clients an

Re: [Bacula-users] Wildcard File Selection on Restore?

2005-09-23 Thread Alan Brown
On Fri, 23 Sep 2005, Kern Sibbald wrote: Unfortunately, the restore command doesn't have the best of all user interfaces Kern is the master of understatement. , and I don't think it is possible to recursively mark all *.dbx files. I've had similar requests and it's rather painful to mark t

Re: [Bacula-users] Backup strategy & not-so-strict schedule

2005-09-25 Thread Alan Brown
On Sun, 25 Sep 2005, Timo Neuvonen wrote: - nominally, the next tape would be taken into use in the beginning of every month Reasons behind this are minimal manual handling of the tapes, knowing there will be loss of up to one month's data if the current tape gets destroyed. I believe my tape d

Re: [Bacula-users] "Read-only" error during restore

2005-09-26 Thread Alan Brown
On Mon, 26 Sep 2005, Ryan Novosielski wrote: I write protect the tapes when I'm done with them, I guess it never crossed my mind that bacula would need _write_ access for a restore. This is a good point though -- it really SHOULDN'T, should it? Restore should be an action that cannot even pos

Re: [Bacula-users] Correct way to change magazine in v1.37.latest ?

2005-09-28 Thread Alan Brown
On Wed, 28 Sep 2005, Kern Sibbald wrote: "unmount" any mounted drives using bconsole, and discharge the magazine. If there are any loaded drives, most autochangers unload them. Only the smaller ones. None of our magazine based loaders unload tapes to the magazine before making them available

Re: [Bacula-users] Problem with mtx-changer when library loses which slot for a tape

2005-10-04 Thread Alan Brown
On Mon, 3 Oct 2005, Tom Boyda wrote: Is there something that can be done to the mtx-changer script so that it can return the tape to the correct slot? If MTX doesn't know, it'll unload the tape to the first available slot. If the slot that the tape was loaded from is now occupied, it will unl

Re: [Bacula-users] Problem with mtx-changer when library loses which slot for a tape

2005-10-04 Thread Alan Brown
On Tue, 4 Oct 2005, Kern Sibbald wrote: If somone has transferred a tape into a slot that Bacula has loading, that will undoubtedly cause confusion, According to MTX documentation if that happens the tape will be loaded into the next highest available slot (with wraparound). This would caus

Re: [Bacula-users] Problem with mtx-changer when library loses which slot for a tape

2005-10-04 Thread Alan Brown
On Tue, 4 Oct 2005, Arno Lehmann wrote: Most certainly. The problem in this case might be to reproduce the situation - as far as I understood Tom, he didn't change the tape inventory, but the autochanger somehow lost track of the slots used. I heard that before, and, although seldom, some auto

Re: [Bacula-users] Problem with mtx-changer when library loses which slot for a tape

2005-10-04 Thread Alan Brown
On Tue, 4 Oct 2005, Kern Sibbald wrote: Better yet, try 1.37 and tell me what it does and what it should do. Between 1.36 and 1.37 a lot of things have changed. I believe that the current behavior is to zap the Slot number in the catalog, then to try another tape in the autoloader, and failing

Re: [Bacula-users] user complains bacula slows his laptop

2006-03-16 Thread Alan Brown
On Thu, 16 Mar 2006, Alex Finch wrote: So the user with the laptop finally dropped in again this week and we had a chance to pursue why bacula brings his machine to its knees. We worked through your suggestions and it turned out one of them was right. We turned off Norton Antivirus and everyth

Re: [Bacula-users] Too early End Of Medium

2006-03-20 Thread Alan Brown
On Fri, 17 Mar 2006, Wolfgang Denk wrote: Most critical options are: MT_ST_BUFFER_WRITES, MT_ST_ASYNC_WRITES, MT_ST_READ_AHEAD. Especially the combination of MT_ST_BUFFER_WRITES and MT_ST_ASYNC_WRITES prevents any way to reliably handle end of tape conditions. I thought Bacula tried to

Re: [Bacula-users] no diference between full and inc backup, i'm lost....

2006-03-20 Thread Alan Brown
On Sun, 19 Mar 2006, Carles Bou wrote: i'm running bacula 1.38.5 on gentoo with postgresql, as DB backend. i don't know why, but bacula is always copying all files in the set i've loocked at stat output and files, no change between 2 backups Do you have any chown -R scripts running? Some of

Re: [Bacula-users] General list comment

2006-03-21 Thread Alan Brown
On Mon, 20 Mar 2006, Attila Fülöp wrote: If you reply to a message your client adds a In-Reply-To (and a References) header. So mine will have In-Reply-To: <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> Note that the References: header is a NNTP/Usenet device (RFC1036bis) which was sho

Re: [Bacula-users] Turning compression on and off automatically

2006-03-22 Thread Alan Brown
On Tue, 21 Mar 2006, Bill Moran wrote: For performance reasons, we'd like to have gzip turned off during tape backups, but for space reasons: on during disk backups. Does reiserfs V4 have compression modules yet? Just a thought which would give you an easy way of doing it. AB

Re: [Bacula-users] Potential concerns about Bacula

2006-03-22 Thread Alan Brown
That is correct. This feature is being worked on but for now, Bacula restores ALL files, including deleted and renamed ones. Most backup software works this way. 3) We perform backups overnight, when no operators are here, so as to minimize performance impact on our users. We have enough d

Re: [Bacula-users] Potential concerns about Bacula

2006-03-23 Thread Alan Brown
On Wed, 22 Mar 2006, John Goerzen wrote: Quite simply: In a professional environment, if your full overnight backups do not fit on a single tape then you either need an adequately sized changer or larger tapes. Simple economic calculations will show that staff costs will easily exceed that of ad

Re: [Bacula-users] Disabling Client

2006-03-23 Thread Alan Brown
On Wed, 22 Mar 2006, Craig Dupree wrote: From looking at the Docs, and through the archives I think I can disable a client's backup by commenting out the Schedule line like this: Job { Name = "frodo" Type = Backup Level = incremental Client = frodo FileSet =

Re: [Bacula-users] Ejecting a tape

2006-03-27 Thread Alan Brown
On Mon, 27 Mar 2006, Gavin Conway wrote: Hi All, I'm aware that others have the same problem and that they have apparently solved it but I'm still at my wits end. I'm trying to run a 2 week tape rotation with a monday-friday full system backup along with a catalog backup to tape. Each time i

Re: [Bacula-users] Huge number of files

2006-03-27 Thread Alan Brown
On Mon, 27 Mar 2006, Martin Horcicka wrote: Hi, is there any way to backup directory trees containing a huge number of files (tens of millions) using Bacula? Make sure there's enough disk space to handle the resulting database and make sure the database has enough rows defined to cope. The

Re: [Bacula-users] bacula rescue cd alternative ?

2006-03-29 Thread Alan Brown
On Wed, 29 Mar 2006, Kern Sibbald wrote: Unfortunately, as far as I am concerned kubuntu is a total disaster. I downloaded their latest version 5.10 (if I remember right), burned a CD, did the installation, and ended up with a running system with no root password -- that is a totally useless sy

Re: [Bacula-users] bacula rescue cd alternative ?

2006-03-29 Thread Alan Brown
On Wed, 29 Mar 2006, Kern Sibbald wrote: sudo bash Ugly, but it works. Yes, really ugly, but it does work. Thanks. Now at least I have been able to give my root account a password. Unfortunately, also, what I though was my personal account, apparently has a lot more power than any sane user

Re: [Bacula-users] Avoiding monthly full backup ?

2006-04-02 Thread Alan Brown
On Fri, 31 Mar 2006, [windows-1252] Simon }ekar wrote: So I'm wondering, do I really need to do a Full backup of my servers monthly or is there a way, to make a full backup out of previous full backup + incrementals and then do an incremental backup on these calculated full backup ? Assuming

Re: [Bacula-users] BLOCKED device

2006-04-04 Thread Alan Brown
On Tue, 4 Apr 2006 [EMAIL PROTECTED] wrote: Again: how can I tell the SD to unblock a device during runtime? What seems to work for me is to manually load a tape using MTX and then trying "mount" again. AB --- This SF.Net email is spon

Re: [Bacula-users] Surprise bug + Scratch pool algorithm

2006-04-10 Thread Alan Brown
On Mon, 10 Apr 2006, Kern Sibbald wrote: For those of you who are for or against the new 1.38.6 code that takes Volumes from the Scratch pool earlier in the algorithm, now is the time to make your case. At this point, unless someone can convince me otherwise (again), I am inclined to put it bac

Re: [Bacula-devel] Re: [Bacula-users] Surprise bug + Scratch pool algorithm

2006-04-11 Thread Alan Brown
On Mon, 10 Apr 2006, John Kodis wrote: On a somewhat related note, I'm not clear on how the tape selection algorithm is altered when an autochanger is available. For example, if there are two equally eligible volumes available, only one of which is in the autochanger, would this volume be prefe

Re: [Bacula-devel] Re: [Bacula-users] Surprise bug + Scratch pool algorithm

2006-04-11 Thread Alan Brown
On Mon, 10 Apr 2006, Kern Sibbald wrote: I'd like to add a third. I don't use scratch pools at all, currently, but I can't see why I'd want a new volume being added to the pool when I've got one in there that's supposed to be used. Wouldn't that mean that it would ALWAYS choose a scratch volume

Re: [Bacula-users] Re: GFS rotating howto

2006-04-11 Thread Alan Brown
On Tue, 11 Apr 2006, Georg Lutz wrote: 1. The scheduling is different. In Bacula you cannot schedule on the last workday of a month or week because Bacula doesn't know of workdays and holidays. The internal scheduling mechanism does also not know of exceptions. At least at my site there are some

Re: [Bacula-users] High memory usage when backing up

2006-04-11 Thread Alan Brown
On Tue, 11 Apr 2006, Eric Warnke wrote: What you are seeing appears to be normal block device caching under the linux kernel and nothing to worry about. To explain: buffers = i/o (disk) write buffers cache = i/o (disk) read cache These are dynamic. Linux works on the principle that if the m

Re: [Bacula-users] Bacula marking tapes Full with only a few GB written

2006-04-15 Thread Alan Brown
On Wed, 12 Apr 2006, Wolfgang Denk wrote: As mentioned before, I see the same effect when changing the timing: running the SD on a low end system (400 MHz P II) makes the problem go away reliably - with h/w compression on. I am more and more convinced that this is a subtel timing issue in

Re: [Bacula-users] Encryption?

2006-04-20 Thread Alan Brown
On Sun, 16 Apr 2006, Kern Sibbald wrote: I could imagine three good reasons for this: 1. You want *all* data to be encrypted and you don't want to worry about setting up the encryption in every Client. I.e. it is one point of control for encryption. IE: when tapes are taken offsite for stor

Re: [Bacula-users] Bacula marking tapes Full with only a few GB written

2006-04-20 Thread Alan Brown
On Mon, 17 Apr 2006, Wolfgang Denk wrote: My best guess is that the problem is some sort of kernel SCSI lock race condition. As a consequence, I would recommend that you concentrate on writing lots of buffers as fast as you can, but from multiple processes, possibly to the same or different dri

[Bacula-users] 1.36.* bacula mailbomb

2006-04-20 Thread Alan Brown
This may be fixed in 1.38, which is why I'm posting it here instead of to the bugs page for the moment. Over the easter break, our bacula system loaded in an unformatted LTO2 tape - which it thought was labelled. Normally, if bacula believes the tape isn't labelled, it gets an io error, pr

Re: [Bacula-users] Constructive criticism of current bacula systems

2006-04-25 Thread Alan Brown
On Mon, 24 Apr 2006, Eric Warnke wrote: The Bad. 2) SQLite SQLite is only really there for testing purposes and the odcumentation makes it very clear that it's not recommended for production systems. 6) Does not track deletions between full backups. Show me more than 3 (quite expensiv

Re: [Bacula-users] Backups too big, and other questions

2006-04-25 Thread Alan Brown
On Mon, 24 Apr 2006, Scott Ruckh wrote: I am excluding /BACKUPS in my file list so you can see I am not backing up my backups. VERIFY that this is happening. It is very easy to get the syntax wrong and have /BACKUPS being backed up unintentionally. I think I have found the culprit, /var/lo

Re: [Bacula-users] Restore Error

2006-04-26 Thread Alan Brown
On Tue, 25 Apr 2006, Danie wrote: Hi Eric , Thanks for the advise , seems it was one of my MYI files that were corrupt (Filename.MYI) to be exact , used myisamchk to repair. It was probably originally corrupted due to lack of available filesystem space. Please check there is enough "breat

Re: [Bacula-users] HP Ultrium 232 Device Can you Recomended Me To Buy..?

2006-04-26 Thread Alan Brown
On Tue, 25 Apr 2006, pedro moreno wrote: Hi People. Ok My HP Surestore Ultrium 230 is dead. HP dosent want to repair because they say is old. Ok they offer me the HP StorageWorks Ultrium 232 because they say is compatible with my old one. Them, some here can recomend me this tape drive

Re: [Bacula-users] Problems with tape drive showing busy.

2006-04-27 Thread Alan Brown
On Wed, 26 Apr 2006, Dan Langille wrote: I bet you forgot to stop Bacula before using btape. bacula-sd in particular. I bet it's using the tape. releasing/unmounting the tape means Bacula-sd doesn't need to be stopped, but one MUST remember to remount afterwards. AB

Re: [Bacula-users] License question

2006-04-27 Thread Alan Brown
On Wed, 26 Apr 2006, Jason Martin wrote: I believe the GPL only requires that changes made to the source be available to people who use the modified binary. And the original source too. This has caused a number of problems in embedded linux systems (small adsl/broadband routers. etc) where t

Re: [Bacula-users] License question

2006-04-27 Thread Alan Brown
On Wed, 26 Apr 2006, Hugo Schlebnik wrote: I am indeed talking about the binary, not the source. I have no intention of modifying the bacula client code, but rather integrating it (as is) into a larger, proprietary application. Would that mean I'd have to release source code for the larger ap

Re: [Bacula-users] Help with suggesting a backup policy

2006-04-27 Thread Alan Brown
On Wed, 26 Apr 2006, Lewis Thompson wrote: I've spent the last couple of days setting bacula up with a StorageTek L20. It's equipped with two Ultrium-1 drives and 19 100GB uncompressed tapes (the last slot is a cleaning tape). Make it 20. Unless you have a very dusty environment, you will fin

Re: [Bacula-users] License question

2006-04-27 Thread Alan Brown
On Wed, 26 Apr 2006, Jason Martin wrote: If you have anyone to answer to other than yourself, you should ask *your* lawyer. 'The mailing list said so' probably won't be a good answer if you are under review because something went sour. All we can do is tell you what we think that lawyer *should*

Re: [Bacula-users] subversion backup at SourceForge with public FD?

2006-04-27 Thread Alan Brown
On Thu, 27 Apr 2006, Stephan Ebelt wrote: However, from the implementation point of view I think this is a bit of overhead since it requires local disk space being available and there must be additional logic to detect whether rsync actually succeeded... kind of similar to dumping some large SQL

Re: [Bacula-users] Constructive criticism of current bacula systems

2006-04-27 Thread Alan Brown
On Thu, 27 Apr 2006, Martin Simmons wrote: 6) Does not track deletions between full backups. Show me more than 3 (quite expensive) commercial packages which do this. There are at least two open source ones that work for some unix filesystems (Jörg Schilling's star and Solaris's dump/restore

Re: [Bacula-users] tape drive recommendation

2006-05-01 Thread Alan Brown
On Sat, 29 Apr 2006, Mario Ohnewald wrote: Hello List, i am looking for a cheap IDE Tape drive which holds about 20GB uncompressed data. IDE tape drives tend to have problems operating with *nix systems. Have you considered an external USB one? AB

Re: [Bacula-users] Huge/slow index in MySQL

2006-05-01 Thread Alan Brown
On Mon, 1 May 2006, John Kodis wrote: You have more CPU than I do, but only about half the memory. Since you say that the disks are thrashing, I'd guess that the lack of memory is more likely to be the culprit than the difference in databases. There have, however, been some messages posted her

Re: [Bacula-users] Backup to disk then tape

2006-05-01 Thread Alan Brown
On Mon, 1 May 2006, Bill Moran wrote: How about our reasons for doing this: 1) We need speedy restores, thus we have a 1T RAID5 array and backup to disk devices there. I backup ~20Tb to LTO2. The tapes run almost as fast as most of the disk arrays (MSA 1000 and Nexsan Atabeast) 2) We _mu

Re: [Bacula-users] Backup to disk then tape

2006-05-01 Thread Alan Brown
On Mon, 1 May 2006, John Gerritse wrote: So in short; I want backups on disk, then copy them to tape Cutting to the chase on this: Why? If it's for speed of restores, I have found that as long as the tape is in the changer then file/directory level restores only take about 5 minutes. if i

Re: [Bacula-users] Backup to disk then tape

2006-05-02 Thread Alan Brown
On Mon, 1 May 2006, Bill Moran wrote: I backup ~20Tb to LTO2. The tapes run almost as fast as most of the disk arrays (MSA 1000 and Nexsan Atabeast) I guess I didn't make my point. The tapes are several orders of magnitude slower than disk. Then get faster tapes. If things are that critica

RE: [Bacula-users] Backup to disk then tape

2006-05-02 Thread Alan Brown
On Tue, 2 May 2006, James Harper wrote: . Allows very frequent incremental backups (hourly, depending on the servers ability to cope with the extra load) Do you really want to dump those incrementals to tape or just generate a differental? . Ability to restore to any given backup point, eg

Re: [Bacula-users] Backup to disk then tape

2006-05-02 Thread Alan Brown
On Tue, 2 May 2006, Bill Moran wrote: The time it takes to get them back onsite alone is too slow for most recovery scenerios. Hence the necessity for job cloning - AND a decent data firesafe. What does a firesafe have to do with this? Data backed up to disk can still be erased. A New Ze

Re: [Bacula-users] Huge/slow index in MySQL

2006-05-03 Thread Alan Brown
On Tue, 2 May 2006, Christoph Haas wrote: By way of comparison my systems were thrashing badly even with 2Gb of ram because mySQL wasn't using enough memory. Allowing it to grow to 1Gb ram solved it almost entirely. I just have 512 MB of RAM but you made me think about my server parameters.

Re: [Bacula-users] Clarification in volume creation and utilization (Help)

2006-05-03 Thread Alan Brown
On Tue, 2 May 2006, Ambahunen Gebremariam wrote: Does that mean that server A backs up server B, server B backs up C, ... R backs up A? We have Server 'A' backing up Server 'B', Server 'B' backing up Server 'A', Server 'C' backing up server 'D' and so on ... Ew, that's hideously complicate

Re: [Bacula-users] Re: [Bacula-devel] label only new barcodes proposed patch (fwd)

2006-05-03 Thread Alan Brown
On Wed, 3 May 2006, Michael 'buk' Scherer wrote: But, after, if i add 2 new tapes, and i does an other "label barcodes" it will load and try to label every tape... i have a 180 slots changer and it's quite long... Yes, I can understand that. I still that this is just 'wrong'. IIRC, Label b

Re: [Bacula-users] Huge/slow index in MySQL

2006-05-03 Thread Alan Brown
On Wed, 3 May 2006, Christoph Haas wrote: That won't help, but proper indexing should speed things up. Au contraire. In this case the indexing is slowing down the import. Importing the pure data is taking a few minutes only while creating the indexes is taking a day. Doh, of course... Are y

Re: [Bacula-users] Clarification in volume creation and utilization (Help)

2006-05-04 Thread Alan Brown
On Wed, 3 May 2006, Ambahunen Gebremariam wrote: If you're going to do that, why not just have a dedicated bacula server? I didn't design the backup system; I'm just working with I've got. I've a meeting tomorrow and I will lay the issue on the table. I did and got a new box for the job. Sti

Re: [Bacula-users] File Daemon loosed conx with directory

2006-05-05 Thread Alan Brown
On Fri, 5 May 2006, Chris Boyd wrote: Firewall in between? Ah sorry I forgot to mention that. No firewall, both hosts on the LAN behind firewall. What about the windows software firewall? AB --- Using Tomcat but need to do more? Need t

Re: [Bacula-users] storage daemon "sub-optimal" behaviour using 2 tape drives

2006-05-09 Thread Alan Brown
On Tue, 9 May 2006, Robert Wirth wrote: just a hint about "sub-optimal" behavior of bacula's storage daemon. There's an autochanger with two LTO-3 tape drives. Sometimes, starting some (mostly identical) jobs in parallel leads to an obscure situation: It's not that obscure and is well known i

Re: [Bacula-users] storage daemon "sub-optimal" behaviour using 2 tape drives

2006-05-09 Thread Alan Brown
On Tue, 9 May 2006, Robert Wirth wrote: just a hint about "sub-optimal" behavior of bacula's storage daemon. There's an autochanger with two LTO-3 tape drives. Sometimes, starting some (mostly identical) jobs in parallel leads to an obscure situation: Are you using an older version of Bacula?

Re: [Bacula-users] Autochanger *almost* working (resolved with ugly hack)

2006-05-10 Thread Alan Brown
On Tue, 9 May 2006, Gregory Brauer wrote: This just seems broken to me, though. Bacula should automatically check what tapes are currently in the loader every time it runs a job. Why doesn't it do this? Because if the tapes aren't barcoded, this requires reading the labels. AB --

[Bacula-users] backing up snapshots?

2006-05-16 Thread Alan Brown
Has anyone used LVM/EVMS snapshots to get a stable image to backup? If so, how do you do it? AB --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your

Re: [Bacula-users] backing up snapshots?

2006-05-18 Thread Alan Brown
On Tue, 16 May 2006, Arno Lehmann wrote: Anyway, suggesting an enhancement to the "Where" option during restore to strip leading path elements before applying the actual restore location seems useful. Yes, but it's only a single mv command afterwards the way things are. A bit more awkward fo

RE: [Bacula-users] Doubt about tape space management

2006-05-19 Thread Alan Brown
On Fri, 19 May 2006, Meidal, Knut wrote: The problem would be that there is no way to start rewriting a tape, and then "stop" before you overwrite the important data at the end without destroying that, too. The only way out of that would be to come up with a "tape reclaim" feature where you read

Re: [Bacula-users] problem recycling volumes

2006-05-19 Thread Alan Brown
On Thu, 21 Jul 2005, Matthias Kurz wrote: I don't think so, because of my understanding on physics, the stress to material is higher when the temperature is changing, than at a constant level. spinning up an down would mean that during backup the temperature of the drives are rising to go down a

Re: [Bacula-users] Re: Confusion about changer volumes

2006-05-22 Thread Alan Brown
On Sat, 20 May 2006, John Goerzen wrote: We had three labeled, but otherwise completely unused, tapes in the pool. Two were in the changer, and Bacula knew this. Yet for some inexplicable reason, it decided it wanted the tape that wasn't in the changer! (All three were showing Appendable). I

Re: [Bacula-users] Retaining incremental with full backups

2006-05-23 Thread Alan Brown
On Mon, 22 May 2006, Dan Trainor wrote: It's been a while since I've asked this, and I had a few more questions. Is this kind of backup common? I'll agree that this is not the most efficient way to backup anything, especially considering that this is being done to save all chagnes to all fil

Re: [Bacula-users] Offsite Storage and Incremental Backups

2006-05-23 Thread Alan Brown
On Tue, 23 May 2006, Bill Moran wrote: What other strategies could I use? We do a full backup to tape on Thursday night -- the courier picks tapes up on Friday. We do our full backups on tuesday - thursday morning (midnight-4am) That way we can be reasonably sure that there will be someone

Re: [Bacula-users] Resume interrupted jobs

2006-05-23 Thread Alan Brown
On Thu, 18 May 2006, Cassiano Pilipavicius wrote: The problem is when we need reboot the server and the Bacula job is already running. How often does this happen and why do you need to reboot the server? --- All the advantages of Linux Ma

Re: [Bacula-users] automatic (un)mount of USB disk does not work

2006-05-24 Thread Alan Brown
On Wed, 24 May 2006, Henning Holtschneider wrote: I'm trying to get a USB disk to be automatically mounted and unmounted before/after each backup job with Bacula 1.38.9. My USB drive in at /dev/sdb, You cannot guarantee it will always be there. so I created this device configuration for the

Re: [Bacula-users] Resume interrupted jobs

2006-05-24 Thread Alan Brown
On Wed, 24 May 2006, Cassiano Pilipavicius wrote: Sometimes the tape get locked in the device. Why? Is something holding it active? And we need to reboot the backup server to eject the tape. Why? Almost every tape drive has some magic code to force an eject. (Try pressing the eject button

Re: [Bacula-users] automatic (un)mount of USB disk does not work

2006-05-24 Thread Alan Brown
On Wed, 24 May 2006, Henning Holtschneider wrote: You cannot guarantee it will always be there. That's true, but I wasn't at the point to deal with this, yet :-) I meant at /dev/sdb, but there's always "not there at all" so I created this device configuration for the Storage Daemon: It's

Re: [Bacula-users] Maildir Backups

2006-05-25 Thread Alan Brown
On Wed, 24 May 2006, D Canfield wrote: I'm just curious how other users are backing up maildirs using bacula. We're using cyrus as our mail server, so we've got about 162GB of data stored in 4.4 million files, or an average of 37K per message. Most other products I've tried (both commercial

Re: [Bacula-users] MySQL Indexes

2006-05-25 Thread Alan Brown
On Wed, 24 May 2006, Kern Sibbald wrote: The problem isn't the 360G of data, it could be 1000G and the problem would be the same. It is the 5 million files. The current code is not very scalable beyond a million or two files when doing an interactive restore. It simply takes too long to buil

Re: [Bacula-users] MySQL Indexes

2006-05-25 Thread Alan Brown
On Thu, 25 May 2006, Kern Sibbald wrote: On backups here with ~4 million files in them, the tree build takes less than an hour. I usually just start the restore process and go do something else for a while. Well that is nice to hear. :-) Note that it is _essential_ to have enough RAM or the

Re: [Bacula-users] MySQL Indexes

2006-05-26 Thread Alan Brown
On Thu, 25 May 2006, Ryan Novosielski wrote: Note that it is _essential_ to have enough RAM or the machine will start banging on swap and slow down dramatically. How much is enough? Is there a metric for catalog size vs. memory? I have 2Gb ram. It's enough to cope with restore sets of 4-6 mi

Re: [Bacula-users] rerunning deleted full backup

2006-06-05 Thread Alan Brown
On Mon, 5 Jun 2006, Silver Salonen wrote: > I just "accidentally" deleted the monthly full backup made last night (and > realized the mistake afterwards). Is there a way to upgrade the tonight's > incremental to full again? No need, it will realise theere's o preexisting full backup and upgrade

Re: [Bacula-users] Windows NT Error: "ERR=Access is denied"

2006-06-12 Thread Alan Brown
On Mon, 29 May 2006, jimbox wrote: > bacula client version 1.38 > windows NT 4.0 SBS 4.5 > > fyi: i was persistently (and inconsistently across directories) > getting the error "ERR=Access is denied" while backing up this client. > > i couldnt find any online info addressing this. i eventually de

Re: [Bacula-users] Rocket science: was Re: Bacula version 1.38.10 released

2006-06-15 Thread Alan Brown
On Wed, 14 Jun 2006, Kel Raywood wrote: > On Tue, 13 Jun 2006, Kern Sibbald wrote: >> ... It is now necessary to be a rocket scientist before even >> considering using the GNU C++ compiler :-( > > Rocket scientists are notoriously bad programmers so I don't think that > this is some to aspire to.

Re: [Bacula-users] Tape Loader - Experiences?

2006-06-15 Thread Alan Brown
On Wed, 14 Jun 2006, Quinton Jansen wrote: > We've got the LTO3 option for the Quantum Superloader.. Had a problem with > the picker jamming the tapes.. After a two hour tech support call, they > agreed to send a replacement. > > The other problem was related to the scsi card.. Can't use anythi

Re: [Bacula-users] Bacula-users Digest, Vol 2, Issue 53

2006-06-15 Thread Alan Brown
On Wed, 14 Jun 2006, Richard White wrote: > In my haste, I neglected to mention that I installed the gcc tools with > YaST on the second machine. Please note that the make of bconsole worked > on machine #2, the one on which I initially skipped the development > tools, and failed on the one on

Re: [Bacula-users] Rocket science: was Re: Bacula version 1.38.10 released

2006-06-15 Thread Alan Brown
On Thu, 15 Jun 2006, Kern Sibbald wrote: >> Kern, how well does bacula cope with directories that have 300,000+ files >> in them? (no, not being humourous) > > Well, it really should not have much trouble backing them up or restoring > them, though the restore may be a bit slower when creating so

Re: [Bacula-users] I love my bacula, but my boss says throughput is too slow.... :-( What can I do to optimize?

2006-06-19 Thread Alan Brown
On Fri, 16 Jun 2006, Christoff Buch wrote: > So far I thought about turning off spooling, which speeded throughput up > from ca. 5MB/s to 7MB/s. This will only get a speedup on full backups, and only if the disks are fast enough to keep the tape drive running at full speed. > What are the confi

Re: [Bacula-users] I love my bacula, but my boss says throughput is too slow.... :-( What can I do to optimize?

2006-06-19 Thread Alan Brown
On Sat, 17 Jun 2006, Tracy R Reed wrote: > I am running SQLite3 > for the db. SQLite is only suitable for test setups. Do yourself a big favour and move to MySQL or Postgres. > I set > PRAGMA synchronous = OFF; on the db just for kicks but it seems to have > had no effect. top says 50% of the

<    1   2   3   4   5   6   7   8   9   10   >