Bug #28847 ndb_mgm hangs when connected to none existing host
Submitted: 1 Jun 2007 21:45 Modified: 19 Jun 2007 12:10
Reporter: Jonathan Miller Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:mysql-5.1.18 ndb-6.2.3 OS:Linux
Assigned to: Stewart Smith CPU Architecture:Any

[1 Jun 2007 21:45] Jonathan Miller
Description:
Hi,

If try to use the ndb_mgm and accidentally type a connection string to a host that does not exist, the ndb_mgm act as though is has connected. Then is you try to do a show, or an "all status" it just hangs.

ndbXX:/space/run> ndb_mgm ndb:1186
-- NDB Cluster -- Management Client --
ndb_mgm> all status

#### Hung ####

ndbXX:/space/run> ndb_mgm ndbXX:1186
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: ndbXX:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2    @10.100.1.93  (mysql-5.1.18 ndb-6.2.3, starting)
id=3    @10.100.1.93  (mysql-5.1.18 ndb-6.2.3, starting)

[ndb_mgmd(MGM)] 1 node(s)
id=1   (mysql-5.1.18 ndb-6.2.3)

[mysqld(API)]   13 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)
id=8 (not connected, accepting connect from any host)
id=9 (not connected, accepting connect from any host)
id=10 (not connected, accepting connect from any host)
id=11 (not connected, accepting connect from any host)
id=12 (not connected, accepting connect from any host)
id=13 (not connected, accepting connect from any host)
id=14 (not connected, accepting connect from any host)
id=15 (not connected, accepting connect from any host)
id=16 (not connected, accepting connect from any host)

How to repeat:
see above

Suggested fix:
If the not able to connect to the host in the connection string, we should present the user with an error.
[8 Jun 2007 15:37] Stewart Smith
I think i know what this is... possibly found the same thing today from the API.
[13 Jun 2007 13:46] Stewart Smith
This (at least very much should be) fixed by BUG#29063 fix.

Changing to Documenting so Jon can easily grab the description from here. Affects MGMAPI apps.
[13 Jun 2007 19:40] Jon Stephens
Thanks for the heads-up, Stewart.

I'll document this along with 29063 when that one hits the tree(s).
[15 Jun 2007 8:36] Jon Stephens
(Putting this one back in Patch Queued so it doesn't show up in Docs queue until fix for 29063 hits tree.)
[19 Jun 2007 12:10] Jon Stephens
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented bugfix in 5.1.20 changelog.