|
Hi all: Our application uses Jboss-hibernate with Postgres as the backend. I’m seeing intermittently – the DB connections getting stale – and not getting returned to the Hibernate session pool. Some of the connections are as old as 9 days. The pg_stat shows the connection as IDLE in the DB. datid | datname | procpid | usesysid | usename | application_name | client_addr | client_port | backend_start | xact_start | query_start | waiting |
current_query | ?column? -------+-----------+---------+----------+---------+------------------+-------------+-------------+-------------------------------+-------------------------------+-------------------------------+---------+-----------------------------------------------------------------------------------+------------------------- 22372 | voyencedb | 15874 | 16384 | voyence | | 127.0.0.1 | 54754 | 2013-09-11 15:38:43.706149-05 | | 2013-10-02 11:43:44.410593-05 | f | <IDLE>
| 20 days 20:05:00.704444 22372 | voyencedb | 15875 | 16384 | voyence | | 127.0.0.1 | 54755 | 2013-09-11 15:38:43.706275-05 | | 2013-10-02 11:43:44.410764-05 | f | <IDLE>
| 20 days 20:05:00.704489 Is there anyway to correlate the Process id – the query that is used – or map it to the threads in the Java thread dumps? Need some lead to debug these IDLE connections. Any help in this regard is highly appreciated. Regards Jayashree |
