Re: PANIC: heap_update_redo: no block

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PANIC: heap_update_redo: no block
Date: 2006-03-21 17:07:48
Message-ID: 17851.1142960868@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

"Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu> writes:
> Can you patch the heap/heapam.c/heap_xlog_update() like this:

> - elog(PANIC, "heap_update_redo: no block");
> + elog(PANIC, "heap_update_redo: no block: target block: %u, relation
> length: %u",
> + ItemPointerGetBlockNumber(&(xlrec->target.tid)),
> + RelationGetNumberOfBlocks(reln));

> And restart your database to see what's the output?

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 ...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pailloncy Jean-Gerard 2006-03-21 17:15:29 Re: [GENERAL] A real currency type
Previous Message Thomas F. O'Connell 2006-03-21 16:47:35 Troubling On-line Backup LOG messages

Browse pgsql-hackers by date

  From Date Subject
Next Message Pailloncy Jean-Gerard 2006-03-21 17:15:29 Re: [GENERAL] A real currency type
Previous Message Tom Lane 2006-03-21 16:29:56 Re: Problems with CREATE AGGREGATE and user defined state type.