From: | Tarabas <tarabas(at)tarabas(dot)de> |
---|---|
To: | "Tarabas (Manuel Rorarius)" <tarabas(at)tarabas(dot)de> |
Cc: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: [bulk] Re: Non returning Transactions/Many Locks in Postgres 9.0.4 and 9.0.1 |
Date: | 2011-06-08 14:32:54 |
Message-ID: | 310552584.20110608163254@tarabas.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
the problem just resurfaced and the Wiki page dows not really help
very much.
When i look into the pg_stat_activity, i only see that the connections
all state "<IDLE> in transaction".
Is there any way to find out what the transaction is doing exactly to
be able to debug the Problem?
Best regards
Manuel
Tuesday, June 7, 2011, 5:50:13 PM, you wrote:
T> Hi Scott,
SM>> Snip. Those are ALL either AccessShareLock (which is very low level
SM>> and non-blocking) or virtual tx locks, which again don't block
SM>> anything but their own transaction. Nothing there screams "locks!"
SM>> for a better view of locks and how they're blocking things you can use
SM>> the queries from here: http://wiki.postgresql.org/wiki/Lock_Monitoring
T> Thank you, I will try that. I am currently using Hibernate 3.2 as a
T> Database-Layer but with an older JDBC for 8.2, i will try updating
T> these components to more recent versions.
T> If the problem arises again i will hopefully be able to better
T> analyze, where the locking in my application occurs. It is in fact a
T> multi-threaded environment.
T> Best regards
T> Manuel
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2011-06-08 14:38:08 | Re: [bulk] Re: Non returning Transactions/Many Locks in Postgres 9.0.4 and 9.0.1 |
Previous Message | Craig Ringer | 2011-06-08 13:06:57 | Re: what is the best way of storing text+image documents in postgresql |