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.