Re: PANIC: heap_update_redo: no block

On 3/21/06, Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu> wrote:
>
> "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote
> >
> > While at it, you should extend the error message to include the relation
> > ID, so you have some idea which table is affected ... this is certainly
> > not a very informative message ...
> >
>
> Exactly. Please use the following version:
>
> - elog(PANIC, "heap_update_redo: no block");
> + elog(PANIC, "heap_update_redo: no block: target blcknum: %u,
> relation(%u/%u/%u) length: %u",
> + ItemPointerGetBlockNumber(&(xlrec->target.tid)),
> + reln->rd_node.spcNode,
> + reln->rd_node.dbNode,
> + reln->rd_node.relNode,
> + RelationGetNumberOfBlocks(reln));
>
> BTW: I just realized that there is another (better) way to do so is to
> enable WAL_DEBUG in xlog.h and SET XLOG_DEBUG=true. And that's why we don't
> have much error message in xlog redo.
>

Hrm ok ill see about doing either the patch or setting wal_debug to
true (or both). However im currently on vacation till Saturday so ill
do this first thing then and report the results back. Thank you very
much!

> Regards,
> Qingqing
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>