Re: [Bacula-users] restore: device is blocked waiting for media

[Luca Ferrari]

On Wednesday 5 September 2007 Arno Lehmann's cat, walking on the keyboard, 
wrote:

> I think we'll need some more detailed information here... does Bacula
> send a notification to load the volume it wants, what are the Media
> Types, and so on... the relevant parts of your configuration might
> help here.

In fact looking into the messages I found:

05-set 18:54 backup-sd: Please mount 
Volume "mammuth_uff_g_job-2007-08-30--23-47" on Storage 
Device "mammuth_device" (/backup/mammuth) for Job 
restore_mySelf.2007-09-05_17.53.30

so I manually did a mount of the device and the restore process is now 
running. Why it is not automatically mounting the device? The following is 
the definition of my restore job:

Job {
Name = restore_mySelf
Enabled = no
Type = Restore
Client = mySelf
FileSet = config_fileset
Storage = backup-sd
Messages = Daemon
Pool = Default
Where = /backup/restore
}

Am I missing something?

Thanks,
Luca

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Backup progress information

[Ruben Lopez]

Hi,

Is there any way of knowing the progress of one backup? I mean something 
like "copied 27 of 145 files" or "copied 50 of 145 GB"?

Thanks.

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] How to use internal variables in bacula-dir.conf?

[rote . nase]

Hi,
i'm trying to use internal bacula-variables in bacula-dir.conf in the 
fileset-section:


File = "|sh -c 'grep -i -s \"^$Client\" /path/to/bacula/etc/test-disklist | cut 
-f2 -d@ '"

The corresponding test-disklist is:

# test-disklist
# format: hostname@/path/to/backup-dir_or_file
#
hostname1@/tmp/xxx/dir1
hostname1@/tmp/xxx/file1
hostname2@/var/spool/dir-xxx
hostname3@/home/username

During runtime the internal bacula-variable $Client ( i also tried ${Client} 
with and without '\' ) is always empty so every line is matched.
How to do ?

Thanks,
  Markus
_
Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
http://smartsurfer.web.de/?mc=100071&distributionid=0066


-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula Windows client strange behaviour

[Alex]

Hi Ivan

Hi Alessandro,

On Wednesday 05 September 2007 04:31:22 pm Alessandro Bianchi wrote:
  

> Hi everyone
>
> I use bacula with success on a mixed network with MacOS X, LINUX and
> Windows Xp Workstations.
>
> Everithing goes very well but on on two of the Windows XP PCs the backup
> starts good then slows down and hangs.
>
> I mean the average speed slowly goes to 0 b/sec while the job runs.
>
> The FD is alive, and the job looks running both on the Director/Storage
> (Linux) and on the FD client.
>
> Everyone uses the latest available Bacula version 2.2.x and the problem
> appears only on two Windows PC's while the others work really fine.
>
> The PC's look identical in services and configuration (the Fileset is
> different of corse) to the ones working.
>
> I've tried both VSS and non-VSS backup with the same result.
>
> I've looked into the docs for something useful with absolutely no success.
>
> Does anyone have any idea about what to start checking to have this
> thing debugged?



File client may as well be just busy scanning files. If some of the filesets 
happen to include folders with thousands of small (or otherwise) files then 
scanning those folders and collecting attribute data for all of the files can 
be painfully slow. In my experience this often creates quite a bottleneck. 
You can check this by requesting client status from director and checking if 
it keeps progressing through the list of files, e.g. if the names of the 
current files being processed by a client FD keep are changing at a steady 
rate. You can also do "estimate listing" for that client and compare esimate 
runtime to other clients which run their backups faster. That will tell you 
how much time FD needs to scan all files in a fileset.


--Ivan

Oh I've already investigated this idea with the following result:

- The estimate command works fine, it reports the correct number AND 
size of the backup to be done


- I've also stripped down the fileset to a single directory with a small 
numer of files


The funny thing about this is that the backup seems to "slow down"  even 
earlier.


I mean if I have 1000 files it "hangs" after 400, but id I strip the 
fileset down to 400 files it hang around 150/200.


It looks like a buffer or memory related problem.

Something like bacula stops reading data from the disk and to place it 
in its process buffer (forgive me if this is not correct).


The FD process lies in the process manager with nearly no activity.

I forgot to mention tha one PC has Windows XP Home and the second 
Windows XP Professional and they both act the very same way.


Other PC's mixed Home/Professional work fine.

That's amazing to me

Thank you for you effort

Alessandro Bianchi


-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula Windows client strange behaviour

[Alex]

James Harper ha scritto:

I mean the average speed slowly goes to 0 b/sec while the job runs.



Definitely sounds like it is stopping cold.

  

The FD is alive, and the job looks running both on the


Director/Storage
  

(Linux) and on the FD client.



Does the FD respond to a cancel from the director?

  

No it doesn't

Does anyone have any idea about what to start checking to have this
thing debugged?



I find that 'Process Monitor' from sysinternals (www.sysinternals.com)
is great for looking at what a process is doing. Maybe you can have a
look at bacula-fd at or around the point where it stops?

James

  

James

Thank you for your reply

The only way to cancel the job is to kill the client process on the XP 
PC or reboot it.


It doesn' answer to a cancel command issued from the bconsole on the 
Director.


Best regards

Alex

--

*SkyNet SRL*

P.zza XXV Aprile 14 - 28021 Borgomanero (NO) - ITALY

Tel. +39 0322 836487/834765 - Fax.+39 0322.836608

[EMAIL PROTECTED] -www.skynet-srl.com 




Le  informazioni  contenute in  questo messaggio sono riservate e 
confidenziali ed è  vietata la diffusione in qualunque forma. 

Qualora Lei non fosse la persona a  cui il presente messaggio  è 
destinato, La invitiamo ad  eliminarlo e a  non leggerlo, dandocene 
gentilmente comunicazione. 

Per qualsiasi informazione in merito si prega di contattare 
[EMAIL PROTECTED] . ( Rif. D.L. 196/200 )


-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] missing part on a DVD... why? what to do?

[Arno Lehmann]

Hi,

06.09.2007 02:01,, Wes Hardaker wrote::
>> "AL" == Arno Lehmann <[EMAIL PROTECTED]> writes:
> 
> AL> That might be one option, but I guess the main problem is that Bacula 
> AL> simply doesn't handle things very well when the writing-to-disk phase 
> AL> has problems. You'd need something more integrated into the SD, or 
> AL> implement some way to signal "re-try this part to the next disk" to 
> AL> the SD.
> 
> I have a hard time believing there is no way to say "whoops, I
> accidentally lost volume 5 in a fire  Please continue as if it
> doesn't exist and all the files that were on it should no longer exist
> in the catalog".  That's really what I need at the moment (I know which
> volumes are bad).
> 
> Trying to guess at how the schema works (danger!) it looks like you
> might be able to look at the jobmedia table and use it to remove stuff
> for a broken volume from the Files table so it would get backed up next
> time and suddenly be needed again.  But that's based on not reading any
> documentation on what the columns actually mean; but if someone says I'm
> on the right track I might go down that road :-)

You're on the track to part of project 1 I think... doing accurate 
restores of - for example - moved files requires these to be backed up 
in the first place, so for backups, Bacula can not only rely on the 
file modification timestamps, but also has to check if files actually 
are in a backup.

So, the common task is to make Bacula not simply back up depending on 
the file timestamps, but to previously check if that file is in an 
available backup. (This requires a major code change and additional 
FD-DIR-communication, so it can not be implemented easily.)

This would probably automatically ensure that files stored in 
unavailable backups are backed up again on the next run.

As of now, Bacula does not check for these condition, it only takes 
the date and time of the last succesful job for a given client/fileset 
combination and saves files with a timestamp after that moment.

Or, in short, your proposed solution will not work.

All IMO and without actually reading the code, by the way.

Arno

-- 
Arno Lehmann
IT-Service Lehmann
www.its-lehmann.de

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] autochanger mount/unmount problem

[Arno Lehmann]

Hi,

06.09.2007 04:39,, Nick Pope wrote::
> On Sep 5, 2007, at 6:26 PM, Arno Lehmann wrote:
> 
>> Hi,
>>
>> 05.09.2007 22:30,, Bob Hetzel wrote::
>>> I've been having this trouble for a while.  It was just posted on the
>>> list to add autochanger=yes into a spot in the bacula-dir.conf  
>>> file and
>>> that solved one problem I had unmounting/mounting...  but I'm  
>>> still left
>>> with this one... anybody have any ideas what's still wrong?
>>>
>>> Bob
>>>
>>> *unmount Dell-PV136T
>>> Automatically selected Catalog: MyCatalog
>>> Using Catalog "MyCatalog"
>>> Connecting to Storage daemon Dell-PV136T at gyrus:9103 ...
>>> 3307 Issuing autochanger "unload slot 18, drive 0" command.
>>> 3995 Bad autochanger "unload slot 18, drive 0": ERR=Child exited  
>>> with code 1
>> This is an issue in the mtx-changer script. In this case, mtx itself
>> produced an error.
>>
>> Most likely, you either need to offline the tape before it can be
>> unloaded. Look into the mtx-changer script, there is some inline
>> documentation available.
>>
>> Arno
>>
> 
> I recently acquired a136T and I think I finally have it working with  
> Bacula.
> 
> I was getting errors until I put this:
> 
> Offline on Unmount = yes

Good advice... I really forgot that directive :-)

Definitely a better approach than doing this in mtx-changer...

Arno

> in bacula-sd.conf as suggested above.  This is with an HP LTO1 drive  
> installed and an Opteron server running FreeBSD 7.0-current amd64.   
> My error was not the same as yours, but I'm running FreeBSD.  It's  
> worth a shot.
> 
> -Nick
> 
> 
>>> Results=Unloading drive 0 into Storage Element 18...mtx: Request  
>>> Sense:
>>> Long Report=yes
>>> mtx: Request Sense: Valid Residual=no
>>> mtx: Request Sense: Error Code=70 (Current)
>>> mtx: Request Sense: Sense Key=Illegal Request
>>> mtx: Request Sense: FileMark=no
>>> mtx: Request Sense: EOM=no
>>> mtx: Request Sense: ILI=no
>>> mtx: Request Sense: Additional Sense Code = 53
>>> mtx: Request Sense: Additional Sense Qualifier = 01
>>> mtx: Request Sense: BPV=no
>>> mtx: R3002 Device "IBMLTO2-1" (/dev/nst0) unmounted.
>>> *mount
>>> Automatically selected Storage: Dell-PV136T
>>> Enter autochanger slot: 18
>>> 3301 Issuing autochanger "loaded? drive 0" command.
>>> 3302 Autochanger "loaded? drive 0", result is Slot 18.
>>> 3301 Issuing autochanger "loaded? drive 0" command.
>>> 3302 Autochanger "loaded? drive 0", result is Slot 18.
>>> 3001 Mounted Volume: LTO219L2
>>> 3001 Device "IBMLTO2-1" (/dev/nst0) is mounted with Volume "LTO219L2"
>>>
>>> - 
>>> 
>>> This SF.net email is sponsored by: Splunk Inc.
>>> Still grepping through log files to find problems?  Stop.
>>> Now Search log events and configuration files using AJAX and a  
>>> browser.
>>> Download your FREE copy of Splunk now >>  http://get.splunk.com/
>>> ___
>>> Bacula-users mailing list
>>> Bacula-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/bacula-users
>> -- 
>> Arno Lehmann
>> IT-Service Lehmann
>> www.its-lehmann.de
>>
>> -- 
>> ---
>> This SF.net email is sponsored by: Splunk Inc.
>> Still grepping through log files to find problems?  Stop.
>> Now Search log events and configuration files using AJAX and a  
>> browser.
>> Download your FREE copy of Splunk now >>  http://get.splunk.com/
>> ___
>> Bacula-users mailing list
>> Bacula-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/bacula-users
> 
> 
> -
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users

-- 
Arno Lehmann
IT-Service Lehmann
www.its-lehmann.de

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] restore: device is blocked waiting for media

[Arno Lehmann]

Hi,

06.09.2007 09:11,, Luca Ferrari wrote::
> On Wednesday 5 September 2007 Arno Lehmann's cat, walking on the keyboard, 
> wrote:
> 
>> I think we'll need some more detailed information here... does Bacula
>> send a notification to load the volume it wants, what are the Media
>> Types, and so on... the relevant parts of your configuration might
>> help here.
> 
> In fact looking into the messages I found:
> 
> 05-set 18:54 backup-sd: Please mount 
> Volume "mammuth_uff_g_job-2007-08-30--23-47" on Storage 
> Device "mammuth_device" (/backup/mammuth) for Job 
> restore_mySelf.2007-09-05_17.53.30
> 
> so I manually did a mount of the device and the restore process is now 
> running. Why it is not automatically mounting the device?

Is this device defined as an autochanger?

Arno

-- 
Arno Lehmann
IT-Service Lehmann
www.its-lehmann.de

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Backup progress information

[Arno Lehmann]

Hi,

06.09.2007 09:22,, Ruben Lopez wrote::
> Hi,
> 
> Is there any way of knowing the progress of one backup?

Yes... try 'sta sd=' and 'sta 
client=' in a console.

> I mean something 
> like "copied 27 of 145 files" or "copied 50 of 145 GB"?

That's not possible, because Bacula does not know the total amount of 
data or number of files before the job is complete.

You can get a good estimate using the... surprise... 'estimate' command.

Arno

> Thanks.
> 
> -
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users

-- 
Arno Lehmann
IT-Service Lehmann
www.its-lehmann.de

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] How to use internal variables in bacula-dir.conf?

[Arno Lehmann]

Hi,

06.09.2007 09:41,, [EMAIL PROTECTED] wrote::
> Hi, i'm trying to use internal bacula-variables in bacula-dir.conf
> in the fileset-section:

What kind of internal variables do you refer to? The ones mentioned in 
  the section "Variable expansion"? Then note the following:

"Please note that as of version 1.37, the Variable Expansion is 
deprecated and replaced by Python scripting (not yet documented).

Variable expansion is somewhat similar to Unix shell variable 
expansion. Currently (version 1.31), it is used only in format labels, 
but in the future, it will most likely be used in more places."

Adding these statements, I'd say that it's best not to use this feature...

But note that you can use Baculas syntax to get its configuration file 
as output of a program.

Arno

> 
> File = "|sh -c 'grep -i -s \"^$Client\"
> /path/to/bacula/etc/test-disklist | cut -f2 -d@ '"
> 
> The corresponding test-disklist is:
> 
> # test-disklist # format: hostname@/path/to/backup-dir_or_file # 
> hostname1@/tmp/xxx/dir1 hostname1@/tmp/xxx/file1 
> hostname2@/var/spool/dir-xxx hostname3@/home/username
> 
> During runtime the internal bacula-variable $Client ( i also tried
> ${Client} with and without '\' ) is always empty so every line is
> matched. How to do ?
> 
> Thanks, Markus 
> _
>  Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu
> sparen! 
> http://smartsurfer.web.de/?mc=100071&distributionid=0066
> 
> 
> -
>  This SF.net email is sponsored by: Splunk Inc. Still grepping
> through log files to find problems?  Stop. Now Search log events
> and configuration files using AJAX and a browser. Download your
> FREE copy of Splunk now >>  http://get.splunk.com/ 
> ___ Bacula-users
> mailing list Bacula-users@lists.sourceforge.net 
> https://lists.sourceforge.net/lists/listinfo/bacula-users

-- 
Arno Lehmann
IT-Service Lehmann
www.its-lehmann.de

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Purging ancestor of incremental backup

[Marek Simon]

Hi.
I accidentaly get myself to the situation, that one of my backup 
storages is filled up and no space on disk is free. I had to purge some 
of my backups. If there is one full backup and 1st, 2nd 3rd incremental 
backup, and I purge volume with the 2nd incremental backup, which backup 
will the 4th incremental backup get as the reference? Does it take 3rd 
(which is inconsistent since 2nd incr. backup is missing) or 1st, which 
is correct?
Marek

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] restore: device is blocked waiting for media

[Luca Ferrari]

On Thursday 6 September 2007 Arno Lehmann's cat, walking on the keyboard, 
wrote:
> Hi,
>
> 06.09.2007 09:11,, Luca Ferrari wrote::
> > On Wednesday 5 September 2007 Arno Lehmann's cat, walking on the
> > keyboard,
> >
> > wrote:
> >> I think we'll need some more detailed information here... does Bacula
> >> send a notification to load the volume it wants, what are the Media
> >> Types, and so on... the relevant parts of your configuration might
> >> help here.
> >
> > In fact looking into the messages I found:
> >
> > 05-set 18:54 backup-sd: Please mount
> > Volume "mammuth_uff_g_job-2007-08-30--23-47" on Storage
> > Device "mammuth_device" (/backup/mammuth) for Job
> > restore_mySelf.2007-09-05_17.53.30
> >
> > so I manually did a mount of the device and the restore process is now
> > running. Why it is not automatically mounting the device?
>
> Is this device defined as an autochanger?


No, here it is:

Device {
   Name = mammuth_device
   Archive Device = /backup/mammuth
   Device Type = File
   Removable Media = No
   Random Access = Yes
   Media Type = mammuth_disk_storage
   LabelMedia = yes
   AutomaticMount = yes
}

any idea?

Thanks,
Luca

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] SQL error after upgrading 2.0.3 -> 2.2.0

[Arno Lehmann]

Hi,

06.09.2007 08:23,, Silver Salonen wrote::
> Hello.
> 
> Yesterday I upgraded Bacula (dir, sd, fd) from 2.0.3 to 2.2.0 on FreeBSD-5.3. 
> I use Bacula with MySQL 4.0.27. In the evening all the backups failed with 
> error:
> =
> 06-Sep 00:33 mydom-sd: Job write elapsed time = 00:00:44, Transfer rate = 
> 2.103 M bytes/second
> 06-Sep 00:33 mydom-dir: myser-conf.2007-09-06_00.32.49 Fatal error: Can't 
> fill 
> Path table Query failed: INSERT INTO Path (Path) SELECT a.Path 
> FROM  (SELECT DISTINCT Path FROM batch) AS a  
>  
> WHERE NOT EXISTS(SELECT Path  FROM Path 
> AS pWHERE p.Path = a.Path) : ERR=You have an error in 
> your SQL syntax.  Check the manual that corresponds to your MySQL server 
> version for the right syntax to use near 'SELECT DISTINCT Path 
> FROM batch) AS a   WHE
> =
> 
> May the problem be in MySQL, i.e. Bacula 2.2 isn't compatible with MySQL 4.0 
> although 2.0 was?

Yes... as far as I know, subqueries or nested selects are available 
ony with MySQL 4.1 and up.

Arno

-- 
Arno Lehmann
IT-Service Lehmann
www.its-lehmann.de

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Purging ancestor of incremental backup

[Martin Simmons]

> On Thu, 06 Sep 2007 11:07:17 +0200, Marek Simon said:
> 
> Hi.
> I accidentaly get myself to the situation, that one of my backup 
> storages is filled up and no space on disk is free. I had to purge some 
> of my backups. If there is one full backup and 1st, 2nd 3rd incremental 
> backup, and I purge volume with the 2nd incremental backup, which backup 
> will the 4th incremental backup get as the reference? Does it take 3rd 
> (which is inconsistent since 2nd incr. backup is missing) or 1st, which 
> is correct?

It will take the newest one in the catalog, i.e. the 3rd.  You will probably
need to purge the 3rd one as well.

__Martin

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] bscan 2.2.0 can't find a volume

[Silver Salonen]

Hi.

I'm using Bacula 2.2.0 on FreeBSD-6.2 with MySQL 5.0.45.
I started to restore some files from wx-console, but some of the files seemed 
to be missing, so I though I'll try syncing backups' database with backups' 
contents.

I keep all the backups on HDD - clients are put into separate folders and all 
the backups are in separate files (i.e. maximum volume jobs = 1). So I'm 
trying to sync some incremental backups:
=
# bscan -c /usr/local/etc/bacula-sd.conf -v -V cl1-s2-incr-0007\|
cl1-s2-incr-0008\|cl1-s2-incr-0009\|cl1-s2-incr-0010\|cl1-s2-incr-0011\|
cl1-s2-incr-0012 -h localhost -P mysql-pswd -s -m /backup/bacula/cl1-s2
=

At first bscan says:
=
06-Sep 14:46 bscan: bscan Error: butil.c:147 Volume name or names is too long. 
Please use a .bsr file.
=

But well, it starts scanning and updating records. After the last volume, it 
reports:
=
06-Sep 14:49 bscan: Fatal Error at dev.c:482 because:
dev.c:480 Could not open: /backup/bacula/cl1-s2/cl1-s2, ERR=No such file or 
directory
06-Sep 14:49 bscan: bscan Warning: acquire.c:206 Read open 
device "device-cl1-s2" (/backup/bacula/cl1-s2) Volume "cl1-s2" failed: 
ERR=dev.c:480 Could not open: /backup/bacula/cl1-s2/cl1-s2, ERR=No such file 
or directory
=

and waits for me to:
=
Mount Volume "cl1-s2" on device "device-cl1-s2" (/backup/bacula/cl1-s2) and 
press return when ready:
=

I don't get it - why does Bacula come up with volume 'cl1-s2'? Am I misusing 
bscan?

-- 
Silver

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Bacula version 2.2.2 release

[Kern Sibbald]

Hello,

I have just released the source tar and Win32 binary files for Bacula version 
2.2.2 to the Source Forge release area.  This is a bug fix update to 2.2.1, 
primarily to correct a seg fault in the Win32 Director.  This problem only 
affects "older" OSes that do not have a va_copy() facility, and this release 
was made because the Win32 binaries must be updated, so a simple patch would 
not suffice.

The changes are as follows:

Version 2.2.2 is a bug fix release to 2.2.1
- Detect if new PosgreSQL batch insert API is present.
- Correct incorrect mempool call causing Director crash.
- Update spec files for 2.2.1 release

I doubt that there will be rpms for this version since it does not affect 
Linux, FreeBSD, or Solaris machines.  If you have some older OS, such as AIX 
or HP, you may want to use this release rather than 2.2.1.  

Also, any user attempting to run the Win32 servers (Director or SD) should 
upgrade to the new Win32 binaries.

If you are using the Win32 2.2.1 FD, there is no need to upgrade.

Best regards,

Kern

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Bacula on a Linksys NSLU2 or similar

[James Harper]

Has anyone attempted to run the Bacula FD on a Linksys NSLU2 or similar
NAS device? For anyone who doesn't know, the NSLU2 (as shipped from
Linksys) is a ARM (I think) based NAS box with USB2 ports on it for
plugging in external disks. There are a few Linux distributions
available for it, including Debian and OpenWRT.

I ask because one of our clients has a building which is physically
separate from the main building but still connected via high speed
network, which would make an excellent semi-offsite backup, but the
environment is pretty hostile (they are a foundry - lots of metal dust
and sand) so anything with a fan is not such a good idea. Obviously
there are plenty of x86 based box's which would probably meet the
criteria, but the NSLU2 is pretty cheap and if it works it would be
perfect.

Obviously this doesn't replace their current really-offsite backups, but
it would give them easier access to the data if required, and a fire in
the main office would be unlikely to reach this other building.

Thanks

James

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula on a Linksys NSLU2 or similar

[James Harper]

> 
> Has anyone attempted to run the Bacula FD on a Linksys NSLU2 or
similar
> NAS device? For anyone who doesn't know, the NSLU2 (as shipped from
> Linksys) is a ARM (I think) based NAS box with USB2 ports on it for
> plugging in external disks. There are a few Linux distributions
> available for it, including Debian and OpenWRT.

Hmmm... on further reading it doesn't appear to have a gigabit network
interface, only 10/100, which limits it's usefulness a bit... anyone
know of something similar which does have a gigabit interface?

Thanks

James

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula on a Linksys NSLU2 or similar

[Hristo Benev]

James Harper wrote:
> Has anyone attempted to run the Bacula FD on a Linksys NSLU2 or similar
> NAS device? For anyone who doesn't know, the NSLU2 (as shipped from
> Linksys) is a ARM (I think) based NAS box with USB2 ports on it for
> plugging in external disks. There are a few Linux distributions
> available for it, including Debian and OpenWRT.
>
> I ask because one of our clients has a building which is physically
> separate from the main building but still connected via high speed
> network, which would make an excellent semi-offsite backup, but the
> environment is pretty hostile (they are a foundry - lots of metal dust
> and sand) so anything with a fan is not such a good idea. Obviously
>   
Just for this I'll not recommend placing HDD backup there. If you could 
get a room (even small one)there with air cleaning unit it is possible.

> there are plenty of x86 based box's which would probably meet the
> criteria, but the NSLU2 is pretty cheap and if it works it would be
> perfect.
>
> Obviously this doesn't replace their current really-offsite backups, but
> it would give them easier access to the data if required, and a fire in
> the main office would be unlikely to reach this other building.
>
> Thanks
>
> James
>
> -
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>   

Just an idea Why you do not use NSLU2 in his primary task (NAS 
drive) and put your backup there instead of running bacula on it

Hristo

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Frequent Intervention emails

[Support]

Dear Arno

Should I do a "formal" test - ie force the error and if it does occur
again report the bug?

It would not be hard to set up - just load the autochanger with cartridges
that cannot be appended, recycled etc.

Regards
Stephen Carr

Arno Lehmann wrote:
> Hi,
>
> 06.09.2007 00:07,, Support wrote::
>> Dear Arno
>>
>> Yes I do have the heart beat interval set to 2 minutes.
>>
>> I will remove it.
>
> This is definitely a bug then... I encountered it in one installation,
> but never got around to verify and report it.
>
>> I had put it there to see if it would help with client disconnects  it
>> did
>> not.
>
> Just use the heartbeat setting on the client side - in my case, that
> worked. Obviously, it won't help if it's not the connection timeout
> that gets you into trouble.
>
>> FYI If a client disconnects I found out the default TCP timeout of 2
>> hours
>> is timed from the initial connection time.
>
> Interesting... I would have thought it should start at the last
> succesful transfer of data, but, when a client is not responding at
> all, that would be the connection setup itself...
>
> Arno
>
>> Thanks
>> Stephen Carr
>>
>> Arno Lehmann wrote:
>>> Hello,
>>>
>>> 05.09.2007 07:00,, Support wrote::
 Dear All

 Anyone have an idea as to where I can change a setting to reduce the
 frequency of "Bacula: Intervention needed ..." that occur every 2
 minutes.
>>> Normally it sends mail immediately, after one hour, two hours, four
>>> hours, and so on...
>>>
 This happened when I forgot to change tapes in an autoloader and for 5
 hours got a 150+ emails requesting I mount another volume.

 I would like an email every 15 or 20 minutes.

 I think this maybe autoloader/autochanger specific as sometime back I
 had
 a similar pronlem with a DLT unit and it sent an email every 20
 minutes.

 My suspicion is the fix or hack is in wait.c in /stored
>>> Is it possible you have a heartbeat interval set in the SD?
>>>
>>> Arno
>>>
 Thanks
 Stephen Carr






 -
 This SF.net email is sponsored by: Splunk Inc.
 Still grepping through log files to find problems?  Stop.
 Now Search log events and configuration files using AJAX and a
 browser.
 Download your FREE copy of Splunk now >>  http://get.splunk.com/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users
>>> --
>>> Arno Lehmann
>>> IT-Service Lehmann
>>> www.its-lehmann.de
>>>
>>> -
>>> This SF.net email is sponsored by: Splunk Inc.
>>> Still grepping through log files to find problems?  Stop.
>>> Now Search log events and configuration files using AJAX and a browser.
>>> Download your FREE copy of Splunk now >>  http://get.splunk.com/
>>> ___
>>> Bacula-users mailing list
>>> Bacula-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/bacula-users
>>>
>>>
>>
>>
>>
>> -
>> This SF.net email is sponsored by: Splunk Inc.
>> Still grepping through log files to find problems?  Stop.
>> Now Search log events and configuration files using AJAX and a browser.
>> Download your FREE copy of Splunk now >>  http://get.splunk.com/
>> ___
>> Bacula-users mailing list
>> Bacula-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
> --
> Arno Lehmann
> IT-Service Lehmann
> www.its-lehmann.de
>
> -
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
>



-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Frequent Intervention emails

[Arno Lehmann]

Hi,

06.09.2007 14:42,, Support wrote::
> Dear Arno
> 
> Should I do a "formal" test - ie force the error and if it does occur
> again report the bug?

That's what I would have done, if the system where this happened 
wouldn't work without SD-side heartbead interval and could be 
"misused" for this sort of test...

> It would not be hard to set up - just load the autochanger with cartridges
> that cannot be appended, recycled etc.

Quite true. Make sure you include some debug trace output showing what 
the SD does - in my case, it showed quite clearly what happened, and I 
could locate the code leading to this behaviour quite easily. 
Unfortunately, I'm not sure which debug level I used.

Arno

> Regards
> Stephen Carr
> 
> Arno Lehmann wrote:
>> Hi,
>>
>> 06.09.2007 00:07,, Support wrote::
>>> Dear Arno
>>>
>>> Yes I do have the heart beat interval set to 2 minutes.
>>>
>>> I will remove it.
>> This is definitely a bug then... I encountered it in one installation,
>> but never got around to verify and report it.
>>
>>> I had put it there to see if it would help with client disconnects  it
>>> did
>>> not.
>> Just use the heartbeat setting on the client side - in my case, that
>> worked. Obviously, it won't help if it's not the connection timeout
>> that gets you into trouble.
>>
>>> FYI If a client disconnects I found out the default TCP timeout of 2
>>> hours
>>> is timed from the initial connection time.
>> Interesting... I would have thought it should start at the last
>> succesful transfer of data, but, when a client is not responding at
>> all, that would be the connection setup itself...
>>
>> Arno
>>
>>> Thanks
>>> Stephen Carr
>>>
>>> Arno Lehmann wrote:
 Hello,

 05.09.2007 07:00,, Support wrote::
> Dear All
>
> Anyone have an idea as to where I can change a setting to reduce the
> frequency of "Bacula: Intervention needed ..." that occur every 2
> minutes.
 Normally it sends mail immediately, after one hour, two hours, four
 hours, and so on...

> This happened when I forgot to change tapes in an autoloader and for 5
> hours got a 150+ emails requesting I mount another volume.
>
> I would like an email every 15 or 20 minutes.
>
> I think this maybe autoloader/autochanger specific as sometime back I
> had
> a similar pronlem with a DLT unit and it sent an email every 20
> minutes.
>
> My suspicion is the fix or hack is in wait.c in /stored
 Is it possible you have a heartbeat interval set in the SD?

 Arno

> Thanks
> Stephen Carr
>
>
>
>
>
>
> -
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a
> browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
 --
 Arno Lehmann
 IT-Service Lehmann
 www.its-lehmann.de

 -
 This SF.net email is sponsored by: Splunk Inc.
 Still grepping through log files to find problems?  Stop.
 Now Search log events and configuration files using AJAX and a browser.
 Download your FREE copy of Splunk now >>  http://get.splunk.com/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users


>>>
>>>
>>> -
>>> This SF.net email is sponsored by: Splunk Inc.
>>> Still grepping through log files to find problems?  Stop.
>>> Now Search log events and configuration files using AJAX and a browser.
>>> Download your FREE copy of Splunk now >>  http://get.splunk.com/
>>> ___
>>> Bacula-users mailing list
>>> Bacula-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/bacula-users
>> --
>> Arno Lehmann
>> IT-Service Lehmann
>> www.its-lehmann.de
>>
>> -
>> This SF.net email is sponsored by: Splunk Inc.
>> Still grepping through log files to find problems?  Stop.
>> Now Search log events and configuration files using AJAX and a browser.
>> Download your FREE copy of Splunk now >>  http://get.splunk.com/
>> ___
>> Bacula-users mailing list
>> Bacula-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/bacula-users
>>
>>
> 
> 

-- 
Arno Lehmann
IT-Service Lehmann
www.its-lehmann.de

---

Re: [Bacula-users] bscan 2.2.0 can't find a volume

[Arno Lehmann]

Hi,

06.09.2007 13:52,, Silver Salonen wrote::
> Hi.
> 
> I'm using Bacula 2.2.0 on FreeBSD-6.2 with MySQL 5.0.45.
> I started to restore some files from wx-console, but some of the files seemed 
> to be missing, so I though I'll try syncing backups' database with backups' 
> contents.
> 
> I keep all the backups on HDD - clients are put into separate folders and all 
> the backups are in separate files (i.e. maximum volume jobs = 1). So I'm 
> trying to sync some incremental backups:
> =
> # bscan -c /usr/local/etc/bacula-sd.conf -v -V cl1-s2-incr-0007\|
> cl1-s2-incr-0008\|cl1-s2-incr-0009\|cl1-s2-incr-0010\|cl1-s2-incr-0011\|
> cl1-s2-incr-0012 -h localhost -P mysql-pswd -s -m /backup/bacula/cl1-s2
> =
> 
> At first bscan says:
> =
> 06-Sep 14:46 bscan: bscan Error: butil.c:147 Volume name or names is too 
> long. 
> Please use a .bsr file.
> =

That about explains it, I think.

> But well, it starts scanning and updating records. After the last volume, it 
> reports:
> =
> 06-Sep 14:49 bscan: Fatal Error at dev.c:482 because:
> dev.c:480 Could not open: /backup/bacula/cl1-s2/cl1-s2, ERR=No such file or 
> directory
> 06-Sep 14:49 bscan: bscan Warning: acquire.c:206 Read open 
> device "device-cl1-s2" (/backup/bacula/cl1-s2) Volume "cl1-s2" failed: 
> ERR=dev.c:480 Could not open: /backup/bacula/cl1-s2/cl1-s2, ERR=No such file 
> or directory
> =
> 
> and waits for me to:
> =
> Mount Volume "cl1-s2" on device "device-cl1-s2" (/backup/bacula/cl1-s2) and 
> press return when ready:
> =
> 
> I don't get it - why does Bacula come up with volume 'cl1-s2'? Am I misusing 
> bscan?

bscan truncated the -V option.

Your best choice would be to prepare a bsr file, or scan the volumes 
in several batches.

Arno

-- 
Arno Lehmann
IT-Service Lehmann
www.its-lehmann.de

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Webmin Bacula-Module does not connect to database

[Ferdi Giese]

Hi,

bacula-2.1.1 is working fine on mysql-database at localhost (SLES10-SP1), but 
when I want to use the Webmin-Module for administration, it echos "Failed to 
connect to the Bacula database: ../config.cgi?bacula-backup. Maybe it is not 
set up, or the module configuration is incorrect."

I tried editing the /etc/webmin/bacula-backup/config-file in many ways (e.g. 
with "host=localhost" or "host=127.0.0.1", with "pass=""), but nothing works. I 
need Your help.

Regards
Ferdi


-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Using tape utility tools

[Gustavo Noronha]

Hello,

One question we are as of yet unable to answer is what daemons should be
stopped while using volume utilities such as btape or bscan. Should we
stop the SD? I was of the opinion that simply issuing 'umount' in the
director should be enough, is that impression correct?

Thanks,

-- 
Gustavo Noronha <[EMAIL PROTECTED]>
 Coordenação de Sustentação e Segurança/CGI


signature.asc
Description: Esta é uma parte de mensagem	assinada digitalmente
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] bscan and HFS+?

[Martin Simmons]

> On Wed, 05 Sep 2007 17:15:40 -0500, Jim Creason said:
> 
> Hi All,
> 
> Trying to use bscan to recover files from a purged volume (client 
> e-mailed about deleted files the day after the volume was purged, of 
> course...), clients are OSX , and the below is what I'm getting from a 
> dry run not modifying the database.  I'm assuming type=14 is the 
> resource fork and type=13 are chunks of the data fork.  Has anybody done 
> this successfully?  I was running 1.3.8, but just upgraded to 2.2.0.
> 
> bscan: bscan.c:792 Unknown stream type!!! stream=14 len=32
> bscan: bscan.c:792 Unknown stream type!!! stream=13 len=32768
> bscan: bscan.c:792 Unknown stream type!!! stream=13 len=32768
> bscan: bscan.c:792 Unknown stream type!!! stream=13 len=32768
> bscan: bscan.c:792 Unknown stream type!!! stream=13 len=32768
> bscan: bscan.c:792 Unknown stream type!!! stream=13 len=32768
> bscan: bscan.c:792 Unknown stream type!!! stream=13 len=31013
> bscan: bscan.c:792 Unknown stream type!!! stream=14 len=32
> bscan: bscan.c:792 Unknown stream type!!! stream=13 len=32768
> bscan: bscan.c:792 Unknown stream type!!! stream=13 len=8777
> bscan: bscan.c:792 Unknown stream type!!! stream=14 len=32

Actually, 13 is the resource fork and 14 is the HFS+ attributes.  I think it
is safe to ignore these messages, though the Job.JobBytes in the catalog will
be slightly too low.

__Martin

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula on a Linksys NSLU2 or similar

[Ryan Novosielski]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

James Harper wrote:
>> Has anyone attempted to run the Bacula FD on a Linksys NSLU2 or
> similar
>> NAS device? For anyone who doesn't know, the NSLU2 (as shipped from
>> Linksys) is a ARM (I think) based NAS box with USB2 ports on it for
>> plugging in external disks. There are a few Linux distributions
>> available for it, including Debian and OpenWRT.
> 
> Hmmm... on further reading it doesn't appear to have a gigabit network
> interface, only 10/100, which limits it's usefulness a bit... anyone
> know of something similar which does have a gigabit interface?

Over a WAN, though, how much can this really matter? Or have I
misunderstood?

- --
  _  _ _  _ ___  _  _  _
 |Y#| |  | |\/| |  \ |\ |  | |Ryan Novosielski - Systems Programmer II
 |$&| |__| |  | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922)
 \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFG4AfKmb+gadEcsb4RAutDAKCptDrhMJs3HCXkwlFGAwSZ1CK93gCffYkk
bW2jwU57lV6fazmmt0zEIK4=
=z5aW
-END PGP SIGNATURE-


-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Using tape utility tools

[Ryan Novosielski]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Gustavo Noronha wrote:
> Hello,
> 
> One question we are as of yet unable to answer is what daemons should be
> stopped while using volume utilities such as btape or bscan. Should we
> stop the SD? I was of the opinion that simply issuing 'umount' in the
> director should be enough, is that impression correct?
> 
> Thanks,

I believe it is, provided you can be sure nothing will try to mount the
tape while you're away from bconsole (I think umount is blocking
though). I believe the rule of thumb is if you CAN access the tape drive
(you won't be able to outside of bconsole when a tape is mounted), it is OK.

- --
  _  _ _  _ ___  _  _  _
 |Y#| |  | |\/| |  \ |\ |  | |Ryan Novosielski - Systems Programmer II
 |$&| |__| |  | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922)
 \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFG4Airmb+gadEcsb4RAq2YAJ4gt9lyWL7F/B/EzKg/tfrJJ13wvwCfV4e1
+I/l9rdeERZuQTz/l9P60Ws=
=IfNA
-END PGP SIGNATURE-


-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] old records in database

[David Pospisil]

Hi,
my catalog database has 10G, but there is a lot of old records (file records) 
from Jobs which do not exist now. Will the old records be pruned or will they 
stay in database forever? Is there any way how to delete old records from 
database?


David Pospisil

2.6.21.5 #1 SMP Tue Jul 3 14:43:04 CEST 2007 x86_64 GNU/Linux
bacula 1.38.11-8 from Debian Linux (Etch)

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] old records in database

[Dan Langille]

On 6 Sep 2007 at 16:14, David Pospisil wrote:

> Hi,
> my catalog database has 10G, but there is a lot of old records (file records) 
> from Jobs which do not exist now. Will the old records be pruned or will they 
> stay in database forever? Is there any way how to delete old records from 
> database?

They will be pruned if you specify they should be pruned.  Look at 
retention.  There are values for each of Job, File, and Volume.  Look 
also at AutoPrune.

-- 
Dan Langille - http://www.langille.org/
Available for hire: http://www.freebsddiary.org/dan_langille.php



-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Using tape utility tools

[Dan Langille]

On 6 Sep 2007 at 10:33, Gustavo Noronha wrote:

> One question we are as of yet unable to answer is what daemons should be
> stopped while using volume utilities such as btape or bscan. Should we
> stop the SD? I was of the opinion that simply issuing 'umount' in the
> director should be enough, is that impression correct?

Might be.  Unless you have automount on.

Have you encountered a problem?
-- 
Dan Langille - http://www.langille.org/
Available for hire: http://www.freebsddiary.org/dan_langille.php



-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] old records in database

[David Pospisil]

But I think that bacula prune old job records after doing the job of the same 
name. Example: I have a job called JOB-a, so old job records will be pruned 
after doing job JOB-a (because bacula chceck old records after doing the job 
of the same name), but I am not sure.
Second thing is that I have never seen configuration for old jobs so I dont 
know if they had autoprune set on of off :(

Thx for reply,
David


Dne čtvrtek 06 září 2007 16:53 jste napsal(a):
> On 6 Sep 2007 at 16:14, David Pospisil wrote:
> > Hi,
> > my catalog database has 10G, but there is a lot of old records (file
> > records) from Jobs which do not exist now. Will the old records be pruned
> > or will they stay in database forever? Is there any way how to delete old
> > records from database?
>
> They will be pruned if you specify they should be pruned.  Look at
> retention.  There are values for each of Job, File, and Volume.  Look
> also at AutoPrune.

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] missing part on a DVD... why? what to do?

[Wes Hardaker]

> "AL" == Arno Lehmann <[EMAIL PROTECTED]> writes:

AL> As of now, Bacula does not check for these condition, it only takes 
AL> the date and time of the last succesful job for a given client/fileset 
AL> combination and saves files with a timestamp after that moment.

AL> Or, in short, your proposed solution will not work.

Ah.  Well, thanks for the notes.  That does mean, though, that I can
invalidate the job that created the broken volume so the next
incremental would effectively back up from the one previous to it?

(though this doesn't work if another incremental had run since then; IE,
you'd have to nuke the last job before the next incremental gets run or
nuke all jobs after the broken one).

AL> All IMO and without actually reading the code, by the way.

As I mentioned; same here ;-)
-- 
"In the bathtub of history the truth is harder to hold than the soap,
 and much more difficult to find."  -- Terry Pratchett

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Using tape utility tools

[Gustavo Noronha]

Em Qui, 2007-09-06 às 10:53 -0400, Dan Langille escreveu:
> On 6 Sep 2007 at 10:33, Gustavo Noronha wrote:
> 
> > One question we are as of yet unable to answer is what daemons should be
> > stopped while using volume utilities such as btape or bscan. Should we
> > stop the SD? I was of the opinion that simply issuing 'umount' in the
> > director should be enough, is that impression correct?
> 
> Might be.  Unless you have automount on.
> 
> Have you encountered a problem?

Well, yesterday I did that and was using bscan to do a dry-run reimport
of a tape into the catalog. This went OK, but then all backups failed
during the night because the SD was not responding correctly, even
though I had manually mounted the volume again. A restart of the SD made
it work again. I didn't want to have to stop the SD because I'd like
spooling to keep going while we do that kind of operation, though.

We have a PowerVault 132T autochanger with an IBM LTO2 drive. We're
using Bacula 1.38.11 from Debian sarge backport packages.

See you,

-- 
Gustavo Noronha <[EMAIL PROTECTED]>
 Coordenação de Sustentação e Segurança/CGI


signature.asc
Description: Esta é uma parte de mensagem	assinada digitalmente
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] All recovered files are corrupted.

[David Michal]

Hi,

I had to use bextract. I’ve used this syntax:

/usr/sbin/bextract -i include-list -V volume-file client-device /home/dmichal/

Everything went fine, but after recovery process I’ve found all the files 
corrupted. Every of the file is now beginning with something like:

“ 


   [1]   Ô 


„   $   @   [1]  [1]      _ibDèïù(äÔš,[1]  [1] ” $ ÿ­ 
    _ibDèïù(äÔš, [1]   $ ¿     _ibDèïù(äÔš,[1]ÿ­ [1]  [1]   
 ÿ­   ©  [1] ![1] i*  “

 

And all end lines in at least all text files were replaced with hex: 0D 0A.

 

Does anybody know what happened? Why all my files were changed by bextract, or 
may by bacula when stored.

 

All files are related to client where windows version 2.0.1 client. On server 
there is 2.0.2 linux version.

 

Thanks for any idea,

David

 

 

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] StorageTek C2?

[Jason Harley]

Hello list,

Has anyone had any experience using Bacula (on Linux, Solaris or FreeBSD 
-- I'm platform agnostic) with a StorageTek C2 autochanger?

Cheers,
./JRH

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Post-upgrade database issues, Bacula 1.38.11 to 2.2.1 on Solaris

[Jody McDonnell]

Hi all,

I spent the day yesterday upgrading the Bacula install on our Solaris
servers from 1.38.11 to 2.2.1. Things initially seemed to work, but
the overnight incremental backup failed with some database issues.

I should note that I am using MySQL 4.0.18 with Bacula. I've been
using this version since I started using Bacula three years ago with
version 1.34.2. I haven't upgraded our version of MySQL, mainly
because I wasn't exactly sure of the steps required to upgrade MySQL
without risking data loss.

The only database-related maintenance I performed before the upgrade
was to compact the MySQL database via the mysqldump utility, as per
section 21.2 of the Bacula manual.

After building and installing Bacula 2.2.1, I ran the
"update_mysql_tables_9_to_10" script to update my database tables from
1.38-era to 2.0-era.

I seem to have encountered two issues. The first seems to be related
to the fact that my initial configuration script included the
"--enable-batch-insert" directive. The nightly incremental backup
failed with the following error messages:

==
06-Sep 09:39 kodos-dir: BackupKang.2007-09-06_01.05.00 Fatal error:
sql_create.c:730 sql_create.c:730 insert INSERT INTO batch VALUES
(5432,2083,'/repo/cvsroot/est/build/','est.tar.gz,v','gAAW C2IJ IFt B
Bw B A 3ezOL CAA G8Ew BG3vmb BG3uk8 BG3uk9 A A
C','oqzs5tC+gpBJ0EESyZoa7A') failed:
Table 'bacula.batch' doesn't exist
06-Sep 09:39 kodos-dir: sql_create.c:730 INSERT INTO batch VALUES
(5432,2083,'/repo/cvsroot/est/build/','est.tar.gz,v','gAAW C2IJ IFt B
Bw B A 3ezOL CAA G8Ew BG3vmb BG3uk8 BG3uk9 A A
C','oqzs5tC+gpBJ0EESyZoa7A')
06-Sep 09:39 kodos-dir: BackupKang.2007-09-06_01.05.00 Fatal error:
catreq.c:478 Attribute create error. sql_find.c:333 Request for Volume
item 1 greater than max 0 or less than 1
[...etc...]
==

There was a long pause in the backup while Bacula requested that a new
tape be mounted. From searching through past posts to this list, it
sounds like this is due to a timeout by MySQL, and I think that it
might be possible to get around the issue by changing the wait_timeout
value in my.cnf to some really large value.

Since I only have a single-tape DAT drive, backups can sometimes be
stalled over an entire weekend waiting for a new tape to be mounted.
Since I didn't really want to change the wait_timeout to be some huge
number like 4 days, I decided to recompile Bacula 2.2.1 without the
"--enable-batch-insert" directive. I hadn't previously noticed any
database performance issues, anyway.

My second attempt at an incremental backup failed with the following
error message:

==
06-Sep 12:15 kodos-dir: BackupKang.2007-09-06_11.50.55 Fatal error:
Can't fill Path table Query failed: INSERT INTO Path (Path)
SELECT a.Path FROM  (SELECT DISTINCT Path FROM
batch) AS a   WHERE NOT EXISTS(SELECT Path
 FROM Path AS pWHERE p.Path = a.Path)
   : ERR=You have an error in your SQL syntax.  Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'SELECT DISTINCT Path FROM batch) AS a   WHE
==

This error, I believe, might be due to my rather old version of MySQL.

My current plan is to try the following:
- dump the Bacula data via mysqldump
- upgrade MySQL to something more recent (MySQL 5, I guess)
- run drop_bacula_tables and make_bacula_tables
- read the Bacula data file back in via mysql

If anyone has any advice, feedback or suggestions, I would appreciate it.

Regards,
Jody

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Post-upgrade database issues, Bacula 1.38.11 to 2.2.1 on Solaris

[Dan Langille]

On 6 Sep 2007 at 13:18, Jody McDonnell wrote:

> Hi all,
> 
> I spent the day yesterday upgrading the Bacula install on our Solaris
> servers from 1.38.11 to 2.2.1. Things initially seemed to work, but
> the overnight incremental backup failed with some database issues.
> 
> I should note that I am using MySQL 4.0.18 with Bacula. I've been
> using this version since I started using Bacula three years ago with
> version 1.34.2. I haven't upgraded our version of MySQL, mainly
> because I wasn't exactly sure of the steps required to upgrade MySQL
> without risking data loss.
> 
> The only database-related maintenance I performed before the upgrade
> was to compact the MySQL database via the mysqldump utility, as per
> section 21.2 of the Bacula manual.
> 
> After building and installing Bacula 2.2.1, I ran the
> "update_mysql_tables_9_to_10" script to update my database tables from
> 1.38-era to 2.0-era.
> 
> I seem to have encountered two issues. The first seems to be related
> to the fact that my initial configuration script included the
> "--enable-batch-insert" directive. The nightly incremental backup
> failed with the following error messages:
> 
> ==
> 06-Sep 09:39 kodos-dir: BackupKang.2007-09-06_01.05.00 Fatal error:
> sql_create.c:730 sql_create.c:730 insert INSERT INTO batch VALUES
> (5432,2083,'/repo/cvsroot/est/build/','est.tar.gz,v','gAAW C2IJ IFt B
> Bw B A 3ezOL CAA G8Ew BG3vmb BG3uk8 BG3uk9 A A
> C','oqzs5tC+gpBJ0EESyZoa7A') failed:
> Table 'bacula.batch' doesn't exist
> 06-Sep 09:39 kodos-dir: sql_create.c:730 INSERT INTO batch VALUES
> (5432,2083,'/repo/cvsroot/est/build/','est.tar.gz,v','gAAW C2IJ IFt B
> Bw B A 3ezOL CAA G8Ew BG3vmb BG3uk8 BG3uk9 A A
> C','oqzs5tC+gpBJ0EESyZoa7A')
> 06-Sep 09:39 kodos-dir: BackupKang.2007-09-06_01.05.00 Fatal error:
> catreq.c:478 Attribute create error. sql_find.c:333 Request for Volume
> item 1 greater than max 0 or less than 1
> [...etc...]
> ==
> 
> There was a long pause in the backup while Bacula requested that a new
> tape be mounted. From searching through past posts to this list, it
> sounds like this is due to a timeout by MySQL, and I think that it
> might be possible to get around the issue by changing the wait_timeout
> value in my.cnf to some really large value.
> 
> Since I only have a single-tape DAT drive, backups can sometimes be
> stalled over an entire weekend waiting for a new tape to be mounted.
> Since I didn't really want to change the wait_timeout to be some huge
> number like 4 days, I decided to recompile Bacula 2.2.1 without the
> "--enable-batch-insert" directive. I hadn't previously noticed any
> database performance issues, anyway.
> 
> My second attempt at an incremental backup failed with the following
> error message:
> 
> ==
> 06-Sep 12:15 kodos-dir: BackupKang.2007-09-06_11.50.55 Fatal error:
> Can't fill Path table Query failed: INSERT INTO Path (Path)
> SELECT a.Path FROM  (SELECT DISTINCT Path FROM
> batch) AS a   WHERE NOT EXISTS(SELECT Path
>  FROM Path AS pWHERE p.Path = a.Path)
>: ERR=You have an error in your SQL syntax.  Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'SELECT DISTINCT Path FROM batch) AS a   WHE
> ==
> 
> This error, I believe, might be due to my rather old version of MySQL.

I suspect this may be nested selects, which may not be available in 
your older MySQL.

> My current plan is to try the following:
> - dump the Bacula data via mysqldump
> - upgrade MySQL to something more recent (MySQL 5, I guess)
> - run drop_bacula_tables and make_bacula_tables
> - read the Bacula data file back in via mysql
> 
> If anyone has any advice, feedback or suggestions, I would appreciate it.

That sounds OK to me.

-- 
Dan Langille - http://www.langille.org/
Available for hire: http://www.freebsddiary.org/dan_langille.php



-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula again running at 5% of full speed

[Tod Hagan]

On Wed, 2007-09-05 at 21:38 +0200, Arno Lehmann wrote:
> No need to compile, at least for now... use the 'setdebug' command, 
> e.g. 'setdebug dir level=200 trace=1' and 'setdebug sd= 
> level=200 trace=1' and read the resulting (large!) trace files in the 
> working directories. Unfortunately, there are no time stamps in the 
> log files, so it's hard to determine what actually needs so much time...
> 
> Also, check what your systems are actually doing... using vmstat, top, 
> and perhaps strace on the DIR machine might reveal where all that time 
> goes; on the catalog database server, you should also observe 
> PostgreSQL, but since I'm not a PostgreSQL guy, you better ask others 
> for advice :-)

Thanks for the tips -- I tried strace but saw no obvious clue to what's
happening.

I think I've isolated the problem to the tape drive:

 2917   system  OK B F  06-Sep 11:453.583 GB   2447.4 KB/s  
   24 mins 21 secs
 2918   system  OK B F  06-Sep 14:043.583 GB  19327.6 KB/s  
 3 mins 5 secs

Between jobs 2917 and 2918 I shut down Bacula, loaded a scratch tape,
and ran a test using Exabyte's ltoTool:

> sudo /usr/local/sbin/ltoTool /dev/nst0 -m 10240 -t
ltoTool V4.63  --  Copyright (c) 1996-2006, Exabyte Corp.

Tape Drive identified as LTO3(IBM)
/dev/nst0 - SCSI Load Tape...OK
/dev/nst0 - Test size = 10240 MB (command line override)
/dev/nst0 - Rewriting Logical Begin of Tape (LBOT)...OK

0 Writing10240Mb
[WW] 100 %

/dev/nst0 - Rewinding...OK

0 Reading10240Mb
[RR] 100 %

/dev/nst0 - Rewinding...OK
OK

/dev/nst0 - Drive functions properly.

Done

The write phase of the 10240 MB test took 2 minutes and 19 seconds,
which works out to 75437.1 KB/s. This seems like a reasonable raw speed
compared to the maximum achieved by Bacula (in the vicinity of 54848.7
KB/s).

After running the ltoTool test I restarted Bacula and ran job 2918 which
ran at full speed. I had previously tried restarting both Bacula and
Postgresql to no avail.

It seems that something with the tape drive or the /dev/nst0 SCSI tape
driver in RHEL 5 gets messed up causing slow Bacula transfers, which
running ltoTool's test fixes.

I wonder what it is?

Thanks.

Tod

-- 
Tod Hagan
Information Technologist
AIRMAP/Climate Change Research Center
Institute for the Study of Earth, Oceans, and Space
University of New Hampshire
Durham, NH 03824
Phone: 603-862-3116



-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Post-upgrade database issues, Bacula 1.38.11 to 2.2.1 on Solaris

[Dan Langille]

On 6 Sep 2007 at 13:18, Jody McDonnell wrote:

> Hi all,
> 
> I spent the day yesterday upgrading the Bacula install on our Solaris
> servers from 1.38.11 to 2.2.1. Things initially seemed to work, but
> the overnight incremental backup failed with some database issues.
> 
> I should note that I am using MySQL 4.0.18 with Bacula. I've been
> using this version since I started using Bacula three years ago with
> version 1.34.2. I haven't upgraded our version of MySQL, mainly
> because I wasn't exactly sure of the steps required to upgrade MySQL
> without risking data loss.
> 
> The only database-related maintenance I performed before the upgrade
> was to compact the MySQL database via the mysqldump utility, as per
> section 21.2 of the Bacula manual.
> 
> After building and installing Bacula 2.2.1, I ran the
> "update_mysql_tables_9_to_10" script to update my database tables from
> 1.38-era to 2.0-era.
> 
> I seem to have encountered two issues. The first seems to be related
> to the fact that my initial configuration script included the
> "--enable-batch-insert" directive. The nightly incremental backup
> failed with the following error messages:

Have you tried the old MySQL without the batch insert enabled?

-- 
Dan Langille - http://www.langille.org/
Available for hire: http://www.freebsddiary.org/dan_langille.php



-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Post-upgrade database issues, Bacula 1.38.11 to 2.2.1 on Solaris

[Jody McDonnell]

On 9/6/07, Dan Langille <[EMAIL PROTECTED]> wrote:
> On 6 Sep 2007 at 13:18, Jody McDonnell wrote:
>
> > Hi all,
> >
> > I spent the day yesterday upgrading the Bacula install on our Solaris
> > servers from 1.38.11 to 2.2.1. Things initially seemed to work, but
> > the overnight incremental backup failed with some database issues.
> >
> > I should note that I am using MySQL 4.0.18 with Bacula. I've been
> > using this version since I started using Bacula three years ago with
> > version 1.34.2. I haven't upgraded our version of MySQL, mainly
> > because I wasn't exactly sure of the steps required to upgrade MySQL
> > without risking data loss.
> >
> > The only database-related maintenance I performed before the upgrade
> > was to compact the MySQL database via the mysqldump utility, as per
> > section 21.2 of the Bacula manual.
> >
> > After building and installing Bacula 2.2.1, I ran the
> > "update_mysql_tables_9_to_10" script to update my database tables from
> > 1.38-era to 2.0-era.
> >
> > I seem to have encountered two issues. The first seems to be related
> > to the fact that my initial configuration script included the
> > "--enable-batch-insert" directive. The nightly incremental backup
> > failed with the following error messages:
>
> Have you tried the old MySQL without the batch insert enabled?
>
> --
> Dan Langille - http://www.langille.org/
> Available for hire: http://www.freebsddiary.org/dan_langille.php
>

I did try that...I recompiled Bacula without batch insert enabled, and
I received the "INSERT INTO Path (Path)..." SQL error.

Actually, to be more precise, when I first tried an incremental backup
with batch insert enabled, I received "Table 'bacula.batch' does not
exist" errors on the backup itself and "INSERT INTO Path (Path)..."
errors on the Catalog backup job that ran immediately afterward.

After I recompiled Bacula 2.2.1 without batch inserts enabled (and
still with the old MySQL database), I triggered an incremental backup
and received the "INSERT INTO Path (Path)..." SQL errors.

I have pretty much completed what I'd thought about in my first
post--and what you said sounded like a good plan--dumped the existing
database tables to a text file, installed the MySQL 5.0.45 Community
server, ran the grant_bacula_privileges, create_mysql_database, and
make_mysql_tables scripts, and read my data back in via the mysql
executable. The data looks okay--or, at least, I can get a
decent-looking listing when I run "list volumes".

I've just kicked off an incremental backup; I'll post back with results.

Thanks!
Jody

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] restore: device is blocked waiting for media

[Arno Lehmann]

Hello,

06.09.2007 11:10,, Luca Ferrari wrote::
> On Thursday 6 September 2007 Arno Lehmann's cat, walking on the keyboard, 

unfortunately, I don't have a cat. Not even goldfish or a hamster or 
anything ;-)

> wrote:
>> Hi,
>>
>> 06.09.2007 09:11,, Luca Ferrari wrote::
>>> On Wednesday 5 September 2007 Arno Lehmann's cat, walking on the
>>> keyboard,
>>>
>>> wrote:
 I think we'll need some more detailed information here... does Bacula
 send a notification to load the volume it wants, what are the Media
 Types, and so on... the relevant parts of your configuration might
 help here.
>>> In fact looking into the messages I found:
>>>
>>> 05-set 18:54 backup-sd: Please mount
>>> Volume "mammuth_uff_g_job-2007-08-30--23-47" on Storage
>>> Device "mammuth_device" (/backup/mammuth) for Job
>>> restore_mySelf.2007-09-05_17.53.30
>>>
>>> so I manually did a mount of the device and the restore process is now
>>> running. Why it is not automatically mounting the device?
>> Is this device defined as an autochanger?
> 
> 
> No, here it is:
> 
> Device {
>Name = mammuth_device
>Archive Device = /backup/mammuth
>Device Type = File
>Removable Media = No
>Random Access = Yes
>Media Type = mammuth_disk_storage
>LabelMedia = yes
>AutomaticMount = yes
> }
> 
> any idea?

Well, the manual mentions this only for tape drives, so I had a look 
into a system I know and find that's not necessary.

So my only idea is that perhaps you use several file storage devices 
with identical Media Type settings and Bacula chooses the wrong device 
for the needed volumes.

Arno



> Thanks,
> Luca
> 
> -
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users

-- 
Arno Lehmann
IT-Service Lehmann
www.its-lehmann.de

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] old records in database

[Arno Lehmann]

Hi,

06.09.2007 17:10,, David Pospisil wrote::
> But I think that bacula prune old job records after doing the job of the same 
> name.

Right.

> Example: I have a job called JOB-a, so old job records will be pruned 
> after doing job JOB-a (because bacula chceck old records after doing the job 
> of the same name), but I am not sure.
> Second thing is that I have never seen configuration for old jobs so I dont 
> know if they had autoprune set on of off :(

To get rid of old file records, you would run the dbcheck utility and 
check for and remove orphaned file records. I would suggest to stop 
Bacula while you do that.

If you find that dbcheck runs very very long, you might want to add 
some indexes to the catalog first. There are some discussions of this 
problem in the list archives.

Also, depending on the version of Bacula you run, different indexes 
might exist, or dbcheck might be performing differently.

Arno

> Thx for reply,
> David
> 
> 
> Dne čtvrtek 06 září 2007 16:53 jste napsal(a):
>> On 6 Sep 2007 at 16:14, David Pospisil wrote:
>>> Hi,
>>> my catalog database has 10G, but there is a lot of old records (file
>>> records) from Jobs which do not exist now. Will the old records be pruned
>>> or will they stay in database forever? Is there any way how to delete old
>>> records from database?
>> They will be pruned if you specify they should be pruned.  Look at
>> retention.  There are values for each of Job, File, and Volume.  Look
>> also at AutoPrune.
> 
> -
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users

-- 
Arno Lehmann
IT-Service Lehmann
www.its-lehmann.de

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula again running at 5% of full speed

[Arno Lehmann]

Hi,

06.09.2007 20:29,, Tod Hagan wrote::
> On Wed, 2007-09-05 at 21:38 +0200, Arno Lehmann wrote:
>> No need to compile, at least for now... use the 'setdebug' command, 
>> e.g. 'setdebug dir level=200 trace=1' and 'setdebug sd= 
>> level=200 trace=1' and read the resulting (large!) trace files in the 
>> working directories. Unfortunately, there are no time stamps in the 
>> log files, so it's hard to determine what actually needs so much time...
>>
>> Also, check what your systems are actually doing... using vmstat, top, 
>> and perhaps strace on the DIR machine might reveal where all that time 
>> goes; on the catalog database server, you should also observe 
>> PostgreSQL, but since I'm not a PostgreSQL guy, you better ask others 
>> for advice :-)
> 
> Thanks for the tips -- I tried strace but saw no obvious clue to what's
> happening.
> 
> I think I've isolated the problem to the tape drive:
> 
>  2917   system  OK B F  06-Sep 11:453.583 GB   2447.4 KB/s
>  24 mins 21 secs
>  2918   system  OK B F  06-Sep 14:043.583 GB  19327.6 KB/s
>3 mins 5 secs
> 
> Between jobs 2917 and 2918 I shut down Bacula, loaded a scratch tape,
> and ran a test using Exabyte's ltoTool:
> 
> > sudo /usr/local/sbin/ltoTool /dev/nst0 -m 10240 -t
> ltoTool V4.63  --  Copyright (c) 1996-2006, Exabyte Corp.
> 
> Tape Drive identified as LTO3(IBM)
> /dev/nst0 - SCSI Load Tape...OK
> /dev/nst0 - Test size = 10240 MB (command line override)
> /dev/nst0 - Rewriting Logical Begin of Tape (LBOT)...OK
> 
> 0 Writing10240Mb
> [WW] 100 %
> 
> /dev/nst0 - Rewinding...OK
> 
> 0 Reading10240Mb
> [RR] 100 %
> 
> /dev/nst0 - Rewinding...OK
> OK
> 
> /dev/nst0 - Drive functions properly.
> 
> Done
> 
> The write phase of the 10240 MB test took 2 minutes and 19 seconds,
> which works out to 75437.1 KB/s. This seems like a reasonable raw speed
> compared to the maximum achieved by Bacula (in the vicinity of 54848.7
> KB/s).

Well, not perfect, but a reasonable speed IMO. Real life is typically 
more complicated than dumping data from meory to tape.

> After running the ltoTool test I restarted Bacula and ran job 2918 which
> ran at full speed. I had previously tried restarting both Bacula and
> Postgresql to no avail.
> 
> It seems that something with the tape drive or the /dev/nst0 SCSI tape
> driver in RHEL 5 gets messed up causing slow Bacula transfers, which
> running ltoTool's test fixes.
> 
> I wonder what it is?

If it's an external tape drive, you could try power-cycling it if it 
gets slow again. Obviously, you'll make sure it's not accessed at that 
time, that the OS has access to it afterwards ('echo 
scsi-add-single-device > /proc/scsi/scsi' 
IIRC) and that Bacula knows the tape is rewound. Typically, I'd 
unmount from bconsole, unload tapes in the drives, power-cycle, and 
check with mt that the drive is usable by the OS again.

If that fixes the speed problem, the next try might be to unload the 
st and SCSI driver modules and reloading them. This can be tricky or 
impossible, depending on your system setup, though.

Anyway, a better next step might be to see if there is a firmware 
upgrade available for your drive, and install that.

Arno
-- 
Arno Lehmann
IT-Service Lehmann
www.its-lehmann.de

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Webmin Bacula-Module does not connect to database

[Arno Lehmann]

Hello,

06.09.2007 15:15,, Ferdi Giese wrote::
> Hi,
> 
> bacula-2.1.1 is working fine on mysql-database at localhost (SLES10-SP1), but 
> when I want to use the Webmin-Module for administration, it echos "Failed to 
> connect to the Bacula database: ../config.cgi?bacula-backup. Maybe it is not 
> set up, or the module configuration is incorrect."
> 
> I tried editing the /etc/webmin/bacula-backup/config-file in many ways (e.g. 
> with "host=localhost" or "host=127.0.0.1", with "pass=""), but nothing works. 
> I need Your help.

I guess you should ask that the webmin support. I don't think many 
people here use webmin for their Bacula installations, and as the 
webmin module is not produced by the Bacula product, webmin support is 
the right address anyway...

Arno

> Regards
> Ferdi
> 
> 
> -
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users

-- 
Arno Lehmann
IT-Service Lehmann
www.its-lehmann.de

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Post-upgrade database issues, Bacula 1.38.11 to 2.2.1 on Solaris

[Dan Langille]

With a BCC: to devel

On 6 Sep 2007 at 16:21, Jody McDonnell wrote:

> On 9/6/07, Jody McDonnell <[EMAIL PROTECTED]> wrote:
> > I have pretty much completed what I'd thought about in my first
> > post--and what you said sounded like a good plan--dumped the existing
> > database tables to a text file, installed the MySQL 5.0.45 Community
> > server, ran the grant_bacula_privileges, create_mysql_database, and
> > make_mysql_tables scripts, and read my data back in via the mysql
> > executable. The data looks okay--or, at least, I can get a
> > decent-looking listing when I run "list volumes".
> >
> > I've just kicked off an incremental backup; I'll post back with results.
> 
> My incremental backup worked!

Good.

> So, I would say that MySQL 4.0.18 could be considered too old for
> Bacula 2.2.1. At least on Solaris (though I'm not sure if the system
> architecture would make a difference).

We think 4.1 is new enough.

> Thanks for the quick help. Very nice!

You were not the first to encounter this problem.  We are now 
updating the release notes and hope to send out an announcement soon 
letting people know of the new requirement.

FYI: MySQL >= 4.1, PostgreSQL > 7.4

-- 
Dan Langille - http://www.langille.org/
Available for hire: http://www.freebsddiary.org/dan_langille.php



-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] I/O errors with ext. tape

[Tom Plancon]

Hello all,

I'm getting errors on a HP DAT-72 external SCSI drive I'm trying to set
up. I'm hoping I can get some idea of what is going on and if it is
correctable. I'm running Bacula 2.0.3 on Fedora Core 6. Bacula backs-up
to disk just fine.

Checking /proc/scsi:
[EMAIL PROTECTED] bacula]# cat /proc/scsi/scsi
Attached devices:
Host: scsi0 Channel: 00 Id: 06 Lun: 00
  Vendor: HP   Model: C7438A   Rev: ZP5A
  Type:   Sequential-Access    ANSI  SCSI revision: 03
  
Checking with "mt":
[EMAIL PROTECTED] bacula]# mt -f /dev/nst0 status
SCSI 2 tape drive:
File number=0, block number=0, partition=0.
Tape block size 0 bytes. Density code 0x47 (TR-5).
Soft error count since last status=0
General status bits on (4101):
 BOT ONLINE IM_REP_EN
 
Testing with "btape":
[EMAIL PROTECTED] bacula]# btape DAT-72
Tape block granularity is 1024 bytes.
btape: butil.c:286 Using device: "DAT-72" for writing.
btape: btape.c:368 open device "DAT-72" (/dev/nst0): OK
*test

=== Write, rewind, and re-read test ===

I'm going to write 1000 records and an EOF
then write 1000 records and an EOF, then rewind,
and re-read the data to verify that it is correct.

This is an *essential* feature ...

btape: btape.c:825 Wrote 1000 blocks of 64412 bytes.
btape: btape.c:499 Wrote 1 EOF to "DAT-72" (/dev/nst0)
btape: btape.c:841 Wrote 1000 blocks of 64412 bytes.
btape: btape.c:499 Wrote 1 EOF to "DAT-72" (/dev/nst0)
btape: btape.c:850 Rewind OK.
06-Sep 14:15 btape: btape Error: block.c:317 Volume data error at 0:0!
Block checksum mismatch in block=0 len=64480: calc=40203cbc blk=b1d8a199
btape: btape.c:862 Read block 1 failed! ERR=Input/output error

Finally a test with "tar":
[EMAIL PROTECTED] bacula]# tar xvf /dev/nst0 /proj/Arch_Proj
tar: /dev/nst0: Cannot read: Cannot allocate memory
tar: At beginning of tape, quitting now
tar: Error is not recoverable: exiting now

I just noticed that /proc/scsi reports "ANSI 
SCSI revision: 03" and  mt status reports "SCSI
2 tape drive:". Is that an issue?

Any help here is appreciated! Thanks!
-- 
Tom Plancon
CAD/IS Manager
BKA Architects, Inc.
142 Crescent St.
Brockton, MA 02302
508-583-5603
[EMAIL PROTECTED]
 



-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Post-upgrade database issues, Bacula 1.38.11 to 2.2.1 on Solaris

[Jody McDonnell]

On 9/6/07, Jody McDonnell <[EMAIL PROTECTED]> wrote:
> I have pretty much completed what I'd thought about in my first
> post--and what you said sounded like a good plan--dumped the existing
> database tables to a text file, installed the MySQL 5.0.45 Community
> server, ran the grant_bacula_privileges, create_mysql_database, and
> make_mysql_tables scripts, and read my data back in via the mysql
> executable. The data looks okay--or, at least, I can get a
> decent-looking listing when I run "list volumes".
>
> I've just kicked off an incremental backup; I'll post back with results.

My incremental backup worked!

So, I would say that MySQL 4.0.18 could be considered too old for
Bacula 2.2.1. At least on Solaris (though I'm not sure if the system
architecture would make a difference).

Thanks for the quick help. Very nice!

Regards,
Jody

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] I/O errors with ext. tape

[Dan Langille]

On 6 Sep 2007 at 16:29, Tom Plancon wrote:

> 
> Hello all,
> 
> I'm getting errors on a HP DAT-72 external SCSI drive I'm trying to 
> set up. I'm hoping I can get some idea of what is going on and if it 
> is correctable. I'm running Bacula 2.0.3 on Fedora Core 6. Bacula 
> backs-up to disk just fine.

This makes me think it is a hardware issue, not a software (i.e. 
Bacula) issue.

> Checking /proc/scsi:
> [EMAIL PROTECTED] bacula]# cat /proc/scsi/scsi
> Attached devices:
> Host: scsi0 Channel: 00 Id: 06 Lun: 00
>  Vendor: HP Model: C7438ARev: ZP5A
>  Type:Sequential-AccessANSI SCSI revision: 03
> 
> Checking with "mt":
> [EMAIL PROTECTED] bacula]# mt -f /dev/nst0 status
> SCSI 2 tape drive:
> File number=0, block number=0, partition=0.
> Tape block size 0 bytes. Density code 0x47 (TR-5).
> Soft error count since last status=0
> General status bits on (4101):
> BOT ONLINE IM_REP_EN
> 
> Testing with "btape":
> [EMAIL PROTECTED] bacula]# btape DAT-72
> Tape block granularity is 1024 bytes.
> btape: butil.c:286 Using device: "DAT-72" for writing.
> btape: btape.c:368 open device "DAT-72" (/dev/nst0): OK
> *test
> 
> === Write, rewind, and re-read test ===
> 
> I'm going to write 1000 records and an EOF
> then write 1000 records and an EOF, then rewind,
> and re-read the data to verify that it is correct.
> 
> This is an *essential* feature ...
> 
> btape: btape.c:825 Wrote 1000 blocks of 64412 bytes.
> btape: btape.c:499 Wrote 1 EOF to "DAT-72" (/dev/nst0)
> btape: btape.c:841 Wrote 1000 blocks of 64412 bytes.
> btape: btape.c:499 Wrote 1 EOF to "DAT-72" (/dev/nst0)
> btape: btape.c:850 Rewind OK.
> 06-Sep 14:15 btape: btape Error: block.c:317 Volume data error at 0:0!
> Block checksum mismatch in block=0 len=64480: calc=40203cbc 
> blk=b1d8a199
> btape: btape.c:862 Read block 1 failed! ERR=Input/output error

OK.  Does btape give any suggestions for change to your 
configuration?

> Finally a test with "tar":
> [EMAIL PROTECTED] bacula]# tar xvf /dev/nst0 /proj/Arch_Proj
> tar: /dev/nst0: Cannot read: Cannot allocate memory
> tar: At beginning of tape, quitting now
> tar: Error is not recoverable: exiting now

Was there a tar -cf /dev/nst0 before this?  If so, OK.

> I just noticed that /proc/scsi reports "ANSI SCSI revision: 03" and 
> mt status reports "SCSI 2 tape drive:". Is that an issue?

No idea.  That may be an OS specific issue...

Is the SCSI chain properly terminated?  Have you tried a different 
SCSI cable?  A different SCSI terminator?

In this image, the cable coming in from the bottom is attached to the 
computer.  The looped cable goes from one SCSI device to another.  
The block closest to the right is the SCSI terminator.  The green 
light on the terminator indicates the SCSI bus is active.

  http://www.freebsddiary.org/images/tape-libraries-cables.jpg

> Any help here is appreciated! Thanks!

Try what I did for btape:

  http://www.freebsddiary.org/digital-tl891.php

-- 
Dan Langille - http://www.langille.org/
Available for hire: http://www.freebsddiary.org/dan_langille.php



-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Errors migrating jobs

[Robert LeBlanc]

I've been trying to get jobs migrated off my old tape library onto my new tape 
library. I've followed the documentation online, but it seems like it is trying 
to go backwards (new library to old library). I've tried several different 
things and I keep getting an error that says "This shouldn't happen". I'm using 
the bacula 2.2.0 Debian packages from sid on Lenny, but I had the same problem 
with 2.1.28 that I built myself. A few things catch my attention:

06-Sep 15:24 babacula-dir: Job queued. JobId=6256
06-Sep 15:24 babacula-dir: Migration JobId 6256 started.
06-Sep 15:24 babacula-dir: The following 1 JobIds were chosen to be migrated: 
3693
06-Sep 15:24 babacula-dir: Migration using JobId=3693 
Job=nightwing.2007-08-01_08.49.46
06-Sep 15:24 babacula-dir: Bootstrap records written to 
/var/lib/bacula/babacula-dir.restore.54.bsr
06-Sep 15:24 babacula-dir: 
06-Sep 15:24 babacula-dir: The job will require the following
   Volume(s) Storage(s)SD Device(s)
===
06-Sep 15:24 babacula-dir:
06-Sep 15:24 babacula-dir:61L3  Neo8000 
  Drive-1  
06-Sep 15:24 babacula-dir: 
06-Sep 15:24 babacula-dir: Start Migration JobId 6256, 
Job=Migrate_volume.2007-09-06_15.24.49
06-Sep 15:24 babacula-dir: Job queued. JobId=6258
06-Sep 15:24 babacula-dir: Migration JobId 6258 started.
06-Sep 15:24 babacula-dir: Using Device "Drive-1"
06-Sep 14:57 lsbacsd0-sd: acquire.c:115 Changing device. Want Media Type="LTO3" 
have="LTO2"
  device="IBM-1" (/dev/nst2)
06-Sep 14:57 lsbacsd0-sd: Migrate_volume.2007-09-06_15.24.49 Fatal error: 
askdir.c:332 NULL Volume name. This shouldn't happen!!!

First it says that it will use 61L3 which is not in the source or 
destination pool. It is also in the new library. It then says that it wants 
media LTO3, but that is has LTO2 which says that it might be trying to use the 
right device. Then it has a NULL Volume name and says This shouldn't happen.

The error output seems correct:

  Build OS:   i486-pc-linux-gnu debian lenny/sid
  Prev Backup JobId:  3664
  New Backup JobId:   6257
  Migration JobId:6256
  Migration Job:  Migrate_volume.2007-09-06_15.24.49
  Backup Level:   Full
  Client: lsbacsd0-fd
  FileSet:"Windows" 2007-03-22 16:44:22
  Read Pool:  "Monthly" (From Job resource)
  Read Storage:   "PV132T" (From Pool resource)
  Write Pool: "Monthly-new" (From Job Pool's NextPool resource)
  Write Storage:  "Neo8000" (From Storage from Pool's NextPool resource)
  Start time: 06-Sep-2007 15:24:53
  End time:   06-Sep-2007 15:24:54
  Elapsed time:   1 sec
  Priority:   10
  SD Files Written:   0
  SD Bytes Written:   0 (0 B)
  Rate:   0.0 KB/s
  Volume name(s): 
  Volume Session Id:  209
  Volume Session Time:1189109201
  Last Volume Bytes:  0 (0 B)
  SD Errors:  0
  SD termination status:  Error
  Termination:*** Migration Error ***

The correct read/write pool and storage are correct. My director conf is:

Pool {
  Name = Monthly-new
  Volume Use Duration = 20d
  Pool Type = Backup
  Storage = Neo8000
  AutoPrune = yes
  VolumeRetention = 2 years
  Recycle = yes
  Label Format = "Monthly-"
}

Pool {
  Name = Monthly
  Volume Use Duration = 20d
  Pool Type = Backup
  Storage = PV132T
  AutoPrune = yes
  VolumeRetention = 2 years
  Recycle = yes
  Label Format = "Monthly-LTO2-"
  Next Pool = Monthly-new
}

Job {
  Name = "Migrate_volume"
  Type = Migrate
  Level = Full
  Client = lsbacsd0-fd
  File Set = "Windows"
  Messages = Standard
  Pool = Monthly
  Maximum Concurrent Jobs = 4
  Selection Type = Volume
  Selection Pattern = "0*"
}

When we got our new library, I renamed the Monthly pool to Monthly-LTO2 and 
created a Monthly pool on the Neo8000 so that jobs would run there. I tried 
migrating jobs with that configuration and I got the error that Monthly did not 
have a next pool. So I named Monthly to Monthly-new and Monthly-LTO2 to Monthly 
and that is the config and error above. I've also tried migrating to a new pool 
that did not exist in the old library and I get the same errors as above. The 
old library was attached to the director and I was having problems so I 
attached it to the SD that has the Neo8000, so both libraries are attached to 
the same computer.

Any help or pointers will be helpful.

Thanks,
Robert

Life Sciences Computer Support
Brigham Young University
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/___

[Bacula-users] restore problem

[Steve Thompson]

Bacula 2.0.3, director is 32-bit CentOS 4.5, clients are all CentOS 4.5, 
both 32-bit and 64-bit. Backups are to disk files.

I find that I cannot do any restores:

06-Sep 13:59 dante-sd: RestoreFiles.2007-09-06_13.58.29 Error: block.c:275 
Volume data
error at 0:899088562! Wanted ID: "BB02", got "???^g". Buffer discarded. 
06-Sep 13:59 dante-dir: RestoreFiles.2007-09-06_13.58.29 Error: Bacula 2.0.3 
(06Mar07):
06-Sep-2007 13:59:39

I have seen messages in the archive from others with a similar problem, 
with suggestions that they are having hardware problems. I am not having 
hardware problems, however: I can cp the backups, dd them, bls them, 
bextract them, but I cannot run a restoration job to completion. I can 
exercise the hardware for days with no apparent problems.

I have deleted all the backups, reinitialized bacula from scratch, run 
full backups to different disk volumes, and tried a restore again: same 
result.

I'd be thankful for any clue stick that someone can hit me with.

Steve

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Fwd: Problem with install bacula

[Manuel Ostendorf]

-- Forwarded message --
From: Manuel Ostendorf <[EMAIL PROTECTED]>
Date: Sep 6, 2007 11:51 PM
Subject: Re: [Bacula-users] Problem with install bacula
To: Arno Lehmann <[EMAIL PROTECTED]>

HI,

Thank you for helping. I found another way to solve my problem. I used rpm
to install bacula.

I dont know what was problem. The directiory src was there, but make cannot
find that directory. I am using for unpacking tar zxvf.
I think Arno Lehmann has right that there is problem with permission. But I
have installed with Makefile on another computer and it works well.

thank you for helping

Manu

On 9/5/07, Arno Lehmann <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> 05.09.2007 03:34,, Ryan Novosielski wrote::
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > Manuel Ostendorf wrote:
> >> Hello,
> >>
> >> have you an idea to solve my problem? I still have my problem.
>
> Unfortunately, I can't help. But...
>
> >> Manuel
> >>
> >> On 8/30/07, *Manuel Ostendorf* < [EMAIL PROTECTED]
> >> > wrote:
> >>
> >> Hello,
> >>
> >> I cannot install bacule. If I tried after using "./configure
> >> --with-mysql" with "make", I got errors.
> >>
> >>
> >>   == Error in /home/Ponte/bacula ==
> >>
> >>
> >> /bin/sh: line 1: cd: scripts: Datei oder Verzeichnis nicht gefunden
> >> ==>Entering directory /home/Ponte/bacula
> >> make[253]: Entering directory `/home/Ponte/bacula'
> >> /bin/sh: line 1: cd: src: Datei oder Verzeichnis nicht gefunden
> >> ==>Entering directory /home/Ponte/bacula
> >> make[254]: Entering directory `/home/Ponte/bacula'
> >> /bin/sh: line 1: cd: src: Datei oder Verzeichnis nicht gefunden
> >> ==>Entering directory /home/Ponte/bacula
> >> make[255]: Entering directory `/home/Ponte/bacula'
> >> /bin/sh: line 1: cd: src: Datei oder Verzeichnis nicht gefunden
> >> ==>Entering directory /home/Ponte/bacula
> >> make[256]: Entering directory `/home/Ponte/bacula'
> >> /bin/sh: line 1: cd: src: Datei oder Verzeichnis nicht gefunden
> >> ==>Entering directory /home/Ponte/bacula
> >> make[257]: Entering directory `/home/Ponte/bacula'
> >> /bin/sh: line 1: cd: src: Datei oder Verzeichnis nicht gefunden
> >>
> >>
> >> config.out
> >>
> >> Configuration on Thu Aug 30 18:20:53 CEST 2007:
> >>
> >>   Host:   i686-pc-linux-gnu -- suse 10.2
> >>   Bacula version: 2.2.0 (08 August 2007)
> >>   Source code location:   .
> >>   Install binaries:   /sbin
> >>   Install config files:   /etc/bacula
> >>   Scripts directory:  /etc/bacula
> >>   Working directory:  /var/bacula/working
> >>   PID directory:  /var/run
> >>   Subsys directory:   /var/lock/subsys
> >>   Man directory:  /usr/share/man
> >>   Data directory: /usr/share
> >>   C Compiler: gcc 4.1.2
> >>   C++ Compiler:   /usr/bin/g++ 4.1.2
> >>   Compiler flags:  -g -O2 -Wall -fno-strict-aliasing
> >> -fno-exceptions -fno-rtti
> >>   Linker flags:
> >>   Libraries:  -lpthread
> >>   Statically Linked Tools:yes
> >>   Statically Linked FD:   no
> >>   Statically Linked SD:   no
> >>   Statically Linked DIR:  no
> >>   Statically Linked CONS: no
> >>   Database type:  MySQL
> >>   Database lib:   -L/usr/lib/mysql -lmysqlclient_r -lz
> >>   Database name:  bacula
> >>   Database user:  bacula
> >>
> >>   Job Output Email:   [EMAIL PROTECTED]
> >>   Traceback Email:[EMAIL PROTECTED]
> >>   SMTP Host Address:  localhost
> >>
> >>   Director Port:  9101
> >>   File daemon Port:   9102
> >>   Storage daemon Port:9103
> >>
> >>   Director User:
> >>   Director Group:
> >>   Storage Daemon User:
> >>   Storage DaemonGroup:
> >>   File Daemon User:
> >>   File Daemon Group:
> >>
> >>   SQL binaries Directory  /usr/bin
> >>
> >>   Large file support: yes
> >>   Bacula conio support:   yes -lncurses
> >>   readline support:   no
> >>   TCP Wrappers support:   no
> >>   TLS support:no
> >>   Encryption support: no
> >>   ZLIB support:   yes
> >>   enable-smartalloc:  yes
> >>   bat support:no
> >>   enable-gnome:   no
> >>   enable-bwx-console: no
> >>   enable-tray-monitor:
> >>   client-only:no
> >>   build-dird: yes
> >>   build-stored:   yes
> >>   ACL support:yes
> >>   Python support: no
> >>   Batch insert enabled:   yes
> >>
> >>
> >> Can you tell me, what that problem is? How can

[Bacula-users] Recipe for Disaster Recovery of Windows 2003 (and maybe XP)

[James Harper]

I'm not sure if this has been documented anywhere before, but I'm having
a look at disaster recovery of a Windows 2003 computer in the situation
where your director and sd are still running.

What I have done so far (I'll document it better later):

Preparation:
1. Do an NTBackup of your system state to C:\SystemState.bkf
2. Make sure that the SystemState.bkf is on the bacula volume you want
to restore from.
3. Create a Windows install CD, add the contents of your Bacula
directory and include your config file, and the asr.sif and asrpnp.sif
files from C:\WINDOWS\repair
4. Modify the asr.sif file to remove the call to ntbackup and replace it
with a call to cmd.exe (make sure the end of line characters remain the
same!)
5. Include on the CD a text file containing the network details, for
future reference (ip address and dns server are all that should be
required)
6. Include any extra drivers that you might need
7. Burn the CD and make it bootable


Restoration:
1. Boot from the CD, and press F2 to enter ASR mode
2. Let windows do it's thing, it will restore all the partition
information exactly as it was before, eventually it will come up with a
command prompt
3. Copy Bacula from the CD to C:\Bacula
4. configure the network with netsh commands
5. Start Bacula with something like 'bacula-fd -c
C:\bacula\bacula-fd.conf'
6. Perform the restore from the directory (expect lots of 'file in use'
messages)
7. After the restore is complete, start ntbackup, and do a restore from
C:\SystemState.bkf (or whatever you called your system state backup)
8. Exit the command prompt and the system should reboot.

I have just tried all of the above on a domain controller and it appears
to work correctly...

I think that almost all of the backup steps could be scripted, and so
could a few of the restore steps (copying bacula to the harddisk,
configuring the network, starting bacula, and starting ntbackup)

I'll document this a bit better if anyone is interested.

James


-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Bacula environment

[Kelly, Brian]

I am running a post job python script that fails because python is unable to
import some libraries. I am running bacula as root. When running the script
manually as root there are no problems. Issuing the env command as root
yields a correct PYTHONPATH variable:

PYTHONPATH=/usr/lib64/portage/pym:/prod/bacula/local/lib64/python2.4/site-pa
ckages:/prod/bacula/local/lib/python2.4/site-packages

I wrote a small test script to determine what the environment variables look
like when the director fires off a script as follows:

#!/bin/bash
echo "++" >>
/prod/bacula/var/bacula-environment
echo "" >> /prod/bacula/var/bacula-environment
date >> /prod/bacula/var/bacula-environment
echo "" >> /prod/bacula/var/bacula-environment
/bin/env >> /prod/bacula/var/bacula-environment
whoami >> /prod/bacula/var/bacula-environment
echo "***" >>
/prod/bacula/var/bacula-environment

This yields the following output:

++

Thu Sep  6 18:30:54 CDT 2007

SHELL=/bin/bash
TERM=xterm
DEFAULTLEVEL=default
USER=root
PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/sbin:/usr/local/sbin:/usr/loca
l/bin:/usr/sbin:/usr/bin:/sbin:/bin:/opt/bin:/usr/x86_64-pc-linux-gnu/gcc-bi
n/4.1.2
PWD=/
BOOTLEVEL=boot
CONSOLETYPE=pty
SVCNAME=bacula
HOME=/root
SHLVL=2
SOFTLEVEL=default
_=/bin/env
root
***

Can anyone help me to understand why the the PYTHONPATH environment variable
is missing when the director fires off my simple shell script? I'm not sure
if I am doing something incorrectly within Bacula or if I've somehow
configured my Linux distro incorrectly. 

Thanks in advance for any advice with this problem. If you need more
information please let me know.

Brian Kelly


smime.p7s
Description: S/MIME cryptographic signature
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Recipe for Disaster Recovery of Windows 2003 (and maybe XP)

[Frank Sweetser]

James Harper wrote:
> I'll document this a bit better if anyone is interested.

Absolutely!  In fact, there's already a slot where you could add your stuff to
the wiki:

http://wiki.bacula.org/doku.php?id=windows_bare_metal_recovery

-- 
Frank Sweetser fs at wpi.edu  |  For every problem, there is a solution that
WPI Senior Network Engineer   |  is simple, elegant, and wrong. - HL Mencken
GPG fingerprint = 6174 1257 129E 0D21 D8D4  E8A3 8E39 29E3 E2E8 8CEC

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] restore problem

[Tom Sommer]

On Thu, September 6, 2007 23:36, Steve Thompson wrote:
> Bacula 2.0.3, director is 32-bit CentOS 4.5, clients are all CentOS 4.5,
> both 32-bit and 64-bit. Backups are to disk files.
>
> I find that I cannot do any restores:
>
>
> 06-Sep 13:59 dante-sd: RestoreFiles.2007-09-06_13.58.29 Error:
> block.c:275 Volume data
> error at 0:899088562! Wanted ID: "BB02", got "???^g". Buffer discarded.
> 06-Sep 13:59 dante-dir: RestoreFiles.2007-09-06_13.58.29 Error: Bacula
> 2.0.3 (06Mar07):
> 06-Sep-2007 13:59:39
>
>
> I have seen messages in the archive from others with a similar problem,
> with suggestions that they are having hardware problems. I am not having
> hardware problems, however: I can cp the backups, dd them, bls them,
> bextract them, but I cannot run a restoration job to completion. I can
> exercise the hardware for days with no apparent problems.
>
> I have deleted all the backups, reinitialized bacula from scratch, run
> full backups to different disk volumes, and tried a restore again: same
> result.
>
> I'd be thankful for any clue stick that someone can hit me with.

Had/Have this problem too, I suggest opening a bug on it..

--
Tom Sommer



-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] restore problem

[Doytchin Spiridonov]

Hello,

just to mention again that while there were suggestions this is a
hardware problem we did a lot of tests and proved the problem is not
hadrware but there is a bug (which however was closed with "unable to
reproduce" reason)

As you are the next case, can you please test it again ("have deleted
all the backups, reinitialized bacula from scratch, run full backups
to different disk volumes, and tried a restore again") but w/o
enabling concurrent jobs (I bet you are) and see if it will be OK or
you will get the same problems?

Regards.


Friday, September 7, 2007, 12:36:41 AM:

ST> Bacula 2.0.3, director is 32-bit CentOS 4.5, clients are all CentOS 4.5,
ST> both 32-bit and 64-bit. Backups are to disk files.

ST> I find that I cannot do any restores:

ST> 06-Sep 13:59 dante-sd: RestoreFiles.2007-09-06_13.58.29 Error: block.c:275 
Volume data
ST> error at 0:899088562! Wanted ID: "BB02", got "???^g". Buffer 
discarded.
ST> 06-Sep 13:59 dante-dir: RestoreFiles.2007-09-06_13.58.29 Error: Bacula 
2.0.3 (06Mar07):
ST> 06-Sep-2007 13:59:39

ST> I have seen messages in the archive from others with a similar problem,
ST> with suggestions that they are having hardware problems. I am not having
ST> hardware problems, however: I can cp the backups, dd them, bls them, 
ST> bextract them, but I cannot run a restoration job to completion. I can
ST> exercise the hardware for days with no apparent problems.

ST> I have deleted all the backups, reinitialized bacula from scratch, run
ST> full backups to different disk volumes, and tried a restore again: same
ST> result.

ST> I'd be thankful for any clue stick that someone can hit me with.

ST> Steve

ST> -
ST> This SF.net email is sponsored by: Splunk Inc.
ST> Still grepping through log files to find problems?  Stop.
ST> Now Search log events and configuration files using AJAX and a browser.
ST> Download your FREE copy of Splunk now >>  http://get.splunk.com/
ST> ___
ST> Bacula-users mailing list
ST> Bacula-users@lists.sourceforge.net
ST> https://lists.sourceforge.net/lists/listinfo/bacula-users


-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users