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

running gh-ost on mysql 8.0.32 gets erros #1276

Open
spihiker opened this issue May 8, 2023 · 1 comment
Open

running gh-ost on mysql 8.0.32 gets erros #1276

spihiker opened this issue May 8, 2023 · 1 comment

Comments

@spihiker
Copy link

spihiker commented May 8, 2023

 When change a column data type, can finish the job but get error log.
 Thanks for your help.

gh-ost version:1.1.5
mysql version:8.0.32

Error logs as following:
Copy: 1300000/1300000 100.0%; Applied: 0; Backlog: 0/1000; Time: 1m0s(total), 53s(copy); streamer: binlog.000007:81508511; Lag: 0.23s, HeartbeatLag: 0.11s, State: migrating; ETA: due
2023-05-04 16:06:05 INFO Tables renamed
2023-05-04 16:06:05 INFO Lock & rename duration: 4.449586975s. During this time, queries on user were blocked
[2023/05/04 16:06:05] [info] binlogsyncer.go:164 syncer is closing...
[2023/05/04 16:06:05] [error] binlogsyncer.go:631 connection was bad
2023-05-04 16:06:05 INFO Closed streamer connection. err=
[2023/05/04 16:06:05] [error] binlogstreamer.go:77 close sync with err: Sync was closed
[2023/05/04 16:06:05] [info] binlogsyncer.go:179 syncer is closed
2023-05-04 16:06:05 INFO Dropping table mytest._user_ghc
2023-05-04 16:06:06 INFO Table dropped

@dikang123
Copy link

could you support the table structure & and alter SQL statement @spihiker ??

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

2 participants