search

github / gh-ost

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

about connection timed out #856

Open zhangcl52 opened 4 years ago

zhangcl52 commented 4 years ago

mysql:5.6 gh-ost:v1.0.49

gh-ost -user='XXX' -password='XXX' -host='XXX' -database='XXX' -table='XXX' -alter="add index test_index(test)" -allow-on-master -execute -aliyun-rds -assume-rbr -verbose -debug

2020-06-23 02:20:55 INFO starting gh-ost 1.0.49
2020-06-23 02:20:55 INFO Migrating `XXX`.`XXX`
2020-06-23 02:20:55 INFO connection validated on XXX:3306
2020-06-23 02:20:55 INFO User has REPLICATION CLIENT, REPLICATION SLAVE privileges, and has ALL privileges on `XXX`.*
2020-06-23 02:20:55 INFO binary logs validated on XXX:3306
2020-06-23 02:20:55 INFO Inspector initiated on XXX, version 5.6.16-log
2020-06-23 02:20:55 INFO Table found. Engine=InnoDB
2020-06-23 02:20:55 DEBUG Estimated number of rows via STATUS: 65591
2020-06-23 02:20:55 DEBUG Validated no foreign keys exist on table
2020-06-23 02:20:55 DEBUG Validated no triggers exist on table
2020-06-23 02:20:55 INFO Estimated number of rows via EXPLAIN: 65591
2020-06-23 02:20:55 DEBUG Potential unique keys in XXX: [PRIMARY: [id]; has nullable: false]
2020-06-23 02:20:55 INFO Recursively searching for replication master
2020-06-23 02:20:55 DEBUG Looking for master on XXX:3306
2020-06-23 02:20:55 DEBUG Master of XXX:3306 is 11.216.241.93:3040
2020-06-23 02:20:55 DEBUG Looking for master on 11.216.241.93:3040
[mysql] 2020/06/23 02:23:02 connector.go:48: net.Error from Dial()': dial tcp 11.216.241.93:3040: connect: connection timed out
[mysql] 2020/06/23 02:25:10 connector.go:48: net.Error from Dial()': dial tcp 11.216.241.93:3040: connect: connection timed out
[mysql] 2020/06/23 02:27:17 connector.go:48: net.Error from Dial()': dial tcp 11.216.241.93:3040: connect: connection timed out
2020-06-23 02:27:17 ERROR driver: bad connection
2020-06-23 02:27:17 INFO Tearing down inspector
2020-06-23 02:27:17 FATAL driver: bad connection

why there is an ip 11.216.241.93?

acenazriel0108 commented 4 years ago

gh-ost -user='XXX' -password='XXX' -host='XXX' -database='XXX' -table='XXX' -alter="add index test_index(test)" -allow-on-master -execute -aliyun-rds -assume-rbr -verbose -debug

shlomi-noach commented 4 years ago

why there is an ip 11.216.241.93?

The logs say:

2020-06-23 02:20:55 DEBUG Master of XXX:3306 is 11.216.241.93:3040

Do you know otherwise? More details would help.

ruiaylin commented 4 years ago

@shlomi-noach when you have time, Pls check the enhancements（ #854 ， #855 ）

shlomi-noach commented 4 years ago

@ruiaylin your comment is unrelated to this issue, correct? At any case, please be advised I'm not a maintainer of gh-ost at this time.

ruiaylin commented 4 years ago

@ruiaylin your comment is unrelated to this issue, correct? At any case, please be advised I'm not a maintainer of gh-ost at this time.

Yeah ， I got it 。