MySQL Forums
Forum List  »  NDB clusters

Re: Can't create table
Posted by: Maurice Sobiera
Date: April 29, 2021 12:56AM

Hi Mauritz,

as far as i see it looks like the Datanode can't allocate the storage


Node 3:


Try 'fdisk --help' for more information.
[root@v220210316867147014 ~]# fdisk -l
Disk /dev/sda: 1.5 TiB, 1610612736000 bytes, 3145728000 sectors
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: gpt
Disk identifier: 744D726A-2AC1-7744-89B3-072E6920B57A

Device Start End Sectors Size Type
/dev/sda1 2048 6143 4096 2M BIOS boot
/dev/sda2 6144 2103295 2097152 1G Linux filesystem
/dev/sda3 2103296 3145727966 3143624671 1.5T Linux filesystem



Node 4:


[root@v220210316867147015 ~]# fdisk -l
Disk /dev/sda: 1.5 TiB, 1610612736000 bytes, 3145728000 sectors
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: gpt
Disk identifier: 744D726A-2AC1-7744-89B3-072E6920B57A

Device Start End Sectors Size Type
/dev/sda1 2048 6143 4096 2M BIOS boot
/dev/sda2 6144 2103295 2097152 1G Linux filesystem
/dev/sda3 2103296 3145727966 3143624671 1.5T Linux filesystem

Node 3:


[root@v220210316867147014 ~]# vi /usr/local/mysql/data/ndb_3_out.log
2021-03-29 14:16:56 [ndbd] INFO -- Angel pid: 9777 started child: 9778
2021-03-29 14:16:56 [ndbd] INFO -- Normal start of data node using checkpoint and log info if existing
2021-03-29 14:16:56 [ndbd] INFO -- Configuration fetched from 'XXX.XXX.XXX.X26:1186', generation: 1
2021-03-29 14:16:56 [ndbd] INFO -- Changing directory to '/usr/local/mysql/data'
2021-03-29 14:16:56 [ndbd] INFO -- SchedulerSpinTimer = 0
2021-03-29 14:16:56 [ndbd] INFO -- AutomaticThreadConfig = 0, NumCPUs = 0
2021-03-29 14:16:56 [ndbd] INFO -- MaxNoOfTriggers set to 1400
NDBMT: non-mt
2021-03-29 14:16:56 [ndbd] INFO -- NDB Cluster -- DB node 3
2021-03-29 14:16:56 [ndbd] INFO -- mysql-8.0.23 ndb-8.0.23 --
2021-03-29 14:16:56 [ndbd] INFO -- Memory Allocation for global memory pools Starting
2021-03-29 14:16:56 [ndbd] INFO -- numa_set_interleave_mask(numa_all_nodes) : no numa support
2021-03-29 14:16:56 [ndbd] INFO -- SharedGlobalMemory set to 128 MB
2021-03-29 14:16:56 [ndbd] INFO -- DataMemory set to 1000000 MB
2021-03-29 14:16:56 [ndbd] INFO -- RedoLogBuffer uses 132 MB
2021-03-29 14:16:56 [ndbd] INFO -- DiskPageBuffer uses 70 MB
2021-03-29 14:16:56 [ndbd] INFO -- SchemaTransactionMemory uses 2 MB
2021-03-29 14:16:56 [ndbd] INFO -- TransactionMemory calculated to 111 MB
2021-03-29 14:16:56 [ndbd] INFO -- Reserved part of TransactionMemory is 28 MB
2021-03-29 14:16:56 [ndbd] INFO -- No Undo log buffer used, will be allocated from TransactionMemory if later defined by command
2021-03-29 14:16:56 [ndbd] INFO -- TransactionMemory can expand and use SharedGlobalMemory if required
2021-03-29 14:16:56 [ndbd] INFO -- QueryMemory can use memory from SharedGlobalMemory until 90% used
2021-03-29 14:16:56 [ndbd] ERROR -- Unable to alloc min memory from OS: min: 1000315Mb allocated: 17835Mb
2021-03-29 14:16:57 [ndbd] INFO -- Node 3: Node shutdown completed, restarting, no start.
2021-03-29 14:16:57 [ndbd] INFO -- Ndb has terminated (pid 9778) restarting
2021-03-29 14:16:57 [ndbd] INFO -- Angel reconnected to 'XXX.XXX.XXX.X26:1186'
2021-03-29 14:17:18 [ndbd] INFO -- Angel reallocated nodeid: 3
2021-03-29 14:17:18 [ndbd] INFO -- Angel pid: 9777 started child: 9781
2021-03-29 14:17:18 [ndbd] INFO -- Normal start of data node using checkpoint and log info if existing
2021-03-29 14:17:18 [ndbd] INFO -- Configuration fetched from 'XXX.XXX.XXX.X26:1186', generation: 1
2021-03-29 14:17:18 [ndbd] INFO -- Changing directory to '/usr/local/mysql/data'
2021-03-29 14:17:18 [ndbd] INFO -- SchedulerSpinTimer = 0
2021-03-29 14:17:18 [ndbd] INFO -- AutomaticThreadConfig = 0, NumCPUs = 0
2021-03-29 14:17:18 [ndbd] INFO -- MaxNoOfTriggers set to 1400
NDBMT: non-mt
2021-03-29 14:17:18 [ndbd] INFO -- NDB Cluster -- DB node 3
2021-03-29 14:17:18 [ndbd] INFO -- mysql-8.0.23 ndb-8.0.23 --
2021-03-29 14:17:18 [ndbd] INFO -- Memory Allocation for global memory pools Starting
2021-03-29 14:17:18 [ndbd] INFO -- numa_set_interleave_mask(numa_all_nodes) : no numa support
2021-03-29 14:17:18 [ndbd] INFO -- SharedGlobalMemory set to 128 MB
2021-03-29 14:17:18 [ndbd] INFO -- DataMemory set to 1000000 MB
2021-03-29 14:17:18 [ndbd] INFO -- RedoLogBuffer uses 132 MB
2021-03-29 14:17:18 [ndbd] INFO -- DiskPageBuffer uses 70 MB
2021-03-29 14:17:18 [ndbd] INFO -- SchemaTransactionMemory uses 2 MB
2021-03-29 14:17:18 [ndbd] INFO -- TransactionMemory calculated to 111 MB
2021-03-29 14:17:18 [ndbd] INFO -- Reserved part of TransactionMemory is 28 MB
2021-03-29 14:17:18 [ndbd] INFO -- No Undo log buffer used, will be allocated from TransactionMemory if later defined by command
2021-03-29 14:17:18 [ndbd] INFO -- TransactionMemory can expand and use SharedGlobalMemory if required
2021-03-29 14:17:18 [ndbd] INFO -- QueryMemory can use memory from SharedGlobalMemory until 90% used
2021-03-29 14:17:18 [ndbd] ERROR -- Unable to alloc min memory from OS: min: 1000315Mb allocated: 17835Mb
2021-03-29 14:17:19 [ndbd] INFO -- Node 3: Node shutdown completed, restarting, no start.
2021-03-29 14:17:19 [ndbd] INFO -- Ndb has terminated (pid 9781) restarting
2021-03-29 14:17:19 [ndbd] INFO -- Angel reconnected to 'XXX.XXX.XXX.X26:1186'
2021-03-29 14:17:40 [ndbd] INFO -- Angel reallocated nodeid: 3
"/usr/local/mysql/data/ndb_3_out.log" 12932L, 1220726C

Node 4:


[root@v220210316867147015 ~]# ndbd
2021-04-28 22:09:00 [ndbd] INFO -- Angel connected to 'XXX.XXX.XXX.X26:1186'
2021-04-28 22:09:00 [ndbd] INFO -- Angel allocated nodeid: 4
[root@v220210316867147015 ~]# ndbd
2021-04-28 22:14:31 [ndbd] INFO -- Angel connected to 'XXX.XXX.XXX.X26:1186'
2021-04-28 22:14:31 [ndbd] INFO -- Angel allocated nodeid: 4
[root@v220210316867147015 ~]# find / -name ndb_4_out.log
/usr/local/mysql/data/ndb_4_out.log
[root@v220210316867147015 ~]# vi /usr/local/mysql/data/ndb_4_out.log
2021-03-29 14:16:58 [ndbd] INFO -- Angel pid: 1377 started child: 1378
2021-03-29 14:16:58 [ndbd] INFO -- Normal start of data node using checkpoint and log info if existing
2021-03-29 14:16:58 [ndbd] INFO -- Configuration fetched from 'XXX.XXX.XXX.X26:1186', generation: 1
2021-03-29 14:16:58 [ndbd] INFO -- Changing directory to '/usr/local/mysql/data'
2021-03-29 14:16:58 [ndbd] INFO -- SchedulerSpinTimer = 0
2021-03-29 14:16:58 [ndbd] INFO -- AutomaticThreadConfig = 0, NumCPUs = 0
2021-03-29 14:16:58 [ndbd] INFO -- MaxNoOfTriggers set to 1400
NDBMT: non-mt
2021-03-29 14:16:58 [ndbd] INFO -- NDB Cluster -- DB node 4
2021-03-29 14:16:58 [ndbd] INFO -- mysql-8.0.23 ndb-8.0.23 --
2021-03-29 14:16:58 [ndbd] INFO -- Memory Allocation for global memory pools Starting
2021-03-29 14:16:58 [ndbd] INFO -- numa_set_interleave_mask(numa_all_nodes) : no numa support
2021-03-29 14:16:58 [ndbd] INFO -- SharedGlobalMemory set to 128 MB
2021-03-29 14:16:58 [ndbd] INFO -- DataMemory set to 1000000 MB
2021-03-29 14:16:58 [ndbd] INFO -- RedoLogBuffer uses 132 MB
2021-03-29 14:16:58 [ndbd] INFO -- DiskPageBuffer uses 70 MB
2021-03-29 14:16:58 [ndbd] INFO -- SchemaTransactionMemory uses 2 MB
2021-03-29 14:16:58 [ndbd] INFO -- TransactionMemory calculated to 111 MB
2021-03-29 14:16:58 [ndbd] INFO -- Reserved part of TransactionMemory is 28 MB
2021-03-29 14:16:58 [ndbd] INFO -- No Undo log buffer used, will be allocated from TransactionMemory if later defined by command
2021-03-29 14:16:58 [ndbd] INFO -- TransactionMemory can expand and use SharedGlobalMemory if required
2021-03-29 14:16:58 [ndbd] INFO -- QueryMemory can use memory from SharedGlobalMemory until 90% used
2021-03-29 14:16:58 [ndbd] ERROR -- Unable to alloc min memory from OS: min: 1000315Mb allocated: 17835Mb
2021-03-29 14:16:58 [ndbd] INFO -- Node 4: Node shutdown completed, restarting, no start.
2021-03-29 14:16:58 [ndbd] INFO -- Ndb has terminated (pid 1378) restarting
2021-03-29 14:16:58 [ndbd] INFO -- Angel reconnected to 'XXX.XXX.XXX.X26:1186'
2021-03-29 14:17:20 [ndbd] INFO -- Angel reallocated nodeid: 4
2021-03-29 14:17:20 [ndbd] INFO -- Angel pid: 1377 started child: 1381
2021-03-29 14:17:20 [ndbd] INFO -- Normal start of data node using checkpoint and log info if existing
2021-03-29 14:17:20 [ndbd] INFO -- Configuration fetched from 'XXX.XXX.XXX.X26:1186', generation: 1
2021-03-29 14:17:20 [ndbd] INFO -- Changing directory to '/usr/local/mysql/data'
2021-03-29 14:17:20 [ndbd] INFO -- SchedulerSpinTimer = 0
2021-03-29 14:17:20 [ndbd] INFO -- AutomaticThreadConfig = 0, NumCPUs = 0
2021-03-29 14:17:20 [ndbd] INFO -- MaxNoOfTriggers set to 1400
NDBMT: non-mt
2021-03-29 14:17:20 [ndbd] INFO -- NDB Cluster -- DB node 4
2021-03-29 14:17:20 [ndbd] INFO -- mysql-8.0.23 ndb-8.0.23 --
2021-03-29 14:17:20 [ndbd] INFO -- Memory Allocation for global memory pools Starting
2021-03-29 14:17:20 [ndbd] INFO -- numa_set_interleave_mask(numa_all_nodes) : no numa support
2021-03-29 14:17:20 [ndbd] INFO -- SharedGlobalMemory set to 128 MB
2021-03-29 14:17:20 [ndbd] INFO -- DataMemory set to 1000000 MB
2021-03-29 14:17:20 [ndbd] INFO -- RedoLogBuffer uses 132 MB
2021-03-29 14:17:20 [ndbd] INFO -- DiskPageBuffer uses 70 MB
2021-03-29 14:17:20 [ndbd] INFO -- SchemaTransactionMemory uses 2 MB
2021-03-29 14:17:20 [ndbd] INFO -- TransactionMemory calculated to 111 MB
2021-03-29 14:17:20 [ndbd] INFO -- Reserved part of TransactionMemory is 28 MB
2021-03-29 14:17:20 [ndbd] INFO -- No Undo log buffer used, will be allocated from TransactionMemory if later defined by command
2021-03-29 14:17:20 [ndbd] INFO -- TransactionMemory can expand and use SharedGlobalMemory if required
2021-03-29 14:17:20 [ndbd] INFO -- QueryMemory can use memory from SharedGlobalMemory until 90% used
2021-03-29 14:17:20 [ndbd] ERROR -- Unable to alloc min memory from OS: min: 1000315Mb allocated: 17835Mb
2021-03-29 14:17:20 [ndbd] INFO -- Node 4: Node shutdown completed, restarting, no start.
2021-03-29 14:17:20 [ndbd] INFO -- Ndb has terminated (pid 1381) restarting
2021-03-29 14:17:20 [ndbd] INFO -- Angel reconnected to 'XXX.XXX.XXX.X26:1186'
2021-03-29 14:17:42 [ndbd] INFO -- Angel reallocated nodeid: 4

Options: ReplyQuote


Subject
Views
Written By
Posted
605
April 14, 2021 01:57PM
234
April 14, 2021 02:51PM
225
April 15, 2021 03:51AM
242
April 15, 2021 06:02AM
242
April 16, 2021 08:01AM
246
April 16, 2021 11:31AM
219
April 17, 2021 04:33AM
221
April 17, 2021 03:29PM
185
April 28, 2021 10:50AM
221
April 28, 2021 11:51AM
319
April 28, 2021 02:18PM
211
April 28, 2021 02:59PM
Re: Can't create table
180
April 29, 2021 12:56AM
164
April 29, 2021 02:49AM


Sorry, you can't reply to this topic. It has been closed.

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.