{"action":"created","issue":{"url":"https://api.github.com/repos/jhthorsen/mojo-mysql/issues/20","labels_url":"https://api.github.com/repos/jhthorsen/mojo-mysql/issues/20/labels{/name}","comments_url":"https://api.github.com/repos/jhthorsen/mojo-mysql/issues/20/comments","events_url":"https://api.github.com/repos/jhthorsen/mojo-mysql/issues/20/events","html_url":"https://github.com/jhthorsen/mojo-mysql/issues/20","id":77615474,"number":20,"title":"MySQL server has gone away at Database.pm line 78. ","user":{"login":"d33d","id":5840113,"avatar_url":"https://avatars.githubusercontent.com/u/5840113?v=3","gravatar_id":"","url":"https://api.github.com/users/d33d","html_url":"https://github.com/d33d","followers_url":"https://api.github.com/users/d33d/followers","following_url":"https://api.github.com/users/d33d/following{/other_user}","gists_url":"https://api.github.com/users/d33d/gists{/gist_id}","starred_url":"https://api.github.com/users/d33d/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/d33d/subscriptions","organizations_url":"https://api.github.com/users/d33d/orgs","repos_url":"https://api.github.com/users/d33d/repos","events_url":"https://api.github.com/users/d33d/events{/privacy}","received_events_url":"https://api.github.com/users/d33d/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/jhthorsen/mojo-mysql/labels/invalid","name":"invalid","color":"e6e6e6"}],"state":"closed","locked":false,"assignee":{"login":"harry-bix","id":8404213,"avatar_url":"https://avatars.githubusercontent.com/u/8404213?v=3","gravatar_id":"","url":"https://api.github.com/users/harry-bix","html_url":"https://github.com/harry-bix","followers_url":"https://api.github.com/users/harry-bix/followers","following_url":"https://api.github.com/users/harry-bix/following{/other_user}","gists_url":"https://api.github.com/users/harry-bix/gists{/gist_id}","starred_url":"https://api.github.com/users/harry-bix/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/harry-bix/subscriptions","organizations_url":"https://api.github.com/users/harry-bix/orgs","repos_url":"https://api.github.com/users/harry-bix/repos","events_url":"https://api.github.com/users/harry-bix/events{/privacy}","received_events_url":"https://api.github.com/users/harry-bix/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2015-05-18T11:21:14Z","updated_at":"2015-05-21T05:05:55Z","closed_at":"2015-05-21T05:05:55Z","body":"Hi all,\r\n\r\nI get this (well known) exception: DBD::mysql::st execute failed: MySQL server has gone away at -../Mojo/mysql/Database.pm line 78.\r\n\r\nwhen i catch this exception i disconnect the handle to prevent it from getting cached again (as documentation said) and i submit my query again. \r\n\r\nAnyway, is there a more efficient solution? Is there a feature in the module that help to prevent this issue? Thank you.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/jhthorsen/mojo-mysql/issues/comments/104136582","html_url":"https://github.com/jhthorsen/mojo-mysql/issues/20#issuecomment-104136582","issue_url":"https://api.github.com/repos/jhthorsen/mojo-mysql/issues/20","id":104136582,"user":{"login":"harry-bix","id":8404213,"avatar_url":"https://avatars.githubusercontent.com/u/8404213?v=3","gravatar_id":"","url":"https://api.github.com/users/harry-bix","html_url":"https://github.com/harry-bix","followers_url":"https://api.github.com/users/harry-bix/followers","following_url":"https://api.github.com/users/harry-bix/following{/other_user}","gists_url":"https://api.github.com/users/harry-bix/gists{/gist_id}","starred_url":"https://api.github.com/users/harry-bix/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/harry-bix/subscriptions","organizations_url":"https://api.github.com/users/harry-bix/orgs","repos_url":"https://api.github.com/users/harry-bix/repos","events_url":"https://api.github.com/users/harry-bix/events{/privacy}","received_events_url":"https://api.github.com/users/harry-bix/received_events","type":"User","site_admin":false},"created_at":"2015-05-21T05:05:55Z","updated_at":"2015-05-21T05:05:55Z","body":"You can see all the reasons for **MySQL server has gone away** error at https://dev.mysql.com/doc/refman/5.0/en/gone-away.html.\r\nThe most common reasons are: using a stale handle or connectivity problem.\r\n\r\nWhen you catch this exception you don't have to explicitly disconnect the handle. Mojo::mysql will not cache it."}}