Re: failed to fetch tuple for EvalPlanQual recheck

Excerpts from Kenichiro Tanaka's message of dom jul 25 21:01:01 -0400 2010:

> This is a bug report.
> When I tested in PostgreSQL9 beta3,I got an error.
>
> ==================================================
> select * from part_bug where HIRENUM=4 for update;
> failed to fetch tuple for EvalPlanQual recheck
> ==================================================
>
> Is this error assumed?

Hmm, I don't see just an error message here, but an assertion failure:

TRAP: FailedAssertion(«!(((bool) (((void*)(tid) != ((void *)0)) && ((tid)->ip_posid != 0))))», Archivo:
«/pgsql/source/990_rel/src/backend/access/heap/heapam.c»,Línea: 1400) 

This is the backtrace:

#2  0x00000000006f6e0d in ExceptionalCondition (
    conditionName=<value optimized out>, errorType=<value optimized out>,
    fileName=<value optimized out>, lineNumber=<value optimized out>)
    at /pgsql/source/990_rel/src/backend/utils/error/assert.c:57
#3  0x00000000004773cc in heap_fetch (relation=0x7f8fafc62c80,
    snapshot=<value optimized out>, tuple=0x7fffdda09950,
    userbuf=<value optimized out>, keep_buf=0 '\000',
    stats_relation=0x7f8fafcd95ec)
    at /pgsql/source/990_rel/src/backend/access/heap/heapam.c:1400
#4  0x000000000058a936 in ExecLockRows (node=0x27a4800)
    at /pgsql/source/990_rel/src/backend/executor/nodeLockRows.c:203
#5  0x0000000000576968 in ExecProcNode (node=0x27a4800)
    at /pgsql/source/990_rel/src/backend/executor/execProcnode.c:466
#6  0x000000000057569e in ExecutePlan (queryDesc=0x274f608, direction=946,
    count=0) at /pgsql/source/990_rel/src/backend/executor/execMain.c:1190