Skip to content
New issue

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

binlog syncer closes unexpectedly #1397

Open
Tracked by #1400
DevMasterSoonToBe opened this issue Mar 13, 2024 · 0 comments
Open
Tracked by #1400

binlog syncer closes unexpectedly #1397

DevMasterSoonToBe opened this issue Mar 13, 2024 · 0 comments

Comments

@DevMasterSoonToBe
Copy link

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?

@ramshad-sha ramshad-sha mentioned this issue Mar 25, 2024
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant