Slave_IO_Running: No, Slave_SQL_Running: No. Please make sure replication runs before using gh-ost.

[yuexiaofengqing]

描述
当我们今天调用时，前边几个调用正常，后边几个调用遇到了error：
level=error msg="Replication on 121.37.129.7:3306 is broken: Slave_IO_Running: No, Slave_SQL_Running: No. Please make sure replication runs before using gh-ost." file=osc.go func=mysqlExecuteAlterTableGhost line=771
所有调用的目标数据库实例是同一个，但是库名和SQL内容不一样。请问是什么原因导致的出现此报错？
Note：华为云RDS的show slave status;查看到的Slave_IO_Running: No, Slave_SQL_Running: No.一直是这个状态。

重现
无法重现

环境

• 数据库: 华为云 RDS for MySQL
• 版本: 5.7.44

日志
time="2024/05/14 15:21:31.993" level=error msg="con:11207 解析失败! line 1 column 25 near "fauth" " file=session_inception.go func=executeInc line=219
time="2024/05/14 15:21:31.993" level=error msg=" fauth" file=session_inception.go func=executeInc line=220
time="2024/05/14 15:21:31.993" level=info msg="[GENERAL_LOG] con:11207 user:root@127.0.0.1 sql:/--user=dbafabu;--password=;--host=121.37.129.7;--check=1;--port=3306;--real_row_count=true;--trans=1000;/ inception_magic_start; fauth; use fauth;ALTER TABLE manual_auth ADD INDEX IDX_CREATETIME(createTime) USING BTREE, ADD INDEX IDX_AUDITOR(auditor) USING BTREE;; inception_magic_commit; " file=session.go func=logQuery line=1610
time="2024/05/14 15:21:31.993" level=info msg="con:11207 close connection" file=server.go func=func1 line=321
time="2024/05/14 15:21:31.998" level=info msg="con:11208 new connection 127.0.0.1:36420" file=server.go func=onConn line=319
time="2024/05/14 15:21:31.998" level=info msg="[GENERAL_LOG] con:11208 user:root@127.0.0.1 sql:SET AUTOCOMMIT = 0" file=session.go func=logQuery line=1610
time="2024/05/14 15:21:32.004" level=info msg="con:11209 new connection 127.0.0.1:36426" file=server.go func=onConn line=319
time="2024/05/14 15:21:32.005" level=info msg="[GENERAL_LOG] con:11209 user:root@127.0.0.1 sql:SET AUTOCOMMIT = 0" file=session.go func=logQuery line=1610
time="2024/05/14 15:21:32.027" level=error msg="con:11208 解析失败! line 1 column 23 near "ecs" " file=session_inception.go func=executeInc line=219
time="2024/05/14 15:21:32.027" level=error msg=" ecs" file=session_inception.go func=executeInc line=220
time="2024/05/14 15:21:32.027" level=info msg="[GENERAL_LOG] con:11208 user:root@127.0.0.1 sql:/--user=dbafabu;--password=;--host=121.37.129.7;--check=1;--port=3306;--real_row_count=true;--trans=1000;/ inception_magic_start; ecs; use ecs;CREATE INDEX IDX_CONTRACTID USING BTREE ON sign_record (contractId);; inception_magic_commit; " file=session.go func=logQuery line=1610
time="2024/05/14 15:21:32.027" level=info msg="con:11208 close connection" file=server.go func=func1 line=321
time="2024/05/14 15:21:32.038" level=info msg="con:11210 new connection 127.0.0.1:36438" file=server.go func=onConn line=319
time="2024/05/14 15:21:32.038" level=info msg="[GENERAL_LOG] con:11210 user:root@127.0.0.1 sql:SET AUTOCOMMIT = 0" file=session.go func=logQuery line=1610
time="2024/05/14 15:21:32.061" level=info msg="con:11209 use gh-ost: ALTER TABLE manual_auth\nADD INDEX IDX_CREATETIME(createTime) USING BTREE,\nADD INDEX IDX_AUDITOR(auditor) USING BTREE" file=session_inception.go func=executeRemoteStatement line=1449
time="2024/05/14 15:21:32.062" level=info msg="Migrating fauth.manual_auth" file=migrator.go func=Migrate line=356
time="2024/05/14 15:21:32.078" level=info msg="connection validated on 121.37.129.7:3306" file=utils.go func=ValidateConnection line=89
time="2024/05/14 15:21:32.082" level=info msg="User has REPLICATION CLIENT, REPLICATION SLAVE privileges, and has ALL privileges on fauth." file=inspect.go func=validateGrants line=261
time="2024/05/14 15:21:32.086" level=info msg="binary logs validated on 121.37.129.7:3306" file=inspect.go func=validateBinlogs line=364
time="2024/05/14 15:21:32.086" level=info msg="Inspector initiated on host-172-16-16-20:3306, version 5.7.44-240100-log" file=inspect.go func=InitDBConnections line=72
time="2024/05/14 15:21:32.088" level=info msg="Table found. Engine=InnoDB" file=inspect.go func=validateTable line=422
time="2024/05/14 15:21:32.088" level=warning msg="--skip-foreign-key-checks provided: will not check for foreign keys" file=inspect.go func=validateTableForeignKeys line=430
time="2024/05/14 15:21:32.096" level=info msg="Estimated number of rows via EXPLAIN: 36727" file=inspect.go func=estimateTableRowsViaExplain line=531
time="2024/05/14 15:21:32.102" level=info msg="Recursively searching for replication master" file=inspect.go func=getMasterConnectionConfig line=768
time="2024/05/14 15:21:32.113" level=info msg="Tearing down inspector" file=migrator.go func=teardown line=1384
time="2024/05/14 15:21:32.113" level=error msg="Replication on 121.37.129.7:3306 is broken: Slave_IO_Running: No, Slave_SQL_Running: No. Please make sure replication runs before using gh-ost." file=osc.go func=mysqlExecuteAlterTableGhost line=771
time="2024/05/14 15:21:32.115" level=info msg="[GENERAL_LOG] con:11209 user:root@127.0.0.1 sql:/--user=dbafabu;--password=********;--host=121.37.129.7;--execute=1;--port=3306;--real_row_count=true;--trans=1000;/ inception_magic_start; use fauth; ALTER TABLE manual_auth ADD INDEX IDX_CREATETIME(createTime) USING BTREE, ADD INDEX IDX_AUDITOR(auditor) USING BTREE; inception_magic_commit; " file=session.go func=logQuery line=1610
time="2024/05/14 15:21:32.121" level=info msg="con:11209 close connection" file=server.go func=func1 line=321

[zmix999]

这格式有问题吧，inception_magic_start; fauth; use fauth;
正常是inception_magic_start;use db1;

[yuexiaofengqing]

这个格式不影响，因为前面的几个也是这种格式，但是执行成功了。

[zmix999]

inception_magic_start;
fauth;
use fauth;
ALTER TABLE manual_auth ADD INDEX IDX_CREATETIME(createTime) USING BTREE, ADD INDEX IDX_AUDITOR(auditor) USING BTREE;;
inception_magic_commit;
这种格式语法都校验不通过，你能执行成功？