Bacula-users

[Bacula-users] Bacula 5.0.2 & PostgreSQL 8.4.3: ERROR: new row for relation "pool" violates check constraint

2010-06-01 14:57:50
Subject: [Bacula-users] Bacula 5.0.2 & PostgreSQL 8.4.3: ERROR: new row for relation "pool" violates check constraint
From: Holger Rauch <holger.rauch AT empic DOT de>
To: bacula-users AT lists.sf DOT net
Date: Tue, 1 Jun 2010 20:54:42 +0200
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
    

Attachment: signature.asc
Description: Digital signature

------------------------------------------------------------------------------

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
<Prev in Thread] Current Thread [Next in Thread>