5.1 transaction replication problem with InnoDBXtraDB
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Medium
|
Kristian Nielsen | ||
MySQL Server |
Unknown
|
Unknown
|
|||
Percona-XtraDB |
Invalid
|
Undecided
|
Unassigned |
Bug Description
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;
+------
| id | active | en_US | email_id | min_resend_hours |
+------
| 1501580 | 1 | OA bombs19 | 13 | NULL |
+------
1 row in set (0.00 sec)
Result on slave:
select * from MailerType;
Empty set (0.00 sec)
Changed in maria: | |
status: | New → Confirmed |
importance: | Undecided → Medium |
assignee: | nobody → Sergey Petrunia (sergefp) |
Changed in maria: | |
milestone: | none → 5.1 |
milestone: | 5.1 → none |
In 5.0.87 this works fine.