MaterializedMySQL: Fix partial transaction processing on MySQL connection loss

MaterializedMySQL: Fix an issue where if the connection to MySQL was lost, only parts of a transaction could be processed. #29837 (Håvard Kvålen).