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
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 |
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 |
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 |