Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.15-galera
-
None
-
RHEL6
Description
Even under wsrep_osu_method=TOI, alter table TableName exchange partition P1 with table TableName_P1; is not replicated to other nodes in the cluster. The partition was exchanged on the node which issue the command, and have this line in the error log
150124 23:46:42 [ERROR] Transaction not registered for MySQL 2PC, but transaction is active
|
To replicate
CREATE TABLE Temp.T_Test (
|
`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
PRIMARY KEY (`ID`)
|
) ENGINE=InnoDB
|
PARTITION BY RANGE (ID)
|
(PARTITION p10 VALUES LESS THAN (10) ENGINE = InnoDB,
|
PARTITION p20 VALUES LESS THAN (20) ENGINE = InnoDB,
|
PARTITION pMax VALUES LESS THAN MAXVALUE ENGINE = InnoDB) ;
|
 |
INSERT into T_Test (ID) VALUE (9),(19);
|
CREATE table Temp.T_TestP10 like Temp.T_Test;
|
alter table Temp.T_TestP10 remove partitioning;
|
alter table Temp.T_Test exchange partition p10 with table Temp.T_TestP10;
|
select * from Temp.T_Test;
|
On node 1, the result is only one row with value 19, on all other node, the result will have two rows value 9,19.