Bug #18436 RBR: Replication to partition engine triggers assertion on slave side
| Submitted: | 22 Mar 2006 20:11 | Modified: | 11 Apr 2006 13:27 |
|---|---|---|---|
| Reporter: | Mats Kindahl | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S2 (Serious) |
| Version: | 5.1.8 | OS: | Any (ALL) |
| Assigned to: | Mats Kindahl | CPU Architecture: | Any |
[11 Apr 2006 13:27]
MC Brown
Documented in changelog for 5.1.8. Replication of data stored in a partitioned table would cause slave servers to issue a assertion and terminate. (Bug #18436)
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: Replication to a partition storage engine will trigger an assertion inside the partition engine. How to repeat: CREATE TABLE t1 (id MEDIUMINT NOT NULL, b1 BIT(8), vc VARCHAR(255), bc CHAR(255), d DECIMAL(10,4) DEFAULT 0, f FLOAT DEFAULT 0, total BIGINT UNSIGNED, y YEAR, t DATE) PARTITION BY RANGE (YEAR(t)) (PARTITION p0 VALUES LESS THAN (1901), PARTITION p1 VALUES LESS THAN (1946), PARTITION p2 VALUES LESS THAN (1966), PARTITION p3 VALUES LESS THAN (1986), PARTITION p4 VALUES LESS THAN (2005), PARTITION p5 VALUES LESS THAN MAXVALUE); UPDATE t1 SET b1 = 0, t="2006-02-22" WHERE id = 412;