59 messages in com.mysql.lists.clusterRe: DB nodes crash...
FromSent OnAttachments
Gurgen Petrosyan24 Aug 2004 06:32 
Crouch, Luke H.24 Aug 2004 06:56 
Crouch, Luke H.24 Aug 2004 21:49 
Magnus Svensson25 Aug 2004 01:58 
Lars Thalmann25 Aug 2004 04:21 
Gurgen Petrosyan25 Aug 2004 06:02 
Lars Thalmann25 Aug 2004 07:39 
Gurgen Petrosyan25 Aug 2004 13:29 
Tomas Ulin14 Sep 2004 02:37 
Tomas Ulin14 Sep 2004 05:20 
Gurgen Petrosyan14 Sep 2004 08:34 
Gurgen Petrosyan14 Sep 2004 10:32 
Gurgen Petrosyan14 Sep 2004 11:02 
Tomas Ulin16 Sep 2004 06:35 
Gurgen Petrosyan16 Sep 2004 12:38 
Gurgen Petrosyan16 Sep 2004 13:10 
Gurgen Petrosyan17 Sep 2004 12:56 
Gurgen Petrosyan17 Sep 2004 14:41 
Sharad Maloo20 Sep 2004 07:12 
Gurgen Petrosyan20 Sep 2004 13:39 
Magnus Svensson22 Sep 2004 05:28 
Bruce Robertson22 Sep 2004 10:00 
Gurgen Petrosyan22 Sep 2004 13:59 
Gurgen Petrosyan22 Sep 2004 14:21 
Gurgen Petrosyan22 Sep 2004 14:35 
Gurgen Petrosyan22 Sep 2004 14:39 
Gurgen Petrosyan22 Sep 2004 15:49 
Mikael Ronström23 Sep 2004 00:20 
Mikael Ronström23 Sep 2004 00:29 
Gurgen Petrosyan03 Oct 2004 11:32 
Crouch, Luke H.04 Oct 2004 06:12 
Gurgen Petrosyan04 Oct 2004 13:58 
pek...@mysql.com08 Nov 2004 05:16 
Gurgen Petrosyan08 Nov 2004 12:51 
Joseph E. Sacco, Ph.D.11 Nov 2004 05:18 
Gurgen Petrosyan11 Nov 2004 05:25 
Gurgen Petrosyan28 Nov 2004 08:47 
Jonas Oreland29 Nov 2004 00:15 
Klaus Byskov Pedersen18 Jan 2005 00:27 
Mikael Ronström18 Jan 2005 02:14 
Gurgen Petrosyan18 Jan 2005 07:21 
Gurgen Petrosyan18 Jan 2005 08:47 
Gurgen Petrosyan18 Jan 2005 09:00 
Gurgen Petrosyan18 Jan 2005 09:17 
Jon Stephens02 Feb 2005 09:03 
Mikael Ronström02 Feb 2005 11:21 
Gurgen Petrosyan02 Feb 2005 16:28 
Jon Stephens02 Feb 2005 18:16 
Jon Stephens07 Feb 2005 09:16 
Gurgen Petrosyan07 Feb 2005 10:18 
Gurgen Petrosyan09 Feb 2005 11:51 
Stefan Hinz23 Feb 2005 06:12 
Eric Bergen05 Mar 2005 11:36 
Gurgen Petrosyan05 Mar 2005 12:56 
Gurgen Petrosyan05 Mar 2005 14:00 
Gurgen Petrosyan05 Mar 2005 14:15 
Jon Stephens05 Mar 2005 18:20 
Jon Stephens07 Mar 2005 07:35 
Gurgen Petrosyan07 Mar 2005 11:39 
Subject:Re: DB nodes crash...
From:Gurgen Petrosyan (gur@ipia.sci.am)
Date:09/22/2004 02:39:15 PM
List:com.mysql.lists.cluster

but if i have NoOfReplicas=1 ?

On Wed, 22 Sep 2004, Magnus Svensson wrote:

Hi,

when switching between 1 and 2 replicas you must perform and initial system restart of the cluster to create new system files.

This is done using the switch --initial

ndbd --initial

Best regards Magnus

Quoting Gurgen Petrosyan <gur@ipia.sci.am>:

I run MySQL Cluster with

1 MGM node 2 DB nodes and 1 API node

When MySQL Cluster is running 2 DB nodes crashed!

with config.ini file:

[COMPUTER DEFAULT] [DB DEFAULT] NoOfReplicas: 2

[MGM DEFAULT] ArbitrationRank: 2

[TCP DEFAULT] PortNumber: 28002

[COMPUTER] Id: 1 HostName: 10.1.29.101

[COMPUTER] Id: 2 HostName: 10.1.29.102

[COMPUTER] Id: 3 HostName: 10.1.29.103

[COMPUTER] Id: 5 HostName: 10.1.29.105

[MGM] Id: 1 ExecuteOnComputer: 1 PortNumber: 28000

[DB] Id: 2 ExecuteOnComputer: 2 FileSystemPath: /usr/local/mysql_cluster/db-2 IndexMemory: 1M DataMemory: 1M

[DB] Id: 5 ExecuteOnComputer: 5 FileSystemPath: /usr/local/mysql_cluster/db-5 IndexMemory: 1M DataMemory: 1M

[API] Id: 3 ExecuteOnComputer: 3

1st DB node crashed with error: **************************************** Date/Time: Tuesday 21 September 2004 - 16:26:09 Type of error: error Message: Invalid Configuration fetched from Management Server Fault ID: 2350 Problem data: Illegal configuration change. Initial start needs to be performed when changing no of replicas (1 != 2) Object of reference: DBDIH (Line: 3508) 0x0000000a ProgramName: NDB Kernel ProcessID: 386 TraceFile: ./ndb_2_trace.log.8

2nd DB node crashed with error: (when NoOfReplicas=2) ***************************************** Date/Time: Tuesday 21 September 2004 - 16:26:16 Type of error: error Message: Internal program error (failed ndbrequire) Fault ID: 2341 Problem data: QmgrMain.cpp Object of reference: QMGR (Line: 1833) 0x0000000a ProgramName: NDB Kernel ProcessID: 390 TraceFile: ./ndb_5_trace.log.6 ***EOM***

or 2nd DB node crashed with error: (when NoOfReplicas=1) ****************************************** Date/Time: Tuesday 21 September 2004 - 16:41:30 Type of error: error Message: Arbitrator shutdown Fault ID: 2305 Problem data: Arbitrator decided to shutdown this node Object of reference: QMGR (Line: 3774) 0x0000000a ProgramName: NDB Kernel ProcessID: 489 TraceFile: ./ndb_5_trace.log.7

please help!

---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.