Re: PostgreSQL hanging on new connections?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostgreSQL hanging on new connections?
Дата
Msg-id 939.1291054980@sss.pgh.pa.us
обсуждение исходный текст
Ответ на PostgreSQL hanging on new connections?  (hubert depesz lubaczewski <depesz@depesz.com>)
Ответы Re: PostgreSQL hanging on new connections?
Re: PostgreSQL hanging on new connections?
Re: PostgreSQL hanging on new connections?
Список pgsql-general
hubert depesz lubaczewski <depesz@depesz.com> writes:
> straced postmaster when the problem was happening, and I was opening new
> connections. strace looks like this:
> [ backend hangs on semop immediately after reading global/pg_database ]

It looks like something had exclusive lock on the database that new
connections wanted to connect to.  AFAICS the only action in 8.3 that
would do that would be a DROP DATABASE or RENAME DATABASE.  What was
that other session doing?

            regards, tom lane

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

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: PostgreSQL hanging on new connections?
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: PostgreSQL hanging on new connections?