> > > ...next, do you actually get a core file that you can analyze
> > > using gdb? If so, what do the results show?
> >
> > I get a core file, but it doesn't tell me squat,
>
> It can generally tell you alot...do you have gdb on your system?
> have you compiled with -g (debugging symbols) compiled in? Using gdb and
> the core file, you should be able to get pretty close to the exact line
> (and values) where the error is occuring...combine that with 'script', and
> you can pretty much give us a screen capture of what you are doing...
>
> > I've actually zeroed in on the problem. It lies somewhere in the
> > SearchSysCache routine. I'm attempting to debug it now... So far, what I
> > get is: (Note "[KTH]" is a debug message added by yours truly)
> >
> > --- SearchSysCache starts here ---
> > SearchSysCache: [KTH] Hash: 433
> > SearchSysCache: [KTH] Tuple not found in cache, attempting to find.
> > SearchSysCache: [KTH] RelationGetRelationName (pg_proc)
> > SearchSysCache: performing scan (override==0)
> > SearchSysCache: [KTH] IsBootstrapProcessingMode() is true
> > SearchSysCache: [KTH] relation check skipped.
> > SearchSysCache: [KTH] heap_beginscan is okay.
> > heap_getnext([pg_proc,nkeys=3],backw=0,0x1ffff040) called
> > heap_getnext returning EOS
> > SearchSysCache: [KTH] heap_getnext returns null
> > SearchSysCache: [KTH] tuple not found.
> > SearchSysCache: [KTH] Heap scan ends.
> > SearchSysCache: Heap tuple (ntp) is invalid.
> > ERROR: BuildFuncTupleDesc: function mkoidname(opaque, opaque) does not exist
> > ERROR: BuildFuncTupleDesc: function mkoidname(opaque, opaque) does not exist
> > --- End of debug ---
> >
> > Looks like it lies somewhere in heap_getnext. Heap_getnext is a HUMONGOUS
> > command, and I'm not about to spend another 2 hours debugging that. ;)
> >
> > Anyone have any suggestions of a patch for this?
>
> Bruce...I just checked backend/catalog/index.c, where
> BuildFuncTupleDesc() exists, and there is no error message that matches
> his above ERROR...
I think it is at:
backend/catalog/index.c:298: func_error("BuildFuncTupleDesc",
funcname, nargs, argtypes);
The function he is having trouble with is one that gets created by
initdb for use in an index. Must be failing there somehow, but without
initdb completing, you can't easily debug to see what is in the pg_proc
table.
--
Bruce Momjian
maillist@candle.pha.pa.us
