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

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