{"action":"created","issue":{"url":"https://api.github.com/repos/OpenSIPS/opensips/issues/868","repository_url":"https://api.github.com/repos/OpenSIPS/opensips","labels_url":"https://api.github.com/repos/OpenSIPS/opensips/issues/868/labels{/name}","comments_url":"https://api.github.com/repos/OpenSIPS/opensips/issues/868/comments","events_url":"https://api.github.com/repos/OpenSIPS/opensips/issues/868/events","html_url":"https://github.com/OpenSIPS/opensips/issues/868","id":151272626,"number":868,"title":"async: db (mysql) connection lost during mysql query","user":{"login":"ovidiusas","id":4303807,"avatar_url":"https://avatars.githubusercontent.com/u/4303807?v=3","gravatar_id":"","url":"https://api.github.com/users/ovidiusas","html_url":"https://github.com/ovidiusas","followers_url":"https://api.github.com/users/ovidiusas/followers","following_url":"https://api.github.com/users/ovidiusas/following{/other_user}","gists_url":"https://api.github.com/users/ovidiusas/gists{/gist_id}","starred_url":"https://api.github.com/users/ovidiusas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ovidiusas/subscriptions","organizations_url":"https://api.github.com/users/ovidiusas/orgs","repos_url":"https://api.github.com/users/ovidiusas/repos","events_url":"https://api.github.com/users/ovidiusas/events{/privacy}","received_events_url":"https://api.github.com/users/ovidiusas/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"liviuchircu","id":4446084,"avatar_url":"https://avatars.githubusercontent.com/u/4446084?v=3","gravatar_id":"","url":"https://api.github.com/users/liviuchircu","html_url":"https://github.com/liviuchircu","followers_url":"https://api.github.com/users/liviuchircu/followers","following_url":"https://api.github.com/users/liviuchircu/following{/other_user}","gists_url":"https://api.github.com/users/liviuchircu/gists{/gist_id}","starred_url":"https://api.github.com/users/liviuchircu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/liviuchircu/subscriptions","organizations_url":"https://api.github.com/users/liviuchircu/orgs","repos_url":"https://api.github.com/users/liviuchircu/repos","events_url":"https://api.github.com/users/liviuchircu/events{/privacy}","received_events_url":"https://api.github.com/users/liviuchircu/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2016-04-27T00:51:37Z","updated_at":"2016-05-20T15:23:19Z","closed_at":null,"body":"While doing an async mysql query, the following error occurred:\r\n````\r\nERROR:db_mysql:db_mysql_async_raw_resume: error [2013, HY000]: Lost connection to MySQL server during query\r\nERROR:avpops:resume_async_dbquery: async query returned error\r\n```\r\nOn the second call, we got:\r\n````\r\nINFO:db_mysql:switch_state_to_disconnected: disconnect event for 0x7f7e7dbf2ba0\r\nINFO:db_mysql:reset_all_statements: reseting all statements on connection: (0x7f7e7dbb1150) 0x7f7e7dbf2ba0\r\nINFO:db_mysql:connect_with_retry: re-connected successful for 0x7f7e7dbf2ba0\r\n````\r\n\r\nWhen the db connection is lost, opensips should try to re-connect before giving up."},"comment":{"url":"https://api.github.com/repos/OpenSIPS/opensips/issues/comments/220636243","html_url":"https://github.com/OpenSIPS/opensips/issues/868#issuecomment-220636243","issue_url":"https://api.github.com/repos/OpenSIPS/opensips/issues/868","id":220636243,"user":{"login":"ovidiusas","id":4303807,"avatar_url":"https://avatars.githubusercontent.com/u/4303807?v=3","gravatar_id":"","url":"https://api.github.com/users/ovidiusas","html_url":"https://github.com/ovidiusas","followers_url":"https://api.github.com/users/ovidiusas/followers","following_url":"https://api.github.com/users/ovidiusas/following{/other_user}","gists_url":"https://api.github.com/users/ovidiusas/gists{/gist_id}","starred_url":"https://api.github.com/users/ovidiusas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ovidiusas/subscriptions","organizations_url":"https://api.github.com/users/ovidiusas/orgs","repos_url":"https://api.github.com/users/ovidiusas/repos","events_url":"https://api.github.com/users/ovidiusas/events{/privacy}","received_events_url":"https://api.github.com/users/ovidiusas/received_events","type":"User","site_admin":false},"created_at":"2016-05-20T15:23:19Z","updated_at":"2016-05-20T15:23:19Z","body":"We are actively investigating the mysql, but the issue here is that the max_db_retries param has effect for sync queries, but not for async queries."}}
{"actor":{"display_login":"ovidiusas"}}