Re: postgresql 8 abort with signal 10

From: Roman Neuhauser <neuhauser(at)sigpipe(dot)cz>
To: Alexandre Biancalana <biancalana(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postgresql 8 abort with signal 10
Date: 2005-06-02 15:21:22
Message-ID: 20050602152122.GD93005@isis.sigpipe.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

# biancalana(at)gmail(dot)com / 2005-05-03 17:56:53 -0300:
> The FreeBSD is the last STABLE version..... I can try to change some
> hardware, I already changed memory, what can I try now ? the processor
> ? motherboard ??

> On 5/3/05, Scott Marlowe <smarlowe(at)g2switchworks(dot)com> wrote:
> > On Tue, 2005-05-03 at 15:04, Alexandre Biancalana wrote:
> > > Thank you for the detailed explanation Scott, they are very handy !!
> > >
> > > I reduced the shared_buffers to 32768, but the problem still occurs.....
> > >
> > > Any other idea ??
> >
> > Yeah, I had a sneaking suspicion that shared_buffers wasn't causing the
> > issue really.
> >
> > Sounds like either a hardware fault, or a BSD bug. I'd check the BSD
> > mailing lists for mention of said bug, and see if you can grab a spare
> > drive and install the last stable version of FreeBSD 4.x and if that
> > fixes the problem.
> >
> > If you decide to try linux, avoid the 2.6 kernel, it's still got
> > issues... 2.4 is pretty stable.
> >
> > I really doubt it's a problem in postgresql itself though.

For the sake of archives, what was causing the SIGBUSes?

--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man. You don't KNOW.
Cause you weren't THERE. http://bash.org/?255991

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yudie Pg 2005-06-02 15:30:25 Re: hpw to Count without group by
Previous Message Tom Lane 2005-06-02 15:15:35 Re: Stats not getting updated....