virtualidx exclusive lock

From: Uwe Schroeder <uwe(at)oss4u(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: virtualidx exclusive lock
Date: 2009-11-09 07:38:28
Message-ID: 200911082338.29079.uwe@oss4u.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I've googled, but there's 0 hits.

I have an issue with a ton of "idle in transaction" backends.
What I noticed is when I look at pg_locks, pretty much all of the processes being idle in transaction have an exclusive lock of locktype "virtualidx".

Well, that doesn't make sense to me, but maybe someone here can tell me where a "virtualidx" locktype would come from. I'm sure it has to be some type of query.
There is no info about table or anything, all the records look like:

locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted
---------------+----------+----------+------+-------+------------+---------------+---------+-------+----------+--------------------+-------+------------------+---------
virtualxid | | | | | 63/10150 | | | | | 63/10150 | 31932 | ExclusiveLock | t
virtualxid | | | | | 48/48530 | | | | | 48/48530 | 31323 | ExclusiveLock | t
virtualxid | | | | | 47/52387 | | | | | 47/52387 | 31321 | ExclusiveLock | t
virtualxid | | | | | 76/4086 | | | | | 76/4086 | 32074 | ExclusiveLock | t
virtualxid | | | | | 15/6007096 | | | | | 15/6007096 | 31169 | ExclusiveLock | t
virtualxid | | | | | 10/5689919 | | | | | 10/5689919 | 31595 | ExclusiveLock | t
virtualxid | | | | | 32/603998 | | | | | 32/603998 | 31213 | ExclusiveLock | t
virtualxid | | | | | 42/117511 | | | | | 42/117511 | 31270 | ExclusiveLock | t
virtualxid | | | | | 39/279415 | | | | | 39/279415 | 31267 | ExclusiveLock | t

Is there a way to find out what query, or in lack of that at least what table is involved?

Thanks

Uwe

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Uckun 2009-11-09 08:26:24 Re: I can't seem to put the right combination of magic into the pg_hba and pg_ident files.
Previous Message John R Pierce 2009-11-09 07:04:33 Re: I can't seem to put the right combination of magic into the pg_hba and pg_ident files.