Re: database vacuum from cron hanging
| От | Tom Lane |
|---|---|
| Тема | Re: database vacuum from cron hanging |
| Дата | |
| Msg-id | 24858.1129073246@sss.pgh.pa.us обсуждение |
| Ответ на | database vacuum from cron hanging ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>) |
| Ответы |
Re: database vacuum from cron hanging
Re: database vacuum from cron hanging |
| Список | 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 по дате отправления: