MySQL Forums
Forum List  »  NDB clusters

Record too big in NDB engine
Posted by: RAUL ANDRES RODRIGUEZ
Date: October 21, 2019 01:47AM

I recently updated ndb engine version from

$ ndbd -V
MySQL distrib mysql-5.6.29 ndb-7.4.11, for Linux (x86_64)

to

$ ndbd -V
MySQL distrib mysql-8.0.17 ndb-8.0.17-rc, for Linux (x86_64)

Now, I can't create a table with a moderate varchar primary key and a longtext field in ndb engine:

mysql> CREATE TABLE `m` ( `id` varchar(200) NOT NULL, `c` longtext NOT NULL, PRIMARY KEY (`id`)) ENGINE=ndbcluster;
ERROR 1005 (HY000): Can't create table 'm'
mysql> show warnings;
+---------+------+-----------------------------------------+
| Level | Code | Message |
+---------+------+-----------------------------------------+
| Warning | 1296 | Got error 738 'Record too big' from NDB |
| Error | 1005 | Can't create table 'm' |
+---------+------+-----------------------------------------+

I can create the table reducing varchar size up to 13 bytes, or using mediumtext instead of longtext, or using innodb engine.

After the docs, max key length is 3072 bytes, and max record size over 14K, so the table seems to be under those thresholds
Any explanation about the Record too big error?

Thank you in advance

Raul Andres

Options: ReplyQuote


Subject
Views
Written By
Posted
Record too big in NDB engine
328
October 21, 2019 01:47AM
138
October 24, 2019 09:41AM


Sorry, only registered users may post in this forum.

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.