Maybe you have a bad configuraion in bacula-dir.conf file.
In the table pool in bacula Postgres Database exists this contrainst:
CONSTRAINT pool_pooltype CHECK (pooltype = 'Backup'::text OR pooltype =
'Copy'::text OR pooltype = 'Cloned'::text OR pooltype = 'Archive'::text
OR pooltype = 'Migration'::text OR pooltype = 'Scratch'::text)
It seems is trying to insert a "Restore" Pool type and it isn't allowed,
look at the constraint.
Greetings,
Andrés Fernando Yacopino
El 01/06/10 15:54, Holger Rauch escribió:
> Hi,
>
> I'm using Bacula 5.0.2 in conjunction with a PostgreSQL 8.4.3 database
> (both compiled from official sources) on a Debian Lenny system.
>
> A HP StorageWorks 1/8 G2 autoloader equipped with an HP Ultrium 920
> drive is connected to the system.
>
> Whenever a tape is moved to a new pool (e.g. a newly labeled tape
> automatically taken out of the Scratch pool), I get this error message:
>
> ===
>
> 01-Jun 20:42 nathan-dir JobId 0: Fatal error: sql_create.c:211
> sql_create.c:211 insert INSERT INTO Pool
> (Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,Labe
> lFormat,RecyclePoolId,ScratchPoolId,ActionOnPurge)
> VALUES
> ('RestorePool',0,0,0,1,0,1,1,604800,0,0,0,0,'Restore',0,'*',0,0,0)
> failed:
> ERROR: new row for relation "pool" violates check constraint
> "pool_pooltype_check"
>
> ===
>
> (Seems like the same data is inserted twice). What can I do about that?
>
> Any help is greatly appreciated!
>
> Thanks & kind regards,
>
> Holger
>
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
