Re: database vacuum from cron hanging - Mailing list pgsql-hackers

From Tom Lane
Subject Re: database vacuum from cron hanging
Date
Msg-id 24858.1129073246@sss.pgh.pa.us
Whole thread Raw
In response to database vacuum from cron hanging  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: database vacuum from cron hanging
Re: database vacuum from cron hanging
List pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> (gdb) p BufferDescriptors[781]
> $1 = {tag = {rnode = {spcNode = 1663, dbNode = 16385, relNode = 2666}, blockNum = 1}, flags = 70, usage_count = 5,
refcount= 4294967294,
 
>   wait_backend_pid = 748, buf_hdr_lock = 0 '\0', buf_id = 781, freeNext = -2, io_in_progress_lock = 1615,
content_lock= 1616}
 

Whoa.  refcount -2?

Well, now we have an idea what to look for anyway ... and the relNode
says this is pg_constraint_contypid_index.  Again.  There's got to be
some broken code affecting that index in particular ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: database vacuum from cron hanging
Next
From: "Marc G. Fournier"
Date:
Subject: Beta3 Bundled