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