Re: ERROR 1005 (HY000): Can't create table

[Pete Ditmars]

Some additional information:

There is nothing about a table create failure (or any error) in these:
/var/log/mysqld.log
/var/lib/mysql-cluster/ndb_1_out.log
/var/lib/mysql-cluster/ndb_1_cluster.log
/usr/local/mysql/data/ndb_17_out.log

I wouldn't think I would need to bump up logging levels for this kind of failure, but perhaps so, so any hints on which logging level to bump up to debug to assist us in figuring this out would be appreciated.

[root@pcamn01 ~]# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> ALL REPORT MEMORY
Connected to Management Server at: pcamn01:1186
Node 17: Data usage is 0%(251 32K pages of total 261994)
Node 17: Index usage is 0%(150 32K pages of total 261893)
Node 18: Data usage is 0%(251 32K pages of total 261994)
Node 18: Index usage is 0%(150 32K pages of total 261893)
Node 19: Data usage is 0%(251 32K pages of total 261994)
Node 19: Index usage is 0%(150 32K pages of total 261893)

mysql> select count(*) FROM information_schema.TABLES where ENGINE = 'ndbcluster';
+----------+
| count(*) |
+----------+
| 108 |
+----------+
1 row in set (0.00 sec)

[root@pcamn01 ~]# head -10 /var/lib/mysql-cluster/config.ini
[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=3 # Number of replicas
DataMemory=8192M
MaxNoOfOrderedIndexes=256
MaxNoOfAttributes=500000
MaxNoOfTables=1028

[ndb_mgmd]
# Management process options:


Initially our MaxNoOfTables was 128, but I bumped it to 1028 and I believe the change was successfully taken up base on this in /var/lib/mysql-cluster/ndb_1_cluster.log:

2020-12-21 01:32:12 [MgmtSrvr] INFO -- Detected change of /var/lib/mysql-cluster/config.ini on disk, will try to set it. This is the actual diff:
[ndbd(DB)]
NodeId=18
-MaxNoOfTables=128
+MaxNoOfTables=1028

[ndbd(DB)]
NodeId=19
-MaxNoOfTables=128
+MaxNoOfTables=1028

[ndbd(DB)]
NodeId=17
-MaxNoOfTables=128
+MaxNoOfTables=1028


2020-12-21 01:32:12 [MgmtSrvr] INFO -- Starting configuration change, generation: 1
2020-12-21 01:32:12 [MgmtSrvr] INFO -- Configuration 2 commited
2020-12-21 01:32:12 [MgmtSrvr] INFO -- Config change completed! New generation: 2