Re: buffer assertion tripping under repeat pgbench load

Поиск
Список
Период
Сортировка
Искать
От
Greg Stark
Тема
Re: buffer assertion tripping under repeat pgbench load
Дата
Msg-id
CAM-w4HNpog0YA+Mm4QeES9JhbK+3GSZfyhHhJtS_C-A66B=Xow@mail.gmail.com
Ответ на
Список
Дерево обсуждения
buffer assertion tripping under repeat pgbench load Greg Smith <greg@2ndQuadrant.com>
Re: buffer assertion tripping under repeat pgbench load Andres Freund <andres@2ndquadrant.com>
Re: buffer assertion tripping under repeat pgbench load Tom Lane <tgl@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 Simon Riggs <simon@2ndQuadrant.com>
Re: buffer assertion tripping under repeat pgbench load Greg Smith <greg@2ndQuadrant.com>
Re: buffer assertion tripping under repeat pgbench load Simon Riggs <simon@2ndQuadrant.com>
Re: buffer assertion tripping under repeat pgbench load Greg Smith <greg@2ndQuadrant.com>
Re: buffer assertion tripping under repeat pgbench load Tom Lane <tgl@sss.pgh.pa.us>
Re: buffer assertion tripping under repeat pgbench load Simon Riggs <simon@2ndQuadrant.com>
Re: buffer assertion tripping under repeat pgbench load Simon Riggs <simon@2ndQuadrant.com>
Re: buffer assertion tripping under repeat pgbench load Greg Smith <greg@2ndQuadrant.com>
Re: buffer assertion tripping under repeat pgbench load Tom Lane <tgl@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 Tom Lane <tgl@sss.pgh.pa.us>
Re: buffer assertion tripping under repeat pgbench load "anarazel@anarazel.de" <andres@anarazel.de>
Re: buffer assertion tripping under repeat pgbench load Greg Smith <greg@2ndQuadrant.com>
Re: buffer assertion tripping under repeat pgbench load Greg Stark <stark@mit.edu>
Re: buffer assertion tripping under repeat pgbench load Greg Smith <greg@2ndQuadrant.com>
Re: buffer assertion tripping under repeat pgbench load Greg Stark <stark@mit.edu>
Re: buffer assertion tripping under repeat pgbench load Tom Lane <tgl@sss.pgh.pa.us>
Re: buffer assertion tripping under repeat pgbench load Greg Stark <stark@mit.edu>
Re: buffer assertion tripping under repeat pgbench load Tom Lane <tgl@sss.pgh.pa.us>
Re: buffer assertion tripping under repeat pgbench load Robert Haas <robertmhaas@gmail.com>
Re: buffer assertion tripping under repeat pgbench load Greg Smith <greg@2ndQuadrant.com>
Re: buffer assertion tripping under repeat pgbench load Robert Haas <robertmhaas@gmail.com>
Re: buffer assertion tripping under repeat pgbench load Peter Geoghegan <peter@2ndquadrant.com>
Re: buffer assertion tripping under repeat pgbench load Greg Stark <stark@mit.edu>
Re: buffer assertion tripping under repeat pgbench load Greg Smith <greg@2ndQuadrant.com>
Re: buffer assertion tripping under repeat pgbench load Bruce Momjian <bruce@momjian.us>
Re: buffer assertion tripping under repeat pgbench load Satoshi Nagayasu <snaga@uptime.jp>
Re: buffer assertion tripping under repeat pgbench load Greg Smith <greg@2ndQuadrant.com>
Re: buffer assertion tripping under repeat pgbench load Tom Lane <tgl@sss.pgh.pa.us>
Re: buffer assertion tripping under repeat pgbench load Greg Stark <stark@mit.edu>
Re: buffer assertion tripping under repeat pgbench load Greg Smith <greg@2ndQuadrant.com>
Re: buffer assertion tripping under repeat pgbench load Simon Riggs <simon@2ndQuadrant.com>
Re: buffer assertion tripping under repeat pgbench load Greg Smith <greg@2ndQuadrant.com>
On Wed, Dec 26, 2012 at 6:33 PM, Tom Lane  wrote:
> Yeah, that destroys my theory that there's something broken about index
> management specifically.  Now we're looking for something that can
> affect any buffer's refcount, which more than likely means it has
> nothing to do with the buffer's contents ...

Hardware problem is still a plausible candidate. Have you run any
memory checker software or seen anything else crash? Classically gcc
is as good at detecting memory problems as memory checking software.
Or a bad cpu can also sometimes cause problems like this.  Have you
been able to reproduce on any other machines?

Did you ever say what kind of hardware it was? This is the local
reference count so I can't see how it could be a race condition or
anything like that but it sure smells a bit like one.

-- 
greg


В списке pgsql-hackers по дате отправления
От: Andrew Dunstan
Дата:
Сообщение: json api WIP patch
От: Greg Stark
Дата:
FAQ