MySQL Bugs: #20747: In cluster mode, if you have not enough IndexMemory, the system will crash

Bug #20747	In cluster mode, if you have not enough IndexMemory, the system will crash
Submitted:	28 Jun 2006 8:25	Modified:	4 Aug 2006 11:18
Reporter:	Marco Bonfatti	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S1 (Critical)
Version:	5.1.11	OS:	Linux (Linux - Gentoo 2006.0)
Assigned to:		CPU Architecture:	Any

Description:
I bring up a little cluster; I follow the official How-To (chapter 17.3): 2 pc as  data-nodes and 1 pc with the management-server + mysql server.
I under-estimate the index space to 30MB.
I started to fill my db, and all went ok until the db gets full and notice me with the error:
"ERROR 1114 (HY000) at line 555871: The table 'CC_XACTS' is full"

If I try to insert other values or other table, notice me the error:
"ERROR 1005 (HY000) at line 12: Can't create table 'tpcw.CUSTOMER' (errno: 136)"

Then I tried to restart the data node, but every time get me:
"Internal program error (failed ndbrequire) (Internal error, programming
error or missing error message, please report a bug)
Error: 2341"

I tried to re-attach data-node with "--initial", but every time it fails.

The cluster is compromised: the only way to bring-up the cluster, is to restart from zero the data-nodes (delete the data folder and start with the --initial)

How to repeat:
I set in config.ini

DataMemory = 800M
IndexMemory = 30M

and then start to populate the db.

Suggested fix:
Over-estimate the memory for indexes.

Hi,

This should not happen...
Can you please upload error/tracefiles ?
(and possibly your schema)

/Jonas

I've removed all logs... when I'll have enough time, I'll repeat this.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".