Re: Non returning Transactions/Many Locks in Postgres 9.0.4 and 9.0.1

On Mon, Jun 6, 2011 at 11:20 AM, Tarabas <tarabas(at)tarabas(dot)de> wrote:
> Hello!
>
> I am currently having a recurring Locking problem on my Postgres 9.0.4
> Database. I had the same Problem on 9.0.1 and updated to 9.0.4 then.
> It worked fine for a while and just resurfaced.
>
> Suddenly it seems as though there is some kind of "deadlock" in the
> database, which prevents my client from getting results for the open
> transactions, resulting in the system to stop delivering content.

[snip]

locktype|database|relation|page|tuple|virtualxid|transactionid|classid|objid|objsubid|virtualtransaction|pid|mode|granted
> relation|3285581|3287328||||||||15/240971|13069|AccessShareLock|t
> relation|3285581|3287327||||||||40/15748|9861|AccessShareLock|t
...[snip]

One thing that stands out here is that all the locks are 'granted' --
that means at least according to pg_locks your are not blocking in the
database. This is evidence the problem is in your end, not on the
server side...
*) is your application threaded?
*) are you using a connection pooler? (if so, which one?)

merlin