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.