---
slug: "aws-rds-mysql-replication-failed"
title: "Recovery of Stopped AWS RDS MySQL Replication"
description: "Restart a halted replication on AWS RDS MySQL. Includes `CHECK TABLE` for MyISAM tables and the skip/resume operations on the replica side."
url: "https://www.ytyng.com/en/blog/aws-rds-mysql-replication-failed"
publish_date: "2017-01-03T12:34:40Z"
created: "2017-01-03T12:34:40Z"
updated: "2026-05-11T13:06:23.719Z"
categories: ["AWS", "MySQL"]
keywords: ""
featured_image_url: "https://media.ytyng.com/resize/20230812/43d02798e6e4479f98d905328c908cfd.png.webp?width=768"
has_video: false
has_music: false
video_urls: []
music_urls: []
lang: "en"
---

# Recovery of Stopped AWS RDS MySQL Replication

<div>Something is wrong with AWS RDS MySQL replication</div>
<div></div>
<div>There is a MyIsam table,</div>
<div>CHECK TABLE xxxx_xxxx;</div>
<div></div>
<div>When I tried</div>
<div></div>
<div>Table    Op    Msg_type    Msg_text</div>
<div>xxxx.<span>xxxx_xxxx</span>    check    error    Corrupt</div>
<div></div>
<div><img alt="" height="77" src="/media/uploads/blog/aws/スクリーンショット_2016-09-13_18.34.00.png" width="418"></div>
<div></div>
<div>The Msg_text says Corrupt. It tells me that this table is corrupted. The master side has no issues.</div>
<div></div>
<div>When I look at the RDS page on the AWS console</div>
<div></div>
<div><img alt="" height="222" src="/media/uploads/blog/aws/スクリーンショット_2016-09-13_18.28.06.png" width="458"></div>
<div></div>
<div>Replication is failing</div>
<div></div>
<div>Looking at SHOW SLAVE STATUS</div>
<div></div>
<pre>{
    "data":
    [
        {
            "Slave_IO_State": "Waiting for master to send event",
            "Master_Host": "10.7.1.169",
            "Master_User": "rdsrepladmin",
            "Master_Port": 3306,
            "Connect_Retry": 60,
            "Master_Log_File": "mysql-bin-changelog.131739",
            "Read_Master_Log_Pos": 743597,
            "Relay_Log_File": "relaylog.000242",
            "Relay_Log_Pos": 496325,
            "Relay_Master_Log_File": "mysql-bin-changelog.131676",
            "Slave_IO_Running": "Yes",
            "Slave_SQL_Running": "No",
            "Replicate_Do_DB": "",
            "Replicate_Ignore_DB": "",
            "Replicate_Do_Table": "",
            "Replicate_Ignore_Table": "mysql.plugin,mysql.rds_monitor,mysql.rds_sysinfo,mysql.rds_replication_status,mysql.rds_history,innodb_memcache.config_options,innodb_memcache.cache_policies",
            "Replicate_Wild_Do_Table": "",
            "Replicate_Wild_Ignore_Table": "",
            "Last_Errno": 1053,
            "Last_Error": "Query partially completed on the master (error on master: 1053) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; . Query: 'UPDATE xxxxx SET xxxxxxxxxxxxxxxxxxx'",
            "Skip_Counter": 0,
            "Exec_Master_Log_Pos": 496152,
            "Relay_Log_Space": 428001772,
            "Until_Condition": "None",
            "Until_Log_File": "",
            "Until_Log_Pos": 0,
            "Master_SSL_Allowed": "No",
            "Master_SSL_CA_File": "",
            "Master_SSL_CA_Path": "",
            "Master_SSL_Cert": "",
            "Master_SSL_Cipher": "",
            "Master_SSL_Key": "",
            "Seconds_Behind_Master": null,
            "Master_SSL_Verify_Server_Cert": "No",
            "Last_IO_Errno": 0,
            "Last_IO_Error": "",
            "Last_SQL_Errno": 1053,
            "Last_SQL_Error": "Query partially completed on the master (error on master: 1053) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; . Query: 'UPDATE xxxxx SET xxxxxxxxxxxxxxxxxxx'",
            "Replicate_Ignore_Server_Ids": "",
            "Master_Server_Id": 1498488124,
            "Master_UUID": "e247ce2a-13ee-11e5-8f81-0adacdd7d587",
            "Master_Info_File": "mysql.slave_master_info",
            "SQL_Delay": 0,
            "SQL_Remaining_Delay": null,
            "Slave_SQL_Running_State": "",
            "Master_Retry_Count": 86400,
            "Master_Bind": "",
            "Last_IO_Error_Timestamp": "",
            "Last_SQL_Error_Timestamp": "160913 09:37:11",
            "Master_SSL_Crl": "",
            "Master_SSL_Crlpath": "",
            "Retrieved_Gtid_Set": "",
            "Executed_Gtid_Set": "",
            "Auto_Position": 0
        }
    ]
}</pre>
<div></div>
<div>It's stuck on a force-stopped query</div>
<div></div>
<div></div>
<pre>
            "Slave_IO_Running": "Yes",
            "Slave_SQL_Running": "No",
</pre>
<div></div>
<pre>SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;</pre>
<div></div>
<div>→ Access Denied!</div>
<div></div>
<div>Cannot recover</div>
<div></div>
<div></div>
<div><a href="http://f-retu.hatenablog.com/entry/2013/11/21/080720" target="_blank">【AWS,RDS,MySQL】How to handle replication errors on RDS (MySQL) read replica - Herohoro Moheji</a></div>
<div></div>
<div>Referring to this</div>
<div></div>
<pre>CALL mysql.rds_skip_repl_error;</pre>
<div></div>
<div></div>
<pre>"Slave_IO_Running": "Yes",
"Slave_SQL_Running": "Yes",
</pre>
<div>Fixed</div>