| 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.
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;