[Bacula-users] Delete old volumes - FULL DISK (argh!)

2006-03-28 Thread Giuseppe

Hi!
This moring I saw the "FULL DISK" error (argh!) so I'm trying to
understand how to delete old volumes, even if they're not alredy
expired. I also read something in the mailing list archive about it,
but the only thing I found was a mail from Phil Stracchino about
a pool directive called: "Delete Volume When Prined = yes", but
it seems not working. Can anyone suggest me a way to do so?

Thanks for your time!

Giuseppe


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Bacula jobstatus codes

2006-03-30 Thread Giuseppe

Hi!
I'm looking for bacula codes about jobstatus, but I can't
find them in the bacula online manual. (Am I blind? ehehe )
Can anyone tell me where can I find them please?

Thanks for your time!

Giuseppe




---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Mysql databases backup

2006-03-30 Thread Giuseppe

Hi!
This is not really a problem, I'm just asking which is the best way to 
do a thing.
I've to backup about 13GB of Mysql Databases, so I 've 2 possibile 
solutions:


1) include /var/lib/mysql in fileset resource
2) run "mysqldump --all-databases" before job

Should I stop mysqld before a backup?

Which is the best way to do so?
Any other suggestion is well accepted! :)

Thanks!

Giuseppe


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Echo cancellation problem

2006-03-31 Thread Giuseppe

Hi!
I'm here again with echo canceller problem... :-(
I think I've done everything to enable echo canceller feature, but it 
still doesn't work...
Can anybody tell me if there is some error or something missing in this 
configuration please?


I'm using Eicon Diva Server 4Bri.
http://www.eicon.com/worldwide/products/MediaGateways/disv4bri.htm?techspec=1®ID=4999

Card features:

   * Supplementary Services
 o Number Identification services (CLIP, CLIR, COLP, COLR, KEY,
   MSN, DDI, SUB)
 o Call offering services (TP, CFU, CFB, CFNR)
 o Call completion services (CW, HOLD, ECT)
 o Charging services (AoC)
 o Three-party conference
 o Large Conference
   * VoIP Gateway support
 o Echo cancellation (G.168) 128ms (32ms for VoIP)   <  it
   seems to support echo cancellation
 o Real Time Protocol (RTP framing)
 o Dynamic Anti-Jitter Buffer
 o Comfort Noise Generation
 o Voice Activity Detection
 o Voice compression (GSM, G.726)


= capi.conf =

[general]
nationalprefix=039
;;internationalprefix=011
rxgain=1.0
txgain=2.0
;rxgain=1.0
;txgain=1.0
alaw=yes ;
;ulaw=yes ;set this, if you live in u-law world instead of a-law --beppe

[ISDN3]
ntmode=yes
incomingmsn=*
controller=3
group=1 
;softdtmf=on

;relaxdtmf=on
;accountcode=
context=isdn3in
holdtype=local 
immediate=yes

;echosquelch=1
echocancel=yes
;echocancelold=yes
echotail=64  
bridge=yes   
callgroup=1  
;deflect=1234567 
devices=2  

== and this is a piece of what "asterisk -rv" says when 
someone calls ==


 == ISDN3: Incoming call 'yy' -> 'x'
   -- Executing Set("CAPI/ISDN3/'x'-1", "LANGUAGE()=it") in new 
stack
   -- Executing GotoIfTime("CAPI/ISDN3/'x'-1", 
"09:00-13:00|mon-fri|*|*?coda_lib_uni|s|1") in new stack
   -- Executing GotoIfTime("CAPI/ISDN3/'x'-1", 
"15:00-18:00|mon-fri|*|*?coda_lib_uni|s|1") in new stack

   -- Goto (coda_lib_uni,s,1)
   -- Executing Set("CAPI/ISDN3/'x'-1", "LANGUAGE()=it") in new 
stack
   -- Executing SetVar("CAPI/ISDN3/'x'-1", 
"MONITOR_FILENAME=lib-uni-31032006-16:40:21-039564615724") in new stack
   -- Executing Playback("CAPI/ISDN3/'x'-1", 
"wsa_benvenuto_lib_uni") in new stack

 == ISDN3: Answering for 'x'
   -- Playing 'wsa_benvenuto_lib_uni' (language 'it')
Mar 31 16:40:21 WARNING[30181]: file.c:1029 ast_waitstream: Unexpected 
control subclass '14'
 == ISDN3: Setting up echo canceller (PLCI=0x103, function=1, 
options=4, tail=64)

 == ISDN3: Setting up DTMF detector (PLCI=0x103, flag=1)
   -- ISDN3: Error setting up echo canceller (PLCI=0x103)
Mar 31 16:40:21 WARNING[29878]: chan_capi.c:3334 show_capi_conf_error: 
ISDN3: conf_error 0x300b PLCI=0x103 Command=FACILITY_CONF,0x8497

  > CAPI INFO 0x300b: Facility not supported






---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] sorry

2006-03-31 Thread Giuseppe

Hi!
I'm sorry for previous mail about Asterisk Echo Cancellation, I wrote to 
wrong mailinglist!

Sorry again

Giuseppe


---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Info of HP MSL2024 SCSI or FC

2007-10-02 Thread Giuseppe Cortese
Hi all,
I have a question on HP MSL2024 (Ultrium 960) SCSI or FC compatibility with
bacula on Linux.
Bacula support, from posts on this mailing list, msl2024 but I understand if
bacula support only SCSI model or also Fiber channel model.

Thanks for any answer!!



Thank's in advance


Giuseppe Cortese

***=*=*=*=**=*=*=*=***
* Giuseppe Cortese   *
* System Manager *
* CISCO Certified CCNA   *
**
* Presidenza della Facolta' di Scienze MM.FF.NN. *
* Università degli Studi di Padova   *
**
* Indirizzo: Via Jappelli, 1 - 35121 Padova  *
* E-mail: [EMAIL PROTECTED]  *
* Telefono: +39 049 827 5074 *
* Fax: +39 049 827 5069  *
***=*=*=*=**=*=*=*=***  



-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Automatic Volume generator on pool (and presentation)

2016-02-19 Thread Giuseppe Moscato
Hi!
I'm Giuseppe moscato aka peppeska from Milan (Italy).
I'm happy to have the opportunity to use Bacula system for work purpose!

I'm new in Bacula so I have a little question...

I have this Daily pool:

Pool {
  Name = Daily
  Pool Type = Backup
  Recycle = yes

  AutoPrune = yes
  Volume Retention = 2 weeks

  Label Format = VolDaily_
  Maximum Volume Bytes = 50G
  Maximum Volumes = 100

  #Accept Any Volume = yes # write on any volume in the pool
  Recycle Oldest Volume = yes
  Recycle Current Volume = yes
  #Maximum Volume Jobs = 1
  Volume Use Duration = 24h
}

In this Pool I used "Volume Use Duration = 24h" 'cause I would like that
bacula change Volume every day...
but this down not happen..

why??


Fro complete information i write my complete scheduling:

Schedule {
  Name = "ScheduleNip"
  Run = Level=Full Pool=Monthly 1st sun at 23:05
  Run = Level=Differential Pool=Weekly 2nd-5th sun at 23:05
  Run = Level=Incremental Pool=Daily mon-sat at 23:05

  Run = Level=Full Pool=Archive on jan 1 at 1:00
  Run = Level=Full Pool=Archive on mar 1 at 1:00
  Run = Level=Full Pool=Archive on may 1 at 1:00
  Run = Level=Full Pool=Archive on jul 1 at 1:00
  Run = Level=Full Pool=Archive on aug 1 at 1:00
  Run = Level=Full Pool=Archive on oct 1 at 1:00
}


Pool {
  Name = Archive
  Pool Type = Backup
  Recycle = yes

  AutoPrune = yes
  Volume Retention = 24 months

  Label Format = VolArchivie_
  Maximum Volume Bytes = 50G
  Maximum Volumes = 100

  #Accept Any Volume = yes # write on any volume in the pool
  Recycle Oldest Volume = yes
  Recycle Current Volume = yes
  #Maximum Volume Jobs = 1
  Volume Use Duration = 12 months
}

Pool {
  Name = Monthly
  Pool Type = Backup
  Recycle = yes

  AutoPrune = yes
  Volume Retention = 365 days

  Label Format = VolMonthly_
  Maximum Volume Bytes = 50G
  Maximum Volumes = 100

  #Accept Any Volume = yes # write on any volume in the pool
  Recycle Oldest Volume = yes
  Recycle Current Volume = yes
  #Maximum Volume Jobs = 1
  Volume Use Duration = 1 month
}

Pool {
  Name = Weekly
  Pool Type = Backup
  Recycle = yes

  AutoPrune = yes
  Volume Retention = 4 weeks

  Label Format = VolWeekly_
  Maximum Volume Bytes = 50G
  Maximum Volumes = 100

  #Accept Any Volume = yes # write on any volume in the pool
  Recycle Oldest Volume = yes
  Recycle Current Volume = yes
  #Maximum Volume Jobs = 1
  Volume Use Duration = 1 weeks
}

Pool {
  Name = Daily
  Pool Type = Backup
  Recycle = yes

  AutoPrune = yes
  Volume Retention = 2 weeks

  Label Format = VolDaily_
  Maximum Volume Bytes = 50G
  Maximum Volumes = 100

  #Accept Any Volume = yes # write on any volume in the pool
  Recycle Oldest Volume = yes
  Recycle Current Volume = yes
  #Maximum Volume Jobs = 1
  Volume Use Duration = 24h
}





--
Giuseppe Moscato
NextIP



---
Questa e-mail è stata controllata per individuare virus con Avast antivirus.
https://www.avast.com/antivirus
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Recycling problem.

2014-10-15 Thread Giuseppe Vitillaro
I can't understand why the bacula director, 5.2.13 under a stable
updated gentoo, recycled one volume "000506L4", the correct one in
the slot 9 of my changer, but instead the storage daemon recycled
the current volume mounted in drive1, from slot4, volume "000529L4"
and without actually doing any pruning on the volume, pruning that
was correctly performed for the "000506L4" volume.

Note that the volume "000506L4" exceeded "Max configure use duration"
just before the records for volume "000506L4" had been pruned.

After this I've just a sequence, complete log attached to this message,
of 

Recycled volume "000506L4"
Recycled volume "000529L4" on device "lto1" (/dev/nlto1), all previous data 
lost.

This configuration of bacula had been running for quite a while without
a glitch, almost 10 months now and I had not any hardware error on my
library at the time of this job, at least for what I can see.

I can't understand what is going on.

Any clue?

Regards, G. Vitillaro.
13-Oct 21:00 bl13-dir JobId 1761: Start Backup JobId 1761, 
Job=Fs02Home.2014-10-13_21.00.00_33
13-Oct 21:00 bl13-sd JobId 1761: 3307 Issuing autochanger "unload slot 16, 
drive 1" command.
13-Oct 21:01 bl13-dir JobId 1761: Using Device "lto1" to write.
13-Oct 21:01 bl13-dir JobId 1761: Sending Accurate information.
13-Oct 21:01 bl13-sd JobId 1761: 3304 Issuing autochanger "load slot 4, drive 
1" command.
13-Oct 21:02 bl13-sd JobId 1761: 3305 Autochanger "load slot 4, drive 1", 
status is OK.
13-Oct 21:02 bl13-dir JobId 1761: Max configured use duration=604,800 sec. 
exceeded. Marking Volume "000529L4" as Used.
13-Oct 21:02 bl13-dir JobId 1761: There are no more Jobs associated with Volume 
"000506L4". Marking it purged.
13-Oct 21:02 bl13-dir JobId 1761: All records pruned from Volume "000506L4"; 
marking it "Purged"
13-Oct 21:02 bl13-dir JobId 1761: Recycled volume "000506L4"
13-Oct 21:02 bl13-sd JobId 1761: Recycled volume "000529L4" on device "lto1" 
(/dev/nlto1), all previous data lost.
13-Oct 21:02 bl13-dir JobId 1761: Max configured use duration=604,800 sec. 
exceeded. Marking Volume "000529L4" as Used.
13-Oct 21:02 bl13-sd JobId 1761: Spooling data ...
13-Oct 21:08 bl13-sd JobId 1761: Committing spooled data to Volume "000529L4". 
Despooling 7,153,238,703 bytes ...
14-Oct 12:58 bl13-sd JobId 1761: Despooling elapsed time = 00:01:06, Transfer 
rate = 108.3 M Bytes/second
14-Oct 12:58 bl13-sd JobId 1761: Elapsed time=15:55:43, Transfer rate=124.6 K 
Bytes/second
14-Oct 12:58 bl13-sd JobId 1761: Alert: TapeAlert: OK
14-Oct 12:58 bl13-sd JobId 1761: Sending spooled attrs to the Director. 
Despooling 37,665 bytes ...
14-Oct 12:58 bl13-dir JobId 1761: Bacula bl13-dir 5.2.13 (19Jan13):

--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Recycling problem.

2014-10-16 Thread Giuseppe Vitillaro

Apologies for appending to my own post, but I found
another occurence of the same pattern, I didn't notice,
in another job of some months ago, again attached to
this message. The same volumes are involved, and these,
for what I can see from my logs, are the only occurences
of the pattern.

It looks like that a volume exceeding the "use duration"
once the job has choosed the backup volume, create this
problem.

May I guess the routine "find_next_volume_for_append()"
in the source next_vol.c of the director could have
a bug, at least in the version 5.2.13 (19Jan13) I'm using?

In all the other cases I've verified, almost one year
of correctly running jobs, the "use duration"
have not been checked just after the beginning of the
job, once the director has already decided the volume
to use, but at a different time.

I may be on the wrong track, but if I'm right bacula
may overwrite a non empty, not purged volume.

Something, I guess, all the bacula users would hate,
isn't?

G. Vitillaro.


I can't understand why the bacula director, 5.2.13 under a stable 
updated gentoo, recycled one volume "000506L4", the correct one in the 
slot 9 of my changer, but instead the storage daemon recycled the 
current volume mounted in drive1, from slot4, volume "000529L4" and 
without actually doing any pruning on the volume, pruning that was 
correctly performed for the "000506L4" volume.


Note that the volume "000506L4" exceeded "Max configure use duration" 
just before the records for volume "000506L4" had been pruned.


After this I've just a sequence, complete log attached to this message, 
of


Recycled volume "000506L4" Recycled volume "000529L4" on device "lto1" 
(/dev/nlto1), all previous data lost.


This configuration of bacula had been running for quite a while without 
a glitch, almost 10 months now and I had not any hardware error on my 
library at the time of this job, at least for what I can see.


I can't understand what is going on.

Any clue?

Regards, G. Vitillaro.



--
Giuseppe Vitillaro  |  E-Mail : giuse...@vitillaro.org
CNR - ISTM  |  06123 Perugia  Phone:+39.075.585-5518
-07-Apr 21:00 bl13-dir JobId 734: Start Backup JobId 734, 
Job=SccwHome.2014-04-07_21.00.00_44
07-Apr 21:01 bl13-dir JobId 734: Using Device "lto1" to write.
07-Apr 21:01 bl13-dir JobId 734: Sending Accurate information.
07-Apr 21:01 bl13-sd JobId 734: 3304 Issuing autochanger "load slot 4, drive 1" 
command.
07-Apr 21:02 bl13-sd JobId 734: 3305 Autochanger "load slot 4, drive 1", status 
is OK.
07-Apr 21:02 bl13-dir JobId 734: Max configured use duration=604,800 sec. 
exceeded. Marking Volume "000529L4" as Used.
07-Apr 21:02 bl13-dir JobId 734: There are no more Jobs associated with Volume 
"000506L4". Marking it purged.
07-Apr 21:02 bl13-dir JobId 734: All records pruned from Volume "000506L4"; 
marking it "Purged"
07-Apr 21:02 bl13-dir JobId 734: Recycled volume "000506L4"
07-Apr 21:02 bl13-sd JobId 734: Recycled volume "000529L4" on device "lto1" 
(/dev/nlto1), all previous data lost.
07-Apr 21:02 bl13-dir JobId 734: Max configured use duration=604,800 sec. 
exceeded. Marking Volume "000529L4" as Used.
07-Apr 21:02 bl13-sd JobId 734: Spooling data ...
07-Apr 21:04 bl13-sd JobId 734: User specified Job spool size reached: 
JobSpoolSize=10,000,031,919 MaxJobSpoolSize=10,000,000,000
07-Apr 21:04 bl13-sd JobId 734: Writing spooled data to Volume. Despooling 
10,000,031,919 bytes ...
08-Apr 09:57 bl13-sd JobId 734: Despooling elapsed time = 00:02:03, Transfer 
rate = 81.30 M Bytes/second
08-Apr 09:57 bl13-sd JobId 734: Spooling data again ...
08-Apr 10:00 bl13-sd JobId 734: Committing spooled data to Volume "000506L4". 
Despooling 7,938,365,967 bytes ...
08-Apr 10:04 bl13-sd JobId 734: Despooling elapsed time = 00:01:13, Transfer 
rate = 108.7 M Bytes/second
08-Apr 10:04 bl13-sd JobId 734: Elapsed time=13:02:08, Transfer rate=382.0 K 
Bytes/second
08-Apr 10:04 bl13-sd JobId 734: Alert: TapeAlert: OK
08-Apr 10:04 bl13-sd JobId 734: Sending spooled attrs to the Director. 
Despooling 79,631 bytes ...
08-Apr 10:04 bl13-dir JobId 734: Bacula bl13-dir 5.2.13 (19Jan13):
--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Recycling problem.

2014-10-17 Thread Giuseppe Vitillaro
On Friday 17 October 2014 12:05:35 Ana Emília M. Arruda wrote:
> Hi Giuseppe,
> 
> I would like to append some comments here about your "volume use duration"
> configuration. As the directive name says, this is used to leave the volume
> available for Bacula "during" your backup jobs (at least the ones you want
> the data goes to that volume). Maybe you are having volume retention time
> troubleshooting here. If Bacula is using 000529L4 instead of 000506L4, this
> is because both volumes have a status (purged, append, recycle) that
> permits bacula to choose which one is the best one (guided by its volume
> recycling algorithm).  So, it seems the 000529L4 has a last written time
> older than the 000506L4.
> 
> I recommend you to put your "volume use duration" in hours, like Josh
> Fisher said, and just the time that you need the volume be available
> (append) for receiving data. And take a look at your volume retention
> period. If you have 10 volumes and want just one of them be available at a
> time, set a volume use duration of 9 days (you can set in hours if you are
> sure about the last written time of your volumes).
> 
> Best regards,
> Ana
> 
The volume 000529L4 had status "Append" at the time the
jobs started, then moved to status "Used", at the time
of the "mount". 

Beside that the volume 000529L4 was written
the day before the run, has a retention of 7 days and
was not neither "pruned", neither "purged" and not
marked as "Recycled".

Bacula wrote over a non empty, not pruned, not purged,
marked as "Used", Volume, leaving "dangling" jobs and
files alive into the database.

This shouldn't NEVER happen.

Am I wrong?

G. Vitillaro.
--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Recycling problem.

2014-10-18 Thread Giuseppe Vitillaro
> Consider how Bacula treats the case where "maximum volume jobs = 1". The job 
> starts to run and selects a volume marked "append", possibly first recycling 
> a volume if no available "append" volumes are empty. It then marks the volume 
> as "used" so that no other jobs will try to select it. After it is marked 
> "used" the job continues and writes the job data to it. So, yes, there is a 
> use for writing a volume after it is marked "used". Since multiple jobs may 
> start at the same or nearly the same time, Bacula serializes volume selection 
> by allowing only one job at a time to select a volume. So the job that marked 
> it "used" writes to it, but no other job can subsequently select it.
> 
> I think something similar is happening when "use duration" runs out while the 
> job is running. The "use duration" period begins when the volume is first 
> written to, which is always AFTER the job starts. If the "use duration" is an 
> integer multiple of the time period between job runs, then there will always 
> be a job that starts just minutes or seconds BEFORE the  "use duration" 
> expires. That causes the volume to get marked "used" during the job, though 
> it was indeed marked "append" when the job first started. The job doesn't 
> (and shouldn't) fail because of this. It continues and writes to the "used" 
> volume.
> 
> Jobs that start after the volume is marked "used" will NOT select it when 
> searching for a volume. This is why it is a good idea to make the "use 
> duration" period a bit shorter. That way the "use duration" has already 
> expired before the job starts.
> 
> So, I don't think you are "wrong". I just think you are miscalculating the 
> exact time of the end of the "use duration" period, that the volume isn't 
> being marked "used" until after the job has already started, meaning that the 
> "Use duration" is too long.

The reason for which bacula marks "used" the volume 000529L4 "after"
the job started is clear and for me would be perfectly
acceptable if the jobs continue to write on this volume
for this particular job. The logic looks correct.

My trouble starts trying to understand why bacula do this:

13-Oct 21:02 bl13-dir JobId 1761: Recycled volume "000506L4"
13-Oct 21:02 bl13-sd JobId 1761: Recycled volume "000529L4" on device "lto1" 
(/dev/nlto1), all previous data lost.

Bacula director decided to "recycle" the correct volume, the one which has
just pruned and purged 000506L4

13-Oct 21:02 bl13-dir JobId 1761: There are no more Jobs associated with Volume 
"000506L4". Marking it purged.
13-Oct 21:02 bl13-dir JobId 1761: All records pruned from Volume "000506L4"; 
marking it "Purged"

Now why on the hell the storage daemon recycle the volume 000529L4
which has not neither expired, purged or recycled?

Just trying to undertand, forgive me, but this is driving
me crazy ;-)

G. Vitillaro.
--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Recycling problem.

2014-10-18 Thread Giuseppe Vitillaro
On Friday 17 October 2014 21:41:49 Ana Emília M. Arruda wrote:
> Hi Giuseppe,
> 
> Yes, this could happen if bacula couldn't find a reciclable volume and you
> have the "purge oldest volume = yes" directive configured and this is, for
> Bacula, the oldest volume. The purge oldest volume doesn't respect the
> volume retention period.
> 
> Best regards,
> Ana
I was almost sure, but I just "grepped" all
my bacula conf file.

I'm sure the directive "purge oldest volume" is not present
in my files, so the default, for what I can read, should be
a plain "no".

Correct?

This is the definition of my "Incr" pool


Pool {
  Name = Incr
  Pool Type = Backup
  Recycle = yes
  Recycle Oldest Volume = yes
  Recycle Current Volume = no
  AutoPrune = yes   # Prune expired volumes
  Maximum Volumes =  2
  Volume Use Duration =  7 days# 1 week
  Volume Retention=  6  days   # 1 week - 1
}


G. Vitillaro.
--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Recycling problem.

2014-10-18 Thread Giuseppe Vitillaro
On Friday 17 October 2014 09:11:54 Josh Fisher wrote:
>Generally, schedules are starting jobs at the same time of day. It follows 
>that the time period between successive runs will tend to be very nearly an 
>integer number of days. If the use duration is also an integer number of days, 
>then it can be expected that a volume's use duration will expire at very 
>nearly the exact time that a job using a volume from that pool is scheduled to 
>run. This is alleviated by configuring a use duration that is not an integer 
>multiple of days. For example, instead of using a use duration of "7 days", 
>set use duration to "156 hours" (6 days 12 hours). The hysteresis makes it far 
>less likely that a job will be launched at exactly the same time that a 
>volume's use duration is expiring.
> 
Beside understanding the reason why the storage daemon recycled
a non empty volume, you advice seems to go in the direction to
minimime the probability this accident, use duration expiring
at the beginning of a job, would repeat.

I'll try it, but what about "9367 minutes" = "6 days 12h 7m"? 
Wouldn't be better to achieve this goal?

G. Vitillaro.
--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Recycling problem.

2014-10-18 Thread Giuseppe Vitillaro
On Saturday 18 October 2014 11:01:28 Ana Emília M. Arruda wrote:
> Just a comment here. Since you have "volume use duration = 7 days" and your
> volume was used until 12:58 next day, I'm quite sure (don't know how is
> your schedule configured) that this volume will be available (append) for
> use in the next week by your backup jobs. Because of your "volume use
> duration" configuration, Bacula started to use the same volume two weeks
> sequentially.
> 
> 13-Oct 21:08 bl13-sd JobId 1761: Committing spooled data to Volume
> "000529L4". Despooling 7,153,238,703 bytes ...
> 14-Oct 12:58 bl13-sd JobId 1761: Despooling elapsed time = 00:01:06,
> Transfer rate = 108.3 M Bytes/second
> 14-Oct 12:58 bl13-sd JobId 1761: Elapsed time=15:55:43, Transfer rate=124.6
> K Bytes/second
> 14-Oct 12:58 bl13-sd JobId 1761: Alert: TapeAlert: OK
> 14-Oct 12:58 bl13-sd JobId 1761: Sending spooled attrs to the Director.
> Despooling 37,665 bytes ...
> 14-Oct 12:58 bl13-dir JobId 1761: Bacula bl13-dir 5.2.13 (19Jan13):
> 
> Do you have prefer mounted volume set to yes?
> 
> Regards,
> Ana
It didn't used the volume incorrectly recyled, 000529L4,
bacula storage daemon just recycled it, marked as used 
and proceeded, correctly to backup on 000506L4 after
a manual intervention.

The manual intervention was required because the volume
000506L4 for some reason I don't quite understand was 
not considered anymore inside the changer (it was of course),
as this log, from another concurrent job show

13-Oct 21:00 bl13-dir JobId 1762: Start Backup JobId 1762, 
Job=MccwHome.2014-10-13_21.00.00_34
13-Oct 21:01 bl13-dir JobId 1762: Using Device "lto1" to write.
13-Oct 21:01 bl13-dir JobId 1762: Sending Accurate information.
13-Oct 21:02 bl13-sd JobId 1762: No slot defined in catalog (slot=0) for Volume 
"000506L4" on "lto1" (/dev/nlto1).
13-Oct 21:02 bl13-sd JobId 1762: Cartridge change or "update slots" may be 
required.
13-Oct 21:02 bl13-sd JobId 1762: Warning: Director wanted Volume "000506L4".
Current Volume "000529L4" not acceptable because:
1998 Volume "000529L4" catalog status is Used, but should be Append, Purged 
or Recycle.
13-Oct 21:02 bl13-sd JobId 1762: 3307 Issuing autochanger "unload slot 4, drive 
1" command.
13-Oct 21:03 bl13-sd JobId 1762: No slot defined in catalog (slot=0) for Volume 
"000506L4" on "lto1" (/dev/nlto1).
13-Oct 21:03 bl13-sd JobId 1762: Cartridge change or "update slots" may be 
required.

After the intervention, "update slots", the jobs continued without
any problem

14-Oct 12:58 bl13-sd JobId 1761: Despooling elapsed time = 00:01:06, Transfer 
rate = 108.3 M Bytes/second
14-Oct 12:58 bl13-sd JobId 1761: Elapsed time=15:55:43, Transfer rate=124.6 K 
Bytes/second
14-Oct 12:58 bl13-sd JobId 1761: Alert: TapeAlert: OK
14-Oct 12:58 bl13-sd JobId 1761: Sending spooled attrs to the Director. 
Despooling 37,665 bytes ...
14-Oct 12:58 bl13-dir JobId 1761: Bacula bl13-dir 5.2.13 (19Jan13):

14-Oct 12:56 bl13-sd JobId 1762: 3304 Issuing autochanger "load slot 9, drive 
1" command.
14-Oct 12:56 bl13-sd JobId 1762: 3305 Autochanger "load slot 9, drive 1", 
status is OK.
14-Oct 12:56 bl13-sd JobId 1762: Recycled volume "000506L4" on device "lto1" 
(/dev/nlto1), all previous data lost.

And yes, I've "prefer mounted volume set to yes" for these jobs.

G. Vitillaro.

--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] sg device node stickyness

2014-10-22 Thread Giuseppe Vitillaro
On Wednesday 22 October 2014 10:24:53 Robert Oschwald wrote:
> Using Bacula Server 7.0.4 on CentOS6_64.
> 
> One thing which annoys me is that the sg device node for TapeAlert changes 
> with every reboot from /dev/sg4 to /dev/sg6 and vice versa.
> Is there any setting I can set in udev to get sticky device nodes for my tape 
> device changer device node?
> 
> System has a LSI 3Ware  9650SE controller installed which is the one fighting 
> for sg device node with my HP Ultrium 4 SCA tape device.
> 
> Thanks,
> Robert
>  
> 
> 
This is my autochg.sh script under gentoo stable

#!/bin/sh
sgdev=$(sg_map26 $1)

if [ -z "${sgdev}" ]; then
echo "TapeAlert: no sgdev for $1"
exit 0
fi

The command "sg_map26" come from the sg3_utils
package that should be available under CentOS6
and make a good job for me converting the tape
device into the sg device.

Then, in the bacula-sd.conf stanza of your tape
or changer, you may use something like this

Alert Command = "sh -c '/etc/bacula/autochg.sh /dev/nlto0 | grep TapeAlert|cat'"

Seems to work correctly for me.

Hope it helps, G. Vitillaro
--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Upgrade to 3.0.3 Job is waiting for execution

2009-11-17 Thread Giuseppe De Nicolo'
Hi All,

Since the upgrade to 3.0.3 our test server have this strange 
behavior , the first job after bacula start up runs fine all others get 
in line as "job is waiting execution" and nothing happens, restarting 
bacula reset job lists and again only the first job run fine.

The log show nothing usefull to debug the problem, job e-mail is 
empty and it fires off only when I do manually restart the bacula 
service ... After noticing the issue I tried to rewrite from scratch 
config files , remove and recreate the Backup volume ( I do use file 
storage) but to no avail.

Any guess on what could cause this problem ?  I found this post 
http://www.backupcentral.com/phpBB2/two-way-mirrors-of-external-mailing-lists-3/bacula-25/job-is-waiting-for-execuition-101508/

Where this guy is having my same problem but noone still answered him


Thank you in advance for your patience.

Sincerely

--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Upgrade to 3.0.3 Job is waiting for execution

2009-11-17 Thread Giuseppe De Nicolo'
Giuseppe De Nicolo' wrote:
> Alan Brown wrote:
>> On Tue, 17 Nov 2009, Giuseppe De Nicolo' wrote:
>>
>>  
>>> Hi All,
>>>
>>> Since the upgrade to 3.0.3 our test server have this strange
>>> behavior , the first job after bacula start up runs fine all others get
>>> in line as "job is waiting execution" and nothing happens, restarting
>>> bacula reset job lists and again only the first job run fine.
>>> 
>>
>> Have your concurrency settings been reset? Remember it needs to be 
>> checked
>> in multiple places.
>>
>>   
> Hi and thank you for your answer, actually you where right , I had ma 
> concurrent jobs se to 1 into director configuration file, though I had 
> it also in 3.0.1 and it worked like a charm  thats why I 
> overlooked the problem, has something changed since 3.0.1 ? and anyway 
> even if I had a concurrency limit of 1 ( which I could like ) why are 
> jobs then not firing up once the first one has completed ?
>
> Anyway I may consider my problem for such I thank you very much
>
> Sincerely
>
Well evidently I was wrong my problem is not solved, it just change 
behavior, now subsequent jobs does not sit anymore in queue saying

"job is waiting execution" but  instead they claim to be running which in fact 
is not true, since backup devise is dismounted and nothing happens , pratically 
the system is on hang till I reboot the bacula service  then only  the 
firts job in line again does run others hangs the system and so on ...

Any clue ?? 


--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Upgrade to 3.0.3 Job is waiting for execution

2009-11-19 Thread Giuseppe De Nicolo'
Giuseppe De Nicolo' wrote:
> Giuseppe De Nicolo' wrote:
>   
>> Alan Brown wrote:
>>     
>>> On Tue, 17 Nov 2009, Giuseppe De Nicolo' wrote:
>>>
>>>  
>>>   
>>>> Hi All,
>>>>
>>>> Since the upgrade to 3.0.3 our test server have this strange
>>>> behavior , the first job after bacula start up runs fine all others get
>>>> in line as "job is waiting execution" and nothing happens, restarting
>>>> bacula reset job lists and again only the first job run fine.
>>>> 
>>>> 
>>> Have your concurrency settings been reset? Remember it needs to be 
>>> checked
>>> in multiple places.
>>>
>>>   
>>>   
>> Hi and thank you for your answer, actually you where right , I had ma 
>> concurrent jobs se to 1 into director configuration file, though I had 
>> it also in 3.0.1 and it worked like a charm  thats why I 
>> overlooked the problem, has something changed since 3.0.1 ? and anyway 
>> even if I had a concurrency limit of 1 ( which I could like ) why are 
>> jobs then not firing up once the first one has completed ?
>>
>> Anyway I may consider my problem for such I thank you very much
>>
>> Sincerely
>>
>> 
> Well evidently I was wrong my problem is not solved, it just change 
> behavior, now subsequent jobs does not sit anymore in queue saying
>
> "job is waiting execution" but  instead they claim to be running which in 
> fact is not true, since backup devise is dismounted and nothing happens , 
> pratically the system is on hang till I reboot the bacula service  then 
> only  the firts job in line again does run others hangs the system and so on 
> ...
>
> Any clue ?? 
>
>   
Well in the end I solved this problem ... disintstalling bacula ... 
dropped the db  recompiled the 3.0.3 then reinstalled ... I know would 
have been better to debug but I had no time

Thank you for your support


--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Bacula plugin exchange 2003 backup

2009-11-19 Thread Giuseppe De Nicolo'
Hello all,

I m finally configuring my test configuration to run exchange 
backup, I configured my fd like this after reading this 
http://www.bacula.org/3.0.x-manuals/en/concepts/concepts/New_Features.html#SECTION00320
to my unbderstanding I have to backup the stores using the plugin and 
not the file selction  ( I would do like that also utilizing Windows 
backup ) I excluded VSS and db filesystem  backup.

FileSet {
   Name = "Earendil Set"
   Enable VSS = no
   Include {
 Options {
signature = MD5
compression = GZIP9
IgnoreCase = yes
}
Plugin = "exchange:/@EXCHANGE/Microsoft Information Store"
}
   Exclude {
  File = C:/Program Files/Exchsrvr/Archivio
  File = C:/Program Files/Exchsrvr/Dirigenza
  File = C:/Program Files/Exchsrvr/mdbdata
  File = C:/Program Files/Exchsrvr/Responsabili 
} 
}
At the moment the backup is undergoing 20 gb and running so I assume 
everything is ok ( at least on backup ), I would then try to do a 
restore on the Recovery group I know how to do this in windows but it is 
not really clear in my mind how to do that using bconsole is there some 
documentation describing these steps ?

Thank you all

--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Upgrade to 3.0.3 Job is waiting for execution

2009-12-14 Thread Giuseppe De Nicolo'
Bruno Friedmann wrote:
> On 11/17/2009 03:31 PM, Giuseppe De Nicolo' wrote:
>   
>> Giuseppe De Nicolo' wrote:
>> 
>>> Alan Brown wrote:
>>>   
>>>> On Tue, 17 Nov 2009, Giuseppe De Nicolo' wrote:
>>>>
>>>>  
>>>> 
>>>>> Hi All,
>>>>>
>>>>> Since the upgrade to 3.0.3 our test server have this strange
>>>>> behavior , the first job after bacula start up runs fine all others get
>>>>> in line as "job is waiting execution" and nothing happens, restarting
>>>>> bacula reset job lists and again only the first job run fine.
>>>>> 
>>>>>   
>>>> Have your concurrency settings been reset? Remember it needs to be 
>>>> checked
>>>> in multiple places.
>>>>
>>>>   
>>>> 
>>> Hi and thank you for your answer, actually you where right , I had ma 
>>> concurrent jobs se to 1 into director configuration file, though I had 
>>> it also in 3.0.1 and it worked like a charm  thats why I 
>>> overlooked the problem, has something changed since 3.0.1 ? and anyway 
>>> even if I had a concurrency limit of 1 ( which I could like ) why are 
>>> jobs then not firing up once the first one has completed ?
>>>
>>> Anyway I may consider my problem for such I thank you very much
>>>
>>> Sincerely
>>>
>>>   
>> Well evidently I was wrong my problem is not solved, it just change 
>> behavior, now subsequent jobs does not sit anymore in queue saying
>>
>> "job is waiting execution" but  instead they claim to be running which in 
>> fact is not true, since backup devise is dismounted and nothing happens , 
>> pratically the system is on hang till I reboot the bacula service  then 
>> only  the firts job in line again does run others hangs the system and so on 
>> ...
>>
>> Any clue ?? 
>>
>>
>> 
> Since yesterday, I've upgraded our working 2.4.4 version to a 3.0.3 build.
>
> I'm facing the same trouble. first job run smoothly, other are marked as 
> running
> but a status client / storage show that nothing is running on other daemons.
>
> How did you fix your case ?
>
>   
Hi,

well in my case I purged all my store deleted and recreated em  , 
disinstalled bacula ( saving all the config files ) then re-compiled it 
and reinstalled directly the 3.0.3 , wich of course can't be actually 
define a "solution" AND I could do this since I m still in testing phase 
I dunno if you can purge all your backup stores ...






--
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Exchange 2010 plugin backup failure

2010-03-12 Thread Giuseppe De Nicolo'




On 03/10/2010 05:27 PM, Angus Jordan wrote:

  Hi James,

  
  
Can you try making the registry changes documented in this link

http://forum.ultrabac.com/showthread.php?p=607
or
http://www.asigraforums.com/viewtopic.php?f=1&t=3347

  
  
I will give these a try tonight, but I'm fairly certain that these
only apply to Exchange 2007.

This client is running Exchange 2010 and, according to the Microsoft
links I put in my original post, Microsoft has removed this "legacy"
backup functionality from their 2010 product and replaced it with a
supposedly "more robust" backup system.

In any case, I will try the registry changes and let you know what
happens later this evening.

  

Hi, I m also interested since I recently migrated to Exchange 2010 ,
and was looking to move my bacula schedule to the new server thought
from :
http://msdn.microsoft.com/en-us/library/dd877010.aspx

 Backup and Restore
Technologies and Features Removed from Exchange 2010

The following Exchange 2007 technologies and features are no longer
available or supported in Exchange 2010: 

   Streaming database backup and restore.
  
   Storage Groups. Each Exchange store database is managed
separately in Exchange 2010.
  
   The Exchange Recovery Storage Group. This has been replaced by
the Exchange Recovery database.
  
   Single-Copy Clusters (SCC).
  
   Local Continuous Replication (LCR).

Really lots of change to take care of that was removed even from
Exchange 2007 I dubt that a registry hack will do it


--
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Lookup of symbol "BaculaSDdriver"

2021-10-21 Thread SO Giuseppe - COMAE via Bacula-users
Hello, fellowes 

I am using Bacula 11.0.5 on Debian 10. After installation, including 
bacula-aligned package, everything is running well! 
After procedures to install ZFS and implement Optimized Volumes ( [ 
https://www.bacula.lat/block-level-deduplication-with-aligned-volumes-tutorial-bacula-7-9-9-0-and-above/?lang=en
 | 
https://www.bacula.lat/block-level-deduplication-with-aligned-volumes-tutorial-bacula-7-9-9-0-and-above/?lang=en
 ] ) an error rises when I start a job: 
bacula-sd JobId 384: Error: [SE0003] Lookup of symbol "BaculaSDdriver" in 
driver FileStorage for device 
/opt/bacula/plugins/bacula-sd-aligned-driver-11.0.5.so failed: 
ERR=/opt/bacula/plugins/bacula-sd-aligned-driver-11.0.5.so: undefined symbol: 
BaculaSDdriver
bacula-sd JobId 384: Warning: 
 Device "FileStorage" requested by DIR could not be opened or does not 
exist. 

Please, see attached the setup files. I still using Bacula for tests and it is 
not in production yet. 

I would like some help to solve this issue. I don't know if it is possible to 
use ZFS drive as a "Device Type = File" or I must to setup as "Device Type = 
Aligned" (look into bacula-sd.conf). 

Best regards. 

GIUSEPPE VALITUTTI NETTO 
Brasília/DF - Brasil 


--

[PT] Texto confidencial para uso exclusivo do destinat�rio. N�o o divulgue e 
apague-o imediatamente se o recebeu por engano.

[EN] This is a confidential text to be exclusively used by the recipient. Do 
not disclose it to anybody and delete it immediately if you received it by 
mistake.

[ES] Texto confidencial para uso exclusivo del destinatario. Si usted lo 
recibi� por error no lo divulgue y excl�yalo inmediatamente.




bacula-fd.conf
Description: Binary data


bacula-sd.conf
Description: Binary data


bconsole.conf
Description: Binary data


bacula-dir.conf
Description: Binary data
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] query.sql

2022-05-25 Thread SO Giuseppe - COMAE via Bacula-users
Hi 

I rewrote a sql command from the /opt/bacula/scripts/query.sql: 

# 11 
:List total files/bytes by Volume 
SELECT count(*) AS Jobs,sum(JobFiles) AS Files,sum(JobBytes) AS 
Bytes,VolumeName 
FROM Job,JobMedia,Media 
WHERE JobMedia.JobId=Job.JobId 
AND JobMedia.MediaId=Media.MediaId 
GROUP by VolumeName; 

Which was miscalculating the values of each column 

This is the version that works: 
# 11 
:List total files/bytes by Volume 
SELECT count(*) AS Jobs,sum(JobFiles) AS Files,sum(JobBytes) AS 
Bytes,VolumeName 
FROM (SELECT DISTINCT Jobmedia.JobId, JobFiles, JobBytes, VolumeName 
FROM Job,JobMedia,Media 
WHERE JobMedia.JobId=Job.JobId 
AND JobMedia.MediaId=Media.MediaId) AS f 
GROUP BY VolumeName 
ORDER BY VolumeName; 

I would like someone to test the code. 
I don't know how to send it to the people who maintain the query.sql file. 

Giuseppe 

--
[PT] Texto confidencial para uso exclusivo do destinat�rio. N�o o divulgue e 
apague-o imediatamente se o recebeu por engano.
[EN] This is a confidential text to be exclusively used by the recipient. Do 
not disclose it to anybody and delete it immediately if you received it by 
mistake.
[ES] Texto confidencial para uso exclusivo del destinatario. Si usted lo 
recibi� por error no lo divulgue y excl�yalo inmediatamente.___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users