MySQL Forums
Forum List  »  NDB clusters

Re: I help with finding a bug in NDBCluster 7.5.11
Posted by: Nimbi lin
Date: November 13, 2018 06:15AM

the above error is also because I change system conf file of config.ini as https://forums.mysql.com/read.php?25,614127,614164,quote=1#REPLY said:
-TimeBetweenWatchDogCheck=6000
+TimeBetweenWatchDogCheck=60000
-TransactionDeadlockDetectionTimeout=1200
+TransactionDeadlockDetectionTimeout=5000
-LcpScanProgressTimeout=60
+LcpScanProgressTimeout=300

but when I restart other data node 23,
I get another errors of as below:
2018-11-13 19:28:06 [ndbd] INFO -- Restart recreating table with id = 985
error: [ code: 1509 line: 24276 node: 23 count: 1 status: 0 key: 0 name: '' ]
2018-11-13 19:28:06 [ndbd] INFO -- Failed to restore schema during restart, error 1509.
2018-11-13 19:28:06 [ndbd] INFO -- DBDICT (Line: 4807) 0x00000002
2018-11-13 19:28:06 [ndbd] INFO -- Error handler shutting down system
2018-11-13 19:28:06 [ndbd] INFO -- Error handler shutdown completed - exiting
2018-11-13 19:28:06 [ndbd] ALERT -- Node 23: Forced node shutdown completed. Occured during startphase 4. Caused by error 2355: 'Failure to restore schema(Resource configuration error). Permanent error, external action needed'.

The only left data node failed to start in a 2-data nodes cluster, does it mean the cluster totally crashed? cause I couldn't find a solution online on Error 1509.

My YHconfig.iniLogConcur is as below:


[NDBD DEFAULT]
#1: 表示只有一份数据,但是分成n块分别存储在n个数据节点上。2:数据被分成n/2块,每块数据都有2个备份,这样即使有任意一个节点发生故障,只要它的备份节点正常,系统就可以正常运行
NoOfReplicas=2
#以下参数都可再优化
DataDir=/usr/local/mysqlLinJiaXin/ndbdata
DataMemory=8000M
IndexMemory=1000M
##BackupMemory: 64M
##ljx新增
#add 1113
#TimeBetweenWatchDogCheck=60000
#TransactionDeadlockDetectionTimeout=5000
#LcpScanProgressTimeout=328
#1110 ChaYiYiBiaoZheng
TimeBetweenLocalCheckpoints=10
#not work NoOfFragmentLogFiles=32
#ok MaxNoOfExecutionThreads=6
MaxNoOfExecutionThreads=10
DiskPageBufferMemory=160M
BackupDataDir=/usr/local/mysqlLinJiaXin/ndbBack
BackupDataBufferSize=160M
BackupLogBufferSize=32M
BackupMemory=192M
BackupWriteSize=2048K
BackupMaxWriteSize=8M
LockPagesInMainMemory=0
#MHX LockExecuteThreadToCPU=0
#MHX LockMaintThreadsToCPU=1
RealtimeScheduler=1
#1106Change to smaller than 851798
MaxNoOfConcurrentTransactions: 158098
#1106Change to smaller than 8517980
MaxNoOfConcurrentOperations: 180980
SchedulerExecutionTimer=10
SchedulerSpinTimer=100
#CompressedLCP=1
#CompressedBackup=1
#Enabling CompressedLCP and CompressedBackup causes, respectively, local
## Transaction Parameters #
#MaxNoOfConcurrentTransactions: 4096
#MaxNoOfConcurrentOperations: 100000
#1106Change to smaller than 110000
MaxNoOfLocalOperations: 325980
MaxNoOfTables = 1024
MaxNoOfAttributes = 100000
MaxNoOfOrderedIndexes = 10000

[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
#ljx新增
#SendBufferMemory=2M
#ReceiveBufferMemory=2M

[NDB_MGMD]
Nodeid=22
#管理节点服务器
HostName=192.168.70.12
PortNumber=8518
# Storage Engines
DataDir=/usr/local/mysqlLinJiaXin/mgmdata

[NDBD]
Nodeid=23
#MySQL集群db1的IP地址
HostName=192.168.70.13

[NDBD]
Nodeid=24
#MySQL集群db2的IP地址
HostName=192.168.70.14

[MYSQLD]
Nodeid=25
HostName=192.168.70.13

[MYSQLD]
Nodeid=26
HostName=192.168.70.14
[MYSQLD]

Oracle&MCluster lover: Georgelin,
Share monthly salary with the person who recommend a big-data relative job to me now,
Personal cross platform website: www.gloCalHelp.com(Official) or glocalhelp.servebeer.com(temp),
Mobile: 0086 180 500 42436 or 156 6865 8383



Edited 1 time(s). Last edit at 11/13/2018 06:21AM by Nimbi lin.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: I help with finding a bug in NDBCluster 7.5.11
580
November 13, 2018 06:15AM


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.