Bug #44404 creating a cluster tablespace file is in checking permissions state all the time
Submitted: 22 Apr 2009 10:22 Modified: 22 Apr 2009 10:23
Reporter: Oli Sennhauser Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: Disk Data Severity:S3 (Non-critical)
Version:mysql-5.1-telco-6.3 OS:Linux
Assigned to: CPU Architecture:Any
Triage: Triaged: D4 (Minor) / R6 (Needs Assessment) / E6 (Needs Assessment)

[22 Apr 2009 10:22] Oli Sennhauser
Description:
When creating undo log files and tablespace files for disk data cluster tables with show processlist the process is all/most of the time in state: checking permissions.

How to repeat:
mysql> CREATE LOGFILE GROUP lg_PCM ADD UNDOFILE 'undo_0000.dat' INITIAL_SIZE=128M UNDO_BUFFER_SIZE=16M ENGINE=NDB;
mysql> CREATE TABLESPACE ts_CL ADD DATAFILE 'data_cl.0000' USE LOGFILE GROUP lg_PCM INITIAL_SIZE=1G EXTENT_SIZE=1M ENGINE=NDB;

mysql> show processlist
+----+-------------+-----------------+------+---------+------+-----------------------------------+-------------------------------------------------------------------------------+
| Id | User        | Host            | db   | Command | Time | State                             | Info                                                                          |
+----+-------------+-----------------+------+---------+------+-----------------------------------+-------------------------------------------------------------------------------+
| 10 | root        | localhost:60031 | test | Query   |   30 | checking permissions              | ALTER TABLESPACE ts_CL ADD DATAFILE 'data_cl.0002' INITIAL_SIZE=1G ENGINE=NDB |
+----+-------------+-----------------+------+---------+------+-----------------------------------+-------------------------------------------------------------------------------+

Suggested fix:
report an appropriate state like creating file or such.
[30 Apr 2009 13:22] Jonathan Miller
version ->6.3.19/20