Kern Sibbald <[EMAIL PROTECTED]> wrote:
> Most likely you upgraded you SQL engine but did not rebuild Bacula against
> the
> new client libraries.
Wow ... takes quite a while to pg_dump a 800M database.
Anyway ... digging a bit deeper, the problem was that there were two
records in the pool table with a name of CFOnDisk. Each had a unique
poolid, however.
I did a "select distinct poolid from media" and found that only one of
the poolids was being used, and deleted the other record from the pool
table. Everything is working fine now.
Shouldn't there be a unique constraint on the name column of the pool
table?
> On Saturday 22 July 2006 16:55, Bill Moran wrote:
> > Do these errors ring a bell with anyone. I've been having trouble with
> > this catalog database off and on for a few weeks now, but this is the
> > first tangible error I've seen. (Until now, the dir has froze up or
> > exited mysteriously or exhibited other mysterious behavior)
> >
> > 22-Jul 00:00 mindwipe-dir: sql_create.c:196 INSERT INTO Pool
> > (Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,
> >VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,Labe
> >lType,LabelFormat) VALUES
> > ('CFOnDisk',0,0,0,1,1,1,1,604800,82800,0,0,100000000000,'Backup',0,'Daily-'
> >) 22-Jul 00:00 mindwipe-dir: Fatal Error because: Bacula interrupted by
> > signal 11: Segmentation violation 22-Jul 00:00 mindwipe-dir:
> > sql_create.c:196 INSERT INTO Pool
> > (Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,
> >VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,Labe
> >lType,LabelFormat) VALUES
> > ('CFOnDisk',0,0,0,1,1,1,1,604800,82800,0,0,100000000000,'Backup',0,'Daily-'
> >) 22-Jul 00:00 mindwipe-dir: Fatal Error because: Bacula interrupted by
> > signal 11: Segmentation violation 22-Jul 10:42 mindwipe-dir:
> > *Console*.2006-07-22_10.41.57 Error: sql_get.c:560 More than one Pool!: 2
> > 22-Jul 10:42 mindwipe-dir: *Console*.2006-07-22_10.41.57 Error:
> > sql_get.c:560 More than one Pool!: 2 22-Jul 10:42 mindwipe-dir:
> > *Console*.2006-07-22_10.41.57 Fatal error: Pool CFOnDisk not in database.
> > sql_create.c:171 pool record CFOnDisk already exists
> >
> > The last three repeat over and over.
> >
> > I ran dbcheck with the fix option, but the problem persists. Any
> > suggestions as to what could be wrong?
> >
> > -------------------------------------------------------------------------
> > Take Surveys. Earn Cash. Influence the Future of IT
> > Join SourceForge.net's Techsay panel and you'll get the chance to share
> > your opinions on IT & business topics through brief surveys -- and earn
> > cash
> > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> > _______________________________________________
> > Bacula-users mailing list
> > Bacula-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Bill Moran
I lay down for a while, and I woke up on the ocean,
floating on my back, and staring at the grey.
It was completely still, 'cept for the pounding of my heart,
was bring me back to life, from three strange days.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
