Re: Vacuum full hang => strace

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Vacuum full hang => strace
Дата
Msg-id 14053.1044282747@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Vacuum full hang => strace  ("Gaetano Mendola" <mendola@bigfoot.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: LWLock acquire - can't wait without a proc structure
Следующее
От: mjoseph@inautix.com
Дата:
Сообщение: Database access problem : SOS