Re: postgresql 8 abort with signal 10

From: Alexandre Biancalana <biancalana(at)gmail(dot)com>
To: Alexandre Biancalana <biancalana(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: postgresql 8 abort with signal 10
Date: 2005-06-02 16:25:31
Message-ID: 8e10486b0506020925c25efae@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I changed from postgresql to mysql and everything now is great ;)

Same machine, same os, etc...

On 6/2/05, Roman Neuhauser <neuhauser(at)sigpipe(dot)cz> wrote:
> # 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

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2005-06-02 16:35:42 Re: [SQL] index row size 2728 exceeds btree maximum, 27
Previous Message Mark Lubratt 2005-06-02 16:12:27 Re: SRFs returning records from a view