Bug #31414 MySQL Cluster 5.1 Row size too large

• Submitted: 4 Oct 2007 23:12
• Modified: 5 Oct 2007 12:12
• Reporter: tom lastname
• Status: Not a Bug
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: 5.1.22 rc1
• OS: Linux (Debian4)
• CPU Architecture: Any
• Tags: ndb cluster row limit

[4 Oct 2007 23:12] tom lastname

Description:
Hello, I'm developing Simple Groupware. Just tested it with a MySQL 5.1 Cluster:
An error message comes up when creating this table:
(when doing it with MyISAM it is ok, NDB fails, without UTF8 it is also ok)

CREATE TABLE simple_offices(
id decimal( 15, 0 ) NOT NULL default '0',
officename varchar( 255 ) default NULL ,
manager varchar( 255 ) default NULL ,
ceo varchar( 255 ) default NULL ,
cio varchar( 255 ) default NULL ,
street varchar( 255 ) default NULL ,
zipcode varchar( 255 ) default NULL ,
city varchar( 255 ) default NULL ,
state varchar( 255 ) default NULL ,
country varchar( 255 ) default NULL ,
description text,
bgcolor varchar( 255 ) default NULL ,
notification text,
created decimal( 10, 0 ) default NULL ,
createdby varchar( 255 ) default NULL ,
lastmodified decimal( 10, 0 ) default NULL ,
lastmodifiedby varchar( 255 ) default NULL ,
dsize decimal( 10, 0 ) default '0',
history text,
folder decimal( 15, 0 ) default NULL ,
PRIMARY KEY ( id ) ,
KEY ind_offices_folder( folder )
) ENGINE = NDBCLUSTER DEFAULT CHARSET = utf8;

MySQL said: Documentation
#1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8052. You have to change some columns to TEXT or BLOBs 

How to repeat:
CREATE TABLE simple_offices(
id decimal( 15, 0 ) NOT NULL default '0',
officename varchar( 255 ) default NULL ,
manager varchar( 255 ) default NULL ,
ceo varchar( 255 ) default NULL ,
cio varchar( 255 ) default NULL ,
street varchar( 255 ) default NULL ,
zipcode varchar( 255 ) default NULL ,
city varchar( 255 ) default NULL ,
state varchar( 255 ) default NULL ,
country varchar( 255 ) default NULL ,
description text,
bgcolor varchar( 255 ) default NULL ,
notification text,
created decimal( 10, 0 ) default NULL ,
createdby varchar( 255 ) default NULL ,
lastmodified decimal( 10, 0 ) default NULL ,
lastmodifiedby varchar( 255 ) default NULL ,
dsize decimal( 10, 0 ) default '0',
history text,
folder decimal( 15, 0 ) default NULL ,
PRIMARY KEY ( id ) ,
KEY ind_offices_folder( folder )
) ENGINE = NDBCLUSTER DEFAULT CHARSET = utf8;

Suggested fix:
Increase to 32K like suggested in:
http://forums.mysql.com/read.php?25,46886,47102

[5 Oct 2007 11:34] Hartmut Holzgraefe

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

[5 Oct 2007 12:12] tom lastname

Thanks for the feedback, the documentation says it will be implemented for "5.1".
Is still in progress or has the roadmap changed for that ?