Re: Problems restarting after database crashed (signal

On Wed, 2004-06-30 at 18:57, Christopher Cashell wrote:
> Yesterday, while attempting to access a database, I received errors
> saying that the database was innaccessible. After investigating a
> little, I found the following in the PostgreSQL log files:
>
> 2004-06-30 08:30:19 [24119] LOG: checkpoint process (PID 28423) was
> terminated by signal 11

> Eventually I attempted to shut it down and restart it, however that
> failed too. When I attempted to shut it down, I discovered a hung
> 'startup subprocess' that can't be killed.
>
> nexus:~# ps aux | grep postgres
> postgres 28424 0.0 1.5 16804 3044 pts/313 D 08:35 0:06 postgres:
> startup subprocess
> nexus:~# kill -9 28424
> nexus:~# ps aux | grep postgres
> postgres 28424 0.0 1.5 16804 3044 pts/313 D 08:35 0:06 postgres:
> startup subprocess
> nexus:~#

The combination of a Sig 11 failure and a process stuck in a D state
makes me lean towards thinking it's bad hardware (CPU or memory). Have
you tested this machine?