{"action":"created","issue":{"url":"https://api.github.com/repos/MarimerLLC/csla/issues/377","labels_url":"https://api.github.com/repos/MarimerLLC/csla/issues/377/labels{/name}","comments_url":"https://api.github.com/repos/MarimerLLC/csla/issues/377/comments","events_url":"https://api.github.com/repos/MarimerLLC/csla/issues/377/events","html_url":"https://github.com/MarimerLLC/csla/issues/377","id":86733117,"number":377,"title":"ConnectionManager may not be releasing connections under stress","user":{"login":"rockfordlhotka","id":2333134,"avatar_url":"https://avatars.githubusercontent.com/u/2333134?v=3","gravatar_id":"","url":"https://api.github.com/users/rockfordlhotka","html_url":"https://github.com/rockfordlhotka","followers_url":"https://api.github.com/users/rockfordlhotka/followers","following_url":"https://api.github.com/users/rockfordlhotka/following{/other_user}","gists_url":"https://api.github.com/users/rockfordlhotka/gists{/gist_id}","starred_url":"https://api.github.com/users/rockfordlhotka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rockfordlhotka/subscriptions","organizations_url":"https://api.github.com/users/rockfordlhotka/orgs","repos_url":"https://api.github.com/users/rockfordlhotka/repos","events_url":"https://api.github.com/users/rockfordlhotka/events{/privacy}","received_events_url":"https://api.github.com/users/rockfordlhotka/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/MarimerLLC/csla/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-06-09T20:58:35Z","updated_at":"2015-08-03T05:23:11Z","closed_at":null,"body":"http://forums.lhotka.net/forums/p/12896/58322.aspx#58322\r\n\r\n\r\n> Yes, I'm fairly confident it's ConnectionManager.  The issue seems to be, ironically, that the connections are not being properly returned to the pool.  We already have the pool size at 500, from the 100 default.\r\n> \r\n> Last year, when we were still on Csla 3.7 we tried to do a wholesale conversion from manually new'ing up SqlConnection to using ConnectionManager.  Quite literally a find/replace.  It worked well for a few days, but then we got these hangs.  We did see some errors logged about timeouts trying to get a connection from the pool.  We reverted the changes and redeployed, and things went back to normal.  The timing of the hang seems to be as our load increases (when our East coast customers begin coming online through when our West coast customers do).\r\n> \r\n> We had hoped that our planned Csla 4.5 update would have some changes that would resolve this, and after we did the update we've been slowly converting things to use CM as we touch the BOs for other reasons since upgraded about six months ago (and are on the most current version).\r\n> \r\n> We have a bunch of background threads (our SaaS app is a WinForms client) pooling for things at various times.  This last release we did some refactoring and added one more, and moved something that was not previously in the DB to the DB; both these threads basically are new hits to the DB and we did them with ConnectionManager.  The hangs returned, and I did find more errors indicating timeouts getting a connection from the pool.  I changed the server code used by these two threads to just new up the connection, and our hang has gone away again, so far.  We'll see, we just did the hotfix on Sunday so I want to give it a few more days, but based on our previous experience I don't think the issue will return.\r\n> \r\n> So, that's all I have, and of course we've only seen this in production, so we haven't had a lot of opportunity to investigate as we have to get the system back online.  The issue does seem to only manifest during our busy times, which are mornings and especially weekends (Saturday / Sunday), so I suspect load has something to do with it.\r\n"},"comment":{"url":"https://api.github.com/repos/MarimerLLC/csla/issues/comments/127128589","html_url":"https://github.com/MarimerLLC/csla/issues/377#issuecomment-127128589","issue_url":"https://api.github.com/repos/MarimerLLC/csla/issues/377","id":127128589,"user":{"login":"jonnybee","id":3512406,"avatar_url":"https://avatars.githubusercontent.com/u/3512406?v=3","gravatar_id":"","url":"https://api.github.com/users/jonnybee","html_url":"https://github.com/jonnybee","followers_url":"https://api.github.com/users/jonnybee/followers","following_url":"https://api.github.com/users/jonnybee/following{/other_user}","gists_url":"https://api.github.com/users/jonnybee/gists{/gist_id}","starred_url":"https://api.github.com/users/jonnybee/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jonnybee/subscriptions","organizations_url":"https://api.github.com/users/jonnybee/orgs","repos_url":"https://api.github.com/users/jonnybee/repos","events_url":"https://api.github.com/users/jonnybee/events{/privacy}","received_events_url":"https://api.github.com/users/jonnybee/received_events","type":"User","site_admin":false},"created_at":"2015-08-03T05:23:11Z","updated_at":"2015-08-03T05:23:11Z","body":"Unless we are really sure that the OP has coded and used ConnectionManager properly and there is no logical flaw in the code we should close this issue. \r\nThere is not enough information to pursue this issue as is.  "}}