gh-ost icon indicating copy to clipboard operation
gh-ost copied to clipboard

running gh-ost on mysql 8.0.32 gets erros

Open spihiker opened this issue 2 years ago • 1 comments

 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

spihiker avatar May 08 '23 07:05 spihiker

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

dikang123 avatar May 22 '23 02:05 dikang123