https://community.hpe.com/t5/operating-system-linux/mysql-cluster-problem-ndbd-down/m-p/3450270#M71577 ndbd down when was started about 1 minute....<BR />Why?<BR /><BR />As trace log is following:<BR /><BR />--------------- Signal ----------------<BR />r.bn: 253 "NDBFS", r.proc: 2, r.sigId: 1708759 gsn: 264 "FSREADREQ" prio: 0<BR />s.bn: 248 "DBACC", s.proc: 2, s.sigId: 1708758 length: 10 trace: 0 #sec: 0<BR />fragInf: 0<BR /> UserPointer: 0<BR /> FilePointer: 545<BR /> UserReference: H'00f80002 Operation flag: H'00000000 (No sync, Format=List of pairs)<BR /> varIndex: 2<BR /> numberOfPages: 2<BR /> pageData: H'00000000, H'0000003b<BR /> H'00000001, H'0000003c<BR /><BR /><BR />As config.ini is following:<BR />[NDBD DEFAULT]<BR />NoOfReplicas= 2<BR />DataDir= /var/lib/mysql-cluster<BR />DataMemory = 700M<BR />IndexMemory = 196M<BR />MaxNoOfOrderedIndexes = 1024<BR />MaxNoOfUniqueHashIndexes = 512<BR />MaxNoOfConcurrentOperations=250000<BR />UndoIndexBuffer=10M<BR />RedoBuffer=32M<BR />NoOfFragmentLogFiles=16<BR /><BR />[NDB_MGMD]<BR />Hostname= 61.129.68.152<BR />DataDir= /var/lib/mysql-cluster<BR /><BR />[NDBD]<BR />Hostname= 61.129.68.141<BR /><BR />[NDBD]<BR />Hostname= 61.129.68.152<BR /><BR />[MYSQLD]<BR />Hostname= 61.129.68.141<BR /><BR />[MYSQLD]<BR />Hostname= 61.129.68.152<BR /> Sat, 25 Dec 2004 03:32:05 GMT NiCK_76 2004-12-25T03:32:05Z https://community.hpe.com/t5/operating-system-linux/mysql-cluster-problem-ndbd-down/m-p/3450270#M71577 ndbd down when was started about 1 minute....<BR />Why?<BR /><BR />As trace log is following:<BR /><BR />--------------- Signal ----------------<BR />r.bn: 253 "NDBFS", r.proc: 2, r.sigId: 1708759 gsn: 264 "FSREADREQ" prio: 0<BR />s.bn: 248 "DBACC", s.proc: 2, s.sigId: 1708758 length: 10 trace: 0 #sec: 0<BR />fragInf: 0<BR /> UserPointer: 0<BR /> FilePointer: 545<BR /> UserReference: H'00f80002 Operation flag: H'00000000 (No sync, Format=List of pairs)<BR /> varIndex: 2<BR /> numberOfPages: 2<BR /> pageData: H'00000000, H'0000003b<BR /> H'00000001, H'0000003c<BR /><BR /><BR />As config.ini is following:<BR />[NDBD DEFAULT]<BR />NoOfReplicas= 2<BR />DataDir= /var/lib/mysql-cluster<BR />DataMemory = 700M<BR />IndexMemory = 196M<BR />MaxNoOfOrderedIndexes = 1024<BR />MaxNoOfUniqueHashIndexes = 512<BR />MaxNoOfConcurrentOperations=250000<BR />UndoIndexBuffer=10M<BR />RedoBuffer=32M<BR />NoOfFragmentLogFiles=16<BR /><BR />[NDB_MGMD]<BR />Hostname= 61.129.68.152<BR />DataDir= /var/lib/mysql-cluster<BR /><BR />[NDBD]<BR />Hostname= 61.129.68.141<BR /><BR />[NDBD]<BR />Hostname= 61.129.68.152<BR /><BR />[MYSQLD]<BR />Hostname= 61.129.68.141<BR /><BR />[MYSQLD]<BR />Hostname= 61.129.68.152<BR /> Sat, 25 Dec 2004 03:32:05 GMT https://community.hpe.com/t5/operating-system-linux/mysql-cluster-problem-ndbd-down/m-p/3450270#M71577 NiCK_76 2004-12-25T03:32:05Z https://community.hpe.com/t5/operating-system-linux/mysql-cluster-problem-ndbd-down/m-p/3450271#M71578 I solved below problem by mysql maillist.However , another problem cornered me.<BR />"ERROR 1297: Get temporary error 4031 'Node failure caused abort of transaction' from ndbcluster" appear when alter a big table to ndb engine. The big table contain about 800000 rows.<BR /><BR />How to solve it? Sat, 25 Dec 2004 05:13:10 GMT https://community.hpe.com/t5/operating-system-linux/mysql-cluster-problem-ndbd-down/m-p/3450271#M71578 NiCK_76 2004-12-25T05:13:10Z