Home > mailing lists

Re: vacuum taking an unusually long time - Mailing list pgsql-general

From	Mason Hale
Subject	Re: vacuum taking an unusually long time
Date	July 16, 2008 16:26:22
Msg-id	8bca3aa10807160840q1610349fn6e339f072e531e39@mail.gmail.com Whole thread Raw
In response to	Re: vacuum taking an unusually long time ("Mason Hale" <masonhale@gmail.com>)
Responses	Re: vacuum taking an unusually long time
List	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

From: "Mason Hale"
Date: 16 July 2008, 16:21:32
Subject: Re: vacuum taking an unusually long time

From: Michael Glaesemann
Date: 16 July 2008, 16:45:28
Subject: Re: unable to drop a constraint