Bacula-users

Re: [Bacula-users] Error: sql_create.c:387 Volume x already exists

2017-03-04 18:00:11
Subject: Re: [Bacula-users] Error: sql_create.c:387 Volume x already exists
From: Matteo Cerutti <matteo.cerutti AT hotmail.co DOT uk>
To: Heitor Faria <heitor AT bacula.com DOT br>
Date: Sat, 4 Mar 2017 22:44:57 +0000

Hi Heitor,


thanks for you reply.


I have not set any maximum size over the volumes, so the first problem should not occur. What is a multi-volume backup? Right now, the way I've set it up is to create a new volume for every executed job.


  Maximum Volume Jobs = 1
  LabelFormat = "${Client}-${Pool}-${Year}${Month:p/2/0/r}${Day:p/2/0/r}-${Hour:p/2/0/r}${Minute:p/2/0/r}-${JobId}-${NumVols}"

I have removed the 'Use volume once' and added the NumVols as you suggested. Let's see how this goes.


Updated gists:


https://gist.github.com/m4ce/4d4b296bb2964a9be8ff4ddae210bd00#file-bacula-dir-pools

https://gist.github.com/m4ce/4d4b296bb2964a9be8ff4ddae210bd00#file-llist-pools


Thanks,

Matteo



From: heitorfaria AT gmail DOT com <heitorfaria AT gmail DOT com> on behalf of Heitor Faria <heitor AT bacula.com DOT br>
Sent: 04 March 2017 21:54
To: Matteo Cerutti
Cc: bacula-users AT lists.sourceforge DOT net
Subject: Re: [Bacula-users] Error: sql_create.c:387 Volume x already exists
 

I am experiencing the following error quite frequently now:

03-Mar 19:57 bacula-dir JobId 88: Error: sql_create.c:387 Volume "fw01-Inc-20170303-1957-88" already exists.

Hello, Matteo: is it possible your disk volumes are becoming Full within 1 minute, and them Bacula tries to create again a volume with a non-unique name? This may happen if your disk is full or if it is a multi-volume backup.
Even using JobID variable it's not guaranteed you will have unique LabelFormat naming generation. I would add (v.g.) NumVols variable.
Also, there is no need to you "Maximum Volume Jobs = 1" and "Use Volume _Once_ = yes" both.  And the first one is better.

Regards,
--
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users