5.1 transaction replication problem with InnoDBXtraDB

Bug #493863 reported by Arjen Lentz on 2009-12-08
6
This bug affects 1 person
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)

Arjen Lentz (arjen-lentz) wrote :

In 5.0.87 this works fine.

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
Stewart Smith (stewart) wrote :

All development of XtraDB has moved under the Percona Server project - https://launchpad.net/percona-server - If this bug can be reproduced against current Percona Server, please file this bug against percona-server (you can simply do so by using the "Also affects project" link above).

Thanks,
Stewart Smith
Director of Server Development
Percona.

Changed in percona-xtradb:
status: New → Invalid
Kristian Nielsen (knielsen) wrote :

No longer repeatable in MariaDB 5.5.
(There were a bunch of fixes related to mixed myisam/inno replication in 5.5)

Changed in maria:
assignee: Sergey Petrunia (sergefp) → Kristian Nielsen (knielsen)
milestone: none → 5.5
status: Confirmed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.