{"action":"closed","issue":{"url":"https://api.github.com/repos/librenms/librenms/issues/1920","labels_url":"https://api.github.com/repos/librenms/librenms/issues/1920/labels{/name}","comments_url":"https://api.github.com/repos/librenms/librenms/issues/1920/comments","events_url":"https://api.github.com/repos/librenms/librenms/issues/1920/events","html_url":"https://github.com/librenms/librenms/issues/1920","id":106926255,"number":1920,"title":"Polling bug causes too many connections in Mysql DB","user":{"login":"justnx","id":5025584,"avatar_url":"https://avatars.githubusercontent.com/u/5025584?v=3","gravatar_id":"","url":"https://api.github.com/users/justnx","html_url":"https://github.com/justnx","followers_url":"https://api.github.com/users/justnx/followers","following_url":"https://api.github.com/users/justnx/following{/other_user}","gists_url":"https://api.github.com/users/justnx/gists{/gist_id}","starred_url":"https://api.github.com/users/justnx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/justnx/subscriptions","organizations_url":"https://api.github.com/users/justnx/orgs","repos_url":"https://api.github.com/users/justnx/repos","events_url":"https://api.github.com/users/justnx/events{/privacy}","received_events_url":"https://api.github.com/users/justnx/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/librenms/librenms/labels/Needs-Info","name":"Needs-Info","color":"ff9933"}],"state":"closed","locked":false,"assignee":{"login":"f0o","id":1656377,"avatar_url":"https://avatars.githubusercontent.com/u/1656377?v=3","gravatar_id":"","url":"https://api.github.com/users/f0o","html_url":"https://github.com/f0o","followers_url":"https://api.github.com/users/f0o/followers","following_url":"https://api.github.com/users/f0o/following{/other_user}","gists_url":"https://api.github.com/users/f0o/gists{/gist_id}","starred_url":"https://api.github.com/users/f0o/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/f0o/subscriptions","organizations_url":"https://api.github.com/users/f0o/orgs","repos_url":"https://api.github.com/users/f0o/repos","events_url":"https://api.github.com/users/f0o/events{/privacy}","received_events_url":"https://api.github.com/users/f0o/received_events","type":"User","site_admin":false},"milestone":null,"comments":14,"created_at":"2015-09-17T07:26:38Z","updated_at":"2015-10-16T18:50:34Z","closed_at":"2015-10-16T18:50:34Z","body":"after running my Librenms instance around 8 hours, i recognized that the polling seems stop working again and again with Message \"ERROR: Could not connect to Mysql\".\r\n\r\nReason: ERROR 1040 (08004): Too many connections\r\nLibrenms poller-wrapper (poller.php) is creating 3000 sleeping connection to my Mysql Database like this which doesn't seem not get closed probably:\r\n 3126 | librenms | localhost | librenms | Sleep   |   465 |       | NULL             |    0.000\r\n\r\nA temp workaround for me was, lowering mysql wait_timeout, interactive_timeout but that's surelly no solution but to prevent running out of max connections."}}