In this post, you’ll learn more about the MariaDB Error 1788 ER_GTID_MODE_CAN_ONLY_CHANGE_ONE_STEP_AT_A_TIME with the details of the error message and why you receive this error
Maria DB Error Description
MariaDB Error 1788 – ER_GTID_MODE_CAN_ONLY_CHANGE_ONE_STEP_AT_A_TIME with the sqlState HY000
Error Description for the MariaDB Error ER_GTID_MODE_CAN_ONLY_CHANGE_ONE_STEP_AT_A_TIME
The value of @@GLOBAL.GTID_MODE can only change one step at a time: OFF <-> UPGRADE_STEP_1 <-> UPGRADE_STEP_2 <-> ON. Also note that this value must be stepped up or down simultaneously on all servers; see the Manual for instructions.