From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@postgresql.org
Subject: Re: server process (PID xxx) was terminated by signal 7
Date: Wed, 24 Jan 2007 10:47:44 +0200
Message-ID: <200701241047.45279.achill@matrix.gatewaynet.com> (raw)
In-Reply-To: <18126.1169562310@sss.pgh.pa.us>
References: <20070122105038.805CA19F306@smtp07l.fasthosts.co.uk>
<200701230940.39784.achill@matrix.gatewaynet.com>
<18126.1169562310@sss.pgh.pa.us>
Στις Τρίτη 23 Ιανουάριος 2007 16:25, γράψατε:
> Achilleas Mantzios <achill@matrix.gatewaynet.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: achill@matrix.gatewaynet.com, pgsql-admin@postgresql.org
Subject: Re: server process (PID xxx) was terminated by signal 7
In-Reply-To: <200701241047.45279.achill@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox