Bug #27349 NodeId<n> Parameter is not allowed in tcp section

• Submitted: 21 Mar 2007 17:50
• Modified: 21 Mar 2007 18:19
• Reporter: Oli Sennhauser
• Status: Not a Bug
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.1.16
• OS: Any
• CPU Architecture: Any

[21 Mar 2007 17:50] Oli Sennhauser

Description:
When I try to tell a 4 node cluster (on 2 machines) to use a dedicated interconnect I got the following error:

> ndb_mgmd
Error line 22: [TCP] Unknown parameter: NodeId3
Error line 22: Could not parse name-value pair in config file.
Invalid configuration file: config.ini

How to repeat:
[TCP]
 
NodeId1                     = 10
NodeId2                     = 11
NodeId3                     = 12
NodeId4                     = 13
Hostname1                   = 10.0.0.1
Hostname2                   = 10.0.0.2
Hostname3                   = 10.0.0.1
Hostname4                   = 10.0.0.2

[21 Mar 2007 18:19] Jonas Oreland

Hi,

I'm not really sure what you're trying to do.
But that is not a supported syntex...

maybe you meant
[ndbd]
NodeId: 1
Hostname: kalle

[ndbd]
NodeId: 2
Hostname: anka

[22 Mar 2007 7:34] Oli Sennhauser

Thats exactly like it is documented:
http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-tcp-definition-direct.html

# TCP/IP Connections
[TCP]
NodeId1=3
NodeId2=4
HostName1=1.1.0.1
HostName2=1.1.0.2

So at least docu is wrong!?! But also the error message is bullshit. Because it seems that it recognizes at least entry for NodeId1 and NodeId2!

What I try to do is to tell him, that he should find NodeId1=10 on the IP Hostname=10.0.0.1 for a Cluster-Interconnect.

[22 Mar 2007 8:15] Oli Sennhauser

Bernd told me, that you have to use a tcp section for each node pair. So our docu is completely wrong: 
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-tcp-definition-direct.html

"Du musst für jede einzelne Verbindun zwischen zwei Rechnern eine [TCP] Gruppe haben.
Also [TCP] NodeId1 = 3 NodeId2 = 4, [TCP]NodeId1 = 4 NodeId2 = 5,  etc.
Bei vier nodes heisst dass also 6 TCP sections?
Ja."

[22 Mar 2007 9:00] Oli Sennhauser

It should also more clearly be commented in the docu that TCP sections should be move to the end of the config.ini.

[5 Apr 2007 12:25] Oli Sennhauser

OK. When it is not a bug. then it should at least clearly be docuemented in our docu:
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-tcp-definition-direct.html