[CAUSEWAY-1097] Suspicion that Isis may be leaving DB connections open under certain circumstances, leading to instability

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: core-1.8.0
• Fix Version/s: 1.9.0
• Component/s: Core
• Assignee: Unassigned
• Reporter: Daniel Keir Haywood
• Created: 17/Mar/15 12:29
• Updated: 01/Sep/15 19:49
• Resolved: 24/Apr/15 17:05

Description

Report from the field:

Users reporting that the app was slow. We've seen some active sessions in Tomcat that didn't correspond to any user, but also 3 database connections on PostgreSQL that were "IN TRANSACTION" for a long time.

Killing the Tomcat and database sessions the correct speed has been recovered

~~~~
One monitoring option to consider (open source with commercial support) is hyperic,

• http://sourceforge.net/projects/hyperic-hq/

• https://my.vmware.com/web/vmware/details?downloadGroup=VRHQ_584_OSS&productId=378