OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
MySQL Cluster Out of fragment records (increase MaxNoOfOrderedIndexes)

From: Manasi Save (manasi.saveartificialmachines.com)
Date: Thu Jun 24 2010 - 07:30:31 CDT

Dear All,

I want to add one column in my existing NDB table. While adding column in to the table I am getting this error:-

| Level | Code | Message
Error | 1296 | Got error 904 'Out of fragment records (increase MaxNoOfOrderedIndexes)' from NDB |
| Error | 1005 | Can't create table 'ChitMeRegistration.User_1' (errno: 136)

Whereas my ndb_mgm - is showing me only

Node 3: Index usage is 2%(376 8K pages of total 16416)
Node 3: Index usage is 2%(392 8K pages of total 16416)
Node 3: Data usage is 1%(800 32K pages of total 40960)
Node 4: Index usage is 2%(366 8K pages of total 16416)
Node 4: Index usage is 2%(382 8K pages of total 16416)
Node 4: Data usage is 1%(800 32K pages of total 40960)

But still I am getting this error. Can anyone help me understanding how should I go about this error. As I have only few hundred records in my table and still i m getting this error.

Thanks in advance.

--
Regards,
 Manasi Save