Re: DB node problems across two PCs - Magnus Svensson - com.mysql.lists.cluster

5 messages in com.mysql.lists.clusterRe: DB node problems across two PCs

From	Sent On	Attachments
Craig Steadman	23 Aug 2004 01:58
Magnus Svensson	23 Aug 2004 04:14
Magnus Svensson	23 Aug 2004 05:22
Craig Steadman	23 Aug 2004 06:10
Magnus Svensson	24 Aug 2004 00:50

Subject:	Re: DB node problems across two PCs
From:	Magnus Svensson (magn...@mysql.com)
Date:	08/23/2004 04:14:57 AM
List:	com.mysql.lists.cluster

On Mon, 2004-08-23 at 10:58, Craig Steadman wrote:

I've just spent two days testing mysql-4.1.4-beta-nightly-20040820 which works ok on a single pc with mgm,db,api nodes. If I attempt to extend the config to combine a second db node (nodeid 4) on a another pc i see the following error.

Type of error: error Message: Invalid Configuration fetched from Management Server Fault ID: 2350 Problem data: Unable to alloc node id Object of reference: Could not alloc node id: no free nodeid 4 for nodetype 0 ProgramName: NDB Kernel ProcessID: 6294 TraceFile: ndb_0_trace.log.1 ***EOM***

Also after restarting the whole thing with the new 2x db node config I observe the following when i attempt to access the test table that was setup initially, which should return NULL when i query it.

mysql> use test; Database changed mysql> select * from ctest; ERROR 1015 (HY000): Can't lock file (errno: 4009)

Ive read the list archive an it appears others are having similar problems. Here's my config.ini

# file "config.ini" - showing minimal setup with 1 DB node # This file is placed in the start directory of ndb_mgmd, # the management server.

[COMPUTER DEFAULT]

[DB DEFAULT] #NoOfReplicas: 1 NoOfReplicas: 2

[API DEFAULT]

[MGM DEFAULT] ArbitrationRank: 2

[TCP DEFAULT] PortNumber: 28002

[COMPUTER] Id:1 HostName: 192.168.2.1

[COMPUTER] Id: 2 HostName: 192.168.3.254

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

[DB] Id: 2 ExecuteOnComputer: 1 FileSystemPath: /usr/local/mysql/mysql-cluster/node2/

[API] Id: 3 ExecuteOnComputer: 1

[DB] Id: 4 ExecuteOnComputer: 2 FileSystemPath: /usr/local/mysql/mysql-cluster/node3/

One thing I've noticed with the Ndb.cfg files that any trailing newlines for node1 at least stop it from intialising properly, ndb_mgmd just aborts.

Any assistance is appreciated.

There is a problem for the second ndbd to connect to ndb_mgmd. How do you configure the connect string of the fourth node? It should be "192.168.2.1:2200" or "192.168.2.1:2200;nodeid=4"

Also remember to do an "initial system restart" (ndbd -i) on both nodes the first time you startup the _new_ cluster. This will erase all old 1-node files/data and create system files for a 2-node cluster. Your old table will deleted!

Best regards Magnus

Cheers Craig