Skip to content

Replication is broken: Slave_IO_Running: No, Slave_SQL_Running: No #983

@artem-dronov

Description

@artem-dronov

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions