On Sunday 23 July 2006 16:22, Bill Moran wrote:
> 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?
Possibly, but normally Bacula ensures that it is unique by locking the
database. Having unique constraints is one of the portability nightmares of
SQL from what I remember. There was no universal way to determine what is
going on and required digging into the details of returned error codes. That
is something that I would like to avoid.
A more important question is why it was segment faulting because of this
condition. It should have simply reported an error and continued.
>
> > 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,Recy
> > >cle,
> > > 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,'Dai
> > >ly-' ) 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,Recy
> > >cle,
> > > 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,'Dai
> > >ly-' ) 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=DEVD
> > >EV _______________________________________________
> > > Bacula-users mailing list
> > > Bacula-users@lists.sourceforge.net
> > > https://lists.sourceforge.net/lists/listinfo/bacula-users
-------------------------------------------------------------------------
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
