MySQL Bugs: #28847: ndb_mgm hangs when connected to none existing host

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

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.

I think i know what this is... possibly found the same thing today from the API.

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.

Thanks for the heads-up, Stewart.

I'll document this along with 29063 when that one hits the tree(s).

(Putting this one back in Patch Queued so it doesn't show up in Docs queue until fix for 29063 hits tree.)

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.