Re: vacuum taking an unusually long time

Поиск
Список
Период
Сортировка
От Mason Hale
Тема Re: vacuum taking an unusually long time
Дата
Msg-id 8bca3aa10807160840q1610349fn6e339f072e531e39@mail.gmail.com
обсуждение исходный текст
Ответ на Re: vacuum taking an unusually long time  ("Mason Hale" <masonhale@gmail.com>)
Ответы Re: vacuum taking an unusually long time  (Steve Atkins <steve@blighty.com>)
Список pgsql-general
Дерево обсуждения


On Wed, Jul 16, 2008 at 10:26 AM, Mason Hale <masonhale@gmail.com> wrote:
Here's some of the strace output:

select(0, NULL, NULL, NULL, {0, 10000}) = 0 (Timeout)

If I read the 'select(2)' man page correctly, it appears this process is waiting indefinitely for a NULL file descriptor.
That looks pretty stuck to me.

Should I kill this autovacuum process via pg_cancel_backend? 
Or is there a better way to "unstick" it?

Any ideas what may have caused it to get into this condition?

- Mason 

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

Предыдущее
От: "Mason Hale"
Дата:
Сообщение: Re: vacuum taking an unusually long time
Следующее
От: Michael Glaesemann
Дата:
Сообщение: Re: unable to drop a constraint