Re: Postgresql 9.0.13 core dump - Mailing list pgsql-general

From Kevin Grittner
Subject Re: Postgresql 9.0.13 core dump
Date
Msg-id 1381796947.23050.YahooMailNeo@web162905.mail.bf1.yahoo.com
Whole thread Raw
In response to Re: Postgresql 9.0.13 core dump  (Laurentius Purba <lpurba@sproutloud.com>)
Responses Re: Postgresql 9.0.13 core dump
List 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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: what is BIND in OS log for Postgresql
Next
From: "Huang, Suya"
Date:
Subject: Re: werid error"index row size 3040 exceeds btree maximum, 2712" occur randomly