Bug #88010 Unable to add new node under existing cluster from different machine
Submitted: 6 Oct 2017 13:56 Modified: 28 Oct 2017 22:15
Reporter: vikash tiwari Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: plugin Severity:S1 (Critical)
Version: OS:Microsoft Windows
Assigned to: CPU Architecture:Any
Tags: cluster

[6 Oct 2017 13:56] vikash tiwari
Description:
On a single window machine, I have basic setup of cluster with two sql and data node. It is working fine. I am trying to add new node from different machine and getting below alert.

'Could not obtain resource information for host '192.168.1.172': DLL load failed: The specified module could not be found.. Please click the appropriate cell in the host definition page to edit hardware resource information manually'

Can you please help to fix this issue. Kindly find details given below.

Operating System - Windows 10
Cluster version - MySQL Cluster 7.5
Installer version - mysql-cluster-gpl-7.5.7-winx64
Installation path - C:\Users\vtiwari\mysqlc (without any white-space and running as administrator)

How to repeat:
Please have a cluster setup on single window machine. Then try to add new node from different machine.
[6 Oct 2017 13:57] vikash tiwari
DLL load failed

Attachment: err-3.png (image/png, text), 88.34 KiB.

[7 Oct 2017 0:17] MySQL Verification Team
Hi,

If you want to install cluster on single machine for testing purposes use 127.0.0.1 as ip address.

regards
Bogdan
[7 Oct 2017 5:19] vikash tiwari
Thank you for reply.

As I mentioned earlier that there is no issue on single machine installation. I installed it successfully and it is perfectly fine.

The issue come when I am trying to add new node(sql/data) in installed cluster. Can you please suggest why I am getting below error.

"Could not obtain resource information for host '192.168.1.172': DLL load failed: The specified module could not be found.."
[7 Oct 2017 5:29] vikash tiwari
Thank you for reply.

As I mentioned earlier that there is no issue on single machine installation. I installed it successfully and it is perfectly fine.

The issue come when I am trying to add new node(sql/data) in installed cluster. Can you please suggest why I am getting below error.

"Could not obtain resource information for host '192.168.1.172': DLL load failed: The specified module could not be found.."
[7 Oct 2017 10:15] MySQL Verification Team
Hi,

sorry, I misunderstood the problem.

If you have a single computer cluster (on localhost) you can't add other machines to it (not easily nor automated).

If it's a normal cluster then check if it's installed at all on the other machine.

Does this help?

all best
Bogdan
[9 Oct 2017 5:40] vikash tiwari
Thank you so much for reply.

Can you please suggest how can setup normal cluster on multiple machines (Windows 10) at once. 

I tried to setup normal cluster using same interface . I had two below two machine.
1. 192.168.192
2. 192.168.1.172
 
Installer installed files were put in folder 'C:\Users\vtiwari\mysqlc' and cluster location was 'C:\Users\vtiwari\MySQL_Cluster' at both machine (using same user id). I tried from setup using'192.168.192' machine interface and got error message "Could not open socket to host '192.168.1.172'". 

Can you please explain that how to setup normal cluster using both above machine.
[10 Oct 2017 4:08] vikash tiwari
Dear Bogdan, 

Looking forward for your comments on my previous comment.

Thank you.
[28 Oct 2017 22:15] MySQL Verification Team
Hi,

While this works ok on my "old" setups, I tested with 2 "freshly installed" windows 10 boxes and reproduced the problem immediately. There's obviously some dependency that's not met and since this ndb_setup is a python thing I'll leave the setup team to deal with it.

The problem is verified, reported up the chain so hopefully will be fixed soon. For start a workaround should be found stating what dependency needs to be manually installed and then that dependency should become part of the package itself

Thanks for the report and patience
Bogdan