{"action":"created","issue":{"url":"https://api.github.com/repos/github/gh-ost/issues/150","repository_url":"https://api.github.com/repos/github/gh-ost","labels_url":"https://api.github.com/repos/github/gh-ost/issues/150/labels{/name}","comments_url":"https://api.github.com/repos/github/gh-ost/issues/150/comments","events_url":"https://api.github.com/repos/github/gh-ost/issues/150/events","html_url":"https://github.com/github/gh-ost/issues/150","id":170592435,"number":150,"title":"How to recover from \"ETA: postponing cut-over\" ?","user":{"login":"linwaterbin","id":4126532,"avatar_url":"https://avatars.githubusercontent.com/u/4126532?v=3","gravatar_id":"","url":"https://api.github.com/users/linwaterbin","html_url":"https://github.com/linwaterbin","followers_url":"https://api.github.com/users/linwaterbin/followers","following_url":"https://api.github.com/users/linwaterbin/following{/other_user}","gists_url":"https://api.github.com/users/linwaterbin/gists{/gist_id}","starred_url":"https://api.github.com/users/linwaterbin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/linwaterbin/subscriptions","organizations_url":"https://api.github.com/users/linwaterbin/orgs","repos_url":"https://api.github.com/users/linwaterbin/repos","events_url":"https://api.github.com/users/linwaterbin/events{/privacy}","received_events_url":"https://api.github.com/users/linwaterbin/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2016-08-11T08:18:17Z","updated_at":"2016-08-12T05:54:53Z","closed_at":null,"body":"fisrt, this tool is very wonderful,being full of imagination,thank you a lot;\r\nI test my environment, my table PlayerInventory,which rows have 3 million,size is 30G\r\nwhen gh-ost running, I execute a UPDATA statement, the gh-ost output as following:\r\n\r\n```\r\nCopy: 11241000/299550386 3.8%; Applied: 0; Backlog: 0/100; Time: 5m0s(total), 3m41s(copy); streamer: binlog20000.000052:21082625; ETA: 1h34m28s\r\n2016-08-11 15:49:30 ERROR Error 1205: Lock wait timeout exceeded; try restarting transaction\r\n2016-08-11 15:49:30 ERROR Error 1205: Lock wait timeout exceeded; try restarting transaction\r\n2016-08-11 15:49:30 INFO Row copy complete\r\nCopy: 11241000/299550386 3.8%; Applied: 0; Backlog: 0/100; Time: 5m26s(total), 4m7s(copy); streamer: binlog20000.000052:21091001; ETA: 1h45m49s\r\nCopy: 11241000/299550386 3.8%; Applied: 0; Backlog: 0/100; Time: 5m30s(total), 4m7s(copy); streamer: binlog20000.000052:21092614; ETA: postponing cut-over\r\nCopy: 11241000/299550386 3.8%; Applied: 0; Backlog: 0/100; Time: 5m35s(total), 4m7s(copy); streamer: binlog20000.000052:21094542; ETA: postponing cut-over\r\n```\r\n\r\nnext, has been in the state, that is, \" ETA: postponing cut-over \", never heals,but update already over\r\nhow do I let gh-ost to continue to perform rather than terminate\r\nmy command as follows:\r\n\r\n```\r\n./gh-ost \\\r\n--max-load=Threads_running=25 \\\r\n--critical-load=Threads_running=1000 \\\r\n--chunk-size=1000 \\\r\n--throttle-control-replicas=\"replip\" \\\r\n--max-lag-millis=1500 \\\r\n--user=\"gh\" \\\r\n--password=\"gh123\" \\\r\n--host=\"replip\" \\\r\n--port=20000 \\\r\n--database=\"test\" \\\r\n--table=\"PlayerInventory\" \\\r\n--verbose \\\r\n--alter=\"change orig_source orig_source bigint\" \\\r\n--switch-to-rbr \\\r\n--allow-master-master \\\r\n--cut-over=default \\\r\n--exact-rowcount \\\r\n--default-retries=120 \\\r\n--postpone-cut-over-flag-file=/data/dbbak/gh-ost/ghost.postpone.flag \\\r\n--execute\r\n```\r\n\r\nanyone can help me? thank you before : )\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/github/gh-ost/issues/comments/239366851","html_url":"https://github.com/github/gh-ost/issues/150#issuecomment-239366851","issue_url":"https://api.github.com/repos/github/gh-ost/issues/150","id":239366851,"user":{"login":"shlomi-noach","id":2607934,"avatar_url":"https://avatars.githubusercontent.com/u/2607934?v=3","gravatar_id":"","url":"https://api.github.com/users/shlomi-noach","html_url":"https://github.com/shlomi-noach","followers_url":"https://api.github.com/users/shlomi-noach/followers","following_url":"https://api.github.com/users/shlomi-noach/following{/other_user}","gists_url":"https://api.github.com/users/shlomi-noach/gists{/gist_id}","starred_url":"https://api.github.com/users/shlomi-noach/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shlomi-noach/subscriptions","organizations_url":"https://api.github.com/users/shlomi-noach/orgs","repos_url":"https://api.github.com/users/shlomi-noach/repos","events_url":"https://api.github.com/users/shlomi-noach/events{/privacy}","received_events_url":"https://api.github.com/users/shlomi-noach/received_events","type":"User","site_admin":true},"created_at":"2016-08-12T05:54:53Z","updated_at":"2016-08-12T05:54:53Z","body":"I apologize, I'm not sure I can understand this last statement."}}
{"actor":{"display_login":"shlomi-noach"}}