Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

FATAL ERROR 1105 (HY000): Failed to register slave: too long 'report-host' #734

Open
ealter opened this issue May 7, 2019 · 2 comments
Open

Comments

@ealter
Copy link
Contributor

ealter commented May 7, 2019

I have been running into this issue when running gh-ost inside of some of our docker containers. When the hostname of the docker container is at least 61 characters in length, I get the following error when trying to run gh-ost.

$ cat /tmp/ghost_user.cnf
[client]
user = ghost
$ /usr/bin/gh-ost --database yelp_pushplan_execution --table pushplan_run --alter ENGINE=InnoDB --conf /tmp/ghost_user.cnf --host xx.xx.xx.xx --chunk-size 500 --force-table-names 1557255792_pushplan_run --assume-rbr
2019/05/07 20:20:05 binlogsyncer.go:79: [info] create BinlogSyncer with config {99999 mysql 10.121.133.170 3306 ghost   false false <nil>}
2019/05/07 20:20:05 binlogsyncer.go:246: [info] begin to sync binlog from position (mysql-bin.000008, 951800672)
2019/05/07 20:20:05 binlogsyncer.go:139: [info] register slave for master server 10.121.133.170:3306
2019-05-07 20:20:05 FATAL ERROR 1105 (HY000): Failed to register slave: too long 'report-host'

The docker container is running on Ubuntu Bionic.

When I specified --hostname when creating the same docker container to be 61 characters instead, gh-ost ran without any issues.

The error message comes from https://github.com/mysql/mysql-server/blob/124c7ab1d6f914637521fd4463a993aa73403513/sql/rpl_master.cc#L161 and it looks like hostname is chosen from https://github.com/siddontang/go-mysql/blob/master/replication/binlogsyncer.go#L495

Let me know if you need any other information to reproduce this.

@shlomi-noach
Copy link
Contributor

Thank you for investigating! I'd say this is an issue for https://github.com/siddontang/go-mysql ; fixing it in gh-ost is probably not the best idea.

@ealter
Copy link
Contributor Author

ealter commented May 9, 2019

Sounds good. I filed go-mysql-org/go-mysql#388

ealter added a commit to ealter/paasta that referenced this issue May 9, 2019
Internal tracking ticket: PAASTA-15442

This will enable us to workaround
github/gh-ost#734
# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants