Re: PostgreSQL hanging on new connections?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: depesz(at)depesz(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL hanging on new connections?
Date: 2010-11-29 18:23:00
Message-ID: 939.1291054980@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hubert depesz lubaczewski <depesz(at)depesz(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2010-11-29 18:24:02 Re: PostgreSQL hanging on new connections?
Previous Message hubert depesz lubaczewski 2010-11-29 17:18:40 PostgreSQL hanging on new connections?