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

From Laurentius Purba
Subject Re: Postgresql 9.0.13 core dump
Date
Msg-id CAMfLBnhWPY0t7AdxKcPAqXHiAQVGQ1rn=fEUN1t1XC977TKyoA@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql 9.0.13 core dump  (Kevin Grittner <kgrittn@ymail.com>)
Responses Re: Postgresql 9.0.13 core dump  (Alban Hertroys <haramrae@gmail.com>)
List 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 by date:

Previous
From: Christian Affolter
Date:
Subject: Alter the default access privileges of the public schema by the db owner
Next
From: David Johnston
Date:
Subject: Re: recursive query returning extra rows in 8.4