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.

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.