Re: [Bacula-users] Need some help

[Mark Nesterovych]

Ok. Using script is good for my issue. Thanks for idea.
But I have once more question.
I've installed bacula at my ubuntu-server 9.04.
I can't find awk script which is used to backup catalog.
Folder /etc/bacula/scripts is empty.
May be scripts located in another package. Can anybody point me which
one ?



On Thu, 2009-06-18 at 10:53 -0500, Mike Eggleston wrote:
 I have a Run Before Job script named pre-tape-backup.sh that does a find
 for everything that was touched during the night's backup. My first
 job in the night runs a script named pre-backup.sh that does a 'touch
 $file'. I know that any file modified after that touched file is new,
 so I feed those files to my last backup job for writing to tape.
 
 Mike
 
-- 
Mark Nesterovych marknesterov...@itt-consulting.com
ITT Consulting


--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Personal messages for every client

[Christian Gaul]

Reynier Pérez Mira schrieb:
 Hi every:
 I have a group of people setting up some Bacula Clients. I'm checking 
 also some Clients and the Director. I'm asking if is possible to 
 configure Clients in Director (bacula-dir.conf) to send email to the 
 people who configure the client. For example: I'm setting up a client 
 called reynierpm-fd.conf but another specialist is configuring a client 
 called specialist1-fd.conf. Now it's possible to send the Bacula Errors 
 from reynierpm-fd.conf to my email address and the Bacula Errors from 
 specialist1-fd.conf to the specialist email address? Any tip or help?

 Regards,

 --
 Crystal Reports - New Free Runtime and 30 Day Trial
 Check out the new simplified licensing option that enables unlimited
 royalty-free distribution of the report engine for externally facing 
 server and web deployment.
 http://p.sf.net/sfu/businessobjects
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users
   
Check out the Message Resource. You can make one for every client, if
you were so inclined, so the user gets his own e-mail reports, or in
your case one for every specialist.

-- 
Christian Gaul
otop AG
D-55116 Mainz
Rheinstraße 105-107
Fon: 06131.5763.310
Fax: 06131.5763.500
E-Mail: christian.g...@otop.de
Internet: www.otop.de

Vorsitzender des Aufsichtsrats: Christof Glasmacher
Vorstand: Dirk Flug
Registergericht: Amtsgericht Mainz
Handelsregister: HRB 7647 


--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

[Tom Sommer]

Jari Fredriksson wrote:
 INSERT INTO Filename( Name )
 SELECT a.Name
 FROM (

 SELECT DISTINCT Name
 FROM batch
 ) AS a
 WHERE NOT
 EXISTS (

 SELECT Name
 FROM Filename AS f
 WHERE f.Name = a.Name
 )

 

 That looks silly.

 I would write it shorter as

 INSERT INTO Filename(Name)
 SELECT DISTINCT Name
 FROM batch AS a
 WHERE NOT EXISTS
 (
 SELECT Name
 FROM Filename AS f
 WHERE f.Name = a.Name
 )
Make a bug report :)

--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

[Tom Sommer]

Martin Simmons wrote:
 On Thu, 18 Jun 2009 17:11:04 +0200, Michel Meyers said:
 
 Martin Simmons wrote:
 
 On Wed, 17 Jun 2009 13:48:58 +0200, Tom Sommer said:
 
 Martin Simmons wrote:
 
 On Tue, 16 Jun 2009 15:05:18 +0200, Tom Sommer said:
 
 
 Hi,

 I have a somewhat pressing problem with the performance of my Bacula
 installation.

 My MySQL database currently holds 247,342,127 (36GB) records in the File
 table, and 78,576,199 (10GB) records in the Filename table.

 Since 3.0.0, but even more since 3.0.1, I have a problem with queries
 being really slow. Basically when doing a full backup of a server
 (mailserver, LOTS of small files), I can have my MySQL hanging for up to
 24+ hours on queries like this:

 INSERT INTO Filename( Name )
 SELECT a.Name
 FROM (

 SELECT DISTINCT Name
 FROM batch
 ) AS a
 WHERE NOT
 EXISTS (

 SELECT Name
 FROM Filename AS f
 WHERE f.Name = a.Name
 )
 
 [...]
 
 Sorry, I don't know how to optimize it.

 These queries are part of the new batch insert code.  You can turn that 
 off
 by passing --disable-batch-insert to configure when building Bacula.
   
   
 what does this mean in practice? 1 query per file? or?
 
 The non-batch approach makes several queries per file.
   
 But it will do so as it backs up the files, as opposed to the batch
 approach where it collects all the queries and does them at the end of
 the job, right?
 

 Yes, but if you have spooling turned on, then it will spool the attributes too
 and insert them all at the end using several queries per file.
   
Well, the problem is really that first is spends time storing the files,
and then it spends time saving information about the backup in the database.
It would make more sense, for larger clients, to spend the idle database
time (while taking the file backup) more wisely.

I'm having a hard time judging if turning off batch-inserts is the right
action, if I would gain anything from this.

--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

[Martin Simmons]

 On Fri, 19 Jun 2009 03:00:54 +0300, Jari Fredriksson said:
 
  
  INSERT INTO Filename( Name )
  SELECT a.Name
  FROM (
  
  SELECT DISTINCT Name
  FROM batch
  ) AS a
  WHERE NOT
  EXISTS (
  
  SELECT Name
  FROM Filename AS f
  WHERE f.Name = a.Name
  )
  
 
 That looks silly.
 
 I would write it shorter as
 
 INSERT INTO Filename(Name)
 SELECT DISTINCT Name
 FROM batch AS a
 WHERE NOT EXISTS
 (
 SELECT Name
 FROM Filename AS f
 WHERE f.Name = a.Name
 )

Maybe, but perhaps it quicker to remove the duplicates from batch.name before
comparing them to the rows in Filename.name?

__Martin

--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

[Martin Simmons]

 On Fri, 19 Jun 2009 09:51:20 +0200, Tom Sommer said:
 
 Martin Simmons wrote:
  On Thu, 18 Jun 2009 17:11:04 +0200, Michel Meyers said:
  
  Martin Simmons wrote:
  
  On Wed, 17 Jun 2009 13:48:58 +0200, Tom Sommer said:
  
  Martin Simmons wrote:
  
  On Tue, 16 Jun 2009 15:05:18 +0200, Tom Sommer said:
  
  
  Hi,
 
  I have a somewhat pressing problem with the performance of my Bacula
  installation.
 
  My MySQL database currently holds 247,342,127 (36GB) records in the 
  File
  table, and 78,576,199 (10GB) records in the Filename table.
 
  Since 3.0.0, but even more since 3.0.1, I have a problem with queries
  being really slow. Basically when doing a full backup of a server
  (mailserver, LOTS of small files), I can have my MySQL hanging for up 
  to
  24+ hours on queries like this:
 
  INSERT INTO Filename( Name )
  SELECT a.Name
  FROM (
 
  SELECT DISTINCT Name
  FROM batch
  ) AS a
  WHERE NOT
  EXISTS (
 
  SELECT Name
  FROM Filename AS f
  WHERE f.Name = a.Name
  )
  
  [...]
  
 Sorry, I don't know how to optimize it.
 
 These queries are part of the new batch insert code.  You can turn that 
 off
 by passing --disable-batch-insert to configure when building Bacula.
   
   
  what does this mean in practice? 1 query per file? or?
  
  The non-batch approach makes several queries per file.

  But it will do so as it backs up the files, as opposed to the batch
  approach where it collects all the queries and does them at the end of
  the job, right?
  
 
  Yes, but if you have spooling turned on, then it will spool the attributes 
  too
  and insert them all at the end using several queries per file.

 Well, the problem is really that first is spends time storing the files,
 and then it spends time saving information about the backup in the database.
 It would make more sense, for larger clients, to spend the idle database
 time (while taking the file backup) more wisely.
 
 I'm having a hard time judging if turning off batch-inserts is the right
 action, if I would gain anything from this.

AFAIK, the non-batch approach in Bacula 3.x does the same queies as Bacula
2.x.  Since you started the thread by saying that backups are slower in 3.x
because of the queries, turning off batch-inserts might solve that.

__Martin

--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

[Mike Holden]

Jari Fredriksson wrote:

 INSERT INTO Filename( Name )
 SELECT a.Name
 FROM (

 SELECT DISTINCT Name
 FROM batch
 ) AS a
 WHERE NOT
 EXISTS (

 SELECT Name
 FROM Filename AS f
 WHERE f.Name = a.Name
 )


 That looks silly.

 I would write it shorter as

 INSERT INTO Filename(Name)
 SELECT DISTINCT Name
 FROM batch AS a
 WHERE NOT EXISTS
 (
 SELECT Name
 FROM Filename AS f
 WHERE f.Name = a.Name
 )

You may also want to consider using a JOIN rather than a subquery with a
NOT EXISTS, something like (untested and unvalidated!):

INSERT INTO filename(name)
SELECT DISTINCT name
FROM batch AS a
LEFT JOIN filename AS f USING (name)
WHERE f.name IS NULL

I know from experience as an Oracle DBA (my day job) that this can often
produce far more efficient results.

Of course, all options need testing for both speed of execution and
resource usage, bearing in mind that data varies from one installation to
another, and one size may not fit all!
-- 
Mike Holden

http://www.by-ang.com - the place to shop for all manner of hand crafted
items, including Jewellery, Greetings Cards and Gifts




--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Can I exclude directories from the client config?

[Kevin Thorpe]

I know this sounds a little odd but can I exclude directories from the 
client config?

The reason is that I've got control over the client but my hosting 
company has control over the director.
The more things I can control myself, the less chance of something going 
wrong.

thanks

--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

[Tom Sommer]

Mike Holden wrote:
 Jari Fredriksson wrote:
   
 INSERT INTO Filename( Name )
 SELECT a.Name
 FROM (

 SELECT DISTINCT Name
 FROM batch
 ) AS a
 WHERE NOT
 EXISTS (

 SELECT Name
 FROM Filename AS f
 WHERE f.Name = a.Name
 )

   
 That looks silly.

 I would write it shorter as

 INSERT INTO Filename(Name)
 SELECT DISTINCT Name
 FROM batch AS a
 WHERE NOT EXISTS
 (
 SELECT Name
 FROM Filename AS f
 WHERE f.Name = a.Name
 )
 

 You may also want to consider using a JOIN rather than a subquery with a
 NOT EXISTS, something like (untested and unvalidated!):

 INSERT INTO filename(name)
 SELECT DISTINCT name
 FROM batch AS a
 LEFT JOIN filename AS f USING (name)
 WHERE f.name IS NULL

 I know from experience as an Oracle DBA (my day job) that this can often
 produce far more efficient results.

 Of course, all options need testing for both speed of execution and
 resource usage, bearing in mind that data varies from one installation to
 another, and one size may not fit all!
   
Good suggestions, sounds like there might be an overall performance
problem with the current query for batch-inserts with lots of data. I'm
a bit unsure if I dare test these queries on my current installation.

I'll CC Kern on the thread, perhaps he has some insights.

// Tom

--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

[James Harper]

  INSERT INTO Filename(Name)
  SELECT DISTINCT Name
  FROM batch AS a
  WHERE NOT EXISTS
  (
  SELECT Name
  FROM Filename AS f
  WHERE f.Name = a.Name
  )
 
 You may also want to consider using a JOIN rather than a subquery with
a
 NOT EXISTS, something like (untested and unvalidated!):
 
 INSERT INTO filename(name)
 SELECT DISTINCT name
 FROM batch AS a
 LEFT JOIN filename AS f USING (name)
 WHERE f.name IS NULL
 
 I know from experience as an Oracle DBA (my day job) that this can
often
 produce far more efficient results.
 
 Of course, all options need testing for both speed of execution and
 resource usage, bearing in mind that data varies from one installation
to
 another, and one size may not fit all!

The subquery returns a very small result set (0 or 1, assuming you use
DISTINCT) and so isn't too inefficient. It's when you say 'WHERE NOT
EXISTS (SOME QUERY WITH LOTS OF RESULTS)' that you start to really bog
down

James

--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

[Mike Holden]

James Harper wrote:
 The subquery returns a very small result set (0 or 1, assuming you use
 DISTINCT) and so isn't too inefficient. It's when you say 'WHERE NOT
 EXISTS (SOME QUERY WITH LOTS OF RESULTS)' that you start to really bog
 down

True, but if the outer query contains a very large number of records, the
inner query is executed over and over and over and ...

This multiplies the small execution time by a large number.

Think of it like a WHILE loop that executes a block of code each time
round. The inner block of code might be quick, but if the loop goes round
several million times, the cumulative time becomes significant.

One general rule of thumb of SQL execution is that bulk processing is
almost always faster than processing records individually in a loop.
-- 
Mike Holden


--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Can I exclude directories from the client config?

[Fahrer, Julian]

You can have a filelist on your client:
http://www.bacula.org/manuals/en/install/install/Configuring_Director.html#SECTION0067


Include {
  Options { signature = SHA1 }
  File = \\/home/xxx/filelist-on-client
}

-Ursprüngliche Nachricht-
Von: Kevin Thorpe [mailto:ke...@pibenchmark.com] 
Gesendet: Freitag, 19. Juni 2009 12:32
An: bacula-users@lists.sourceforge.net
Betreff: [Bacula-users] Can I exclude directories from the client config?

I know this sounds a little odd but can I exclude directories from the 
client config?

The reason is that I've got control over the client but my hosting 
company has control over the director.
The more things I can control myself, the less chance of something going 
wrong.

thanks

--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] The tipically error: Cannot find any appendable volumes.

[Reynier Pérez Mira]

Hi every:
I have configured some Bacula Clients (two days ago more or less) and 
all was working fine until today. I check my email and see two clients 
with the same error: Cannot find any appendable volumes. Can any tell me 
why if this was working fine?

This is the mail content:
19-Jun 08:17 FileSAN JobId 51: Job 
SP_F06_POLO_BIOINFORMATICA-FD.2009-06-19_02.00.01_52 waiting. Cannot 
find any appendable volumes.
Please use the label  command to create a new Volume for:
 Storage:  FileStorage (/data)
 Pool: SP_F06_POLO_BIOINFORMATICA_Pool
 Media type:   File

Regards,

--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Can I exclude directories from the client config?

[John Drescher]

On Fri, Jun 19, 2009 at 6:32 AM, Kevin Thorpeke...@pibenchmark.com wrote:
 I know this sounds a little odd but can I exclude directories from the
 client config?

 The reason is that I've got control over the client but my hosting
 company has control over the director.
 The more things I can control myself, the less chance of something going
 wrong.


If you are using 3.0.X

http://bacula.org/manuals/en/concepts/concepts/New_Features.html#SECTION00317

John

--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] The tipically error: Cannot find any appendable volumes.

[John Drescher]

 I have configured some Bacula Clients (two days ago more or less) and
 all was working fine until today. I check my email and see two clients
 with the same error: Cannot find any appendable volumes. Can any tell me
 why if this was working fine?

 This is the mail content:
 19-Jun 08:17 FileSAN JobId 51: Job
 SP_F06_POLO_BIOINFORMATICA-FD.2009-06-19_02.00.01_52 waiting. Cannot
 find any appendable volumes.
 Please use the label  command to create a new Volume for:
     Storage:      FileStorage (/data)
     Pool:         SP_F06_POLO_BIOINFORMATICA_Pool
     Media type:   File

 Regards,


Check the output of list media

John

--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

[James Harper]

 
 James Harper wrote:
  The subquery returns a very small result set (0 or 1, assuming you
use
  DISTINCT) and so isn't too inefficient. It's when you say 'WHERE NOT
  EXISTS (SOME QUERY WITH LOTS OF RESULTS)' that you start to really
bog
  down
 
 True, but if the outer query contains a very large number of records,
the
 inner query is executed over and over and over and ...
 
 This multiplies the small execution time by a large number.
 
 Think of it like a WHILE loop that executes a block of code each time
 round. The inner block of code might be quick, but if the loop goes
round
 several million times, the cumulative time becomes significant.
 
 One general rule of thumb of SQL execution is that bulk processing is
 almost always faster than processing records individually in a loop.

I would have thought that the query planner would have reduced both
solutions to the same thing (eg for every record in the outer or left
part, match it up with the inner or left part). I agree that the JOIN
lends itself better to optimization though, and that's certainly the way
I would have written it as it is far clearer to read and scales to far
more situations than the 'NOT EXISTS' solution does.

I constructed a simple test scenario - created a table 'james' with a
few hundred thousand rows in it of both real filenames and corrupted
versions of real filenames, and ran the following tests:

RESET QUERY CACHE; (can't remember if that was the exact syntax)
SELECT COUNT(DISTINCT Name)
FROM james AS a
WHERE NOT EXISTS
(
SELECT Name
FROM Filename AS f
WHERE f.Name = a.Name
);

And

RESET QUERY CACHE;
SELECT COUNT(DISTINCT Name)
FROM james AS a
LEFT JOIN filename AS f ON a.name = f.name
WHERE f.name IS NULL;

And compared the times over a half a dozen runs. There wasn't a
measurable difference between the results, but the server was busy
enough at the time that a significant amount of 'noise' was added in -
both queries ran for between 2 and 6 seconds. The simple timing test
also completely fails to measure memory and io usage.

I'm sure someone could construct some more precise tests that would
eliminate any speculation, but on face value you aren't going to get an
order-of-magnitude improvement or anything close just by tinkering with
this query, unless you can identify some indexes that could be added
onto the batch table (which is temporary isn't it?). Although given that
Filename already has an index on the only field being used, I suspect
that even that won't do much for you.

Does MySQL have a 'profiler' tool like MSSQL does? I spend most of my
time in MSSQL and if some operation is running slow I just attach the
profiler to it and capture the queries and focus on the ones that are
taking most of the time.

James


--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

[Jari Fredriksson]

 James Harper wrote:
 The subquery returns a very small result set (0 or 1,
 assuming you use DISTINCT) and so isn't too inefficient.
 It's when you say 'WHERE NOT EXISTS (SOME QUERY WITH
 LOTS OF RESULTS)' that you start to really bog down
 
 True, but if the outer query contains a very large number
 of records, the inner query is executed over and over and
 over and ... 
 
 This multiplies the small execution time by a large
 number. 
 
 Think of it like a WHILE loop that executes a block of
 code each time round. The inner block of code might be
 quick, but if the loop goes round several million times,
 the cumulative time becomes significant. 
 
 One general rule of thumb of SQL execution is that bulk
 processing is almost always faster than processing
 records individually in a loop. 

All right then. Then there is this version:

INSERT INTO Filename(Name)
SELECT DISTINCT Name
FROM batch AS
WHERE Name NOT IN
(
SELECT DISTINCT Name
FROM Filename
);

I guess it depends on RDMS, but I wonder it it executes the subquery more than 
once.



--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] The tipically error: Cannot find any appendable volumes.

[Reynier Pérez Mira]

John Drescher wrote:
   Check the output of list media
 
 John
 

Pool: SP_F06_POLO_BIOINFORMATICA_Pool
+-+--+---+-+---+--+
 
 
--+-+--+---+---+-+
| mediaid | volumename   | volstatus | enabled | 
volbytes  | volfiles | volrete ntion 
| recycle | slot | inchanger | mediatype | lastwritten |
+-+--+---+-+---+--+
 
 
--+-+--+---+---+-+
|   8 | SP_F06_POLO_BIOINFORMATICA_Pool-0008 | Used  |   1 | 
6,101,686,396 |1 |   31,53 6,000 
|   1 |0 | 0 | File  | 2009-06-17 17:10:37 |
|  17 | SP_F06_POLO_BIOINFORMATICA_Pool-0017 | Used  |   1 | 
1,016,910,838 |0 |   31,53 6,000 
|   1 |0 | 0 | File  | 2009-06-18 08:38:12 |
+-+--+---+-+---+--+
 
 
--+-+--+---+---+-+

What's the problem?


--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] The tipically error: Cannot find any appendable volumes.

[John Drescher]

2009/6/19 Reynier Pérez Mira rper...@uci.cu:
 John Drescher wrote:
   Check the output of list media

 John


 Pool: SP_F06_POLO_BIOINFORMATICA_Pool
 +-+--+---+-+---+--+
 --+-+--+---+---+-+
 | mediaid | volumename                           | volstatus | enabled |
 volbytes      | volfiles | volrete                                 ntion |
 recycle | slot | inchanger | mediatype | lastwritten         |
 +-+--+---+-+---+--+
 --+-+--+---+---+-+
 |       8 | SP_F06_POLO_BIOINFORMATICA_Pool-0008 | Used      |       1 |
 6,101,686,396 |        1 |   31,53                                 6,000 |
     1 |    0 |         0 | File      | 2009-06-17 17:10:37 |
 |      17 | SP_F06_POLO_BIOINFORMATICA_Pool-0017 | Used      |       1 |
 1,016,910,838 |        0 |   31,53                                 6,000 |
     1 |    0 |         0 | File      | 2009-06-18 08:38:12 |
 +-+--+---+-+---+--+
 --+-+--+---+---+-+

 What's the problem?


Your retention period of 6000 seconds has expired so these volumes
should be recycled. Can you post your bacula-dir.conf?

John

--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Where is bat?

[Ralph Böhme]

Allan Black allan.bl...@btconnect.com wrote:

 Ralph Böhme wrote:
 on Opensolaris, now that I'm done: where is bat?
 What am I missing?

 Possibly export PATH PKG_CONFIG_PATH

Well at least this now gives me (command c/p from gmake run):
---8---
ra...@os:~/bacula-3.0.1/src/qt-console$ pfexec  
/export/home/ralph/bacula-3.0.1/libtool --silent --mode=install  
install -m 0754 -p /export/home/ralph/bacula-3.0.1/src/qt-console/bat  
//usr/local/bacula/sbin/
find: stat() error //usr/local/bacula/sbin/bat: No such file or directory
find: cycle detected for /lib/crypto/32/
find: cycle detected for /lib/32/
find: cycle detected for /lib/secure/32/
find: cycle detected for /usr/lib/secure/32/
find: cycle detected for /usr/lib/elfedit/32/
find: cycle detected for /usr/lib/locale/en_US.UTF-8/32/
find: cycle detected for /usr/lib/locale/en_US.UTF-8/LC_CTYPE/32/
find: cycle detected for /usr/lib/locale/en_US.UTF-8/LO_LTYPE/32/
find: cycle detected for /usr/lib/link_audit/32/
find: cycle detected for /usr/lib/32/
find: cycle detected for /usr/lib/lwp/32/
install: -p was not found anywhere!
---8---

It's using install which doesn't work, ginstall does:
---8---
ra...@os:~/bacula-3.0.1/src/qt-console$ pfexec  
/export/home/ralph/bacula-3.0.1/libtool --silent --mode=install  
ginstall -m 0754 -p /export/home/ralph/bacula-3.0.1/src/qt-console/bat  
//usr/local/bacula/sbin/
ra...@os:~/bacula-3.0.1/src/qt-console$ ls /usr/local/bacula/sbin
bacula  bacula-fd   bat bcopy   bls bscan   
  btape   bwild
bacula-dir  bacula-sd   bconsolebextractbregex  bsmtp   
  btraceback  dbcheck
---8---

Et voila: bat.

Anybody who know's where one is supposed to stick this in when  
configuring ? It's only the install command for bat that ends using  
`install`, from what I can see every other installation uses ginstall.  
I've already looked at the mkspecs file used to qmake Qt, but that  
doesn't have an explicit option to specify which install command to use.

Thanks!
-Ralph

--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] The tipically error: Cannot find any appendable volumes.

[Reynier Pérez Mira]

John Drescher wrote:
 
 Your retention period of 6000 seconds has expired so these volumes
 should be recycled. Can you post your bacula-dir.conf?
 
 John
Ok, here it's:

Director {# define myself
   Name = serverbacula-dir
   Description = Bacula Director Centro de Datos UCI
   DIRport = 9101# where we listen for UA connections
   DirAddress = 10.128.50.11
   QueryFile = /etc/bacula/query.sql
   WorkingDirectory = /var/bacula/working
   PidDirectory = /var/run
   Maximum Concurrent Jobs = 5
   Password = 
shqjya3k7n8w673ieDj6fRkh2SciKrBL2GhB6RrasThBG2xYTufoY3chV3cvm6x9  # 
Debe ser la misma contr$
   Messages = Daemon
   FD Connect Timeout = 5 min # tiempo durante el cual Bacula intentará 
contactar con el FD
   SD Connect Timeout = 5 min # tiempo durante el cual Bacula intentará 
contactar con el SD
}

#Trabajos - Clientes
@/etc/bacula/clients/catalog.conf # BD Bacula

#F01

#F02
@/etc/bacula/clients/salvasprod_f02_imac-fd.conf # Proyecto IMAC - F02

#F03
@/etc/bacula/clients/salvasprod_f03_sigespro-fd.conf
@/etc/bacula/clients/salvasprod_f03_fiscalia-fd.conf
@/etc/bacula/clients/salvasprod_f03_tribunales-fd.conf
@/etc/bacula/clients/salvasprod_f03_rnvss-fd.conf

#F04
@/etc/bacula/clients/salvasprod_f04_aduana01-fd.conf
@/etc/bacula/clients/salvasprod_f04_aduana02-fd.conf

#F05
@/etc/bacula/clients/salvasprod_f05_cneuro-fd.conf
@/etc/bacula/clients/salvasprod_f05_cneuro_jonline-fd.conf

#F06
@/etc/bacula/clients/salvasprod_f06_polo_bioinformatica-fd.conf

#F07
#@/etc/bacula/clients/salvasprod_f07_his-fd.conf

#F08
#@/etc/bacula/clients/salvasprod_f08_libelectronicos-fd.conf

#F09
@/etc/bacula/clients/salvasprod_f09_sipp-fd.conf

#F10
@/etc/bacula/clients/salvasprod_f10-fd.conf

#Centro de Desarrollo
@/etc/bacula/clients/salvasprod_cd_centalad-fd.conf
@/etc/bacula/clients/salvasprod_cd_consultoria-fd.conf

#Otras areas

JobDefs {
   Name = DefinicionPorDefectoParaCopias
   Type = Backup
   Level = Incremental
   Storage = FileSAN
   Messages = Standard
   Priority = 5 #Es la opcion por defecto, a mayor numero menos prioridad
   Reschedule on error = yes
   Reschedule interval = 30 minutes
   Reschedule times = 2
   Max Start Delay = 1 hours
   #Accurate = yes # permite verificar los ficheros con cambios despues 
de realizada la copia

   # Script para setear el proxy
   #RunScript {
   #  RunsWhen = After
   #  RunsOnFailure = yes
   #  Command = /etc/bacula/scripts/send_beeper.sh
   #}
}

Schedule {
   Name = ScheduleFull
   Run = Full 1st sun at 4:00
   Run = Differential 2nd-5th sun at 2:00
   Run = Incremental mon-sat at 2:00
}

# Definition of file storage device
Storage {
   Name = FileSAN
   Address = 10.128.50.11# N.B. Use a fully qualified 
name here
   SDPort = 9103
   Password = 
w4RRaeX7ZnhQnN8sSgFcXHh42ApmAgn7ZfT6kf3wBtCLpJyfgtq75GNHswwbTk6L
   Device = FileStorage
   Media Type = File
}

Catalog {
   Name = MyCatalog
   dbname = bacula_db;
   dbuser = bacula_user;
   dbpassword = LW9DEjh5hVmqAweB
   DB Address = 10.128.50.3
}

Messages {
   Name = Standard
#  mailcommand = /sbin/bsmtp -h 10.128.50.1 -f \\(Bacula\) \%r\\ -s 
\Bacula: %t %e of %c %l\ %r
   mailcommand = /sbin/bsmtp -h 10.128.50.1 -f \\(Bacula Service\) 
\bac...@prod.uci.cu\\ -s \Bacula: $
#  operatorcommand = /sbin/bsmtp -h 10.128.50.1 -f \\(Bacula\) 
\%r\\ -s \Bacula: Intervention needed$
   operatorcommand = /sbin/bsmtp -h 10.128.50.1 -f \\(Bacula Service\) 
\bac...@prod.uci.cu\\ -s \Bacu$
   mail = rper...@uci.cu = all, !skipped
   operator = rper...@uci.cu = mount
   console = all, !skipped, !saved
   append = /var/bacula/working/log = all, !skipped
}

Messages {
   Name = Daemon
#  mailcommand = /sbin/bsmtp -h 10.128.50.1 -f \\(Bacula\) \%r\\ -s 
\Bacula daemon message\ %r
   mailcommand = /sbin/bsmtp -h 10.128.50.1 -f \\(Bacula Service\) 
\bac...@prod.uci.cu\\ -s \Bacula d$
   mail = rper...@uci.cu = all, !skipped
   console = all, !skipped, !saved
   append = /var/bacula/working/log = all, !skipped
}

Console {
   Name = serverbacula-mon
   Password = ZKu3rWgOAqBXhQ57nURO58txSPTTgWIU8XcKbNKHuCNI
   CommandACL = status, .status
}



--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] 3.0.1 Bat, Yes is an invalid Command

[Dirk Bartley]

Your probably experiencing a common thing with the qt widget set and my
lack of knowledge of how to prevent it.  Just mouse around on the window
and you should see a grabable splitter window that you can grab and move
over.  Then you should see the jobs table.

You may experience that on any page that uses a splitter.  I wish the
splitter control would have a more contrasting color.

That happens because I try to pull the splitter from a saved
configuration the last time it was closed.

Dirk


On Fri, 2009-06-19 at 15:44 +1200, John Huttley wrote:
 Hi Dirk,
 I didn't know that was even possible.
 Actually, I've just tried it and the Director status showed the jobs
 and let me cancel.
 The JobList is a blank pane. Not even a pane on the right hand side,
 to be more precise.
 
 Regards,
 
 John
 
 
 Dirk Bartley wrote: 
  I would not have thought to do it that way which is more like what the
  command line console would allow.  I would have Highlighted all of the
  jobs in either dir status or joblist and right clicked and chose a
  cancel option in the popup.
  
  My efforts were not in simulating a command line console but in being a
  gui interface.  I just had never tried it that much.  I started working
  on bat shortly after starting using bacula.
  
  One thought I had was to have two separate pages, console and bconsole.
  But that was just a thought, nothing I've contemplated on what it would
  take to accomplish or discussed with Kern.  Where the bconsole would
  behave completely with text.
  
  Dirk
  
  
  On Fri, 2009-06-19 at 12:19 +1200, John Huttley wrote:

   Hi Dirk.
   I just type Cancel in the command line thingy.
   That, by default, cancels the currently running job.
   If I ever need to cancel /anything/ then I need to cancel /everything/
   so I just
   click yes
   
   Glad to see you are on the job!!
   
   Regards,
   
   John
   
   
   Dirk Bartley wrote: 
   
I recall resolving a similar issue, but I'm not sure if it is the same
one.  There are two places to cancel a job, from the joblist and from
the director status.

Identifiy which one and make sure it is a repeatable error, and let me
know and I'll double check to make sure I resolved it in the head.

Dirk


On Fri, 2009-06-19 at 10:05 +1200, John Huttley wrote:
  
  
 Hi,
 I've just tried to cancel a job in bat.
 It pops up a dialog. Options are Yes or No.
 
 Click yes to cancel, but the Yes goes straight to the cancel command 
 which then says
 Yes: is an invalid command.
 
 Of course I can click 'No' and get
 
 No: is an invalid command.
 
 --john
 
 --
 Crystal Reports - New Free Runtime and 30 Day Trial
 Check out the new simplified licensing option that enables unlimited
 royalty-free distribution of the report engine for externally facing 
 server and web deployment.
 http://p.sf.net/sfu/businessobjects
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users
 
 

  
  
  

 


--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

[Bruno Friedmann]

Jari Fredriksson wrote:
 James Harper wrote:
 The subquery returns a very small result set (0 or 1,
 assuming you use DISTINCT) and so isn't too inefficient.
 It's when you say 'WHERE NOT EXISTS (SOME QUERY WITH
 LOTS OF RESULTS)' that you start to really bog down
 True, but if the outer query contains a very large number
 of records, the inner query is executed over and over and
 over and ... 

 This multiplies the small execution time by a large
 number. 

 Think of it like a WHILE loop that executes a block of
 code each time round. The inner block of code might be
 quick, but if the loop goes round several million times,
 the cumulative time becomes significant. 

 One general rule of thumb of SQL execution is that bulk
 processing is almost always faster than processing
 records individually in a loop. 
 
 All right then. Then there is this version:
 
 INSERT INTO Filename(Name)
 SELECT DISTINCT Name
 FROM batch AS
 WHERE Name NOT IN
 (
 SELECT DISTINCT Name
 FROM Filename
 );
 
 I guess it depends on RDMS, but I wonder it it executes the subquery more 
 than once.
 
 
 

The keyword EXPLAIN before the query should show how mysql would react.

There's some tools also mysql-administrator which can be use to detect / search 
point of slow


-- 

 Bruno Friedmann



--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

[Bruno Friedmann]

Jari Fredriksson wrote:
 James Harper wrote:
 The subquery returns a very small result set (0 or 1,
 assuming you use DISTINCT) and so isn't too inefficient.
 It's when you say 'WHERE NOT EXISTS (SOME QUERY WITH
 LOTS OF RESULTS)' that you start to really bog down
 True, but if the outer query contains a very large number
 of records, the inner query is executed over and over and
 over and ... 

 This multiplies the small execution time by a large
 number. 

 Think of it like a WHILE loop that executes a block of
 code each time round. The inner block of code might be
 quick, but if the loop goes round several million times,
 the cumulative time becomes significant. 

 One general rule of thumb of SQL execution is that bulk
 processing is almost always faster than processing
 records individually in a loop. 
 
 All right then. Then there is this version:
 
 INSERT INTO Filename(Name)
 SELECT DISTINCT Name
 FROM batch AS
 WHERE Name NOT IN
 (
 SELECT DISTINCT Name
 FROM Filename
 );
 
 I guess it depends on RDMS, but I wonder it it executes the subquery more 
 than once.
 
 
 

The keyword EXPLAIN before the query should show how mysql would react.

There's some tools also mysql-administrator which can be use to detect / search 
point of slow


-- 

 Bruno Friedmann



--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Bat 3.0.1 from src.rpm not working

[Mark Nienberg]

I rebuilt the bacula 3.0.1 src rpm on a fedora core 7 system and everything 
seemed to 
work out fine except bat.  An rpm was built and it installed, but when I start 
it I get

[r...@khyber bacula-3.0.1]# bat
/usr/sbin/bat: line 118: cd: /usr/src/redhat/BUILD/bacula-3.0.1/src/qt-console: 
No 
such file or directory
g++: obj/main.o: No such file or directory
g++: obj/bat_conf.o: No such file or directory
g++: obj/mainwin.o: No such file or directory
etc, etc

Bat 2.4.4 built and worked just fine on this system.

It has the correct qt:

[r...@khyber bacula-3.0.1]# rpm -qa | grep qt
qt4-x11-4.3.4-14.fc7
qt4-devel-4.3.4-14.fc7
qt4-4.3.4-14.fc7

Any hints on getting this to work?  thanks,
-- 
Mark Nienberg
Sent from an invalid address. Please reply to the group.


--
Are you an open source citizen? Join us for the Open Source Bridge conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] The tipically error: Cannot find any appendable volumes.

[Bruno Friedmann]

Reynier Pérez Mira wrote:
 John Drescher wrote:
 Your retention period of 6000 seconds has expired so these volumes
 should be recycled. Can you post your bacula-dir.conf?

 John
 Ok, here it's:
 
 Director {# define myself
Name = serverbacula-dir
Description = Bacula Director Centro de Datos UCI
DIRport = 9101# where we listen for UA connections
DirAddress = 10.128.50.11
QueryFile = /etc/bacula/query.sql
WorkingDirectory = /var/bacula/working
PidDirectory = /var/run
Maximum Concurrent Jobs = 5
Password = 
 shqjya3k7n8w673ieDj6fRkh2SciKrBL2GhB6RrasThBG2xYTufoY3chV3cvm6x9  # 
 Debe ser la misma contr$
Messages = Daemon
FD Connect Timeout = 5 min # tiempo durante el cual Bacula intentará 
 contactar con el FD
SD Connect Timeout = 5 min # tiempo durante el cual Bacula intentará 
 contactar con el SD
 }
 
 #Trabajos - Clientes
 @/etc/bacula/clients/catalog.conf # BD Bacula
 
 #F01
 
 #F02
 @/etc/bacula/clients/salvasprod_f02_imac-fd.conf # Proyecto IMAC - F02
 
 #F03
 @/etc/bacula/clients/salvasprod_f03_sigespro-fd.conf
 @/etc/bacula/clients/salvasprod_f03_fiscalia-fd.conf
 @/etc/bacula/clients/salvasprod_f03_tribunales-fd.conf
 @/etc/bacula/clients/salvasprod_f03_rnvss-fd.conf
 
 #F04
 @/etc/bacula/clients/salvasprod_f04_aduana01-fd.conf
 @/etc/bacula/clients/salvasprod_f04_aduana02-fd.conf
 
 #F05
 @/etc/bacula/clients/salvasprod_f05_cneuro-fd.conf
 @/etc/bacula/clients/salvasprod_f05_cneuro_jonline-fd.conf
 
 #F06
 @/etc/bacula/clients/salvasprod_f06_polo_bioinformatica-fd.conf
 
 #F07
 #@/etc/bacula/clients/salvasprod_f07_his-fd.conf
 
 #F08
 #@/etc/bacula/clients/salvasprod_f08_libelectronicos-fd.conf
 
 #F09
 @/etc/bacula/clients/salvasprod_f09_sipp-fd.conf
 
 #F10
 @/etc/bacula/clients/salvasprod_f10-fd.conf
 
 #Centro de Desarrollo
 @/etc/bacula/clients/salvasprod_cd_centalad-fd.conf
 @/etc/bacula/clients/salvasprod_cd_consultoria-fd.conf
 
 #Otras areas
 
 JobDefs {
Name = DefinicionPorDefectoParaCopias
Type = Backup
Level = Incremental
Storage = FileSAN
Messages = Standard
Priority = 5 #Es la opcion por defecto, a mayor numero menos prioridad
Reschedule on error = yes
Reschedule interval = 30 minutes
Reschedule times = 2
Max Start Delay = 1 hours
#Accurate = yes # permite verificar los ficheros con cambios despues 
 de realizada la copia
 
# Script para setear el proxy
#RunScript {
#  RunsWhen = After
#  RunsOnFailure = yes
#  Command = /etc/bacula/scripts/send_beeper.sh
#}
 }
 
 Schedule {
Name = ScheduleFull
Run = Full 1st sun at 4:00
Run = Differential 2nd-5th sun at 2:00
Run = Incremental mon-sat at 2:00
 }
 
 # Definition of file storage device
 Storage {
Name = FileSAN
Address = 10.128.50.11# N.B. Use a fully qualified 
 name here
SDPort = 9103
Password = 
 w4RRaeX7ZnhQnN8sSgFcXHh42ApmAgn7ZfT6kf3wBtCLpJyfgtq75GNHswwbTk6L
Device = FileStorage
Media Type = File
 }
 
 Catalog {
Name = MyCatalog
dbname = bacula_db;
dbuser = bacula_user;
dbpassword = LW9DEjh5hVmqAweB
DB Address = 10.128.50.3
 }
 
 Messages {
Name = Standard
 #  mailcommand = /sbin/bsmtp -h 10.128.50.1 -f \\(Bacula\) \%r\\ -s 
 \Bacula: %t %e of %c %l\ %r
mailcommand = /sbin/bsmtp -h 10.128.50.1 -f \\(Bacula Service\) 
 \bac...@prod.uci.cu\\ -s \Bacula: $
 #  operatorcommand = /sbin/bsmtp -h 10.128.50.1 -f \\(Bacula\) 
 \%r\\ -s \Bacula: Intervention needed$
operatorcommand = /sbin/bsmtp -h 10.128.50.1 -f \\(Bacula Service\) 
 \bac...@prod.uci.cu\\ -s \Bacu$
mail = rper...@uci.cu = all, !skipped
operator = rper...@uci.cu = mount
console = all, !skipped, !saved
append = /var/bacula/working/log = all, !skipped
 }
 
 Messages {
Name = Daemon
 #  mailcommand = /sbin/bsmtp -h 10.128.50.1 -f \\(Bacula\) \%r\\ -s 
 \Bacula daemon message\ %r
mailcommand = /sbin/bsmtp -h 10.128.50.1 -f \\(Bacula Service\) 
 \bac...@prod.uci.cu\\ -s \Bacula d$
mail = rper...@uci.cu = all, !skipped
console = all, !skipped, !saved
append = /var/bacula/working/log = all, !skipped
 }
 
 Console {
Name = serverbacula-mon
Password = ZKu3rWgOAqBXhQ57nURO58txSPTTgWIU8XcKbNKHuCNI
CommandACL = status, .status
 }
 
 
 

I think John or us, need also the
@/etc/bacula/clients/salvasprod_f06_polo_bioinformatica-fd.conf
if this is the fd which has trouble and in which the incriminated pool was 
defined


-- 

 Bruno Friedmann


--
Are you an open source citizen? Join us for the Open Source Bridge conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
___
Bacula-users mailing list

Re: [Bacula-users] The tipically error: Cannot find any appendable volumes.

[John Drescher]

 I think John or us, need also the
 @/etc/bacula/clients/salvasprod_f06_polo_bioinformatica-fd.conf
 if this is the fd which has trouble and in which the incriminated pool was 
 defined


Yes I do need that file. I was going to ask for that but I am too busy
at the day job and I can not let my volunteer bacula support get in
the way paying job..

John

--
Are you an open source citizen? Join us for the Open Source Bridge conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] The tipically error: Cannot find any appendable volumes.

[Reynier Pérez Mira]

John Drescher wrote:
 I think John or us, need also the
 @/etc/bacula/clients/salvasprod_f06_polo_bioinformatica-fd.conf
 if this is the fd which has trouble and in which the incriminated pool was 
 defined


Sorry for both of you. Here is the file needed:

#Description: Backup the files include in FS for salvasprod_f02_imac-fd
#-
#Job Definition
Job {
   Name = SP_F06_POLO_BIOINFORMATICA-FD
   JobDefs = DefinicionPorDefectoParaCopias
   Level = Incremental
   Client = salvasprod_f06_polo_bioinformatica-fd
   FileSet = SP_F06_POLO_BIOINFORMATICA-FS
   Schedule = ScheduleFull
   Write Bootstrap = /data/BoostrapFiles/SP_F06_POLO_BIOINFORMATICA-FD.bsr
   Priority = 5
   Pool = SP_F06_POLO_BIOINFORMATICA_Pool
}

#Client Definition
Client {
   Name = salvasprod_f06_polo_bioinformatica-fd
   Address = 10.7.19.203
   FDPort = 9102
   Catalog = MyCatalog
   Password = jdl5.!jhdg45dfg1
   File Retention = 1 years
   Job Retention = 1 years
}

#Pool Definition
Pool {
   Name = SP_F06_POLO_BIOINFORMATICA_Pool
   Pool Type = Backup
   Recycle = yes
   AutoPrune = yes
   Volume Retention = 1 year
   Recycle Oldest Volume = yes
   Maximum Volume Jobs = 1
   Label Format =  SP_F06_POLO_BIOINFORMATICA_Pool-
   Maximum Volumes = 2
}

#FileSet Definition
FileSet {
   Name = SP_F06_POLO_BIOINFORMATICA-FS
   Include {
 Options {
   signature = SHA1
   compression = GZIP
 }
 File = /etc
 File = /data/svn
   }
}

Regards and thanks for all your reply


--
Are you an open source citizen? Join us for the Open Source Bridge conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Maximum Concurrent Jobs

[Dirk Bartley]

Greetings

I'm trying to understand Maximum Concurrent Jobs.

Here is an example output from status dir



Running Jobs:
Console connected at 19-Jun-09 17:51
 JobId Level   Name   Status
==
  9334 FullAlum3JobMain.2009-06-19_17.01.00_47 is running
  9336 FullAlum2RootJob.2009-06-19_17.01.00_49 is waiting on Storage
Alum2FileStorage
  9337 FullAlum1Job.2009-06-19_17.01.00_50 is waiting on Storage
Alum2FileStorage
  9338 FullAlum3root.2009-06-19_17.01.00_51 is waiting on Storage
Alum2FileStorage
  9339 FullAlum3sharedlvm.2009-06-19_17.01.00_52 is waiting on
Storage Alum2FileStorage
  9340 FullDatabaseJob.2009-06-19_17.01.00_53 is waiting execution
  9341 FullSubversionJob.2009-06-19_17.01.00_54 is waiting for
higher priority jobs to finish



These jobs are all being written to filestorage.  Then when they are all
done the low priority jobs will trigger a run after script that will
start them all being copied to tape, but that is later.

So it looks like only one job is running because I have a maximum
concurrent directive relating to storage limiting the number of jobs
running concurrently.

Reading the storage daemons config documentation, there is only one and
it is on the storage daemon itself, not on the Device resource.  It is
set to 50.

On this storage daemon I have 2 tape devices and one Filestorage device
on this storage Daemon.

I can see from the director configuration, there is a maximum concurrent
jobs directive for just about every resource.  The director resource is
set to 5.  All jobs are set to 5 with the exception of the copy jobs.
All client resources are set to 10.  Each storage resource in the
directors config is set to a Max of 10.

So I'm not understanding why I can't have more jobs running at the same
time.  The pool resource for the File-xxx pool sets Maximum Volume Jobs
= 1 so that each job will have it's own volume (or file on the hard
drive) that it is writing to.

Because I am writing to file first, I am not setting up spooling.

Any possible assistance in helping me understand this is apprecieated.
I guess I could be happy that everything is working, I'ts just that when
someone asks me why I can't get more jobs running concurrently, I want
to be able to answer.  Because I know one person will ask.

Dirk



--
Are you an open source citizen? Join us for the Open Source Bridge conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Maximum Concurrent Jobs

[John Drescher]

On Fri, Jun 19, 2009 at 6:29 PM, Dirk Bartleybartle...@chartermi.net wrote:
 Greetings

 I'm trying to understand Maximum Concurrent Jobs.

 Here is an example output from status dir



 Running Jobs:
 Console connected at 19-Jun-09 17:51
  JobId Level   Name                       Status
 ==
  9334 Full    Alum3JobMain.2009-06-19_17.01.00_47 is running
  9336 Full    Alum2RootJob.2009-06-19_17.01.00_49 is waiting on Storage
 Alum2FileStorage
  9337 Full    Alum1Job.2009-06-19_17.01.00_50 is waiting on Storage
 Alum2FileStorage
  9338 Full    Alum3root.2009-06-19_17.01.00_51 is waiting on Storage
 Alum2FileStorage
  9339 Full    Alum3sharedlvm.2009-06-19_17.01.00_52 is waiting on
 Storage Alum2FileStorage
  9340 Full    DatabaseJob.2009-06-19_17.01.00_53 is waiting execution
  9341 Full    SubversionJob.2009-06-19_17.01.00_54 is waiting for
 higher priority jobs to finish
 


 These jobs are all being written to filestorage.  Then when they are all
 done the low priority jobs will trigger a run after script that will
 start them all being copied to tape, but that is later.

 So it looks like only one job is running because I have a maximum
 concurrent directive relating to storage limiting the number of jobs
 running concurrently.

 Reading the storage daemons config documentation, there is only one and
 it is on the storage daemon itself, not on the Device resource.  It is
 set to 50.

 On this storage daemon I have 2 tape devices and one Filestorage device
 on this storage Daemon.

 I can see from the director configuration, there is a maximum concurrent
 jobs directive for just about every resource.  The director resource is
 set to 5.  All jobs are set to 5 with the exception of the copy jobs.
 All client resources are set to 10.  Each storage resource in the
 directors config is set to a Max of 10.

 So I'm not understanding why I can't have more jobs running at the same
 time.  The pool resource for the File-xxx pool sets Maximum Volume Jobs
 = 1 so that each job will have it's own volume (or file on the hard
 drive) that it is writing to.

 Because I am writing to file first, I am not setting up spooling.

 Any possible assistance in helping me understand this is apprecieated.
 I guess I could be happy that everything is working, I'ts just that when
 someone asks me why I can't get more jobs running concurrently, I want
 to be able to answer.  Because I know one person will ask.


Are the priorities the same for all jobs but the  SubversionJob?

John

--
Are you an open source citizen? Join us for the Open Source Bridge conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bat 3.0.1 from src.rpm not working

[Mark Nienberg]

Dirk Bartley wrote:
 Something that changed recently is that bat is a script that runs the
 binary.  The script usually wants to see the binary in a subdirectory
 called .libs of the pwd of the script.
 
 Not sure as to what the packaging solution is.  All apologies.
 
 Dirk

Oh, I guess it is a packaging problem then.  The rpm installs the wrapper 
script in 
/usr/sbin/bat and the executable file in /bin/bat.

At the top of the wrapper script it says:

This wrapper script should never be moved out of the build directory.
If it is, it will not operate correctly.

But of course there is no build directory in an rpm installation.

I don't see how this could possibly work.  Does anyone have a working bat that 
was 
installed from rpm?

Mark
Sent from an invalid address. Please reply to the group.

 
 
 On Fri, 2009-06-19 at 10:35 -0700, Mark Nienberg wrote:
 I rebuilt the bacula 3.0.1 src rpm on a fedora core 7 system and everything 
 seemed to 
 work out fine except bat.  An rpm was built and it installed, but when I 
 start it I get

 [r...@khyber bacula-3.0.1]# bat
 /usr/sbin/bat: line 118: cd: 
 /usr/src/redhat/BUILD/bacula-3.0.1/src/qt-console: No 
 such file or directory
 g++: obj/main.o: No such file or directory
 g++: obj/bat_conf.o: No such file or directory
 g++: obj/mainwin.o: No such file or directory
 etc, etc

 Bat 2.4.4 built and worked just fine on this system.

 It has the correct qt:

 [r...@khyber bacula-3.0.1]# rpm -qa | grep qt
 qt4-x11-4.3.4-14.fc7
 qt4-devel-4.3.4-14.fc7
 qt4-4.3.4-14.fc7

 Any hints on getting this to work?  thanks,


--
Are you an open source citizen? Join us for the Open Source Bridge conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Maximum Concurrent Jobs

[Dirk Bartley]

On Fri, 2009-06-19 at 19:24 -0400, John Drescher wrote:
 On Fri, Jun 19, 2009 at 6:29 PM, Dirk Bartleybartle...@chartermi.net wrote:
  Greetings

  Because I am writing to file first, I am not setting up spooling.
 
  Any possible assistance in helping me understand this is apprecieated.
  I guess I could be happy that everything is working, I'ts just that when
  someone asks me why I can't get more jobs running concurrently, I want
  to be able to answer.  Because I know one person will ask.
 
 
 Are the priorities the same for all jobs but the  SubversionJob?

Correct.  That is the only job with a different priority.

Subversion job is with a priority = 11
The rest are with priority = 10.

I do this so that it is the last job that starts which triggers the copy
jobs.

Dirk


--
Are you an open source citizen? Join us for the Open Source Bridge conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bat 3.0.1 from src.rpm not working

[Mark Nienberg]

Here is some more info.

I made the initial rpms using
rpmbuild --rebuild (plus some options)

Now, I did
rpm -i bacula.src.rpm

and then
rpmbuild -bb /usr/src/redhat/SPECS/bacula.spec (plus some options)

with this approach, the BUILD directory is not cleaned after the packages are 
build, 
so bat is able to locate the files it needs to do the relink and bat starts 
correctly.

So now I'm wondering if this is a one-time-only requirement or if I must leave 
the 
BUILD directory in place in order to keep bat running in the future?

Thanks,

-- 
Mark Nienberg
Sent from an invalid address. Please reply to the group.


--
Are you an open source citizen? Join us for the Open Source Bridge conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users