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: 72

Leave a Reply

This website stores cookies on your computer. These cookies are used to provide a more personalized experience and to track your whereabouts around our website in compliance with the European General Data Protection Regulation. If you decide to to opt-out of any future tracking, a cookie will be setup in your browser to remember this choice for one year.

Accept or Deny