If you face the above error in any of your RDS replicas, please follow the below steps. When you face this issue you will also see the lag between your master and replica. The status of the “Replication state” will be in “error” state.

  1. Check the status of the slave by running the below query.
    show slave status\G;
  2. Check for the query which is causing this.
  3. Investigate why this is caused. If that’s not critical run the below query.
    CALL mysql.rds_skip_repl_error;
  4. Goto AWS RDS console and check for the “Replication state“. It should be in “Replicating” state but you will see the lag. Late will come down after some time.
Post Views: 165

Leave a Reply