Re: Problems restarting after database crashed (signal 11).

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Problems restarting after database crashed (signal 11).
Дата
Msg-id 873c49w6ae.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: Problems restarting after database crashed (signal 11).  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Problems restarting after database crashed (signal 11).  (Christopher Cashell <topher@zyp.org>)
Список pgsql-general
Tom Lane <tgl@sss.pgh.pa.us> writes:

> Christopher Cashell <topher-pgsql@zyp.org> writes:
> > 28424 postgres  18   0 16804 3044  15m D  0.0  1.6   0:06.72 postmaster
>
> > Note that it does have a process status of 'D', or uninterruptible
> > sleep.  That would explain the unkillable part, though I'm curious how
> > it ended up there.

Is there an NFS server involved? If an NFS server disappears any process
waiting on I/O for it enters disk-wait indefinitely until it reappears.

--
greg

В списке pgsql-general по дате отправления:

Предыдущее
От: Mike Nolan
Дата:
Сообщение: Re: Run a unix or perl command in a trigger
Следующее
От: Tom Lane
Дата:
Сообщение: Re: alter table cascade does not give notice about dropped indexes