Bug #47741 rpl_ndb_extraCol fails in next-mr (mysql-5.1-rep+2) in RBR
| Submitted: | 30 Sep 2009 12:05 | Modified: | 15 Mar 2010 4:49 |
|---|---|---|---|
| Reporter: | Alfranio Tavares Correia Junior | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Row Based Replication ( RBR ) | Severity: | S3 (Non-critical) |
| Version: | 5.1 | OS: | Any |
| Assigned to: | Alfranio Tavares Correia Junior | CPU Architecture: | Any |
| Tags: | ndb, RBR, replication | ||
[30 Sep 2009 12:07]
Alfranio Tavares Correia Junior
The failure does not happen in 5.4.
[30 Sep 2009 14:56]
Alfranio Tavares Correia Junior
Applied the patches in BUG#38173 and BUG#43789 over the mysql-5.1-telco-6.2 and the problem does not happen. It seems that the bug is due to an outdated version of the cluster in the 5.1-bugteam/main as both Innodb and MyIsam work fine on such tree.
[30 Sep 2009 15:37]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/85230 3122 Alfranio Correia 2009-09-30 BUG#47741 rpl_ndb_extraCol fails in next-mr (mysql-5.1-rep+2) in RBR This is a temporary fix. NOTE: Backporting the patch to next-mr.
[27 Oct 2009 9:48]
Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20091027094604-9p7kplu1vd2cvcju) (version source revid:zhenxing.he@sun.com-20091026140226-uhnqejkyqx1aeilc) (merge vers: 6.0.14-alpha) (pib:13)
[28 Oct 2009 6:39]
Jon Stephens
Change in tests only; no end-user cases to document. Closed w/out further action.
[12 Nov 2009 8:16]
Bugs System
Pushed into 5.5.0-beta (revid:alik@sun.com-20091110093229-0bh5hix780cyeicl) (version source revid:alik@sun.com-20091027095744-rf45u3x3q5d1f5y0) (merge vers: 5.5.0-beta) (pib:13)
[12 Nov 2009 12:15]
Jon Stephens
Re-closed w/o further action; see previous comments.
[2 Dec 2009 8:05]
Bugs System
Pushed into 5.1.42 (revid:joro@sun.com-20091202080033-mndu4sxwx19lz2zs) (version source revid:davi.arnaut@sun.com-20091125130912-d7hrln14ef7y5d7i) (merge vers: 5.1.42) (pib:13)
[3 Dec 2009 11:33]
Jon Stephens
Re-closed w/o further action; see previous comments.
[16 Dec 2009 8:41]
Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20091216083311-xorsasf5kopjxshf) (version source revid:alik@sun.com-20091214191830-wznm8245ku8xo702) (merge vers: 6.0.14-alpha) (pib:14)
[16 Dec 2009 8:47]
Bugs System
Pushed into 5.5.0-beta (revid:alik@sun.com-20091216082430-s0gtzibcgkv4pqul) (version source revid:alexey.kopytov@sun.com-20091124083136-iqm136jm31sfdwg3) (merge vers: 5.5.0-beta) (pib:14)
[16 Dec 2009 8:55]
Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20091216083231-rp8ecpnvkkbhtb27) (version source revid:alik@sun.com-20091212203859-fx4rx5uab47wwuzd) (merge vers: 5.6.0-beta) (pib:14)
[16 Dec 2009 15:50]
Jon Stephens
Re-closed w/o further action; see previous comments.
[12 Mar 2010 14:18]
Bugs System
Pushed into 5.1.44-ndb-7.0.14 (revid:jonas@mysql.com-20100312135944-t0z8s1da2orvl66x) (version source revid:jonas@mysql.com-20100312115609-woou0te4a6s4ae9y) (merge vers: 5.1.44-ndb-7.0.14) (pib:16)
[12 Mar 2010 14:33]
Bugs System
Pushed into 5.1.44-ndb-6.2.19 (revid:jonas@mysql.com-20100312134846-tuqhd9w3tv4xgl3d) (version source revid:jonas@mysql.com-20100312060623-mx6407w2vx76h3by) (merge vers: 5.1.44-ndb-6.2.19) (pib:16)
[12 Mar 2010 14:50]
Bugs System
Pushed into 5.1.44-ndb-6.3.33 (revid:jonas@mysql.com-20100312135724-xcw8vw2lu3mijrhn) (version source revid:jonas@mysql.com-20100312103652-snkltsd197l7q2yg) (merge vers: 5.1.44-ndb-6.3.33) (pib:16)
[15 Mar 2010 4:49]
Jon Stephens
Re-closed w/o further action; see previous comments.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.048 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: rpl_ndb_extraCol fails in next-mr (mysql-5.1-rep+2) in RBR with the following message: Could not execute Write_rows event on table test.t9; Got error 839 'Illegal null attribute' from NDB, Error_code: 1296; Got error 839 'Illegal null attribute' from NDBCLUSTER, Error_code: 1296; handler error <unknown>; the event's master log master-bin.000001, end_log_pos 447 How to repeat: -- source include/have_ndb.inc --source include/have_binlog_format_row.inc -- source include/ndb_master-slave.inc let $engine=NDB; connection master; SET SQL_LOG_BIN= 0; eval CREATE TABLE t5 (a INT PRIMARY KEY, b BLOB, c CHAR(5) ) ENGINE=$engine; SET SQL_LOG_BIN= 1; connection slave; STOP SLAVE; --source include/wait_for_slave_to_stop.inc SET sql_mode=''; SHOW VARIABLES LIKE 'sql_mode'; START SLAVE; --source include/wait_for_slave_to_start.inc eval CREATE TABLE t5 (a INT KEY, b BLOB, c CHAR(5), d TIMESTAMP, e INT NOT NULL, f text not null, g text, h blob not null, i blob) ENGINE=$engine; connection master; set @b1 = 'b1b1b1b1'; set @b1 = concat(@b1,@b1); INSERT INTO t5 () VALUES(1,@b1,'Kyle'),(2,@b1,'JOE'),(3,@b1,'QA'); sync_slave_with_master; 090930 14:52:49 [ERROR] Slave SQL: Could not execute Write_rows event on table test.t5; Column 'b' cannot be null, Error_code: 1048; Column 'b' cannot be null, Error_code: 1048; Column 'b' cannot be null, Error_code: 1048; Column 'b' cannot be null, Error_code: 1048; Column 'b' cannot be null, Error_code: 1048; Column 'b' cannot be null, Error_code: 1048; Column 'b' cannot be null, Error_code: 1048; Column 'b' cannot be null, Error_code: 1048; Column 'b' cannot be null, Error_code: 1048; Column 'b' cannot be null, Error_code: 1048; Column 'b' cannot be null, Error_code: 1048; Column 'b' cannot be null, Error_code: 1048;Column 'b' cannot be null, Error_code: 1048; Column 'b' cannot be null, Error_code: 1048; Got error 839 'Illegal null attribute' from NDB, Error_code: 1296;Got error 839 'Illegal null attribute' from NDBCLUSTER, Error_code: 1296; handler error <unknown>; the event's master log master-bin.000001, end_log_pos 855, Error_code: 1296 090930 14:52:49 [Warning] Slave: Column 'b' cannot be null Error_code: 1048 090930 14:52:49 [Warning] Slave: Column 'b' cannot be null Error_code: 1048 090930 14:52:49 [Warning] Slave: Column 'b' cannot be null Error_code: 1048 090930 14:52:49 [Warning] Slave: Column 'b' cannot be null Error_code: 1048 090930 14:52:49 [Warning] Slave: Column 'b' cannot be null Error_code: 1048 090930 14:52:49 [Warning] Slave: Column 'b' cannot be null Error_code: 1048 090930 14:52:49 [Warning] Slave: Column 'b' cannot be null Error_code: 1048 090930 14:52:49 [Warning] Slave: Column 'b' cannot be null Error_code: 1048 eval CREATE TABLE t5 (a INT PRIMARY KEY, b BLOB, c CHAR(5) ) ENGINE=$engine;