{"action":"created","issue":{"url":"https://api.github.com/repos/travis-ci/travis-build/issues/431","labels_url":"https://api.github.com/repos/travis-ci/travis-build/issues/431/labels{/name}","comments_url":"https://api.github.com/repos/travis-ci/travis-build/issues/431/comments","events_url":"https://api.github.com/repos/travis-ci/travis-build/issues/431/events","html_url":"https://github.com/travis-ci/travis-build/pull/431","id":69607346,"number":431,"title":"Restart MySQL on each boot","user":{"login":"BanzaiMan","id":25666,"avatar_url":"https://avatars.githubusercontent.com/u/25666?v=3","gravatar_id":"","url":"https://api.github.com/users/BanzaiMan","html_url":"https://github.com/BanzaiMan","followers_url":"https://api.github.com/users/BanzaiMan/followers","following_url":"https://api.github.com/users/BanzaiMan/following{/other_user}","gists_url":"https://api.github.com/users/BanzaiMan/gists{/gist_id}","starred_url":"https://api.github.com/users/BanzaiMan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BanzaiMan/subscriptions","organizations_url":"https://api.github.com/users/BanzaiMan/orgs","repos_url":"https://api.github.com/users/BanzaiMan/repos","events_url":"https://api.github.com/users/BanzaiMan/events{/privacy}","received_events_url":"https://api.github.com/users/BanzaiMan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"BanzaiMan","id":25666,"avatar_url":"https://avatars.githubusercontent.com/u/25666?v=3","gravatar_id":"","url":"https://api.github.com/users/BanzaiMan","html_url":"https://github.com/BanzaiMan","followers_url":"https://api.github.com/users/BanzaiMan/followers","following_url":"https://api.github.com/users/BanzaiMan/following{/other_user}","gists_url":"https://api.github.com/users/BanzaiMan/gists{/gist_id}","starred_url":"https://api.github.com/users/BanzaiMan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BanzaiMan/subscriptions","organizations_url":"https://api.github.com/users/BanzaiMan/orgs","repos_url":"https://api.github.com/users/BanzaiMan/repos","events_url":"https://api.github.com/users/BanzaiMan/events{/privacy}","received_events_url":"https://api.github.com/users/BanzaiMan/received_events","type":"User","site_admin":false},"milestone":null,"comments":4,"created_at":"2015-04-20T15:02:33Z","updated_at":"2015-04-21T00:19:37Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/travis-ci/travis-build/pulls/431","html_url":"https://github.com/travis-ci/travis-build/pull/431","diff_url":"https://github.com/travis-ci/travis-build/pull/431.diff","patch_url":"https://github.com/travis-ci/travis-build/pull/431.patch"},"body":"With the move to MySQL 5.6 packages from mysql.com, we noticed that\r\nMySQL socket (`/var/run/mysqld/mysqld.sock`) is inexplicably lost (sometimes?).\r\nThe process is running, and users can connect with TCP\r\n(e.g., `mysql -h 127.0.0.1`), but connexions over the socket are\r\nunsuccessful, leading to lots of frustration.\r\n\r\nUpon restarting, though, the socket is re-created, and things\r\nwork.\r\n\r\nI have not been able to determine what is removing the socket."},"comment":{"url":"https://api.github.com/repos/travis-ci/travis-build/issues/comments/94598414","html_url":"https://github.com/travis-ci/travis-build/pull/431#issuecomment-94598414","issue_url":"https://api.github.com/repos/travis-ci/travis-build/issues/431","id":94598414,"user":{"login":"BanzaiMan","id":25666,"avatar_url":"https://avatars.githubusercontent.com/u/25666?v=3","gravatar_id":"","url":"https://api.github.com/users/BanzaiMan","html_url":"https://github.com/BanzaiMan","followers_url":"https://api.github.com/users/BanzaiMan/followers","following_url":"https://api.github.com/users/BanzaiMan/following{/other_user}","gists_url":"https://api.github.com/users/BanzaiMan/gists{/gist_id}","starred_url":"https://api.github.com/users/BanzaiMan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BanzaiMan/subscriptions","organizations_url":"https://api.github.com/users/BanzaiMan/orgs","repos_url":"https://api.github.com/users/BanzaiMan/repos","events_url":"https://api.github.com/users/BanzaiMan/events{/privacy}","received_events_url":"https://api.github.com/users/BanzaiMan/received_events","type":"User","site_admin":false},"created_at":"2015-04-21T00:19:37Z","updated_at":"2015-04-21T00:19:37Z","body":"Things that might explain the loss of the socket:\r\n\r\n1. The boot cleanup process in `/tmp`. The socket is in `/var/run`, so this does not apply.\r\n1. SELinux. This is a plain Ubuntu, so this does not apply.\r\n1. The path for the socket is correct; if you restart it, the file is recreated. Furthermore, `/var/run/mysqld/mysqld.sock` shows up in `lsof`, but is not marked DELETED.\r\n1. `/var/run` is a symbolic link to `/run`, which is not a FS mount.\r\n\r\n[This StackOverflow answer](http://askubuntu.com/a/595560) alludes to an issue on Trusty; maybe a similar problem exists for Precise, but I don't really know."}}