MySQL Bugs: #32869: creating ndb table is too slow!

Bug #32869	creating ndb table is too slow!
Submitted:	30 Nov 2007 10:07	Modified:	4 Dec 2007 2:21
Reporter:	li david	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S2 (Serious)
Version:	5.1.22RC	OS:	Linux (redhat as4)
Assigned to:		CPU Architecture:	Any

Description:
mysql> create  table testndb(id int) engine=ndb;
Query OK, 0 rows affected (2 min 0.68 sec)
There are lots of the following messages when excuting the above statement.
out of order bucket: 1  gci: 5941  m_latestGCI: 5939
out of order bucket: 1  gci: 5941  m_latestGCI: 5939
out of order bucket: 2  gci: 5942  m_latestGCI: 5939
out of order bucket: 2  gci: 5942  m_latestGCI: 5939
out of order bucket: 3  gci: 5943  m_latestGCI: 5939
out of order bucket: 3  gci: 5943  m_latestGCI: 5939
out of order bucket: 0  gci: 5944  m_latestGCI: 5939
out of order bucket: 0  gci: 5944  m_latestGCI: 5939
out of order bucket: 1  gci: 5945  m_latestGCI: 5939
out of order bucket: 1  gci: 5945  m_latestGCI: 5939
out of order bucket: 2  gci: 5946  m_latestGCI: 5939
out of order bucket: 2  gci: 5946  m_latestGCI: 5939
out of order bucket: 3  gci: 5947  m_latestGCI: 5939
out of order bucket: 3  gci: 5947  m_latestGCI: 5939
out of order bucket: 0  gci: 5948  m_latestGCI: 5939
out of order bucket: 0  gci: 5948  m_latestGCI: 5939
out of order bucket: 1  gci: 5949  m_latestGCI: 5939
out of order bucket: 1  gci: 5949  m_latestGCI: 5939
out of order bucket: 2  gci: 5950  m_latestGCI: 5939
out of order bucket: 2  gci: 5950  m_latestGCI: 5939
out of order bucket: 3  gci: 5951  m_latestGCI: 5939
out of order bucket: 3  gci: 5951  m_latestGCI: 5939

How to repeat:
mysql> create  table testndb(id int) engine=ndb;

Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php

To handle cluster bugs we need to know at least the cluster configuration,
usually also the complete cluster logs (you can use the ndb_error_reporter
tool from our distribution to automatically collect these as a single tarball).

For the problem you reported here we'd also like to know whether this was 
a fresh cluster setup or one already populated with data and/or handling query traffic ...

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

mangement node config:
[NDBD DEFAULT]
NoOfReplicas=2   
DataMemory=800M    
IndexMemory=180M  
[TCP DEFAULT]
portnumber=2202  
[NDB_MGMD]
hostname=10.11.36.20           
datadir=/var/lib/mysql-cluster 
[NDBD]                             
hostname=10.11.54.190         
datadir=/slave/ndb_data  
[NDBD]
hostname=10.11.54.192         
datadir=/home/ndb_data   
[MYSQLD]
hostname=10.11.36.21
data node config:
[MYSQLD]
ndbcluster                     
ndb-connectstring=10.11.36.20  
[MYSQL_CLUSTER]
ndb-connectstring=10.11.36.20 
when creating cluster table,it will spent long time and there are lots of following messages in sql node.
But if create other engine type table ,it is very quick.
out of order bucket: 1  gci: 5973  m_latestGCI: 5939
out of order bucket: 2  gci: 5974  m_latestGCI: 5939
out of order bucket: 2  gci: 5974  m_latestGCI: 5939
out of order bucket: 3  gci: 5975  m_latestGCI: 5939
out of order bucket: 3  gci: 5975  m_latestGCI: 5939
out of order bucket: 0  gci: 5976  m_latestGCI: 5939
out of order bucket: 0  gci: 5976  m_latestGCI: 5939
out of order bucket: 1  gci: 5977  m_latestGCI: 5939
out of order bucket: 1  gci: 5977  m_latestGCI: 5939
out of order bucket: 2  gci: 5978  m_latestGCI: 5939
out of order bucket: 2  gci: 5978  m_latestGCI: 5939 
out of order bucket: 3  gci: 5979  m_latestGCI: 5939
out of order bucket: 3  gci: 5979  m_latestGCI: 5939
out of order bucket: 0  gci: 5980  m_latestGCI: 5939
out of order bucket: 0  gci: 5980  m_latestGCI: 5939
out of order bucket: 1  gci: 5981  m_latestGCI: 5939
out of order bucket: 1  gci: 5981  m_latestGCI: 5939
out of order bucket: 2  gci: 5982  m_latestGCI: 5939
out of order bucket: 2  gci: 5982  m_latestGCI: 5939