github / github/gh-ost

about connection timed out

Open
#856 5 comments 2 reactions 0 assignees View on GitHub
Dominant language
Go
Stars
13.6k
Forks
1.4k
Avg merge
2h 31m
Merged PRs (30d)
4

Description

> 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?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.