{"action":"opened","issue":{"url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/706","repository_url":"https://api.github.com/repos/brettwooldridge/HikariCP","labels_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/706/labels{/name}","comments_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/706/comments","events_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/706/events","html_url":"https://github.com/brettwooldridge/HikariCP/issues/706","id":173649966,"number":706,"title":"Relationship between idleTimeout and maxLifetime wrt open connections.","user":{"login":"godenji","id":238557,"avatar_url":"https://avatars.githubusercontent.com/u/238557?v=3","gravatar_id":"","url":"https://api.github.com/users/godenji","html_url":"https://github.com/godenji","followers_url":"https://api.github.com/users/godenji/followers","following_url":"https://api.github.com/users/godenji/following{/other_user}","gists_url":"https://api.github.com/users/godenji/gists{/gist_id}","starred_url":"https://api.github.com/users/godenji/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/godenji/subscriptions","organizations_url":"https://api.github.com/users/godenji/orgs","repos_url":"https://api.github.com/users/godenji/repos","events_url":"https://api.github.com/users/godenji/events{/privacy}","received_events_url":"https://api.github.com/users/godenji/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-08-28T14:42:40Z","updated_at":"2016-08-28T14:42:40Z","closed_at":null,"body":"Hi, thanks for Hikari, quite impressive on the performance front, very nice ;-)\r\n\r\nQuestion about interplay between idleTimeout and maxLifetime; with the following I'm seeing 116 connections open (with max used at 9) in MySQL:\r\n```\r\nminimumIdle=\"5\"\r\nmaximumPoolSize=\"10\"\r\nidleTimeout=\"0\" # does this negate maxLifetime setting?\r\nmaxLifetime=\"27000000\" # 7.5 hours (mysql timeout is 8 hours)\r\n```\r\nIn local dev I noticed that there were 6546 connections open, heh O_o \r\nThis may have to do with a bug in Play Framework where stop hooks are not getting called on application reload.\r\n\r\nJust trying to narrow down what may be causing the large number of open connections, suspect it's that the `idleTimeout` setting is causing `maxLifetime` to be ignored."}}
{"actor":{"display_login":"godenji"}}