{"action":"created","issue":{"url":"https://api.github.com/repos/apache/incubator-superset/issues/4666","repository_url":"https://api.github.com/repos/apache/incubator-superset","labels_url":"https://api.github.com/repos/apache/incubator-superset/issues/4666/labels{/name}","comments_url":"https://api.github.com/repos/apache/incubator-superset/issues/4666/comments","events_url":"https://api.github.com/repos/apache/incubator-superset/issues/4666/events","html_url":"https://github.com/apache/incubator-superset/issues/4666","id":307618476,"number":4666,"title":"Sessions still active on Datasource","user":{"login":"AmineTay","id":37660269,"avatar_url":"https://avatars3.githubusercontent.com/u/37660269?v=4","gravatar_id":"","url":"https://api.github.com/users/AmineTay","html_url":"https://github.com/AmineTay","followers_url":"https://api.github.com/users/AmineTay/followers","following_url":"https://api.github.com/users/AmineTay/following{/other_user}","gists_url":"https://api.github.com/users/AmineTay/gists{/gist_id}","starred_url":"https://api.github.com/users/AmineTay/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AmineTay/subscriptions","organizations_url":"https://api.github.com/users/AmineTay/orgs","repos_url":"https://api.github.com/users/AmineTay/repos","events_url":"https://api.github.com/users/AmineTay/events{/privacy}","received_events_url":"https://api.github.com/users/AmineTay/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":8,"created_at":"2018-03-22T12:14:49Z","updated_at":"2018-04-20T04:43:36Z","closed_at":"2018-03-27T08:14:36Z","author_association":"NONE","body":"Hello,\r\n\r\nI am contacting you concerning a problem found when using superset. \r\nWe have several session still running on our datasource (Postgres Database) even when superset dashboard is closed or cached on redis.\r\n\r\nHow can we make sure that superset session are well closed after querying the datasource.\r\n\r\n\r\nThank you for you help.\r\n"},"comment":{"url":"https://api.github.com/repos/apache/incubator-superset/issues/comments/382974139","html_url":"https://github.com/apache/incubator-superset/issues/4666#issuecomment-382974139","issue_url":"https://api.github.com/repos/apache/incubator-superset/issues/4666","id":382974139,"user":{"login":"austenhead","id":6146404,"avatar_url":"https://avatars2.githubusercontent.com/u/6146404?v=4","gravatar_id":"","url":"https://api.github.com/users/austenhead","html_url":"https://github.com/austenhead","followers_url":"https://api.github.com/users/austenhead/followers","following_url":"https://api.github.com/users/austenhead/following{/other_user}","gists_url":"https://api.github.com/users/austenhead/gists{/gist_id}","starred_url":"https://api.github.com/users/austenhead/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/austenhead/subscriptions","organizations_url":"https://api.github.com/users/austenhead/orgs","repos_url":"https://api.github.com/users/austenhead/repos","events_url":"https://api.github.com/users/austenhead/events{/privacy}","received_events_url":"https://api.github.com/users/austenhead/received_events","type":"User","site_admin":false},"created_at":"2018-04-20T04:43:36Z","updated_at":"2018-04-20T04:43:36Z","author_association":"NONE","body":"The number of database connections to the metadata server is small and not an issue.\r\nThe number of database connections to the database with company metrics (the data that gets shown in superset) got very big.\r\n\r\nI have 5 gunicorn processes running.\r\n\r\nFrom https://serverfault.com/a/862418 it looks like database on AWS's RDS by default can handle ~85 connections per 1GB of RAM. So you're right that 100 connections shouldn't bother me as much as it is. If someone is running this against a small database, then it could be an issue.\r\n\r\nFrom looking at the flask-sqlalchemy I think you're right that that is the most likely culprit.\r\n\r\nThanks for the quick response! I'll write back in the next couple of weeks if this did not resolve my issue (or if it ends up being tricky and someone else might benefit from notes on it)."}}
{"actor":{"display_login":"austenhead"}}