On Mon, Jun 6, 2011 at 11:20 AM, Tarabas <tarabas@xxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
