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:
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

[28 Jun 2006 8:25] Marco Bonfatti
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.
[28 Jun 2006 8:40] Jonas Oreland

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

[28 Jun 2006 13:04] Marco Bonfatti
I've removed all logs... when I'll have enough time, I'll repeat this.
[4 Aug 2006 23:00] Bugs System
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".