Re: Postgresql 9.0.13 core dump

Поиск
Список
Период
Сортировка
От Laurentius Purba
Тема Re: Postgresql 9.0.13 core dump
Дата
Msg-id CAMfLBnhWPY0t7AdxKcPAqXHiAQVGQ1rn=fEUN1t1XC977TKyoA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgresql 9.0.13 core dump  (Kevin Grittner <kgrittn@ymail.com>)
Ответы Re: Postgresql 9.0.13 core dump  (Alban Hertroys <haramrae@gmail.com>)
Список pgsql-general
Kevin,

Thanks for the response. I will look into it based on your suggestion.

-Laurent


On Mon, Oct 14, 2013 at 8:29 PM, Kevin Grittner <kgrittn@ymail.com> wrote:
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 по дате отправления:

Предыдущее
От: Christian Affolter
Дата:
Сообщение: Alter the default access privileges of the public schema by the db owner
Следующее
От: David Johnston
Дата:
Сообщение: Re: recursive query returning extra rows in 8.4