• unknown's avatar
    Fix for BUG#16559 "Replication Problems with Non transactional tables inside... · cefc0b6d
    unknown authored
    Fix for BUG#16559 "Replication Problems with Non transactional tables inside an interrupted trans.":
    problem was: when a connection disconnects having an open transaction affecting MyISAM and InnoDB, the ROLLBACK event stored in the binary log
    contained a non-zero error code (1053 because of the disconnection), so when slave applied the transaction, slave complained that its ROLLBACK succeeded
    (error_code=0) while master's had 1053, so slave stopped. But internally generated binlog events such as this ROLLBACK
    should always have 0 as error code, as is true in 4.1 and was accidentally broken in 5.0,
    so that there is no false alarm.
    
    
    mysql-test/r/mix_innodb_myisam_binlog.result:
      result update
    mysql-test/t/mix_innodb_myisam_binlog.test:
      test for BUG#16559
    sql/log.cc:
      Internally generated binlog events should always have an error code of zero (like in 4.1; in 5.0 this was accidentally broken).
    cefc0b6d
mix_innodb_myisam_binlog.result 9.58 KB