MariaDB Error 1802 – ER_MTS_CHANGE_MASTER_CANT_RUN_WITH_GAPS

In this post, you’ll learn more about the MariaDB Error 1802 ER_MTS_CHANGE_MASTER_CANT_RUN_WITH_GAPS with the details of the error message and why you receive this error

Maria DB Error Description

MariaDB Error 1802 – ER_MTS_CHANGE_MASTER_CANT_RUN_WITH_GAPS with the sqlState HY000

Error Description for the MariaDB Error ER_MTS_CHANGE_MASTER_CANT_RUN_WITH_GAPS

CHANGE MASTER cannot be executed when the slave was stopped with an error or killed in MTS mode. Consider using RESET SLAVE or START SLAVE UNTIL.