Re: Postgresql 9.0.13 core dump

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Postgresql 9.0.13 core dump
Дата
Msg-id 1381796947.23050.YahooMailNeo@web162905.mail.bf1.yahoo.com
обсуждение исходный текст
Ответ на Re: Postgresql 9.0.13 core dump  (Laurentius Purba <lpurba@sproutloud.com>)
Ответы Re: Postgresql 9.0.13 core dump  (Laurentius Purba <lpurba@sproutloud.com>)
Список pgsql-general
Laurentius Purba <lpurba@sproutloud.com> wrote:

> I did google this error message, "...signal 10: Bus error.." and
> found the issue with hardware problem, memory.
>
> Do you have any other pointers or clues that I can look into?

Well, the very first thing I would do is to make sure that the OS
and jail software was up-to-date, in case it is a bug which has
been fixed.  I might take a look at BIOS and firmware levels, too.
Tomas makes a good point about the XML library tending to be
problematic, so I would make sure that was current.

If I still had the problem after that, I would try to distil it
down to the smallest reproducible test case, and see whether it ran
OK outside the jail.

Another approach would be to run hardware tests, although that
tends to require a longer maintenance window than the other things.

Basically, there are a lot of layers the problem could be in, and
not a lot of reason to suspect any particular layer, so you need to
start ruling things out.  In a situation like that I tend to start
with the fastest, easiest layers to check first.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: what is BIND in OS log for Postgresql
Следующее
От: "Huang, Suya"
Дата:
Сообщение: Re: werid error"index row size 3040 exceeds btree maximum, 2712" occur randomly