github / github/gh-ost

Replication is broken: Slave_IO_Running: No, Slave_SQL_Running: No

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

Description

Good day! gh-ost cannot find the replication master, previously we promoted the slave to the master, that is, if we SHOW SLAVE STATUS on the master, it will show Slave_IO_Running: No, Slave_SQL_Running: No, what should we do in this case?

`./gh-ost --host=master_host --user=test_user --password=????? \
--database=test_db --table=test --assume-rbr --allow-on-master \
--verbose --alter="add test SMALLINT NULL" --chunk-size=3000 --assume-rbr \
--max-load=Threads_connected=20 > gh.log &`

> 2021-06-02 09:08:53 INFO starting gh-ost 1.1.1
> 2021-06-02 09:08:53 INFO Migrating `test_db`.`test`
> 2021-06-02 09:08:53 INFO inspector connection validated on master_host:3306
> 2021-06-02 09:08:53 INFO User has REPLICATION CLIENT, REPLICATION SLAVE privileges, and has ALL privileges on `test_db`.*
> 2021-06-02 09:08:53 INFO binary logs validated on master_host:3306
> 2021-06-02 09:08:53 INFO Inspector initiated on slave_host:3306, version 5.7.32-log
> 2021-06-02 09:08:53 INFO Table found. Engine=InnoDB
> 2021-06-02 09:08:53 INFO Estimated number of rows via EXPLAIN: 75277111
> 2021-06-02 09:08:53 INFO Recursively searching for replication master
> 2021-06-02 09:08:53 INFO Tearing down inspector
> 2021-06-02 09:08:53 FATAL Replication on master_host:3306 is broken: Slave_IO_Running: No, Slave_SQL_Running: No. Please make sure replication runs before using gh-ost.

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.