We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
I have an issue when running ghost command bynlog sincer just stops unexpectedly and ghost fails.
I can replicate issue on v1.1.5 and v1.1.6
Output on v1.1.5: [2024/03/12 08:32:01] [error] binlogstreamer.go:77 close sync with err: sync is been closing... [2024/03/12 08:32:01] [info] binlogsyncer.go:179 syncer is closed 2024-03-12 08:32:01 ERROR Error 1146: Table 'xxxxx_ghc' doesn't exist
output on v1.1.6: [2024/03/13 10:35:16] [info] binlogsyncer.go:180 syncer is closing... [2024/03/13 10:35:16] [info] binlogsyncer.go:864 kill last connection id 1501 [2024/03/13 10:35:16] [info] binlogsyncer.go:210 syncer is closed 2024-03-13 10:35:16 ERROR Error 1146: Table 'xxxxxx_ghc' doesn't exist
this is command I run: /usr/bin/gh-ost --allow-on-master --assume-master-host=${DB_HOST} --host=${DB_HOST} --database=xxx --port=3306 --user=${DB_USERNAME} --max-lag-millis=1500 --ssl --ssl-allow-insecure --exact-rowcount --concurrent-rowcount --password=${DB_PASSWORD} --table=xxx --alter="xxx" --assume-rbr --default-retries=120 --cut-over=default --postpone-cut-over-flag-file postpone.txt —-verbose —-cunk-size 10000 --dml-batch-size 100 --execute | tee -a gh-ost_run.out
Can you help me how do I troubleshoot this issue?
The text was updated successfully, but these errors were encountered:
No branches or pull requests
I have an issue when running ghost command bynlog sincer just stops unexpectedly and ghost fails.
I can replicate issue on v1.1.5 and v1.1.6
Output on v1.1.5:
[2024/03/12 08:32:01] [error] binlogstreamer.go:77 close sync with err: sync is been closing...
[2024/03/12 08:32:01] [info] binlogsyncer.go:179 syncer is closed
2024-03-12 08:32:01 ERROR Error 1146: Table 'xxxxx_ghc' doesn't exist
Done
output on v1.1.6:
[2024/03/13 10:35:16] [info] binlogsyncer.go:180 syncer is closing...
[2024/03/13 10:35:16] [info] binlogsyncer.go:864 kill last connection id 1501
[2024/03/13 10:35:16] [info] binlogsyncer.go:210 syncer is closed
2024-03-13 10:35:16 ERROR Error 1146: Table 'xxxxxx_ghc' doesn't exist
this is command I run:
/usr/bin/gh-ost
--allow-on-master
--assume-master-host=${DB_HOST}
--host=${DB_HOST}
--database=xxx
--port=3306
--user=${DB_USERNAME}
--max-lag-millis=1500
--ssl
--ssl-allow-insecure
--exact-rowcount
--concurrent-rowcount
--password=${DB_PASSWORD}
--table=xxx
--alter="xxx"
--assume-rbr
--default-retries=120
--cut-over=default
--postpone-cut-over-flag-file postpone.txt
—-verbose
—-cunk-size 10000
--dml-batch-size 100
--execute
| tee -a gh-ost_run.out
Can you help me how do I troubleshoot this issue?
The text was updated successfully, but these errors were encountered: