{"action":"created","issue":{"url":"https://api.github.com/repos/soundcloud/lhm/issues/107","repository_url":"https://api.github.com/repos/soundcloud/lhm","labels_url":"https://api.github.com/repos/soundcloud/lhm/issues/107/labels{/name}","comments_url":"https://api.github.com/repos/soundcloud/lhm/issues/107/comments","events_url":"https://api.github.com/repos/soundcloud/lhm/issues/107/events","html_url":"https://github.com/soundcloud/lhm/issues/107","id":71765630,"number":107,"title":"Handle deadlocks","user":{"login":"avit","id":4278,"avatar_url":"https://avatars.githubusercontent.com/u/4278?v=3","gravatar_id":"","url":"https://api.github.com/users/avit","html_url":"https://github.com/avit","followers_url":"https://api.github.com/users/avit/followers","following_url":"https://api.github.com/users/avit/following{/other_user}","gists_url":"https://api.github.com/users/avit/gists{/gist_id}","starred_url":"https://api.github.com/users/avit/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/avit/subscriptions","organizations_url":"https://api.github.com/users/avit/orgs","repos_url":"https://api.github.com/users/avit/repos","events_url":"https://api.github.com/users/avit/events{/privacy}","received_events_url":"https://api.github.com/users/avit/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-04-29T03:15:10Z","updated_at":"2016-06-09T19:34:56Z","closed_at":null,"body":"While copying data to the table, I experienced a deadlock that aborted the migration halfway through. \r\n\r\nI'm guessing deadlocks happen if the INSERT statement and a trigger both try to touch the same row. Some possible solutions:\r\n\r\n* Add an option for `deadlock_retries: 1` to handle it when the query gets dropped?\r\n* Use a different transaction isolation level for copying?"},"comment":{"url":"https://api.github.com/repos/soundcloud/lhm/issues/comments/225002576","html_url":"https://github.com/soundcloud/lhm/issues/107#issuecomment-225002576","issue_url":"https://api.github.com/repos/soundcloud/lhm/issues/107","id":225002576,"user":{"login":"arthurnn","id":833383,"avatar_url":"https://avatars.githubusercontent.com/u/833383?v=3","gravatar_id":"","url":"https://api.github.com/users/arthurnn","html_url":"https://github.com/arthurnn","followers_url":"https://api.github.com/users/arthurnn/followers","following_url":"https://api.github.com/users/arthurnn/following{/other_user}","gists_url":"https://api.github.com/users/arthurnn/gists{/gist_id}","starred_url":"https://api.github.com/users/arthurnn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/arthurnn/subscriptions","organizations_url":"https://api.github.com/users/arthurnn/orgs","repos_url":"https://api.github.com/users/arthurnn/repos","events_url":"https://api.github.com/users/arthurnn/events{/privacy}","received_events_url":"https://api.github.com/users/arthurnn/received_events","type":"User","site_admin":true},"created_at":"2016-06-09T19:34:56Z","updated_at":"2016-06-09T19:34:56Z","body":"from pt-osc:\r\n```\r\nThe tool retries each operation if these errors occur:\r\n\r\nLock wait timeout (innodb_lock_wait_timeout and lock_wait_timeout)\r\nDeadlock found\r\nQuery is killed (KILL QUERY <thread_id>)\r\nConnection is killed (KILL CONNECTION <thread_id>)\r\nLost connection to MySQL\r\n```\r\n(https://www.percona.com/doc/percona-toolkit/2.2/pt-online-schema-change.html)\r\n\r\nSo, we might wanna retry on all those messages."}}
{"actor":{"display_login":"arthurnn"}}