MySQL :: Re: Can't create table

New Topic

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

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

Can't create table

1296

Maurice Sobiera

April 14, 2021 01:57PM

Re: Can't create table

549

Magnus Blåudd

April 14, 2021 02:51PM

Re: Can't create table

534

Maurice Sobiera

April 15, 2021 03:51AM

Re: Can't create table

564

Mauritz Sundell

April 15, 2021 06:02AM

Re: Can't create table

555

Maurice Sobiera

April 16, 2021 08:01AM

Re: Can't create table

568

Mauritz Sundell

April 16, 2021 11:31AM

Re: Can't create table

457

Maurice Sobiera

April 17, 2021 04:33AM

Re: Can't create table

519

Mauritz Sundell

April 17, 2021 03:29PM

Re: Can't create table

441

Maurice Sobiera

April 28, 2021 10:50AM

Re: Can't create table

498

Mauritz Sundell

April 28, 2021 11:51AM

Re: Can't create table

799

Maurice Sobiera

April 28, 2021 02:18PM

Re: Can't create table

507

Mauritz Sundell

April 28, 2021 02:59PM

Re: Can't create table

482

Maurice Sobiera

April 29, 2021 12:56AM

Re: Can't create table

439

Mauritz Sundell

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.