Re: Problem running "ALTER TABLE...", ALTER TABLE waiting

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problem running "ALTER TABLE...", ALTER TABLE waiting
Дата
Msg-id 27601.1344473932@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Problem running "ALTER TABLE...", ALTER TABLE waiting  (Brian McNally <bmcnally@uw.edu>)
Ответы Re: Problem running "ALTER TABLE...", ALTER TABLE waiting
Список pgsql-general
Дерево обсуждения 
Brian McNally <bmcnally@uw.edu> writes:
> Ok, I'm running with all available updates and kernel 2.6.18-308.4.1.el5
> but am still having the same problem.

It's fairly clearly blocked on a lock ... have you looked into the
pg_locks view to see what is holding the lock?

(I'm wondering about a prepared transaction, myself.  There isn't much
else that could hold a lock across a server restart.)

            regards, tom lane

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

Предыдущее
От: Brian McNally
Дата:
Сообщение: Re: Problem running "ALTER TABLE...", ALTER TABLE waiting
Следующее
От: Geert Mak
Дата:
Сообщение: Re: processing large amount of rows with plpgsql