MySQL Forums
Forum List  »  NDB clusters

Re: ERROR 1005 (HY000): Can't create table
Posted by: Pete Ditmars
Date: December 21, 2020 10:18AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: ERROR 1005 (HY000): Can't create table
360
December 21, 2020 10:18AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.