Re: pg_autovacuum w/ dbt2

On Tue, Dec 21, 2004 at 05:56:47PM -0500, Tom Lane wrote:
> If you want to track it yourself, please change those elog(ERROR)s to
> elog(PANIC) so that they'll generate core dumps, then build with
> --enable-debug if you didn't already (--enable-cassert would be good too)
> and get a debugger stack trace from the core dump.

Ok, well I got a core dump with 8.0rc4, but I'm not sure if it's
exactly the same problem.  I have the postgres binary and the core
here:http://developer.osdl.org/markw/pgsql/core/2files.tar.bz2

But it's for ia64, if you got one.  Otherwise, this is what gdb is
telling me with a bt:

(gdb) bt
#0  FunctionCall2 (flinfo=0x6000000000187850, arg1=16, arg2=1043)   at fmgr.c:1141
#1  0x400000000007a320 in _bt_checkkeys (scan=0x60000000000c2d80,    tuple=0x200000000101f660,
dir=ForwardScanDirection,   continuescan=0x60000fffffff8ae0 "\001") at nbtutils.c:542
 
#2  0x4000000000078eb0 in _bt_endpoint (scan=0x6000000000187690,    dir=ForwardScanDirection) at nbtsearch.c:1309
#3  0x40000000000771e0 in _bt_first (scan=0x6000000000187690,    dir=ForwardScanDirection) at nbtsearch.c:482
#4  0x4000000000074350 in btgettuple (fcinfo=0x1) at nbtree.c:265
#5  0x40000000003bd430 in FunctionCall2 (flinfo=0x6000000000187700,    arg1=6917529027642685072, arg2=1) at
fmgr.c:1141
#6  0x400000000006b3a0 in index_getnext (scan=0x6000000000187690,    direction=ForwardScanDirection) at indexam.c:429
#7  0x400000000006a1e0 in systable_getnext (sysscan=0x6000000000187668)   at genam.c:253
#8  0x400000000039c970 in SearchCatCache (cache=0x200000001f1e0140, v1=0,    v2=6917529027641871376, v3=4294966252,
v4=6917546619827097184)  at catcache.c:1217
 
#9  0x40000000003a9ee0 in SearchSysCache (cacheId=33, key1=1043, key2=0,    key3=0, key4=0) at syscache.c:524
#10 0x4000000000049110 in TupleDescInitEntry (desc=0x60000000001872c8,    attributeNumber=4,
attributeName=0x6000000000187614"\023\004",    oidtypeid=1043, typmod=28, attdim=0) at tupdesc.c:444
 
#11 0x40000000001b5fc0 in ExecTypeFromTLInternal (   targetList=0x6000000000135d40, hasoid=-64 'À', skipjunk=1 '\001')
at execTuples.c:570
 
#12 0x40000000001a4a20 in ExecInitJunkFilter (targetList=0x6000000000135b38,    hasoid=-64 'À',
slot=0x60000000001258a0)at execJunk.c:76
 
#13 0x40000000001a6890 in InitPlan (queryDesc=0x6000000000177ed0,    explainOnly=0 '\0') at execMain.c:456
#14 0x40000000001a5800 in ExecutorStart (queryDesc=0x6000000000177ed0,    explainOnly=0 '\0') at execMain.c:160
#15 0x40000000001d6ab0 in _SPI_pquery (queryDesc=0x6000000000177ed0, tcount=0)   at spi.c:1521
#16 0x40000000001d6390 in _SPI_execute_plan (plan=0x60000fffffff9380,    Values=0x0, Nulls=0x0, snapshot=0x0,
crosscheck_snapshot=0x0,   read_only=0 '\0', tcount=0) at spi.c:1452