postgres connections in IDLE state..

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux