LP:493863 - 5.1 transaction replication problem with InnoDBXtraDB

5.1.39 with InnoDB/XtraDB

Master/Slave configuration with following table on master:

CREATE TABLE `MailerType` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`active` tinyint(1) unsigned DEFAULT NULL,
`en_US` varchar(300) DEFAULT NULL,
`email_id` int(10) unsigned NOT NULL,
`min_resend_hours` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

On slave the table is converted to InnoDB:

ALTER TABLE MailerType ENGINE=InnoDB;

Run following on master:

SET autocommit=0;
insert into MailerType (active, en_US, email_id, min_resend_hours, id)
values (1, 'OA bombs19', 13, null, 1501580);
commit;
rollback;
SET autocommit=1;

Result on master:

mysql> select * from MailerType;
-------------------------------------------------

-------------------------------------------------

-------------------------------------------------
1 row in set (0.00 sec)

Result on slave:

select * from MailerType;
Empty set (0.00 sec)