Re: Postgresql 9.0.13 core dump

Laurentius Purba <lpurba(at)sproutloud(dot)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