-
Notifications
You must be signed in to change notification settings - Fork 1.3k
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 Migratingtest_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 ontest_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.