{"action":"created","issue":{"url":"https://api.github.com/repos/piwik/piwik/issues/7555","labels_url":"https://api.github.com/repos/piwik/piwik/issues/7555/labels{/name}","comments_url":"https://api.github.com/repos/piwik/piwik/issues/7555/comments","events_url":"https://api.github.com/repos/piwik/piwik/issues/7555/events","html_url":"https://github.com/piwik/piwik/issues/7555","id":64728790,"number":7555,"title":"Piwik doesnt closes mysql connections with HHVM","user":{"login":"jg-development","id":6112739,"avatar_url":"https://avatars.githubusercontent.com/u/6112739?v=3","gravatar_id":"","url":"https://api.github.com/users/jg-development","html_url":"https://github.com/jg-development","followers_url":"https://api.github.com/users/jg-development/followers","following_url":"https://api.github.com/users/jg-development/following{/other_user}","gists_url":"https://api.github.com/users/jg-development/gists{/gist_id}","starred_url":"https://api.github.com/users/jg-development/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jg-development/subscriptions","organizations_url":"https://api.github.com/users/jg-development/orgs","repos_url":"https://api.github.com/users/jg-development/repos","events_url":"https://api.github.com/users/jg-development/events{/privacy}","received_events_url":"https://api.github.com/users/jg-development/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/piwik/piwik/labels/Bug","name":"Bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/piwik/piwik/milestones/20","html_url":"https://github.com/piwik/piwik/milestones/Short%20term","labels_url":"https://api.github.com/repos/piwik/piwik/milestones/20/labels","id":713698,"number":20,"title":"Short term","description":"You may expect these tickets to be worked on in the next 3 months.\r\n\r\nOur [roadmap](http://piwik.org/roadmap/) for Piwik project is public. \r\n\r\nMost important tickets are moved from here to the next version's milestone. \r\n","creator":{"login":"mattab","id":466765,"avatar_url":"https://avatars.githubusercontent.com/u/466765?v=3","gravatar_id":"","url":"https://api.github.com/users/mattab","html_url":"https://github.com/mattab","followers_url":"https://api.github.com/users/mattab/followers","following_url":"https://api.github.com/users/mattab/following{/other_user}","gists_url":"https://api.github.com/users/mattab/gists{/gist_id}","starred_url":"https://api.github.com/users/mattab/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mattab/subscriptions","organizations_url":"https://api.github.com/users/mattab/orgs","repos_url":"https://api.github.com/users/mattab/repos","events_url":"https://api.github.com/users/mattab/events{/privacy}","received_events_url":"https://api.github.com/users/mattab/received_events","type":"User","site_admin":false},"open_issues":98,"closed_issues":182,"state":"open","created_at":"2014-06-01T00:00:00Z","updated_at":"2015-05-27T05:09:55Z","due_on":"2015-08-11T12:00:00Z","closed_at":null},"comments":7,"created_at":"2015-03-27T09:44:14Z","updated_at":"2015-06-01T21:22:53Z","closed_at":null,"body":"Hi,\r\nI am using the newst Piwik version 2.12.1 with hhvm 3.6.1.\r\nI have a problem that piwik doesnt close all the mysql connections. Instead it quickly growth\r\nto the current limit of 151.\r\nI can see that with \"show processlist\" in the mysql console.\r\nI switched back to php 5.5.22 and now it works as usual.\r\n\r\nAre there any problem with piwik/mysql connections and hhvm?\r\n\r\n```bash\r\n| 350 | piwik      | localhost:56494 | piwik      | Sleep   |  330 |       | NULL             |\r\n| 351 | piwik      | localhost:56498 | piwik      | Sleep   |  329 |       | NULL             |\r\n| 352 | piwik      | localhost:56502 | piwik      | Sleep   |  329 |       | NULL             |\r\n| 353 | piwik      | localhost:56506 | piwik      | Sleep   |  329 |       | NULL             |\r\n| 354 | piwik      | localhost:56510 | piwik      | Sleep   |  329 |       | NULL             |\r\n| 355 | piwik      | localhost:56514 | piwik      | Sleep   |  329 |       | NULL             |\r\n| 356 | piwik      | localhost:56518 | piwik      | Sleep   |  329 |       | NULL             |\r\n| 357 | piwik      | localhost:56522 | piwik      | Sleep   |  329 |       | NULL             |\r\n| 358 | piwik      | localhost:56527 | piwik      | Sleep   |  329 |       | NULL             |\r\n| 359 | piwik      | localhost:56531 | piwik      | Sleep   |  329 |       | NULL             |\r\n| 360 | piwik      | localhost:56535 | piwik      | Sleep   |  329 |       | NULL             |\r\n| 361 | piwik      | localhost:56541 | piwik      | Sleep   |  329 |       | NULL             |\r\n| 362 | piwik      | localhost:56545 | piwik      | Sleep   |  328 |       | NULL             |\r\n| 363 | piwik      | localhost:56549 | piwik      | Sleep   |  328 |       | NULL             |\r\n| 364 | piwik      | localhost:56553 | piwik      | Sleep   |  328 |       | NULL             |\r\n| 365 | piwik      | localhost:56557 | piwik      | Sleep   |  328 |       | NULL             |\r\n| 366 | piwik      | localhost:56561 | piwik      | Sleep   |  328 |       | NULL             |\r\n| 367 | piwik      | localhost:56565 | piwik      | Sleep   |  328 |       | NULL             |\r\n| 368 | piwik      | localhost:56569 | piwik      | Sleep   |  328 |       | NULL             |\r\n| 369 | piwik      | localhost:56573 | piwik      | Sleep   |  328 |       | NULL             |\r\n| 370 | piwik      | localhost:56577 | piwik      | Sleep   |  328 |       | NULL             |\r\n| 371 | piwik      | localhost:56582 | piwik      | Sleep   |  328 |       | NULL             |\r\n| 372 | piwik      | localhost:56588 | piwik      | Sleep   |  328 |       | NULL             |\r\n| 373 | piwik      | localhost:56597 | piwik      | Sleep   |  327 |       | NULL             |\r\n| 374 | piwik      | localhost:56601 | piwik      | Sleep   |  327 |       | NULL             |\r\n| 375 | piwik      | localhost:56605 | piwik      | Sleep   |  327 |       | NULL             |\r\n| 376 | piwik      | localhost:56609 | piwik      | Sleep   |  327 |       | NULL             |\r\n| 377 | piwik      | localhost:56613 | piwik      | Sleep   |  327 |       | NULL             |\r\n| 378 | piwik      | localhost:56617 | piwik      | Sleep   |  327 |       | NULL             |\r\n| 379 | piwik      | localhost:56621 | piwik      | Sleep   |  326 |       | NULL             |\r\n| 380 | piwik      | localhost:56625 | piwik      | Sleep   |  326 |       | NULL             |\r\n| 381 | piwik      | localhost:56629 | piwik      | Sleep   |  326 |       | NULL             |\r\n| 382 | piwik      | localhost:56633 | piwik      | Sleep   |  326 |       | NULL             |\r\n| 383 | piwik      | localhost:56637 | piwik      | Sleep   |  326 |       | NULL             |\r\n```\r\n\r\nGreetings \r\nJan"},"comment":{"url":"https://api.github.com/repos/piwik/piwik/issues/comments/107716885","html_url":"https://github.com/piwik/piwik/issues/7555#issuecomment-107716885","issue_url":"https://api.github.com/repos/piwik/piwik/issues/7555","id":107716885,"user":{"login":"pasalic","id":12391368,"avatar_url":"https://avatars.githubusercontent.com/u/12391368?v=3","gravatar_id":"","url":"https://api.github.com/users/pasalic","html_url":"https://github.com/pasalic","followers_url":"https://api.github.com/users/pasalic/followers","following_url":"https://api.github.com/users/pasalic/following{/other_user}","gists_url":"https://api.github.com/users/pasalic/gists{/gist_id}","starred_url":"https://api.github.com/users/pasalic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pasalic/subscriptions","organizations_url":"https://api.github.com/users/pasalic/orgs","repos_url":"https://api.github.com/users/pasalic/repos","events_url":"https://api.github.com/users/pasalic/events{/privacy}","received_events_url":"https://api.github.com/users/pasalic/received_events","type":"User","site_admin":false},"created_at":"2015-06-01T21:22:53Z","updated_at":"2015-06-01T21:22:53Z","body":"Hey guys i have a temporary fix. I set the wait_timeout and interactive_timeout for mysql to 300.\r\nI don't know if this is the right way to do it but at least i don't get those pesky db connection errors now. \r\nmysql> SET GLOBAL wait_timeout=300;\r\nmysql> SET GLOBAL interactive_timeout=300;\r\nI also set the SET GLOBAL max_connections = 500; \r\n\r\nreference : http://forums.mysql.com/read.php?22,563616,563830#msg-563830\r\nhttp://club.orbisius.com/howto/web-development/change-mysqls-wait_timeout-interactive_timeout-variables/"}}