On 1/17/08, Tom Lane <[EMAIL PROTECTED]> wrote:
> Do you still have the hung processes available? It would be really
> useful to take a look at the buffer header that the autovac process's
> LockBufferForCleanup() is working on. (In gdb, "f 3" then "p *bufHdr")
Well I just lost the hung processes a few minutes ago thanks to a
cleanup process... but I do still have cores from yesterday:
(gdb) p *bufHdr
$1 = {tag = {rnode = {spcNode = 1663, dbNode = 16384, relNode = 85707},
blockNum = 0}, flags = 70, usage_count = 5, refcount = 2,
wait_backend_pid = 35775, buf_hdr_lock = 0 '\0', buf_id = 14407,
freeNext = -2, io_in_progress_lock = 28933, content_lock = 28934}
Let me know what other info I can provide.
Steve
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
