{"action":"created","issue":{"url":"https://api.github.com/repos/Azure/elastic-db-tools/issues/149","repository_url":"https://api.github.com/repos/Azure/elastic-db-tools","labels_url":"https://api.github.com/repos/Azure/elastic-db-tools/issues/149/labels{/name}","comments_url":"https://api.github.com/repos/Azure/elastic-db-tools/issues/149/comments","events_url":"https://api.github.com/repos/Azure/elastic-db-tools/issues/149/events","html_url":"https://github.com/Azure/elastic-db-tools/issues/149","id":193407903,"number":149,"title":"Connection Leaking v1.3.3","user":{"login":"ConX-Ryan","id":19829170,"avatar_url":"https://avatars.githubusercontent.com/u/19829170?v=3","gravatar_id":"","url":"https://api.github.com/users/ConX-Ryan","html_url":"https://github.com/ConX-Ryan","followers_url":"https://api.github.com/users/ConX-Ryan/followers","following_url":"https://api.github.com/users/ConX-Ryan/following{/other_user}","gists_url":"https://api.github.com/users/ConX-Ryan/gists{/gist_id}","starred_url":"https://api.github.com/users/ConX-Ryan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ConX-Ryan/subscriptions","organizations_url":"https://api.github.com/users/ConX-Ryan/orgs","repos_url":"https://api.github.com/users/ConX-Ryan/repos","events_url":"https://api.github.com/users/ConX-Ryan/events{/privacy}","received_events_url":"https://api.github.com/users/ConX-Ryan/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2016-12-05T04:10:43Z","updated_at":"2016-12-07T04:50:44Z","closed_at":"2016-12-07T04:50:44Z","body":"Hi Team,\r\n\r\n_Solution background:_\r\nMVC WebApp using Ninject DI for the Repository pattern (InRequestScope used).\r\n\r\n public SomeDbContext(ShardMap shardMap, T shardingKey, string connectionStr)\r\n            : base(CreateShardConnection(shardMap, shardingKey, connectionStr),\r\n **true** /*contextOwnsConnection */)\r\n\r\nI have noticed an issue with connection leaking, I have noticed that a large number of connections are trying to \"create procedure __ShardManagement.spValidateShardMappingLocal\".\r\nthese connections appear to remain after the repositories associated with the called controller have been disposed. The connections to the ShardMangerDB function as expected and are working fine.\r\nI have turn connection pooling off for the interim.\r\n\r\nthis problem \"_seems_\" to have become more prevalent after upgrading from 1.3.2 to 1.3.3.  or perhaps as  I suspect I am just doing more incorrect things more often :) standard user error some might say.\r\n\r\n**_DIAG SQL:_**\r\nSELECT ec.session_id, last_read, last_write, text, client_net_address, program_name, host_process_id, login_name, es.status\r\nFROM sys.dm_exec_connections  ec\r\nJOIN sys.dm_exec_sessions es\r\n  ON ec.session_id = es.session_id\r\nCROSS APPLY sys.dm_exec_sql_text(ec.most_recent_sql_handle) AS dest\r\nwhere es.status = 'sleeping'\r\n\r\n\r\nAppreciate your time, Thank you.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/Azure/elastic-db-tools/issues/comments/265355336","html_url":"https://github.com/Azure/elastic-db-tools/issues/149#issuecomment-265355336","issue_url":"https://api.github.com/repos/Azure/elastic-db-tools/issues/149","id":265355336,"user":{"login":"ConX-Ryan","id":19829170,"avatar_url":"https://avatars.githubusercontent.com/u/19829170?v=3","gravatar_id":"","url":"https://api.github.com/users/ConX-Ryan","html_url":"https://github.com/ConX-Ryan","followers_url":"https://api.github.com/users/ConX-Ryan/followers","following_url":"https://api.github.com/users/ConX-Ryan/following{/other_user}","gists_url":"https://api.github.com/users/ConX-Ryan/gists{/gist_id}","starred_url":"https://api.github.com/users/ConX-Ryan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ConX-Ryan/subscriptions","organizations_url":"https://api.github.com/users/ConX-Ryan/orgs","repos_url":"https://api.github.com/users/ConX-Ryan/repos","events_url":"https://api.github.com/users/ConX-Ryan/events{/privacy}","received_events_url":"https://api.github.com/users/ConX-Ryan/received_events","type":"User","site_admin":false},"created_at":"2016-12-07T04:50:44Z","updated_at":"2016-12-07T04:50:44Z","body":"Sorry to waste your time, it seems i was distracted by the update process and the leak was entirely some place else."}}
{"actor":{"display_login":"ConX-Ryan"}}