Re: Vacuum full hang => strace - Mailing list pgsql-admin

From Tom Lane
Subject Re: Vacuum full hang => strace
Date
Msg-id 14053.1044282747@sss.pgh.pa.us
Whole thread Raw
In response to Re: Vacuum full hang => strace  ("Gaetano Mendola" <mendola@bigfoot.com>)
List pgsql-admin
"Gaetano Mendola" <mendola@bigfoot.com> writes:
> gettimeofday({1044264831, 559402}, NULL) = 0
> setitimer(ITIMER_REAL, {it_interval={0, 0}, it_value={1, 0}},
> {it_interval={0, 0}, it_value={0, 0}}) = 0
> semop(21037068, 0xbfffed00, 1)          = -1 EINTR (Interrupted system call)
> --- SIGALRM (Alarm clock) ---
> sigreturn()                             = ? (mask now [])
> semop(21037068, 0xbfffed00, 1

> that's all, after this remain there for ever.

Looks like my guess was right: it's waiting for some other process to
release a lock.  Check for open transactions that have accessed the
table in question.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: LWLock acquire - can't wait without a proc structure
Next
From: mjoseph@inautix.com
Date:
Subject: Database access problem : SOS