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:
None 
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:05] Alfranio Tavares Correia Junior
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;
[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.