[pgpool-general: 672] Transaction never finishes

[Luiz Pasqual]

Hello,

I'm using pgpool-II 3.1.2 with streaming replication and it's working
pretty well. But I'm dealing with a weird situation and I don't know
how to debug:

Sometimes, some transactions never finishes in the master, here is an
example, the following query:
select * from pg_stat_activity where xact_start < current_timestamp -
'10 minutes'::interval

Results:
20994;"****";2445;16385;"****";"";"192.168.**.**";"";44083;"2012-06-27
05:55:39.525881-03";"2012-06-27 11:17:46.475347-03";"2012-06-27
11:18:10.044718-03";f;"<IDLE> in transaction"

This transaction gets AccessShareLock in the relations:
pg_class_relname_nsp_index
pg_class
pg_class_oid_index
pg_namespace
pg_namespace_oid_index
pg_namespace_nspname_index

And one ExclusiveLock that I couldn't identify the relation.

Sometimes, depending on the relations that are locked everything fails
(timeout) and a pgpool restart must be done. Anyone knows what is
going on?

Thanks.

-- 
Luiz Fernando Pasqual S. Souza
mail: luiz at pasquall.com