Re: buffer assertion tripping under repeat pgbench load

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: buffer assertion tripping under repeat pgbench load
Дата
Msg-id 6442.1356368204@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: buffer assertion tripping under repeat pgbench load  (Greg Smith <greg@2ndQuadrant.com>)
Ответы Re: buffer assertion tripping under repeat pgbench load  (Greg Smith <greg@2ndQuadrant.com>)
Список pgsql-hackers
Greg Smith <greg@2ndQuadrant.com> writes:
> I kicked off another test that includes the block number just before Tom 
> suggested it, so I should have the block by tomorrow at the latest.  The 
> range of runtime before crash is 3 to 14 hours so far.

Cool.  Once you get the crash, please also capture the contents of the
index's metapage --- pg_filedump or contrib/pageinspect's bt_metap()
should do.  If the problem page isn't the metapage itself, we'll need
that info to tell if it's the root.

Actually, it might be interesting to capture the content of the problem
page itself, too, if it isn't the metapage.  "pg_filedump -i -F" or
contrib/pageinspect's bt_page_stats() + bt_page_items() should show
anything useful.
        regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: buffer assertion tripping under repeat pgbench load
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap [Review]