Re: server process (PID xxx) was terminated by signal 7

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: server process (PID xxx) was terminated by signal 7
Date: 2007-01-24 08:47:44
Message-ID: 200701241047.45279.achill@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-patches pgsql-sql

Στις Τρίτη 23 Ιανουάριος 2007 16:25, γράψατε:
> Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> writes:
> >> Since you have not told us what the platform is, there is no way to
> >> guess what signal 7 means.
> >
> > Its a Bus error (SIGBUS). Those remote servers run on linux.
>
> Hm, pretty indeterminate then --- could be flaky hardware, or an
> invalid storage access caused either by a software bug or corrupted
> data.
>
> My advice would be (1) update to something newer than 7.4.2, and
> (2) run some hardware tests such as memtest86.

We ship the new machines with 7.4.15 installed.
Unfortunately the ones already at production are not easy
to reach by any means (in the 7 seas, unreliable SAT coms,
mgetty not always work), so not only we cannot boot
memtest86, but many times we can't even get a shell to do basic admin work.

oh and the lines are unreliable 64kbps ISDN, 9600bps or even 2400bps!!,

Weird setup for most of you, but it proves postgresql robustness running
50 such servers with almost zero administration/problems.

>
> regards, tom lane

--
Achilleas Mantzios

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Shoaib Mir 2007-01-24 09:17:07 Re: Install XML on Postgres 8.1
Previous Message Rajesh Kumar Mallah 2007-01-24 06:33:34 Re: Install XML on Postgres 8.1

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Dunstan 2007-01-24 14:19:19 Re: pg_get_domaindef
Previous Message Peter Eisentraut 2007-01-23 23:26:39 Re: server process (PID xxx) was terminated by signal

Browse pgsql-sql by date

  From Date Subject
Next Message Mario Splivalo 2007-01-25 14:39:14 Using Temporary Tables in postgres functions
Previous Message Peter Eisentraut 2007-01-23 23:26:39 Re: server process (PID xxx) was terminated by signal