[Bacula-users] Volume labeling SQL error: sql

I have recently redesigned my pools and jobs. The Label Format = 
directive now includes the job name and current date/time.

Ever since I did that, bacula reports the following error message up to 
a dozen times or so before it finally succeeds. This only happens for 
some jobs, not for all of them.

23-Feb 19:44 nctechcenter-dir JobId 1519: Error: sql_create.c:400 Volume 
"scalix-fd_scalix_20090223194421_Differential.bacula" already exists.
23-Feb 19:44 nctechcenter-dir JobId 1519: Error: sql_create.c:400 Volume 
"scalix-fd_scalix_20090223194421_Differential.bacula" already exists.
23-Feb 19:44 nctechcenter-dir JobId 1519: Error: sql_create.c:400 Volume 
"scalix-fd_scalix_20090223194421_Differential.bacula" already exists.
23-Feb 19:44 nctechcenter-dir JobId 1519: Created new Volume 
"scalix-fd_scalix_20090223194451_Differential.bacula" in catalog.
23-Feb 19:44 nctechcenter-dir JobId 1519: Error: sql_create.c:400 Volume 
"scalix-fd_scalix_20090223194451_Differential.bacula" already exists.
23-Feb 19:44 nctechcenter-dir JobId 1519: Error: sql_create.c:400 Volume 
"scalix-fd_scalix_20090223194451_Differential.bacula" already exists.
23-Feb 19:44 nctechcenter-dir JobId 1519: Error: sql_create.c:400 Volume 
"scalix-fd_scalix_20090223194451_Differential.bacula" already exists.
23-Feb 19:45 nctechcenter-dir JobId 1519: Created new Volume 
"scalix-fd_scalix_20090223194521_Differential.bacula" in catalog.

When I list volumes, I see that all the volumes listed in the error 
message have indeed been created.

What might cause that?


Here are the corresponding resource entries for pool, job, schedule and 
storage. Please note that there are several storage resources (one per 
client) that all reference the same two devices on the same SD. I am 
doing that to allow multiple concurrent backups into different volumes.


Pool {
  Name = Diff-Pool
  Pool Type = Backup
  Maximum Volume Jobs = 1
  Recycle = no
  Auto Prune = no
  Volume Retention = 35 days
  Label Format = "${Client}_${Job:s/ 
/_/g}_${Year}${Month:p/2/0/r}${Day:p/2/0/r}${Hour:p/2/0/r}${Minute:p/2/0/r}${Second:p/2/0/r}_${Level}.bacula"
# Label Format = "${Pool}_${NumVols}.bacula"
}

Job {
  Name = "scalix"
  Client = scalix-fd
  Schedule = Schedule-scalix
  JobDefs = "Linux Default Job"
  Run Before Job = "/usr/local/sbin/nagiosscheduledowntime scalix"
  Full Backup Pool = Full-Pool
  Differential Backup Pool = Diff-Pool
  Incremental Backup Pool = Inc-Pool
  Storage = Disk2
}

Schedule {
  Name = Schedule-scalix
  Run = Level=Full Storage=Disk3-scalix on 1 at 19:05
  Run = Level=Incremental Storage=Disk3-scalix on 2 at 19:05
  Run = Level=Incremental Storage=Disk3-scalix on 3 at 19:05
  Run = Level=Incremental Storage=Disk3-scalix on 4 at 19:05
  Run = Level=Incremental Storage=Disk3-scalix on 5 at 19:05
  Run = Level=Incremental Storage=Disk3-scalix on 6 at 19:05
  Run = Level=Incremental Storage=Disk3-scalix on 7 at 19:05
  Run = Level=Differential Storage=Disk3-scalix on 8 at 19:05
  Run = Level=Incremental Storage=Disk3-scalix on 9 at 19:05
  Run = Level=Incremental Storage=Disk3-scalix on 10 at 19:05
  Run = Level=Incremental Storage=Disk3-scalix on 11 at 19:05
  Run = Level=Incremental Storage=Disk3-scalix on 12 at 19:05
  Run = Level=Incremental Storage=Disk3-scalix on 13 at 19:05
  Run = Level=Incremental Storage=Disk3-scalix on 14 at 19:05
  Run = Level=Incremental Storage=Disk3-scalix on 15 at 19:05
  Run = Level=Full Storage=Disk2-scalix on 16 at 19:05
  Run = Level=Incremental Storage=Disk2-scalix on 17 at 19:05
  Run = Level=Incremental Storage=Disk2-scalix on 18 at 19:05
  Run = Level=Incremental Storage=Disk2-scalix on 19 at 19:05
  Run = Level=Incremental Storage=Disk2-scalix on 20 at 19:05
  Run = Level=Incremental Storage=Disk2-scalix on 21 at 19:05
  Run = Level=Incremental Storage=Disk2-scalix on 22 at 19:05
  Run = Level=Differential Storage=Disk2-scalix on 23 at 19:05
  Run = Level=Incremental Storage=Disk2-scalix on 24 at 19:05
  Run = Level=Incremental Storage=Disk2-scalix on 25 at 19:05
  Run = Level=Incremental Storage=Disk2-scalix on 26 at 19:05
  Run = Level=Incremental Storage=Disk2-scalix on 27 at 19:05
  Run = Level=Incremental Storage=Disk2-scalix on 28 at 19:05
  Run = Level=Incremental Storage=Disk2-scalix on 29 at 19:05
  Run = Level=Incremental Storage=Disk2-scalix on 30 at 19:05
  Run = Level=Incremental Storage=Disk2-scalix on 31 at 19:05
}

Storage {
  Name = Disk2-scalix
  Address = bacula.int.nctechcenter.com
  SDPort = 9103
  Password = "xxxx"
  Device = USBDisk2
  Media Type = File
  Maximum Concurrent Jobs = 1
}
Storage {
  Name = Disk3-scalix
  Address = bacula.int.nctechcenter.com
  SDPort = 9103
  Password = "xxxx"
  Device = eSATADisk3
  Media Type = File
  Maximum Concurrent Jobs = 1
}



-- 
Kevin Keane
Owner
The NetTech
Find the Uncommon: Expert Solutions for a Network You Never Have to Think About

Office: 866-642-7116
http://www.4nettech.com

This e-mail and attachments, if any, may contain confidential and/or 
proprietary information. Please be advised that the unauthorized use or 
disclosure of the information is strictly prohibited. The information herein is 
intended only for use by the intended recipient(s) named above. If you have 
received this transmission in error, please notify the sender immediately and 
permanently delete the e-mail and any copies, printouts or attachments thereof.


------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Volume labeling SQL error: sql_create.c "Volume already exists"
