FbConnectionPoolManager not closing connections
-----------------------------------------------

                 Key: DNET-595
                 URL: http://tracker.firebirdsql.org/browse/DNET-595
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
         Environment: any
            Reporter: Thomas Kragh
            Assignee: Jiri Cincura


I believe to have found at problem in FbConnectionPoolManager. In my case the 
problem shows on a website where there is a spike in user activity in the 
morning, the user activity results in about 75-100 attachments to the database. 
However after the spike, the connections/attachments to the database remains. 
The Connection lifetime is set to 15 in my connectionstring. 

After digging around in the sourcecode I believe I have found the problem in 
FbConnectionPoolManager, where a Queue<Item> is used to hold available 
connections. The FIFO nature of the Queue results in every available 
connections to be checked out of the pool within 15 seconds if there is enough 
database activity. Thus keeping the 75-100 connection/attachment to the 
database open for a long period (usually 6-8 hours) 

I believe using a Stack<Item> instead of Queue<Item> could solve the problem.  


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to