MySQL Cluster Out of fragment records (increase

MySQL Cluster Out of fragment records (increase

am 24.06.2010 14:30:31 von Manasi Save

--=_52zgi8g4d8g0
Content-Type: text/plain;
charset=UTF-8
Content-Description: Plaintext Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit

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


--=_52zgi8g4d8g0
Content-Type: multipart/related;
boundary="=_5d6lzz60qk1s";
start="5d7nxeae2v40@mail.artificialmachines.com"
Content-Transfer-Encoding: 7bit

This message is in MIME format.

--=_5d6lzz60qk1s
Content-Type: text/html;
charset=UTF-8
Content-Description: HTML Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Content-ID: 5d7nxeae2v40@mail.artificialmachines.com

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



--=_5d6lzz60qk1s--

--=_52zgi8g4d8g0--