I have been experiencing some issues with leaky connections. While I was investigating this I saw some behavior that I could not explain.
First some background. I am not sure if my issue is caused by NHibernate or the ASA (v10) provider or database. In order to figure out the answer I've spent a lot of time looking through the logs generated by NHibernate. The application is web based and using the Open Session in view pattern. I am using a custom build of NHibernate (a slightly modified 2.0.x) as I want to know ASA's internal connection ID (the idea is that I might be able to tie the leaky connections with something specific that I am doing in the app). But I see a lot of activity after the EndRequest event fires on the HTTPApplication. And I don't know why. Can someone explain to me what is going on? Here's an excerpt from our log for a single request: 2009-03-18 13:08:40,691 NHibernateSessionModule EndRequest 2009-03-18 13:08:40,701 NHibernate.Connection.ConnectionProvider Closing connection with ID 8 2009-03-18 13:08:41,741 NHibernate.Connection.DriverConnectionProvider Obtaining IDbConnection from Driver 2009-03-18 13:08:41,744 NHibernate.Connection.DriverConnectionProvider Opened IDbConnection with ID 8 2009-03-18 13:08:41,748 NHibernate.Connection.DriverConnectionProvider Obtaining IDbConnection from Driver 2009-03-18 13:08:41,752 NHibernate.Connection.ConnectionProvider Closing connection with ID 8 2009-03-18 13:08:41,827 NHibernate.Connection.DriverConnectionProvider Obtaining IDbConnection from Driver 2009-03-18 13:08:41,828 NHibernate.Connection.DriverConnectionProvider Opened IDbConnection with ID 9 2009-03-18 13:08:41,829 NHibernate.Connection.DriverConnectionProvider Opened IDbConnection with ID 8 2009-03-18 13:08:41,831 NHibernate.Connection.ConnectionProvider Closing connection with ID 8 2009-03-18 13:08:41,837 NHibernate.Connection.DriverConnectionProvider Obtaining IDbConnection from Driver 2009-03-18 13:08:41,839 NHibernate.Connection.DriverConnectionProvider Opened IDbConnection with ID 8 2009-03-18 13:08:41,842 NHibernate.Connection.ConnectionProvider Closing connection with ID 9 2009-03-18 13:08:41,842 NHibernate.Connection.ConnectionProvider Closing connection with ID 8 2009-03-18 13:08:42,868 NHibernate.Connection.DriverConnectionProvider Obtaining IDbConnection from Driver 2009-03-18 13:08:42,876 NHibernate.Connection.DriverConnectionProvider Opened IDbConnection with ID 8 2009-03-18 13:08:42,880 NHibernate.Connection.ConnectionProvider Closing connection with ID 8 2009-03-18 13:08:43,929 NHibernate.Connection.DriverConnectionProvider Obtaining IDbConnection from Driver 2009-03-18 13:08:43,931 NHibernate.Connection.DriverConnectionProvider Opened IDbConnection with ID 8 2009-03-18 13:08:43,933 NHibernate.Connection.ConnectionProvider Closing connection with ID 8 2009-03-18 13:08:44,950 NHibernate.Connection.DriverConnectionProvider Obtaining IDbConnection from Driver 2009-03-18 13:08:44,953 NHibernate.Connection.DriverConnectionProvider Opened IDbConnection with ID 8 2009-03-18 13:08:44,955 NHibernate.Connection.ConnectionProvider Closing connection with ID 8 2009-03-18 13:08:45,982 NHibernate.Connection.DriverConnectionProvider Obtaining IDbConnection from Driver 2009-03-18 13:08:45,984 NHibernate.Connection.DriverConnectionProvider Opened IDbConnection with ID 8 2009-03-18 13:08:45,987 NHibernate.Connection.ConnectionProvider Closing connection with ID 8 2009-03-18 13:08:47,070 NHibernate.Connection.DriverConnectionProvider Obtaining IDbConnection from Driver 2009-03-18 13:08:47,071 NHibernate.Connection.DriverConnectionProvider Opened IDbConnection with ID 8 2009-03-18 13:08:47,073 NHibernate.Connection.ConnectionProvider Closing connection with ID 8 2009-03-18 13:08:48,130 NHibernate.Connection.DriverConnectionProvider Obtaining IDbConnection from Driver 2009-03-18 13:08:48,132 NHibernate.Connection.DriverConnectionProvider Opened IDbConnection with ID 8 2009-03-18 13:08:48,134 NHibernate.Connection.ConnectionProvider Closing connection with ID 8 2009-03-18 13:08:49,141 NHibernate.Connection.DriverConnectionProvider Obtaining IDbConnection from Driver 2009-03-18 13:08:49,143 NHibernate.Connection.DriverConnectionProvider Opened IDbConnection with ID 8 2009-03-18 13:08:49,145 NHibernate.Connection.ConnectionProvider Closing connection with ID 8 2009-03-18 13:08:50,210 NHibernate.Connection.DriverConnectionProvider Obtaining IDbConnection from Driver 2009-03-18 13:08:50,212 NHibernate.Connection.DriverConnectionProvider Opened IDbConnection with ID 8 2009-03-18 13:08:50,214 NHibernate.Connection.ConnectionProvider Closing connection with ID 8 2009-03-18 13:08:51,241 NHibernate.Connection.DriverConnectionProvider Obtaining IDbConnection from Driver 2009-03-18 13:08:51,244 NHibernate.Connection.DriverConnectionProvider Opened IDbConnection with ID 8 2009-03-18 13:08:51,248 NHibernate.Connection.ConnectionProvider Closing connection with ID 8 2009-03-18 13:08:51,261 NHibernate.Connection.DriverConnectionProvider Obtaining IDbConnection from Driver 2009-03-18 13:08:51,261 NHibernate.Connection.DriverConnectionProvider Obtaining IDbConnection from Driver 2009-03-18 13:08:51,263 NHibernate.Connection.DriverConnectionProvider Opened IDbConnection with ID 8 2009-03-18 13:08:51,264 NHibernate.Connection.ConnectionProvider Closing connection with ID 8 2009-03-18 13:08:51,266 NHibernate.Connection.DriverConnectionProvider Opened IDbConnection with ID 9 2009-03-18 13:08:51,268 NHibernate.Connection.ConnectionProvider Closing connection with ID 9 2009-03-18 13:08:51,290 NHibernate.Connection.DriverConnectionProvider Obtaining IDbConnection from Driver 2009-03-18 13:08:51,292 NHibernate.Connection.DriverConnectionProvider Opened IDbConnection with ID 8 2009-03-18 13:08:51,294 NHibernate.Connection.ConnectionProvider Closing connection with ID 8 2009-03-18 13:08:52,302 NHibernate.Connection.DriverConnectionProvider Obtaining IDbConnection from Driver 2009-03-18 13:08:52,304 NHibernate.Connection.DriverConnectionProvider Opened IDbConnection with ID 8 2009-03-18 13:08:52,306 NHibernate.Connection.ConnectionProvider Closing connection with ID 8 2009-03-18 13:08:53,372 NHibernate.Connection.DriverConnectionProvider Obtaining IDbConnection from Driver 2009-03-18 13:08:53,372 NHibernate.Connection.DriverConnectionProvider Obtaining IDbConnection from Driver 2009-03-18 13:08:53,374 NHibernate.Connection.DriverConnectionProvider Opened IDbConnection with ID 8 2009-03-18 13:08:53,375 NHibernate.Connection.DriverConnectionProvider Opened IDbConnection with ID 9 2009-03-18 13:08:53,376 NHibernate.Connection.ConnectionProvider Closing connection with ID 8 2009-03-18 13:08:53,376 NHibernate.Connection.ConnectionProvider Closing connection with ID 9 2009-03-18 13:08:53,421 NHibernate.Connection.DriverConnectionProvider Obtaining IDbConnection from Driver 2009-03-18 13:08:53,422 NHibernate.Connection.DriverConnectionProvider Obtaining IDbConnection from Driver 2009-03-18 13:08:53,424 NHibernate.Connection.DriverConnectionProvider Opened IDbConnection with ID 8 2009-03-18 13:08:53,426 NHibernate.Connection.ConnectionProvider Closing connection with ID 8 2009-03-18 13:08:53,429 NHibernate.Connection.DriverConnectionProvider Opened IDbConnection with ID 9 2009-03-18 13:08:53,432 NHibernate.Connection.ConnectionProvider Closing connection with ID 9 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
