search

github / gh-ost

GitHub's Online Schema-migration Tool for MySQL
MIT License
12.43k stars 1.26k forks source link

running gh-ost on mysql 8.0.32 gets erros #1276

Open spihiker opened 1 year ago

spihiker commented 1 year ago 
 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 commented 1 year ago

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