MySQL Bugs: #37039: backup causes crash for certain table definitions

Bug #37039	backup causes crash for certain table definitions
Submitted:	28 May 2008 14:35	Modified:	30 May 2008 16:48
Reporter:	Jonas Oreland
Status:	Closed
Category:	Server: Cluster	Severity:	S3 (Non-critical)
Version:	telco-6.3..+	OS:	Any
Assigned to:	Jonas Oreland	Target Version:

Description:
Some tables with a specific amount of null values and data
can cause crash when running backup

How to repeat:
.

Suggested fix:
fix computation of maxRecordSize
(patch already written)

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/47191

ChangeSet@1.2614, 2008-05-29 13:30:21+02:00, jonas@perch.ndb.mysql.com +4 -0
  ndb - bug#37039
    certain table/data could cause backup to crash node
    include nullbits in length of mask (READ_PACKED header)

Pushed into 5.1.24-ndb-6.3.15

Just to complete the 'How To Repeat', from test case of Jonas:

mysql> CREATE TABLE t11_c (a int, b00 int null, b01 int null,b02 int null,b03 int
null,b04 int null,b05 int null,b06 int null,b07 int null,b08 int null,b90 int null,b10
int null,b11 int null,b12 int null,b13 int null,b14 int null,b15 int null,b16 int
null,b17 int null,b18 int null,b19 int null,b20 int null,b21 int null,b22 int null,b23
int null,b24 int null,b25 int null,b26 int null,b27 int null,b28 int null,b29 int
null,b30 int null,b31 int null,b32 int null) engine = ndb;
mysql> insert into t11_c values
(1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1);

ndb_mgm> START BACKUP;

Pushed into 5.1.23-ndb-6.4.0

Documented bugfix in the 5.1.24-ndb-6.3.15 changelog as follows:

      Attempting to create a native backup of NDB tables having a large number
      of NULL columns and data could lead to node failures.