Re: Problems restarting after database crashed (signal
От | Scott Marlowe |
---|---|
Тема | Re: Problems restarting after database crashed (signal |
Дата | |
Msg-id | 1088653294.29619.9.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Problems restarting after database crashed (signal 11). (Christopher Cashell <topher-pgsql@zyp.org>) |
Ответы |
Re: Problems restarting after database crashed (signal
Re: Problems restarting after database crashed (signal |
Список | pgsql-general |
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?
В списке pgsql-general по дате отправления: