Re: [Bacula-users] New Exabyte Autochanger question

[Christian Vogel]

Hi Richard, Hi Group,

On Mon, Jul 09, 2007 at 12:01:51PM -0700, Richard White wrote:
> > Are you 100% sure that  /dev/sg0 is your changer?
…
> You are right! /dev/sg0 yields some ATA nonsense, but
> /dev/sg1 tells me it is an Exabyte 1x10 1u. I will
> give it another try.

I recently had to struggle with a server with several
hot-pluggable SATA drives where depending on the number
of plugged drives the /dev/sg nodes seem to shuffle around.

Recent Linux distributions (namely the udev device management) seems to
have a nice solution to this problem (I am currently running Ubuntu
Feisty). They create symlinks named after the devices serial number,
so in Baculas sd.conf, I have:

Changer Device = /dev/tape/by-id/scsi-200900de6055fa000
Archive Device = /dev/tape/by-id/scsi-350060b33c0d9-nst

unfortunately, the same udev rules miss the entry to adjust the
tape changer's permissions (/etc/udev/rules.d/40-permissions.rules):

# SCSI devices
SUBSYSTEMS=="scsi", GOTO="scsi_start"
GOTO="scsi_end"
LABEL="scsi_start"
ATTRS{type}=="1",   GROUP="tape"
- ADD THE NEXT LINE: vvv
ATTRS{type}=="8",   GROUP="tape"
- ADD THE PREVIOUS LINE: ^^^
ATTRS{type}=="5",   GROUP="cdrom"
ATTRS{type}=="6",   GROUP="scanner"
ATTRS{type}=="3", ATTRS{vendor}=="HP",  GROUP="scanner"
ATTRS{type}=="3", ATTRS{vendor}=="Epson", GROUP="scanner"
LABEL="scsi_end"

Hope it's useful for someone of you.

Greetings from Germany,

Chris

-- 
Saying that XP is the most stable MS OS is like saying that 
asparagus is the most articulate vegetable. -- Dave Barry

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Pruning to the scratch pool.

[Falk Sauer]

Hi,

Bacula 2-0-3 from rpm, os10.2 32bit x86, 
adic scalar24 with 2 SDLT320, 5,5TB NTEC IceBox over SCSI

I mean on any post in the last weeks i've read (only with one eye) over a 
option thats allows a volume after pruning, automatically moving to the 
scratch pool.

That can be a very nice feature, in the moment i make this manually.

>From which version of bacula is this option usable and how is the syntax?

And how is the pruning working in the case of reuse a volume while the sd 
needs a pruned volume and have more outtimed volumes as he needs in the 
moment? Comes here the sd first and only momentarily unused volumes going to 
the scratch pool or moves the pruning algo all pruned volumes to the scratch 
pool and the sd reuse one of the volumes after them from scratch pool?

Why i ask? If the sd picks a self pruned volume, the volume believe in the 
same pool and the use structure of the volume is every time  the same 
(monthly, weekly ...), if every time move the prune algo all of the volumes 
to the scratch pool*, we become a better [stochastic/more evenly] use 
structure of the volumes when the volumes rotate between the pools.

*) i've noticed that's the scratch pool works like a fifo.

regards
   Falk


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] New Exabyte Autochanger question

[tomasz dereszynski]

Richard White wrote:
 On 7/9/2007 at 3:47 PM, in message
> <[EMAIL PROTECTED]>, "John Drescher"
> <[EMAIL PROTECTED]> wrote:
>>> Please also note that, in the new and improved versions, the device name
>>> is enclosed in double quotes, just like in the book and your examples, but
>>> not, alas, like my originals.
>>>
>>> Now when I attempt the label barcode, I am presented with a choice of
>>> devices, VXA and Auto. I choose 'Auto', but get exactly the same result from
>>> Bacula. No matter what I do, it can't open the device "VXA3" (/dev/nst0).
>>>
>> This might be a permissions issue. Depending on your install your bacula-sd
>> may be running as user bacula. If so you need to make sure that user bacula
>> has full access to the tape drive.
>>
>> John
> 
> Well, I just did the following:
> 
> # groupadd bacula
> # vi /etc/group
> 
> Make the last line look like this:
> 
> bacula:!:1000:root,bacula,richarw
> 
> # chown bacula:bacula /dev/nst0
> 
> At this point, presumably the user and group bacula own /dev/nst0.
> 
> # ls -l /dev/nst0
> # crw-rw  1 bacula  bacula  9,  128 Jul  5 15:14  /dev/nst0
> 
> No change in result.
> 
> Most perplexing.

that was mention on group earlier
what is your system?
cos quite lot of systems is changing rights owners for devices after restart

what means u should stick it in place like  /etc/devfs.conf on FreeBSD

i dont think changing owner to bacula i a best way

i will recommend to stick bacula in 'operator' group and then in
/etc/devfs.conf add privileges for group to device


-- 
bEsT rEgArDs|   "Confidence is what you have before you
tomasz dereszynski  |   understand the problem." -- Woody Allen
TD840-RIPE  |

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Job Failed Fatal error: sql_create.c:93 Create DB Job record

[Pieter (NL)]

Updated MySQL yesterday and all backups fail with the following message(s):

Job failed.
10-Jul 10:05 backup-dir: sql_create.c:91 INSERT INTO Job
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
('halrouter.2007-07-10_10.05.22','halrouter','B','I','C','2007-07-10
10:05:20',1184054720)
10-Jul 10:05 backup-dir: halrouter.2007-07-10_10.05.22 Fatal error:
sql_create.c:93 Create DB Job record INSERT INTO Job
(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
('halrouter.2007-07-10_10.05.22','halrouter','B','I','C','2007-07-10
10:05:20',1184054720) failed. ERR=

Any suggestions?

Pieter
-- 
View this message in context: 
http://www.nabble.com/Job-Failed-Fatal-error%3A-sql_create.c%3A93-Create-DB-Job-record-tf4054580.html#a11517075
Sent from the Bacula - Users mailing list archive at Nabble.com.


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Job Failed Fatal error: sql_create.c:93 Create DB Job record

[Arno Lehmann]

Hi,

10.07.2007 10:56,, Pieter (NL) wrote::
> Updated MySQL yesterday and all backups fail with the following message(s):
> 
> Job failed.
> 10-Jul 10:05 backup-dir: sql_create.c:91 INSERT INTO Job
> (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
> ('halrouter.2007-07-10_10.05.22','halrouter','B','I','C','2007-07-10
> 10:05:20',1184054720)
> 10-Jul 10:05 backup-dir: halrouter.2007-07-10_10.05.22 Fatal error:
> sql_create.c:93 Create DB Job record INSERT INTO Job
> (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
> ('halrouter.2007-07-10_10.05.22','halrouter','B','I','C','2007-07-10
> 10:05:20',1184054720) failed. ERR=

Really no error message printed?

> Any suggestions?

Yup... check the database. MySQL can fill its table space, the cure is 
simple.
It's also possible that the MySQL server disconnected after a long 
idle time, which can also easily be fixed.
Finally, you might have a more serious problem with the database, 
which you could analyze and hopefully fix using the MySQL tools.

Since you write you updated the database, but give no more details, I 
suggest looking through the MySQL related log files first.

Arno

> Pieter

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

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] btape and bsr sd.conf tweaks

[Martin Simmons]

> On Mon, 9 Jul 2007 20:27:23 -0600, Ken Gunderson said:
> 
> Greetings:
> 
> Since my baffled post I've been doing some testing w/various sd.conf
> tweaks.  btape results and fbsd ports message initially recommended:
> 
> Due to lack of some features in the FreeBSD tape driver
> implementation you MUST add some OS dependent options to
> the bacula-sd.conf file:
> 
>   Hardware End of Medium = no;
>   Backward Space Record  = no;
>   Backward Space File= no;
> 
> With 2 filemarks at EOT (see man mt):
>   Fast Forward Space File = no;
>   BSF at EOM = yes;
>   TWO EOF= yes;
> 
> 
> While btape completes w/above no problem, from man mt it looks like FBSD
> supports bsr, however, and a few tests from command line seem to
> confirm so I trimmed sd.conf down thusly:
> 
>   Hardware End of Medium = no;
>   Fast Forward Space File = no;
>   BSF at EOM = yes;
>   TWO EOF = yes;
> 
> btape test completes fine and no longer recommend the bsr related
> tweaks.  Maybe they're not necessary and btape should be modified?
> Don't know about fill results yet - running now.  Hopefully I'll
> encounter the magic incantation to get my autochanger to actually
> change tapes...

In the current Bacula tape driver, Backward Space Record is only used to
verify that the last block has been written correctly when a tape gets full,
it is not strictly necessary.  In addition, the setting of Backward Space File
is ignored (bsf must work).

You might be able to use these settings on some FBSD tape drives:

  Fast Forward Space File = yes
  BSF at EOM = no
  TWO EOF = no

__Martin

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Winows fd random shutdowns debunked

[Arno Lehmann]

Hello,

10.07.2007 12:35,, Mantas M. wrote::
> Hello,
> 
> I've just submited a bug report regarding this issue, but until it 
> remains unsolved, i'll share my experience in case anyone else runs in 
> to the same problem:
> 
> For a long period of time i had a strange issue with windows (xp pro, 
> server 2003)  fds randomly shutting down. At last, today I figured out why.
> 
> Issue occurs at these scenarios:
> 
> * User A logs in. Then user B connects to the machine using remote 
> desktop. A dialog pops up asking if B wants to remotelly log off A. If 
> accepted, A gets logged off and fd service shuts down.
> 
> * User A logs in, locks the computer (ctrl+alt+del > lock computer). 
> Then  user B unlocks it with his account (B has to have administrative 
> privileges for this to work). The same dialog pops up, if you choose to 
> force log off of user A, the fd gets shut down.
> 
> I guess the problem is, that the file daemon service and the gui program 
> that resides in the systray are actually the same process. When the 
> systray program gets closed down, the fd service goes down as well.

That sounds reasonable.

Currently, development is under progress to separate the tray monitor 
from the FD itself (required for vista). That should fix this issue.

Arno

> 
> 
> I hope this helps... You can check the status of the bug at 
> http://bugs.bacula.org/view.php?id=893
> 
> Regards,
> Mantas
> 
> -
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users

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

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Winows fd random shutdowns debunked

[Mantas M.]

Hello,

I've just submited a bug report regarding this issue, but until it 
remains unsolved, i'll share my experience in case anyone else runs in 
to the same problem:

For a long period of time i had a strange issue with windows (xp pro, 
server 2003)  fds randomly shutting down. At last, today I figured out why.

Issue occurs at these scenarios:

* User A logs in. Then user B connects to the machine using remote 
desktop. A dialog pops up asking if B wants to remotelly log off A. If 
accepted, A gets logged off and fd service shuts down.

* User A logs in, locks the computer (ctrl+alt+del > lock computer). 
Then  user B unlocks it with his account (B has to have administrative 
privileges for this to work). The same dialog pops up, if you choose to 
force log off of user A, the fd gets shut down.

I guess the problem is, that the file daemon service and the gui program 
that resides in the systray are actually the same process. When the 
systray program gets closed down, the fd service goes down as well.



I hope this helps... You can check the status of the bug at 
http://bugs.bacula.org/view.php?id=893

Regards,
Mantas

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Winows fd random shutdowns debunked

[John Drescher]

> Currently, development is under progress to separate the tray monitor
> from the FD itself (required for vista). That should fix this issue.
>
Sorry about the delay of that I had problems with my car that are
prevented me from working on this last week. At this point the tray
has been removed from the bacula-fd but the separate tray app is not
yet started. If anyone wants the executable I do have one I could
email that has the tray removed.

John

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Help with backup plan

[Steen]

On Friday 06 July 2007 06:23:22 Charles Sprickman wrote:
> Hi all,
>
> I'm very happy with Bacula so far.  I've got a bunch of clients setup and
> have a basic config ready to go.  So far backing up to disk is working
> well and I need to figure out how to implement my real schedule and tape
> usage now.  I'm coming from Amanda, so it's taking me a bit of time to
> digest the manual.
i Know nothing of Amanda - took me a bit of time too
>
> What I'd like to do is the following:
>
> -Full backup each sunday, keeping the tapes for a year.  After that I
> would likely manually relabel all the tapes but one.  These tapes would
> all be in one pool.
>
> -Differential backup each following sunday, with 3 tapes that get recycled
> each month.  These tapes are also in their own pool.
>
> -Incrementals mon-fri, with 5 tapes that get recycled each week.  Again,
> in their own pool.
>
> Does this seem like a sane plan? 
I use almost the same pattern - but only diskbased
> I'm on the fence about the differentials 
Don't really get that
> as we very rarely go back to backups for anything...  I'm also wondering
> how these choices will impact the general ease of restoring something if
> we need to.  Again, I'm coming from Amanda, and there's not much thinking
> there.  When you restore, you just keep feeding it the tapes it wants.
Here it graps the disk volumes automatically - guess that would be identical 
to your experience with Amanda with tapes
>
> Here's what I've tentatively got in my bacula-dir config.
>
> pools:
>
> Pool {
>Name = Monthly
>Pool Type = Backup
>Recycle = no# Bacula can automatically recycle
> Volumes AutoPrune = yes # Prune expired volumes
>Volume Retention = 365 days # one year
>Volume Use Duration = 23h
>Maximum Volumes = 12
>LabelFormat = "Monthly"
> }
>
> Pool {
>Name = Weekly
>Pool Type = Backup
>Recycle = yes   # Bacula can automatically recycle
> Volumes Recycle Oldest Volume = yes
>AutoPrune = yes # Prune expired volumes
>Volume Retention =  1 month # one month
>Volume Use Duration = 6 days
>Maximum Volumes = 3
>LabelFormat = "Weekly"
> }
>
> Pool {
>Name = Daily
>Pool Type = Backup
>Recycle = yes   # Bacula can automatically recycle
> Volumes Recycle Oldest Volume = yes
>AutoPrune = yes # Prune expired volumes
>Volume Retention = 5 days   # 5 days
>Volume Use Duration = 23h
>Maximum Volumes = 5
>LabelFormat = "Daily"
> }
>
My Pool defs look like these - except I have "Accept Any Volume = yes"

> I'm hoping what I've got there will force me to put a new tape in for each
> run ("Volume Use Duration").  Am I on the right track with this or not?
Yes
> Would it be simpler to let the incrementals all go to one tape and reduce
> this to four tapes/month for those? 
Yes - no need to switch tapes
> I'm using 100GB LTO-2 tapes, so I 
> certainly have more than enough room, but I suppose I open myself up to
> problems if a tape fails...
Yes - loose 5 days at most
> Does the above config look fairly sane?
>

To me - yes
> Thanks,
>
> Charles
>
> -
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users



-- 
Regards

Steen

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Winows fd random shutdowns debunked

[Mantas M.]

Hi John,

Yes, it would be great if You could email the executable or upload it 
somewhere.

Thanks,

Mantas.



John Drescher wrote:
>> Currently, development is under progress to separate the tray monitor
>> from the FD itself (required for vista). That should fix this issue.
>>
> Sorry about the delay of that I had problems with my car that are
> prevented me from working on this last week. At this point the tray
> has been removed from the bacula-fd but the separate tray app is not
> yet started. If anyone wants the executable I do have one I could
> email that has the tray removed.
> 
> John
> 
> -
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
> 


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Winows fd random shutdowns debunked

[John Drescher]

On 7/10/07, Mantas M. <[EMAIL PROTECTED]> wrote:
> Hi John,
>
> Yes, it would be great if You could email the executable or upload it
> somewhere.
>

I was having a very difficult time trying to get gmail or comcast to
host the file so I tried a free binary host service.The link is below.
You go to this site and click on request download link on the upper
left. After that you click download file on the upper right.

http://mihd.net/mtqigz

John

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] bacula lto-2 drive performance?

[Bob Hetzel]

Hi all,

I'm currently implementing a new bacula server running on a new dual 
core/dual cpu Dell PowerEdge 2900 server into a Dell Powervault 136T 
with a LTO-2 drive (IBM Ultrium-td2 model).  The tape drive and robot 
are on a dedicated Adaptec 29160 card.  The OS is OpenSuse 10.2

I think I should be able to get around 100 gigabytes/hour backup data 
rate with this hardware, but it looks like I'm getting about half that. 
  Of those of you running bacula on LTO-2 hardware, what kind of backup 
rates do you get?

Also, if you've got substantially better than 50 GB/hr on LTO-2 
hardware, what scsi card are you using?

Any other suggestions?

Bob

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Job Failed Fatal error: sql_create.c:93 Create DB Job record

[Pieter (NL)]

There was really no error message. Rebooted the server and recompiled and
reinstalled mysql51-server and client and it's working again. Don't know why
the problem disappeared.



Arno Lehmann wrote:
> 
> Hi,
> 
> 10.07.2007 10:56,, Pieter (NL) wrote::
>> Updated MySQL yesterday and all backups fail with the following
>> message(s):
>> 
>> Job failed.
>> 10-Jul 10:05 backup-dir: sql_create.c:91 INSERT INTO Job
>> (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
>> ('halrouter.2007-07-10_10.05.22','halrouter','B','I','C','2007-07-10
>> 10:05:20',1184054720)
>> 10-Jul 10:05 backup-dir: halrouter.2007-07-10_10.05.22 Fatal error:
>> sql_create.c:93 Create DB Job record INSERT INTO Job
>> (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
>> ('halrouter.2007-07-10_10.05.22','halrouter','B','I','C','2007-07-10
>> 10:05:20',1184054720) failed. ERR=
> 
> Really no error message printed?
> 
>> Any suggestions?
> 
> Yup... check the database. MySQL can fill its table space, the cure is 
> simple.
> It's also possible that the MySQL server disconnected after a long 
> idle time, which can also easily be fixed.
> Finally, you might have a more serious problem with the database, 
> which you could analyze and hopefully fix using the MySQL tools.
> 
> Since you write you updated the database, but give no more details, I 
> suggest looking through the MySQL related log files first.
> 
> Arno
> 
>> Pieter
> 
> -- 
> Arno Lehmann
> IT-Service Lehmann
> www.its-lehmann.de
> 
> -
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Job-Failed-Fatal-error%3A-sql_create.c%3A93-Create-DB-Job-record-tf4054580.html#a11522451
Sent from the Bacula - Users mailing list archive at Nabble.com.


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Please mount volume...but volume is already mounted.

[Brian Debelius]

elkton-dir Version: 2.1.22 (26 June 2007) Linux Cross-compile Win32

Hey,
I am still getting this mounting problem.  Bacula loads the correct 
tape, but then says that I need to mount it.  After which I release, and 
mount the same tape, and it then proceed to backup.

brian-


10-Jul 09:28 elkton-dir: Recycled volume "A009"
10-Jul 09:28 elkton-sd: 3307 Issuing autochanger "unload slot 3, drive 
0" command.
10-Jul 09:29 elkton-sd: 3304 Issuing autochanger "load slot 4, drive 0" 
command.
10-Jul 09:31 elkton-sd: 3305 Autochanger "load slot 4, drive 0", status 
is OK.
10-Jul 09:31 elkton-sd: 3301 Issuing autochanger "loaded? drive 0" command.
10-Jul 09:31 elkton-sd: 3302 Autochanger "loaded? drive 0", result is 
Slot 4.
10-Jul 09:31 elkton-sd: Please mount Volume "A009" or label a new 
one for:
Job:  Elkton_D-drive.2007-07-10_00.01.25
Storage:  "VXA-172" (Tape0)
Pool: Tape-daily
Media type:   X10
*update slots
Automatically selected Catalog: MyCatalog
Using Catalog "MyCatalog"
The defined Storage resources are:
 1: Disk0
 2: Disk1
 3: Tape
Select Storage resource (1-3): 3
Connecting to Storage daemon Tape at elkton.intelesys.local:9103 ...
3306 Issuing autochanger "slots" command.
Device "Packetloader0" has 10 slots.
Connecting to Storage daemon Tape at elkton.intelesys.local:9103 ...
3306 Issuing autochanger "list" command.
Catalog record for Volume "A004" updated to reference slot 1.*release
The defined Storage resources are:
 1: Disk0
 2: Disk1
 3: Tape
Select Storage resource (1-3): 3
3307 Issuing autochanger "unload slot 4, drive 0" command.
3922 Device "VXA-172" (Tape0) waiting for sysop.
*mount
The defined Storage resources are:
 1: Disk0
 2: Disk1
 3: Tape
Select Storage resource (1-3): 3
Enter autochanger slot: 4
3001 OK mount. Device="VXA-172" (Tape0)
Catalog record for Volume "A003" updated to reference slot 2.
Catalog record for Volume "A008" updated to reference slot 3.
Catalog record for Volume "B006" updated to reference slot 5.
Catalog record for Volume "A001" updated to reference slot 6.
Catalog record for Volume "CLNA0002" updated to reference slot 10.
Catalog record for Volume "A009" updated to reference slot 4.
10-Jul 10:50 elkton-sd: 3301 Issuing autochanger "loaded? drive 0" command.
10-Jul 10:50 elkton-sd: 3302 Autochanger "loaded? drive 0", result: 
nothing loaded.
10-Jul 10:50 elkton-sd: 3304 Issuing autochanger "load slot 4, drive 0" 
command.
10-Jul 10:51 elkton-sd: 3305 Autochanger "load slot 4, drive 0", status 
is OK.
10-Jul 10:51 elkton-sd: 3301 Issuing autochanger "loaded? drive 0" command.
10-Jul 10:51 elkton-sd: 3302 Autochanger "loaded? drive 0", result is 
Slot 4.
10-Jul 10:51 elkton-sd: Recycled volume "A009" on device "VXA-172" 
(Tape0), all previous data lost.
10-Jul 10:51 elkton-sd: New volume "A009" mounted on device 
"VXA-172" (Tape0) at 10-Jul-2007 10:51.


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Please mount volume...but volume is already mounted.

[mikee]

On Tue, 10 Jul 2007, Brian Debelius might have said:

> elkton-dir Version: 2.1.22 (26 June 2007) Linux Cross-compile Win32
> 
> Hey,
> I am still getting this mounting problem.  Bacula loads the correct 
> tape, but then says that I need to mount it.  After which I release, and 
> mount the same tape, and it then proceed to backup.
> 
> brian-

How about umounting the mounting the volume?

Mike

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] btape and bsr sd.conf tweaks

[Ken Gunderson]

On Tue, 10 Jul 2007 11:12:35 +0100
Martin Simmons <[EMAIL PROTECTED]> wrote:

> > On Mon, 9 Jul 2007 20:27:23 -0600, Ken Gunderson said:
> > 
> > Greetings:
> > 
> > Since my baffled post I've been doing some testing w/various sd.conf
> > tweaks.  btape results and fbsd ports message initially recommended:
> > 
> > Due to lack of some features in the FreeBSD tape driver
> > implementation you MUST add some OS dependent options to
> > the bacula-sd.conf file:
> > 
> >   Hardware End of Medium = no;
> >   Backward Space Record  = no;
> >   Backward Space File= no;
> > 
> > With 2 filemarks at EOT (see man mt):
> >   Fast Forward Space File = no;
> >   BSF at EOM = yes;
> >   TWO EOF= yes;
> > 
> > 
> > While btape completes w/above no problem, from man mt it looks like FBSD
> > supports bsr, however, and a few tests from command line seem to
> > confirm so I trimmed sd.conf down thusly:
> > 
> >   Hardware End of Medium = no;
> >   Fast Forward Space File = no;
> >   BSF at EOM = yes;
> >   TWO EOF = yes;
> > 
> > btape test completes fine and no longer recommend the bsr related
> > tweaks.  Maybe they're not necessary and btape should be modified?
> > Don't know about fill results yet - running now.  Hopefully I'll
> > encounter the magic incantation to get my autochanger to actually
> > change tapes...
> 
> In the current Bacula tape driver, Backward Space Record is only used to
> verify that the last block has been written correctly when a tape gets full,
> it is not strictly necessary.  In addition, the setting of Backward Space File
> is ignored (bsf must work).
> 
> You might be able to use these settings on some FBSD tape drives:
> 
>   Fast Forward Space File = yes
>   BSF at EOM = no
>   TWO EOF = no
> 
> __Martin

Thanks. I know that it's optional and not needed.  But it seems btape's
suggestions regarding sd.conf tweaks may be a bit inconsistent depending
upon what flags are already set.

This is all a bit confusing on FBSD because per mtio man page various
calls referenced in sd.conf docs are supported, e.g. mtiocget, mtbsr,
mtfsf, etc.  Whether they're supported by SCSI device/driver remains
uncertain, as I don't know how to test.  In this case I'm using LSI
controller and mpt driver.  My assumption was that since btape said I
needed sd flags such as Backward Space Record, etc. that it did not.
But it looks like it does.  So I'm wondering whether the issue is with
btape erroneously reporting or the mpt driver.

To recap, btape and manual backups and restores work but Autochanger is
not changing tapes when it should so I suspected something was not
quite right in sd.conf.

To follow up, btape completed fine.  In this case drive is ARCVault12
w/LTO-2 Drive.  Drive in this one is an HP.  But since HP does no
longer make their own drives who knows...



-- 
Best regards,

Ken Gunderson
GPG Key -- 9F5179FD

"Never hold discussions with the monkey when the organ grinder is in
the room." - Sir Winston Churchill

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] confused by automatic purging

[Craig White]

I have a 3 week rotation with a full backup each Friday and differential
backups every weekday.

Last night, upon execution, the 1_Monday_Week_1 AND 1_Monday_Week_2 were
both purged and it shouldn't have purged 1_Monday_Week_2

from my backup logs...

09-Jul 20:00 SRV1: Start Backup JobId 91,
Job=SRV1Backup.2007-07-09_20.00.00
09-Jul 20:00 SRV1: Pruned 3 Jobs on Volume "1_Monday_Week_1" from
catalog.
09-Jul 20:00 SRV1: ua_purge.c:611 All records pruned from Volume
"1_Monday_Week_1"; marking it "Purged"
09-Jul 20:00 SRV1: ua_purge.c:611 All records pruned from Volume
"1_Monday_Week_2"; marking it "Purged"
09-Jul 20:00 SRV1: Recycled volume "1_Monday_Week_1"
09-Jul 20:00 SRV1: Recycled volume "1_Monday_Week_1" on device
"DDS-4" (/dev/nst0), all previous data lost.

My MondayPool is defined as...
Pool {
  Name = MondayPool
  Pool Type = Backup
  Recycle = yes
  AutoPrune = yes
  Volume Retention = 19d
  Volume Use Duration = 4d
  Maximum Volume Jobs = 5
}

and according to list media...
| MediaId | VolumeName  | VolStatus | Enabled | VolBytes   |
VolFiles | VolRetention | Recycle | Slot | InChanger | MediaType |
LastWritten |
+-+-+---+-++--+--+-+--+---+---+-+
|   2 | 1_Monday_Week_2 | Purged|   1 | 25,815,250,944 |
26 |1,641,600 |   1 |0 | 1 | DDS-4 | 2007-06-25
22:07:04 |

My 1_Monday_Week_2 was last written on 6/25/2007 which is clearly not 19
days of Volume Retention.

Is there something wrong with my understanding of this?

# rpm -qa|grep bacula
bacula-mysql-2.0.3-1
bacula-mtx-2.0.3-1
bacula-wxconsole-2.0.3-1
bacula-gconsole-2.0.3-1

-- 
Craig White <[EMAIL PROTECTED]>


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] btape and bsr sd.conf tweaks

[Martin Simmons]

> On Tue, 10 Jul 2007 09:10:24 -0600, Ken Gunderson said:
> 
> On Tue, 10 Jul 2007 11:12:35 +0100
> Martin Simmons <[EMAIL PROTECTED]> wrote:
> 
> > > On Mon, 9 Jul 2007 20:27:23 -0600, Ken Gunderson said:
> > > 
> > > Greetings:
> > > 
> > > Since my baffled post I've been doing some testing w/various sd.conf
> > > tweaks.  btape results and fbsd ports message initially recommended:
> > > 
> > > Due to lack of some features in the FreeBSD tape driver
> > > implementation you MUST add some OS dependent options to
> > > the bacula-sd.conf file:
> > > 
> > >   Hardware End of Medium = no;
> > >   Backward Space Record  = no;
> > >   Backward Space File= no;
> > > 
> > > With 2 filemarks at EOT (see man mt):
> > >   Fast Forward Space File = no;
> > >   BSF at EOM = yes;
> > >   TWO EOF= yes;
> > > 
> > > 
> > > While btape completes w/above no problem, from man mt it looks like FBSD
> > > supports bsr, however, and a few tests from command line seem to
> > > confirm so I trimmed sd.conf down thusly:
> > > 
> > >   Hardware End of Medium = no;
> > >   Fast Forward Space File = no;
> > >   BSF at EOM = yes;
> > >   TWO EOF = yes;
> > > 
> > > btape test completes fine and no longer recommend the bsr related
> > > tweaks.  Maybe they're not necessary and btape should be modified?
> > > Don't know about fill results yet - running now.  Hopefully I'll
> > > encounter the magic incantation to get my autochanger to actually
> > > change tapes...
> > 
> > In the current Bacula tape driver, Backward Space Record is only used to
> > verify that the last block has been written correctly when a tape gets full,
> > it is not strictly necessary.  In addition, the setting of Backward Space 
> > File
> > is ignored (bsf must work).
> > 
> > You might be able to use these settings on some FBSD tape drives:
> > 
> >   Fast Forward Space File = yes
> >   BSF at EOM = no
> >   TWO EOF = no
> > 
> > __Martin
> 
> Thanks. I know that it's optional and not needed.  But it seems btape's
> suggestions regarding sd.conf tweaks may be a bit inconsistent depending
> upon what flags are already set.
> 
> This is all a bit confusing on FBSD because per mtio man page various
> calls referenced in sd.conf docs are supported, e.g. mtiocget, mtbsr,
> mtfsf, etc.  Whether they're supported by SCSI device/driver remains
> uncertain, as I don't know how to test.  In this case I'm using LSI
> controller and mpt driver.  My assumption was that since btape said I
> needed sd flags such as Backward Space Record, etc. that it did not.
> But it looks like it does.  So I'm wondering whether the issue is with
> btape erroneously reporting or the mpt driver.
> 
> To recap, btape and manual backups and restores work but Autochanger is
> not changing tapes when it should so I suspected something was not
> quite right in sd.conf.

AFAIK, problems with the mechanics of tape changing in the autochanger will
not be affected by any of the mtio options.  The changer is a separate device
with its own protocol.

__Martin

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] New Exabyte Autochanger question

[Richard White]

> what means u should stick it in place like  /etc/devfs.conf on FreeBSD

This is SUSE, so I have no /etc/devfs.conf.

Well, my problem is not with Bacula itself. I loaded a tape into the drive and 
issued this at the command line:

# mt -f /dev/nst0 rewind
# mt: /dev/nst0: Input/output error

So the computer itself can't see the drive. However, commands issued to the 
autchanger work just fine. I loaded a tape into the drive with this:

# ./mtx-changer /dev/sg1 load 1 /dev/nst0 0

Unloading works as well.

So I re-booted. After loading a tape, mt shows normal results. Still, *label 
barcode has the same input/output errors.

After loading a tape, mt -f /dev/nst0 status shows this:
drive type = Generic SCSI-2 tape
drive status = -211392892
sense key error = 0
residue count = 0
file number = 0
block number = 0
Tape block size 1024 bytes. Density code 0x82 (unknown).
Soft error count since last status=01
General status bits on (4101):
  BOT ONLINE IM_REP_EN

It does not make a CR-LF at the end of the last line, so the command prompt 
appears right after '_EN'.

The tape drive /dev/nst0 passes the mt and tar test (tar cvf /dev/nst0 . 
followed by a rewind and tar tvf /dev/nst0), so the OS seems to be happy with 
the drive.

OK, Bacula will label the volumes one at a time. From bconsole I issue a label 
command, select the autochanger device from the storage resource list, give it 
the name of the tape in slot 1, and select the Daily pool. Here's what bacula 
tells me:

Connecting to Storage daemon Auto at bacula-test:9103 ...
Sending label command for Volume "A001" Slot 0 ...
Invalid slot=0 defined, cannot autload Volume.
3301 Issuing autochanger "loaded? drive 0" command.
3302 Auchanger"loaded? drive 0", result is Slot 1
block.c:275 volume data error at 0:0! Wanded ID: "BB02", got "". Buffer 
discarded.
3000 OK label. VolBytes=64512 DVD=0 Volume="A001" Device="VXA3" (/dev/nst0)
Catalog record for Volume "A001", Slot 0 successfully creatged.
Requesting to mount VXA3 ...
3001 Device "VXA3" (/dev/nst0) is mounted with Volume "A001"
You have messages.
*m
10-Jul 08:55 bacula-dir:  Error: bnet.c:439 Write error sending 57 bytes to 
client:127:0.0.2:36131:  ERR=Broken pipe

If, however, I issue this command:

*label storage=Auto volume=A002 slot=2

Bacula deals with it flawlessly. I do get the I/O error mentioned in the 
manual, but otherwise it's OK. Much ado about nothing, I suppose, but I'm under 
some pressure here.

Thanks to all.
-- 

Tks n rgds,
Richard White CNE6, Linux+
Network Engineer
Mason County, Washington
360-427-5501
[EMAIL PROTECTED]


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] confused by automatic purging

[John Drescher]

On 7/10/07, Craig White <[EMAIL PROTECTED]> wrote:


I have a 3 week rotation with a full backup each Friday and differential
backups every weekday.

Last night, upon execution, the 1_Monday_Week_1 AND 1_Monday_Week_2 were
both purged and it shouldn't have purged 1_Monday_Week_2

from my backup logs...

09-Jul 20:00 SRV1: Start Backup JobId 91,
Job=SRV1Backup.2007-07-09_20.00.00
09-Jul 20:00 SRV1: Pruned 3 Jobs on Volume "1_Monday_Week_1" from
catalog.
09-Jul 20:00 SRV1: ua_purge.c:611 All records pruned from Volume
"1_Monday_Week_1"; marking it "Purged"
09-Jul 20:00 SRV1: ua_purge.c:611 All records pruned from Volume
"1_Monday_Week_2"; marking it "Purged"
09-Jul 20:00 SRV1: Recycled volume "1_Monday_Week_1"
09-Jul 20:00 SRV1: Recycled volume "1_Monday_Week_1" on device
"DDS-4" (/dev/nst0), all previous data lost.

My MondayPool is defined as...
Pool {
  Name = MondayPool
  Pool Type = Backup
  Recycle = yes
  AutoPrune = yes
  Volume Retention = 19d
  Volume Use Duration = 4d
  Maximum Volume Jobs = 5
}



Quick question. Have you changed this pool definition after labeling these
tapes? As each tape has an independent Volume Retention that is stored in
the database when the tape is labeled.  This value  is  taken from the
loaded pool definition at that time.

John
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] New Exabyte Autochanger question

[Richard White]

I spoke too soon. If I issue this command:

*label storage=Auto volume=A002 slot=2

the command will fail. If, however, I load slot 2 into the drive (of course, it 
will already be there if I issued the above command; if I haven't, I can load 
it with './mtx-changer /dev/sg1 load 2 /dev/nst0 0' at the shell prompt), then 
issue:

*label storage=VXA volume=A002

That will work.

Now that I have my tapes labeled, I need to figure out how to do a backup with 
this library.
-- 

Tks n rgds,
Richard White CNE6, Linux+
Network Engineer
Mason County, Washington
360-427-5501
[EMAIL PROTECTED]


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Pruning to the scratch pool.

[Andreas Helmcke]

Falk Sauer wrote:
> I mean on any post in the last weeks i've read (only with one eye) over a 
> option thats allows a volume after pruning, automatically moving to the 
> scratch pool.
> 
> That can be a very nice feature, in the moment i make this manually.
> 
> From which version of bacula is this option usable and how is the syntax?
> 

>From the chapter: "The Pool Resource" from the actual bacula manual:

 The Pool Resource

 RecyclePool = 
  On versions 2.1.4 or greater, Bacula can recycle media in the pool of
your choice. The most useful setup is to use Scratch.


Version 2.1.4 is not quite right ;-). This option is under rework by Kern just
at the moment so it will hopefully be usable with next release (2.1.26 (beta
version) or 2.2.0 (release version))

> And how is the pruning working in the case of reuse a volume while the sd 
> needs a pruned volume and have more outtimed volumes as he needs in the 
> moment? Comes here the sd first and only momentarily unused volumes going to 
> the scratch pool or moves the pruning algo all pruned volumes to the scratch 
> pool and the sd reuse one of the volumes after them from scratch pool?

This is one of the points, which are changing at the moment ;-)

But in general bacula will try to prune volumes only when absolutely necessary
and prefer the requested pool. So it will most likely use volumes from the
"wrong" pool only when there are no usable volumes in neither the "correct"
pool nor the scratch pool.

> Why i ask? If the sd picks a self pruned volume, the volume believe in the 
> same pool and the use structure of the volume is every time  the same 
> (monthly, weekly ...), if every time move the prune algo all of the volumes 
> to the scratch pool*, we become a better [stochastic/more evenly] use 
> structure of the volumes when the volumes rotate between the pools.
> 
> *) i've noticed that's the scratch pool works like a fifo.

Also it might be nice this is not a (main) feature of the pruning algorithm.
But improving the tapemanagement is on the wishlist for bacula (see Item 25 on
the projekts-list: http://www.bacula.org/?page=projects )


Andreas


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Unsure of btape output when testing autochanger

[Shon Stephens]

I am not sure of the expected behaviour of btape and am following the User
Guide in configuring, testing my autochanger (Exabyte Magnum 224 LTO-3) with
Bacula. I have already tested the tape device with mt and the changer with
mtx. The mtx-changer script is working as described by the guide. I start
with the tapes loaded in the magazine of the autochanger and no tape in the
drive. If I run the first test

btape -c bacula-sd.conf /dev/rmt/0cbn
Tape block granularity is 1024 bytes.
btape: butil.c:286 Using device: "/dev/rmt/0cbn" for writing.
10-Jul 14:37 btape: 3301 Issuing autochanger "loaded? drive 0" command.
10-Jul 14:37 btape: 3302 Autochanger "loaded? drive 0", result: nothing
loaded.
10-Jul 14:37 btape: Fatal Error at device.c:280 because:
dev open failed: dev.c:425 Unable to open device "Ultrium-TD3"
(/dev/rmt/0cbn): ERR=I/O error
10-Jul 14:37 btape: btape Fatal error: butil.c:195 Cannot open "Ultrium-TD3"
(/dev/rmt/0cbn)

It seems that btape is detecting that no tape is loaded, but doesn't try to
load one. Is this its correct behavior?
I load the tape in Slot 1 into the drive directly with mtx and try again.

btape -c bacula-sd.conf /dev/rmt/0cbn
Tape block granularity is 1024 bytes.
btape: butil.c:286 Using device: "/dev/rmt/0cbn" for writing.
10-Jul 14:51 btape: 3301 Issuing autochanger "loaded? drive 0" command.
10-Jul 14:51 btape: 3302 Autochanger "loaded? drive 0", result is Slot 1.
10-Jul 14:51 btape: 3301 Issuing autochanger "loaded? drive 0" command.
10-Jul 14:51 btape: 3302 Autochanger "loaded? drive 0", result is Slot 1.
btape: btape.c:368 open device "Ultrium-TD3" (/dev/rmt/0cbn): OK

This seems to work, so I run the "test" command in btape

btape: btape.c:1348 Now forward spacing 1 more file.
We should be in file 5. I am at file 5. This is correct!

=== End Forward space files test ===

Ah, I see you have an autochanger configured.
To test the autochanger you must have a blank tape
that I can write on in Slot 1.

Do you wish to continue with the Autochanger test? (y/n):

=== Autochanger test ===

3301 Issuing autochanger "loaded" command.
Slot 1 loaded. I am going to unload it.
3302 Issuing autochanger "unload 1 0" command.
unload status=OK 0
3303 Issuing autochanger "load 1 0" command.
3303 Autochanger "load 1 0" status is OK.
10-Jul 14:55 btape: 3301 Issuing autochanger "loaded? drive 0" command.
10-Jul 14:55 btape: 3302 Autochanger "loaded? drive 0", result is Slot 1.
btape: btape.c:368 open device "Ultrium-TD3" (/dev/rmt/0cbn): OK
btape: btape.c:1235 Rewound "Ultrium-TD3" (/dev/rmt/0cbn)
btape: btape.c:1242 Wrote EOF to "Ultrium-TD3" (/dev/rmt/0cbn)

The test autochanger worked!!

So it seems that btape can issue a load command, and unload properly. So
whats the deal? Should btape has loaded a tape in the first place when it
didn't detect one?

Thanks,
Shon
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] confused by automatic purging

[Arno Lehmann]

Hi,

10.07.2007 20:11,, John Drescher wrote::
> 
> 
> On 7/10/07, *Craig White* <[EMAIL PROTECTED] 
> > wrote:
> 
> I have a 3 week rotation with a full backup each Friday and differential
> backups every weekday.
> 
> Last night, upon execution, the 1_Monday_Week_1 AND 1_Monday_Week_2 were
> both purged and it shouldn't have purged 1_Monday_Week_2
> 
> from my backup logs...
> 
> 09-Jul 20:00 SRV1: Start Backup JobId 91,
> Job=SRV1Backup.2007-07-09_20.00.00
> 09-Jul 20:00 SRV1: Pruned 3 Jobs on Volume "1_Monday_Week_1" from
> catalog.
> 09-Jul 20:00 SRV1: ua_purge.c:611 All records pruned from Volume
> "1_Monday_Week_1"; marking it "Purged"
> 09-Jul 20:00 SRV1: ua_purge.c:611 All records pruned from Volume
> "1_Monday_Week_2"; marking it "Purged"
> 09-Jul 20:00 SRV1: Recycled volume "1_Monday_Week_1"
> 09-Jul 20:00 SRV1: Recycled volume "1_Monday_Week_1" on device
> "DDS-4" (/dev/nst0), all previous data lost.
> 
> My MondayPool is defined as...
> Pool {
>   Name = MondayPool
>   Pool Type = Backup
>   Recycle = yes
>   AutoPrune = yes
>   Volume Retention = 19d
>   Volume Use Duration = 4d
>   Maximum Volume Jobs = 5
> }
> 
> 
> Quick question. Have you changed this pool definition after labeling 
> these tapes? As each tape has an independent Volume Retention that is 
> stored in the database when the tape is labeled.  This value  is  taken 
> from the loaded pool definition at that time.

Unfortunately, the 1,641,600 seconds reported by the list are exactly 
19 days... unless my windows' calculator is broken (or I screwed the 
divisions up).

I'd rather suspect that all jobs on that volume were beyond their 
retention - the messages indicate that there are no more jobs stored 
on the volume (compare with the other volume where it reports that 
records were pruned).

Arno

> John
> 
> 
> 
> 
> -
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> 
> 
> 
> 
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users

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

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Unsure of btape output when testing autochanger

[Arno Lehmann]

Hi,

10.07.2007 21:01,, Shon Stephens wrote::
> I am not sure of the expected behaviour of btape and am following the 
> User Guide in configuring, testing my autochanger (Exabyte Magnum 224 
> LTO-3) with Bacula. I have already tested the tape device with mt and 
> the changer with mtx. The mtx-changer script is working as described by 
> the guide. I start with the tapes loaded in the magazine of the 
> autochanger and no tape in the drive. If I run the first test
> 
> btape -c bacula-sd.conf /dev/rmt/0cbn
> Tape block granularity is 1024 bytes.
> btape: butil.c:286 Using device: "/dev/rmt/0cbn" for writing.
> 10-Jul 14:37 btape: 3301 Issuing autochanger "loaded? drive 0" command.
> 10-Jul 14:37 btape: 3302 Autochanger "loaded? drive 0", result: nothing 
> loaded.
> 10-Jul 14:37 btape: Fatal Error at device.c:280 because:
> dev open failed: dev.c:425 Unable to open device "Ultrium-TD3" 
> (/dev/rmt/0cbn): ERR=I/O error
> 10-Jul 14:37 btape: btape Fatal error: butil.c:195 Cannot open 
> "Ultrium-TD3" (/dev/rmt/0cbn)
> 
> It seems that btape is detecting that no tape is loaded, but doesn't try 
> to load one. Is this its correct behavior?

It always behaved like this for me at least.

> I load the tape in Slot 1 into the drive directly with mtx and try again.
> 
> btape -c bacula-sd.conf /dev/rmt/0cbn
> Tape block granularity is 1024 bytes.
> btape: butil.c:286 Using device: "/dev/rmt/0cbn" for writing.
> 10-Jul 14:51 btape: 3301 Issuing autochanger "loaded? drive 0" command.
> 10-Jul 14:51 btape: 3302 Autochanger "loaded? drive 0", result is Slot 1.
> 10-Jul 14:51 btape: 3301 Issuing autochanger "loaded? drive 0" command.
> 10-Jul 14:51 btape: 3302 Autochanger "loaded? drive 0", result is Slot 1.
> btape: btape.c:368 open device "Ultrium-TD3" (/dev/rmt/0cbn): OK
> 
> This seems to work, so I run the "test" command in btape
> 
> btape: btape.c:1348 Now forward spacing 1 more file.
> We should be in file 5. I am at file 5. This is correct!
> 
> === End Forward space files test ===
> 
> Ah, I see you have an autochanger configured.
> To test the autochanger you must have a blank tape
>  that I can write on in Slot 1.
> 
> Do you wish to continue with the Autochanger test? (y/n):
> 
> === Autochanger test ===
> 
> 3301 Issuing autochanger "loaded" command.
> Slot 1 loaded. I am going to unload it.
> 3302 Issuing autochanger "unload 1 0" command.
> unload status=OK 0
> 3303 Issuing autochanger "load 1 0" command.
> 3303 Autochanger "load 1 0" status is OK.
> 10-Jul 14:55 btape: 3301 Issuing autochanger "loaded? drive 0" command.
> 10-Jul 14:55 btape: 3302 Autochanger "loaded? drive 0", result is Slot 1.
> btape: btape.c:368 open device "Ultrium-TD3" (/dev/rmt/0cbn): OK
> btape: btape.c:1235 Rewound "Ultrium-TD3" (/dev/rmt/0cbn)
> btape: btape.c:1242 Wrote EOF to "Ultrium-TD3" (/dev/rmt/0cbn)
> 
> The test autochanger worked!!
> 
> So it seems that btape can issue a load command, and unload properly. So 
> whats the deal? Should btape has loaded a tape in the first place when 
> it didn't detect one?

I suppose that's because btape is really only a very simple test tool 
and the autochanger usage is not implemented in basic tape drive testing.

Nothing to worry about, that only ensures you know how to operate your 
autochanger even when it doesn't work automatically ;-)

Arno

> Thanks,
> Shon
> 
> 
> 
> 
> -
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> 
> 
> 
> 
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users

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

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] bacula lto-2 drive performance?

[[EMAIL PROTECTED]]

El mar, 10-07-2007 a las 10:31 -0400, Bob Hetzel escribió:
> Hi all,
> 
> I'm currently implementing a new bacula server running on a new dual 
> core/dual cpu Dell PowerEdge 2900 server into a Dell Powervault 136T 
> with a LTO-2 drive (IBM Ultrium-td2 model).  The tape drive and robot 
> are on a dedicated Adaptec 29160 card.  The OS is OpenSuse 10.2
> 
> I think I should be able to get around 100 gigabytes/hour backup data 
> rate with this hardware, but it looks like I'm getting about half that. 
>   Of those of you running bacula on LTO-2 hardware, what kind of backup 
> rates do you get?
> 
> Also, if you've got substantially better than 50 GB/hr on LTO-2 
> hardware, what scsi card are you using?
> 
> Any other suggestions?
> 
> Bob

I'm interested too, I've an HP LTO-2 and bacula says that gets 1,5
MB/sec ( for both backup clients, local and remote )

I'm not an average user of scsi tape devices, any tip will be very
wellcome :)

Regards

D.


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] bacula lto-2 drive performance?

[John Drescher]

I'm interested too, I've an HP LTO-2 and bacula says that gets 1,5
MB/sec ( for both backup clients, local and remote )

I'm not an average user of scsi tape devices, any tip will be very
wellcome :)



These numbers are highly dependent on the backup type (full, incremental
...) and the ability to compress the data, the network speed (as you will
need a gigabit connection to get > 10MB/s over a network, database,
concurrency settings, hard drive performance, and spooling. I have jobs that
get 1MB/s and other jobs that get 25MB/s.
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] bacula lto-2 drive performance?

[Paul Heinlein]

On Tue, 10 Jul 2007, John Drescher wrote:

>>  I'm interested too, I've an HP LTO-2 and bacula says that gets 1,5
>>  MB/sec ( for both backup clients, local and remote )
>>
>>  I'm not an average user of scsi tape devices, any tip will be very
>>  wellcome :)
>
> These numbers are highly dependent on the backup type (full, 
> incremental ...) and the ability to compress the data, the network 
> speed (as you will need a gigabit connection to get > 10MB/s over a 
> network, database, concurrency settings, hard drive performance, and 
> spooling. I have jobs that get 1MB/s and other jobs that get 25MB/s.

I spool in 50GB chunks. For full backups, network transfer rates hover 
around 5MB/s, while streaming to tape varies:

  * 35MB/s -- development hosts (lots of source code)
  * 22MB/s -- home and project directories (mixed code and binaries)
  * 16MB/s -- database server (mostly binaries)

I suspect the median speed is about 22MB/s, but I've never subjected 
my Bacula logs to statistical analysis. :-)

Overall speed (spooling, streaming to tape, writing attrs to database) 
is around 3MB/s.

Oh, yeah, this is 2.0.3 (server and all clients) to a Dell PowerVault 
122T with an Ultrium LTO-2 drive.

-- 
Paul Heinlein <> [EMAIL PROTECTED] <> http://www.madboa.com/

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Reuse old tapes not working correctly

[Jason King]

I have 8 tapes in a cycle. Bacula is suppose to run until the tape is 
full. I have the volume retention set to 4 months, then after that 4 
months the tape should then be in "recycle" or "append" mode and I 
should be able to write data to it fresh. But now each tape is only 
holding a fraction of what is use to be able to hold. Example, I have 
200/400 LTO tapes. The first tape that came back into rotation held 
about 300G the first time around, this time it held about 150G. The next 
tape held only about 140G and the next one only held 600Meg before it 
was labeled "full". Am I not recycling my tapes correctly? Please assist.

Jason

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] btape test works;backup works;restore doesn't

[Michael Hughes]

  I have loaded Bacula 2.0.3 from source on my FreeBSD system.  I ran
btape test and it passed all the tests.  Also ran the autoloader test
and that passed.

  I did a full backup which fit on one DLT IV tape.  Then I wanted to
do a test restore to make sure things are working before I stop doing
my dump(8).  When I do a restore, I picked a couple of files and the
restore started.  I have search the web and having been able to find
anything like this.  I have also noticed that the drive seems to go 
offline right after the restore job starts.  Then it loads the tape 
again, but gets the error.  Here are the errors I get:

Forward spacing Volume "AI0011" to file:block 5:0.
RestoreFiles.2007-07-10_13.00.18 Error: block.c:993 Read error on fd=6 at 
file:blk 5:2563 on device "DLT_9" (/dev/nsa1). ERR=Operation not permitted.
RestoreFiles.2007-07-10_13.00.18 Error: Unexpected Tape is Off-line

  Here is my bacula-sd.conf for the device:

Autochanger {
  Name= Autochanger
  Device  = DLT_9
  Changer Command = "/mnt4/mdh/bacula-2.0.3/examples/autochangers/rc 
chio-changer %c %o %S %a %d"
  Changer Device  = /dev/ch0
}

Device {
  Name= DLT_9
  Drive Index = 0
  Media Type  = DLT
  Archive Device  = /dev/nsa1
  AutomaticMount  = yes;
  LabelMedia  = yes;  
  RemovableMedia  = yes;
  AutoChanger = yes
  Offline On Unmount  = no
  Hardware End of Medium  = no
  BSF at EOM  = yes
  Backward Space Record   = no
  Backward Space File = no
  Fast Forward Space File = no
  TWO EOF = yes
}

--
Michael Hughes  Log Home living is the best
[EMAIL PROTECTED]

Temperatures:
Outside: 77.9 House: 71.2 Computer room: 69.7

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] New Exabyte Autochanger question

[tomasz dereszynski]

Richard White wrote:
> I spoke too soon. If I issue this command:
> 
> *label storage=Auto volume=A002 slot=2
> 
> the command will fail. If, however, I load slot 2 into the drive (of course, 
> it will already be there if I issued the above command; if I haven't, I can 
> load it with './mtx-changer /dev/sg1 load 2 /dev/nst0 0' at the shell 
> prompt), then issue:
> 
> *label storage=VXA volume=A002
> 
> That will work.
> 
> Now that I have my tapes labeled, I need to figure out how to do a backup 
> with this library.

i will recommend you to check /dev/sg1 owner  cos i guess bacula cannot
use it


-- 
bEsT rEgArDs|   "Confidence is what you have before you
tomasz dereszynski  |   understand the problem." -- Woody Allen
TD840-RIPE  |

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] bacula lto-2 drive performance?

[Bob Hetzel]

It was suggested that perhaps my 50 GB/hr data rate was due to the 
client maxing out around that rate.  I believe I have verified this. 
Previously I had been used to seeing much higher rates on another backup 
system, but I was only backing up servers using high performance SCSI 
disks, RAIDed together.

I installed the bacula client on one of those servers, where I saw a 
backup rate of about 77 GB/hr (21375.8 KB/s as reported by bacula).

I now see that this is in approximately the same speed I was able to get 
with Veritas Backup Exec on that particular collection of files.  The 
files in question are videos, about 100MB each, 82 GB total, and 
probably reasonably well compressed.



-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] bacula lto-2 drive performance?

[Michael Nelson]

Bob Hetzel wrote:
> I installed the bacula client on one of those servers, where I saw a 
> backup rate of about 77 GB/hr (21375.8 KB/s as reported by bacula).
>   

That's what I get using LTO-3 drives, so that sounds pretty good to me 
for LTO-2.

Michael

-- 
The music business is a cruel and shallow money trench, a long plastic hallway 
where thieves and pimps run free, and good men die like dogs. There's also a 
negative side.  Hunter S. Thompson


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] btape test works;backup works;restore doesn't

[Atom Powers]

I am getting the same error, or one very similar to it.
FreeBSD 6.1, Bacula 2.0.?, Using an LTO2 drive.
I'm still doing tests to determine if it is my device or a problem with 
Bacula.
I have another backup server with an almost identical setup (different 
tape drive) which does not have this problem.

Michael Hughes wrote:
>   I have loaded Bacula 2.0.3 from source on my FreeBSD system.  I ran
> btape test and it passed all the tests.  Also ran the autoloader test
> and that passed.
> ...
> 
> Forward spacing Volume "AI0011" to file:block 5:0.
> RestoreFiles.2007-07-10_13.00.18 Error: block.c:993 Read error on fd=6 at 
> file:blk 5:2563 on device "DLT_9" (/dev/nsa1). ERR=Operation not permitted.
> RestoreFiles.2007-07-10_13.00.18 Error: Unexpected Tape is Off-line
> 
-- 
Perfection is just a word I use occasionally with mustard.
--Atom Powers--
Systems Administrator
DigiPen Institute of Technology
(425) 895-4443

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] btape and bsr sd.conf tweaks

[Ken Gunderson]

On Tue, 10 Jul 2007 18:59:37 +0100
Martin Simmons <[EMAIL PROTECTED]> wrote:

> > On Tue, 10 Jul 2007 09:10:24 -0600, Ken Gunderson said:
> > 
> > On Tue, 10 Jul 2007 11:12:35 +0100
> > Martin Simmons <[EMAIL PROTECTED]> wrote:
> > 
> > > > On Mon, 9 Jul 2007 20:27:23 -0600, Ken Gunderson said:
> > > > 
> > > > Greetings:
> > > > 
> > > > Since my baffled post I've been doing some testing w/various sd.conf
> > > > tweaks.  btape results and fbsd ports message initially recommended:
> > > > 
> > > > Due to lack of some features in the FreeBSD tape driver
> > > > implementation you MUST add some OS dependent options to
> > > > the bacula-sd.conf file:
> > > > 
> > > >   Hardware End of Medium = no;
> > > >   Backward Space Record  = no;
> > > >   Backward Space File= no;
> > > > 
> > > > With 2 filemarks at EOT (see man mt):
> > > >   Fast Forward Space File = no;
> > > >   BSF at EOM = yes;
> > > >   TWO EOF= yes;
> > > > 
> > > > 
> > > > While btape completes w/above no problem, from man mt it looks like FBSD
> > > > supports bsr, however, and a few tests from command line seem to
> > > > confirm so I trimmed sd.conf down thusly:
> > > > 
> > > >   Hardware End of Medium = no;
> > > >   Fast Forward Space File = no;
> > > >   BSF at EOM = yes;
> > > >   TWO EOF = yes;
> > > > 
> > > > btape test completes fine and no longer recommend the bsr related
> > > > tweaks.  Maybe they're not necessary and btape should be modified?
> > > > Don't know about fill results yet - running now.  Hopefully I'll
> > > > encounter the magic incantation to get my autochanger to actually
> > > > change tapes...
> > > 
> > > In the current Bacula tape driver, Backward Space Record is only used to
> > > verify that the last block has been written correctly when a tape gets 
> > > full,
> > > it is not strictly necessary.  In addition, the setting of Backward Space 
> > > File
> > > is ignored (bsf must work).
> > > 
> > > You might be able to use these settings on some FBSD tape drives:
> > > 
> > >   Fast Forward Space File = yes
> > >   BSF at EOM = no
> > >   TWO EOF = no
> > > 
> > > __Martin
> > 
> > Thanks. I know that it's optional and not needed.  But it seems btape's
> > suggestions regarding sd.conf tweaks may be a bit inconsistent depending
> > upon what flags are already set.
> > 
> > This is all a bit confusing on FBSD because per mtio man page various
> > calls referenced in sd.conf docs are supported, e.g. mtiocget, mtbsr,
> > mtfsf, etc.  Whether they're supported by SCSI device/driver remains
> > uncertain, as I don't know how to test.  In this case I'm using LSI
> > controller and mpt driver.  My assumption was that since btape said I
> > needed sd flags such as Backward Space Record, etc. that it did not.
> > But it looks like it does.  So I'm wondering whether the issue is with
> > btape erroneously reporting or the mpt driver.
> > 
> > To recap, btape and manual backups and restores work but Autochanger is
> > not changing tapes when it should so I suspected something was not
> > quite right in sd.conf.
> 
> AFAIK, problems with the mechanics of tape changing in the autochanger will
> not be affected by any of the mtio options.  The changer is a separate device
> with its own protocol.
> 
> __Martin

But is not the drive itself responsible for sending eom so that changer
device knows it's time to swap tapes?

-- 
Best regards,

Ken Gunderson
GPG Key -- 9F5179FD

"Never hold discussions with the monkey when the organ grinder is in
the room." - Sir Winston Churchill

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] data error... buffer discarded

[Charles Sprickman]

Hi all,

I'm doing my first live backup and the first host seems to have gone 
alright, but there's one error in the run that is not clear to me:

10-Jul 20:40 devel2-sd: devel2.2007-07-10_20.39.56 Error: block.c:275
Volume data error at 0:0! Wanted ID: "BB02", got "". Buffer discarded.

I'm guessing it's not fatal since the job continued, but what is that 
error telling me?  I've got bacula set to spool everything before going to 
tape since I'm running most of my data off a slow wan link.

Here's the message in context:

10-Jul 20:39 devel2-dir: No prior Full backup Job record found.
10-Jul 20:39 devel2-dir: No prior or suitable Full backup found in catalog.
Doing FULL backup.
10-Jul 20:39 devel2-dir: Start Backup JobId 3, 
Job=devel2.2007-07-10_20.39.56
10-Jul 20:40 devel2-dir: Created new Volume "Monthly0001" in catalog.
10-Jul 20:40 devel2-sd: devel2.2007-07-10_20.39.56 Error: block.c:275 
Volume data error at 0:0! Wanted ID: "BB02", got "". Buffer discarded.
10-Jul 20:40 devel2-sd: Labeled new Volume "Monthly0001" on device
"TapeStorage" (/dev/nsa0).
10-Jul 20:40 devel2-sd: Wrote label to prelabeled Volume "Monthly0001" on
device "TapeStorage" (/dev/nsa0)
10-Jul 20:40 devel2-sd: Spooling data ...

Any ideas on this?

Thanks,

Charles

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Help with backup plan

[Charles Sprickman]

On Tue, 10 Jul 2007, Steen wrote:

> On Friday 06 July 2007 06:23:22 Charles Sprickman wrote:
>> What I'd like to do is the following:
>>
>> -Full backup each sunday, keeping the tapes for a year.  After that I
>> would likely manually relabel all the tapes but one.  These tapes would
>> all be in one pool.
>>
>> -Differential backup each following sunday, with 3 tapes that get recycled
>> each month.  These tapes are also in their own pool.
>>
>> -Incrementals mon-fri, with 5 tapes that get recycled each week.  Again,
>> in their own pool.
>>
>> Does this seem like a sane plan?

> I use almost the same pattern - but only diskbased

I am running a test over about 20 machines right now, and I *think* I kind 
of have this down after looking at the Volume Retention section a few more 
times..

>> I'm on the fence about the differentials

> Don't really get that

Never dealt with them before...  But I do have a slightly unique(?) 
situation.  Most of the boxes are in another state, so I want to avoid 
full backups when possible since they generally seem to need more than 12 
hours to run.  So I figure instead of doing a full + incrementals each 
week, I'll do one full per month plus a differential each weekend except 
for the first to save some time/bandwidth.

We don't (yet) have an autochanger or reliable remote hands at the 
datacenter...

>> as we very rarely go back to backups for anything...  I'm also wondering
>> how these choices will impact the general ease of restoring something if
>> we need to.  Again, I'm coming from Amanda, and there's not much thinking
>> there.  When you restore, you just keep feeding it the tapes it wants.

> Here it graps the disk volumes automatically - guess that would be identical
> to your experience with Amanda with tapes

Good.  I assume it's just going to spit out a message when the next tape 
is needed.

Another big question since the fact that catalog retention can be set in 
various places.  Do I need any retention settings in my client configs?  I 
see there are "File Retention" and "Job Retention" settings that can go in 
a client config.  Based on what's below do I need anything in my 
individual client configs (or elsewhere) to make sure things get purged 
out of the catalog properly?

>> Here's what I've tentatively got in my bacula-dir config.

I'm just going to add what I think I'm doing after each pool...

>> pools:
>>
>> Pool {
>>Name = Monthly
>>Pool Type = Backup
>>Recycle = no# Bacula can automatically recycle
>> Volumes AutoPrune = yes # Prune expired volumes
>>Volume Retention = 365 days # one year
>>Volume Use Duration = 23h
>>Maximum Volumes = 12
>>LabelFormat = "Monthly"
>> }

Don't ever recycle these, request a new tape each full run, keep info from 
the fulls in the catalog for a year.  Would there be any point to keeping 
catalog on these fulls for longer or should I just rely on bscan to get 
data off older full tapes?

I assume after a year, I will have to manually relabel(?) or purge these 
tapes to use them again after I put one away for long term storage?

>> Pool {
>>Name = Weekly
>>Pool Type = Backup
>>Recycle = yes   # Bacula can automatically recycle
>> Volumes Recycle Oldest Volume = yes
>>AutoPrune = yes # Prune expired volumes
>>Volume Retention =  1 month # one month
>>Volume Use Duration = 6 days
>>Maximum Volumes = 3
>>LabelFormat = "Weekly"
>> }

This is my differential, and I expect it to request a new tape each week. 
It should keep info in the catalog for one month.  It will automatically 
recycle tapes each month, starting with the oldest volume.  Do I have that 
right?

I'm also considering just using one tape/month for this.  I would change 
"Volume Use Duration" to 1 month to accomplish that, correct?

>> Pool {
>>Name = Daily
>>Pool Type = Backup
>>Recycle = yes   # Bacula can automatically recycle
>> Volumes Recycle Oldest Volume = yes
>>AutoPrune = yes # Prune expired volumes
>>Volume Retention = 5 days   # 5 days
>>Volume Use Duration = 23h
>>Maximum Volumes = 5
>>LabelFormat = "Daily"
>> }

These are the daily incrementals.  I'm expecting these to do incrementals 
based on the last differential, and for Bacula to ask for a new tape each 
day, with a max of 5 tapes.  Each week the catalog will be purged of these 
records.

Again, I'm thinking I can change this to one tape for the week and I would 
accomplish that by setting "Volume Use Duration" to 1 week, correct?

>> Would it be simpler to let the incrementals all go to one tape and reduce
>> this to four tapes/month for those?

> Yes - no need to switch tapes

I think that's a big advantage, as people are already annoyed with 
Amanda's demand for a new tape each day.

>> I'm using 100GB LTO-2 tapes, so I
>> certainly have more than

Re: [Bacula-users] Pruning to the scratch pool.

[Falk Sauer]

Hi Andreas,

thanks for your helpful answer!

Ok we know, that we know nothing quite right how its works. ;-)

I will test especially this new Feature if a released Version is available in 
suse rpm format. I would also find statistically overviews of volume usage 
very helpful for proactive changing havyly used Tapes.

ps: i should read more often the project page. ;-)

On Wednesday 11 July 2007 writes Andreas Helmcke:
> Falk Sauer wrote:
> > I mean on any post in the last weeks i've read (only with one eye) over a
> > option thats allows a volume after pruning, automatically moving to the
> > scratch pool.
> >
> > That can be a very nice feature, in the moment i make this manually.
> >
> > From which version of bacula is this option usable and how is the syntax?
> >
> >
> >From the chapter: "The Pool Resource" from the actual bacula manual:
>
>  The Pool Resource
>
>  RecyclePool = 
>   On versions 2.1.4 or greater, Bacula can recycle media in the pool of
> your choice. The most useful setup is to use Scratch.
>
>
> Version 2.1.4 is not quite right ;-). This option is under rework by Kern
> just at the moment so it will hopefully be usable with next release (2.1.26
> (beta version) or 2.2.0 (release version))
>
> > And how is the pruning working in the case of reuse a volume while the sd
> > needs a pruned volume and have more outtimed volumes as he needs in the
> > moment? Comes here the sd first and only momentarily unused volumes going
> > to the scratch pool or moves the pruning algo all pruned volumes to the
> > scratch pool and the sd reuse one of the volumes after them from scratch
> > pool?
>
> This is one of the points, which are changing at the moment ;-)
>
> But in general bacula will try to prune volumes only when absolutely
> necessary and prefer the requested pool. So it will most likely use volumes
> from the "wrong" pool only when there are no usable volumes in neither the
> "correct" pool nor the scratch pool.
>
> > Why i ask? If the sd picks a self pruned volume, the volume believe in
> > the same pool and the use structure of the volume is every time  the same
> > (monthly, weekly ...), if every time move the prune algo all of the
> > volumes to the scratch pool*, we become a better [stochastic/more evenly]
> > use structure of the volumes when the volumes rotate between the pools.
> >
> > *) i've noticed that's the scratch pool works like a fifo.
>
> Also it might be nice this is not a (main) feature of the pruning
> algorithm. But improving the tapemanagement is on the wishlist for bacula
> (see Item 25 on the projekts-list: http://www.bacula.org/?page=projects )


regards
   Falk


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users