[Bacula-users] Trouble recovering the catalog with bscan

2009-03-24 Thread Christoph Haas
Dear list, I have had a little trouble which I mostly caused myself. :) It's another boring tale of I lost my catalog. (Prologue: I'm backing up to a disk storage (daily) and a tape storage (weekly). And the physical disk ran full so I tried to purge and remove volumes (files) there.

[Bacula-users] AIT streamer makes Bacula hang

2007-04-23 Thread Christoph Haas
Dear list... I have just replaced my working old DDS-3 streamer with an AIT-1 streamer (dmesg says SDX-300C). First I ran btape AIT and entered test to check if Bacula is happy with that drive. Everything went well (only results shown): - # btape AIT Tape

Re: [Bacula-users] AIT streamer makes Bacula hang

2007-04-23 Thread Christoph Haas
Thanks, Arno, for your reply. On Mon, Apr 23, 2007 at 09:32:56PM +0200, Arno Lehmann wrote: On 4/23/2007 8:53 PM, Christoph Haas wrote: I have just replaced my working old DDS-3 streamer with an AIT-1 streamer (dmesg says SDX-300C). First I ran btape AIT and entered test to check if Bacula

Re: [Bacula-users] Bacula Debian repackaging

2006-12-05 Thread Christoph Haas
On Friday 01 December 2006 11:56, Benoit Callebaut wrote: I need a more recent Bacula Debian package( autoloader automatic volume change bug fix). I haven't found one more recent than (1.38.11). Currently Debian's release team is about to prepare the next stable release of Debian codename

Re: [Bacula-users] File Table entries not pruned

2006-10-30 Thread Christoph Haas
On Thursday 26 October 2006 11:53, Martin Simmons wrote: On Wed, 25 Oct 2006 23:39:16 +0200, Christoph Haas said: On Wednesday 25 October 2006 23:18, Martin Simmons wrote: On Wed, 25 Oct 2006 23:00:09 +0200, Christoph Haas said: Actually I haven't changed my config in months

Re: [Bacula-users] File Table entries not pruned

2006-10-26 Thread Christoph Haas
On Thursday 26 October 2006 11:53, Martin Simmons wrote: On Wed, 25 Oct 2006 23:39:16 +0200, Christoph Haas said: On Wednesday 25 October 2006 23:18, Martin Simmons wrote: Yes, it sounds like a bug to me. Which database is that? Did Bacula do any pruning during the night? MySQL

Re: [Bacula-users] File Table entries not pruned

2006-10-25 Thread Christoph Haas
On Wednesday 25 October 2006 15:15, Wolfgang Powisch (privat) wrote: My Setup: bacula-1.38.8 Catalog on PostgreSQL 8.0 Server File Storage I'm seeing my Catalog Database getting larger and larger. the file table has 45 million records now and uses over 10GB on disk. Doing a list

Re: [Bacula-users] File Table entries not pruned

2006-10-25 Thread Christoph Haas
On Wednesday 25 October 2006 22:52, Martin Simmons wrote: On Wed, 25 Oct 2006 20:04:27 +0200, Christoph Haas said: On Wednesday 25 October 2006 15:15, Wolfgang Powisch (privat) wrote: My Setup: bacula-1.38.8 Catalog on PostgreSQL 8.0 Server File Storage I'm seeing

Re: [Bacula-users] building directory tree is very slow

2006-07-02 Thread Christoph Haas
On Fri, Jun 30, 2006 at 03:39:45PM -0500, [EMAIL PROTECTED] wrote: mysql backend cpu is only thing being used. iowait is 0%, everything else is idle. bacula-dir at 100% of one cpu. mem usage of bacula-dir is 11%, 60% of main memory is free. The common cause are missing or wrong SQL

Re: [Bacula-users] Expanding the Job database table entry + manual license

2006-06-12 Thread Christoph Haas
On Sat, May 27, 2006 at 10:31:42AM +0200, Kern Sibbald wrote: 3. Currently the manual is licensed under a somewhat restrictive license that does not permit commercial reproduction of the manual without explicit authorization. This means that the manual does not mean the definition of Free

Re: [Bacula-users] Version error for database bacula. Wanted 8, got 9

2006-05-16 Thread Christoph Haas
[my reply to this posting seems to be still in the moderator queue - repost] On Sat, May 13, 2006 at 08:48:39PM +0200, Maik Derstappen wrote: im upgrading my bacula from 1.36.2 to 1.38.9 on my debian machine. But i have the following error: Version error for database bacula. Wanted 8, got 9

Re: [Bacula-users] Version error for database bacula. Wanted 8, got 9

2006-05-16 Thread Christoph Haas
Hi, Maik... On Sat, May 13, 2006 at 08:48:39PM +0200, Maik Derstappen wrote: im upgrading my bacula from 1.36.2 to 1.38.9 on my debian machine. But i have the following error: Version error for database bacula. Wanted 8, got 9 The Database was new created befor. can anyone help me

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

2006-05-03 Thread Christoph Haas
On Wed, May 03, 2006 at 11:02:20AM +0100, Alan Brown wrote: On Tue, 2 May 2006, Christoph Haas wrote: While I used settings from the large my.cnf example configuration file and had a slight speedup it still took longer than a few hours so I interrupted. What indexes do you have? PRIMARY

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

2006-05-03 Thread Christoph Haas
On Wed, May 03, 2006 at 12:10:38PM +0100, Alan Brown wrote: 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

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

2006-05-02 Thread Christoph Haas
On Mon, May 01, 2006 at 10:43:11PM +0100, Alan Brown wrote: 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

[Bacula-users] Huge/slow index in MySQL

2006-05-01 Thread Christoph Haas
Evening, I'm using MySQL (4.1) as an index storage with the default MyISAM table format. Unfortunately the partition holding the MySQL databases ran full and the database became corrupt. So I wanted to restore the mysqldump of the index from the day before. Now it's 12 hours after I started to

Re: [Bacula-users] 3 theads in debian

2006-01-17 Thread Christoph Haas
On Monday 16 January 2006 21:01, Kern Sibbald wrote: With 2.4 Linux kernels (with a few exceptions), each thread had a separate pid. On 2.6 Linux kernels, all threads share the same pid but have different thread ids. Rats, why didn't I think of that. Of course that bit me once before when

Re: [Bacula-users] 3 theads in debian

2006-01-16 Thread Christoph Haas
On Monday 16 January 2006 16:02, [EMAIL PROTECTED] wrote: I use debian sarge. When i lauch bacula (/etc/init.d/bacula-sd start) i obtains 4 threads # pgrep -l bacula 30232 bacula-sd 30233 bacula-sd 30234 bacula-sd 30235 bacula-sd I wanted to obtain only one (as it is in my other machine

Re: [Bacula-users] Automount not working...?

2006-01-04 Thread Christoph Haas
On Tuesday 03 January 2006 10:28, Beren Gamble wrote: I'm having to unmount and remount my tapes all of a sudden to get bacula to realise that i've physically changed the tapes. I've got AutomaticMount = Yes in my pool resource... any other ideas what I could try? Same here with version

Re: [Bacula-users] Retoring files very slow

2005-12-14 Thread Christoph Haas
On Wednesday 14 December 2005 16:28, Bruno Léon wrote: I'm using bacula for 2 months now and I'm doing some restore tests now that the volume of data is quite big. Actually, I'd like to restore a file but this takes an extremely long time, more than 2 hours to read the catalog. The catalog is

Re: [Bacula-users] Retoring files very slow

2005-12-14 Thread Christoph Haas
Please always copy the list! Personal support is restricted to people who pay me or who are my father-in-law. Thanks. On Wednesday 14 December 2005 16:51, Bruno Léon wrote: Well, I only have an Index on FilenameID at the moment. May be those new indexes come with bacula 1.38? I'm using 1.36.2

Re: [Bacula-users] backing up to disk and tape

2005-12-08 Thread Christoph Haas
On Wednesday 07 December 2005 00:21, Jason Tan wrote: Rob Burris wrote: So what I have is separate file sets for disk and tape and that means I get two full backups and two sets of diffs for each (identical file set). IMHO this is a good idea. And not just because I do it the same way. :) On

Re: [Bacula-users] Mark volume used after a job

2005-12-05 Thread Christoph Haas
On Monday 05 December 2005 13:28, MaxxAtWork wrote: I apologize if it's a stupid question, I didn't yet experience much with Bacula syntax. There are no stupid questions - just stupid people. ;) My wish is that after Bacula terminates a full backup, the volume currently mounted would be

[Bacula-users] Failed jobs still occupy the volumes

2005-12-04 Thread Christoph Haas
Evening... before filing a bug report I wanted to be sure I'm not doing anything wrongly. I have frequently failing backup jobs because my streamer can't be found/opened (a bug of the 2.6 Linux kernel that Kern kindly pointed me to). But then the volumes that have been used so far for the job

Re: [Bacula-users] Re: What do I need to do to get bacula talking to mysql

2005-11-27 Thread Christoph Haas
Hi, Harry... On Sunday 27 November 2005 01:43, Harry Putnam wrote: Just for the record, almost my entire background is linux/unix. That's good to know. It's harder to help someone who is used to expect getting a complex task working by a press of a button. But still, I'm really an illiterate

Re: [Bacula-users] Re: What do I need to do to get bacula talking to mysql

2005-11-27 Thread Christoph Haas
Sorry for double-posting. My son just decided to find the shortcut to send a posting while I was still typing. :) On Sunday 27 November 2005 01:43, Harry Putnam wrote: One thing I'd like to try is running a specific backup setup on request that backs up a specific directory every minute.

Re: [Bacula-users] Re: What do I need to do to get bacula talking to mysql

2005-11-27 Thread Christoph Haas
On Sunday 27 November 2005 12:26, Harry Putnam wrote: Christoph Haas [EMAIL PROTECTED] writes: Basically everytime you run a backup job Bacula will create a copy of every file on the disk (at least those you configured in the file set) to your backup medium (be it a streamer, a DVD writer

Re: [Bacula-users] Re: What do I need to do to get bacula talking to mysql

2005-11-27 Thread Christoph Haas
On Sunday 27 November 2005 18:16, Harry Putnam wrote: Let me ask about something at the other end of my learning bacula. Eventually I will be having bacula write the backups to an external drive that can be hooked up via usb on any of 4 machines including my main desktop gentoo machine. That

Re: [Bacula-users] What do I need to do to get bacula talking to mysql

2005-11-24 Thread Christoph Haas
On Thursday 24 November 2005 19:40, Harry Putnam wrote: NEWUSER ALERT! ;) Using the scripts supplied with the install: ./create_bacula_database -p hpreader Creating MySQL database Enter password: *** regardless what is entered here.. it fails: ERROR 1045 (28000): Access denied for user

Re: [Bacula-users] Bad response to Append Data command.

2005-11-04 Thread Christoph Haas
Kern, thanks for your quick reply. On Thursday 03 November 2005 19:33, Kern Sibbald wrote: It looks like you stumbled into a change they made in the 2.6 kernel, which will undoubtely cause a lot of people a *lot* of pain. The change prohibits a program from opening a drive in read/write mode

Re: [Bacula-users] Restoring catalog through bscan makes the last full job fail

2005-10-29 Thread Christoph Haas
Thanks for your comments, Kern. On Friday 28 October 2005 23:05, Kern Sibbald wrote: On Friday 28 October 2005 21:22, Christoph Haas wrote: I had accidentally purged a client and wanted to rebuild the catalog using bscan. So I browsed through my status mails looking for the status report

[Bacula-users] Restoring catalog through bscan makes the last full job fail

2005-10-28 Thread Christoph Haas
Evening... I had accidentally purged a client and wanted to rebuild the catalog using bscan. So I browsed through my status mails looking for the status report of the last full backup. I inserted all three tapes mentioned in the backup report and ran bscan like this: /usr/lib/bacula/bscan.mysql

Re: [Bacula-users] Problem Restoration

2005-10-26 Thread Christoph Haas
On Wednesday 26 October 2005 09:19, Philippe MULLER wrote: I'm running bacula on Gentoo. I'm using mysql. The problem is easy to desribe : I'm backing up a fileserver (40 Go) and the database make 40 Mo. But, when i restore a file (for a user) with bconsole, it take very very long time...

Re: [Bacula-users] Problem Restoration

2005-10-26 Thread Christoph Haas
On Wednesday 26 October 2005 12:33, Philippe MULLER wrote: Christoph Haas a écrit : See if your File table has proper indices. Mine show this: mysql show index from File; | File | 1 | JobId |1 | JobId | Looks okay. How many entries in the database do you

Re: [Bacula-users] *Extreme* low MySQL performance when prunnig or purging jobs/volumes

2005-10-25 Thread Christoph Haas
On Tuesday 25 October 2005 15:08, Volker Sauer wrote: Yes, and that's the solution! The missing index on JobId make the SQL with ... where JobID= painfully slow! I checked the source and the debian package and this index is included by default. I have no idea why it's missing on my

[Bacula-users] Lazy automatic mount

2005-10-24 Thread Christoph Haas
Morning... I have a DDS-3 streamer without an autoloader. So I'm asked to change tapes frequently. To prevent interaction through the bconsole I want Bacula to spit out the old tape and request the new tape - then automount it and be happy. So far I get the old tape spit out. I get an email

Re: [Bacula-users] SD craches during backup with Network send error to SD

2005-10-16 Thread Christoph Haas
On Sunday 16 October 2005 01:49, Dan Langille wrote: No temperature being raised here. I'm asking questions so as to understand the process better. I apologize if I got your intention wrong. Sounded like bashing for me. Yes, there could be. I would expect you to establish that there was

Re: [Bacula-users] SD craches during backup with Network send error to SD

2005-10-15 Thread Christoph Haas
On Saturday 15 October 2005 20:51, François Roels wrote: I'm not able to backup my server any longer. Le backup processes crach after any attempt without usefull (for me) message. I have filed a bug report against the package a week ago on the BTS (Debian's bug tracking system). See:

Re: [Bacula-users] SD craches during backup with Network send error to SD

2005-10-15 Thread Christoph Haas
On Saturday 15 October 2005 22:56, Dan Langille wrote: On 15 Oct 2005 at 21:04, Christoph Haas wrote: On Saturday 15 October 2005 20:51, François Roels wrote: I'm not able to backup my server any longer. Le backup processes crach after any attempt without usefull (for me) message. I

Re: [Bacula-users] SD craches during backup with Network send error to SD

2005-10-15 Thread Christoph Haas
On Saturday 15 October 2005 23:13, Dan Langille wrote: On 15 Oct 2005 at 23:07, Christoph Haas wrote: On Saturday 15 October 2005 22:56, Dan Langille wrote: On 15 Oct 2005 at 21:04, Christoph Haas wrote: On Saturday 15 October 2005 20:51, François Roels wrote: I'm not able to backup

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

2005-09-12 Thread Christoph Haas
On Mon, Sep 12, 2005 at 08:02:15AM -0400, Henry Yen wrote: On Mon, Sep 12, 2005 at 11:14:00AM +0100, Alan Brown wrote: 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

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

2005-09-11 Thread Christoph Haas
Dear community... the question is a bit off-topic since it's not the Bacula software itself that's giving me a headache (although I assumed that first). I'm using a DDS3 streamer here with a pool of roughly 20 tapes. Recently when I inserted a new tape the streamer started reading the tape and

[Bacula-users] Disabling automount during a backup job

2005-07-18 Thread Christoph Haas
Morning, I'm running my device in the storage daemon with these options: AutomaticMount = yes AlwaysOpen = yes VolumePollInterval = 300 OfflineOnUnmount = yes CloseOnPoll = yes Now when the director informs me that I need to insert a new tape I often have a situation that the tape is spit out.

Re: [Bacula-users] Incremental Only Job

2005-07-03 Thread Christoph Haas
On Thu, Jun 30, 2005 at 11:57:04AM +1000, Jesus Salvo Jr. wrote: I have a job that I just where I only ever wanted incremental level done. Reason is that, the fileset that is associated with the job only keeps the last N days of file to disk. That is, there is a cron job that deletes the

[Bacula-users] bscan does not restore the catalog correctly

2005-06-26 Thread Christoph Haas
Dear list... I had a hard disk crash three days ago and I was pretty happy everything is on tape. Then I found out the database backup job didn't work properly so that my catalog is unusable. My straightforward procedure was to clear the bacula database, create it from scratch and start

[Bacula-users] Labeling new tapes with auto-eject

2005-06-21 Thread Christoph Haas
Dear list... I am running a backup on a single machine using one DDS-3 streamer. All tapes are currently in one pool and whenever I need a new tape I insert a blank one and label it. I have set up these extra options in the 'Device' section: VolumePollInterval = 60 # check if right tape is

Re: [Bacula-users] Spam on this list

2005-05-17 Thread Christoph Haas
On Tue, May 17, 2005 at 01:54:39PM +0200, Kern Sibbald wrote: On Tuesday 17 May 2005 12:18, Christoph Haas wrote: Can't you just set 'generic_nonmember_action' to 'reject'? That's what I do with my mailman lists. It just rejects emails from non-subscribers without administrative

[Bacula-users] Making full backups go to a new tape

2005-05-14 Thread Christoph Haas
Evening... I've been using afbackup for a while and had started a full_backup (that's a command of afbackup) with the -G options which makes it use a new tape. I used it so that each full backup goes onto a fresh tape. If one tape burns in flames, explodes or even gets eaten by my cats I just