[jira] [Commented] (ISIS-1097) Suspicion that Isis may be leaving DB connections open under certain circumstances, leading to instability

["Dan Haywood (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ISIS-1097?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14365060#comment-14365060 ] 

Dan Haywood commented on ISIS-1097:
-----------------------------------

I was wondering if the IsisWicketRequestCycle stuff isn't completing the xactn in certain circumstances, eg if a DB exception (unique index violation, opt locking exception) is encountered.

Then again, for this particular app where the problem was reported, it doesn't use the Wicket viewer, so perhaps that's an unrelated issue.

~~~
Have also had a similar report (but perhaps unrelated) for other system that does use the Wicket viewer.

> Suspicion that Isis may be leaving DB connections open under certain circumstances, leading to instability
> ----------------------------------------------------------------------------------------------------------
>
>                 Key: ISIS-1097
>                 URL: https://issues.apache.org/jira/browse/ISIS-1097
>             Project: Isis
>          Issue Type: Bug
>          Components: Core
>    Affects Versions: core-1.8.0
>            Reporter: Dan Haywood
>            Assignee: Dan Haywood
>             Fix For: 1.9.0
>
>
> 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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)