Replication is broken: Slave_IO_Running: No, Slave_SQL_Running: No
- 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
Assessment
This issue has not been assessed yet.