Bug #29485 No output from REPORT MEMORY for non-DN
Submitted: 2 Jul 2007 14:42 Modified: 31 May 2008 10:10
Reporter: Jon Stephens Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:telco-6.2.3-bk OS:Linux
Assigned to: justin he CPU Architecture:Any
Tags: NDB_MGM, REPORT command, telco

[2 Jul 2007 14:42] Jon Stephens 
Description:
ndb_mgm> SHOW
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2    @127.0.0.1  (mysql-5.1.19 ndb-6.2.3, Nodegroup: 0, Master)
id=3    @127.0.0.1  (mysql-5.1.19 ndb-6.2.3, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @127.0.0.1  (mysql-5.1.19 ndb-6.2.3)

[mysqld(API)]   2 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)

ndb_mgm> ALL REPORT MEMORY

Node 2: Data usage is 1%(29 32K pages of total 2560)
Node 2: Index usage is 0%(20 8K pages of total 2336)
Node 3: Data usage is 1%(29 32K pages of total 2560)
Node 3: Index usage is 0%(20 8K pages of total 2336)
ndb_mgm> 1 report memory

ndb_mgm> 4 report memory

ndb_mgm> 2 report memory
Node 2: Data usage is 1%(29 32K pages of total 2560)
Node 2: Index usage is 0%(20 8K pages of total 2336)

ndb_mgm> 1 report mem

ndb_mgm> 3 report mem
Node 3: Data usage is 1%(29 32K pages of total 2560)
Node 3: Index usage is 0%(20 8K pages of total 2336)

ndb_mgm>

How to repeat:
See Description.

Suggested fix:
For other than a data node, something besides a blank line should returned, e.g. "Node X is not a data node"
[8 Aug 2007 9:59] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/32236

ChangeSet@1.2562, 2007-08-08 17:44:04+08:00, Justin.He@dev3-240.dev.cn.tlan +1 -0
  Bug#29485, No output from REPORT MEMORY for NON-DN
[10 Aug 2007 7:29] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/32345

ChangeSet@1.2562, 2007-08-10 15:14:05+08:00, Justin.He@dev3-240.dev.cn.tlan +1 -0
  Bug#29485, No output from REPORT MEMORY for NON-DN
[18 Sep 2007 15:01] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/34371

ChangeSet@1.2604, 2007-09-18 08:42:40+00:00, justin.he@turbo.localdomain +1 -0
  Bug#29485 No output from REPORT MEMORY for non-DN
[8 Nov 2007 14:29] Jon Stephens 
Documented bugfix in 5.1.22-ndb-6.2.8 and 5.1.22-ndb-6.3.6 changelogs; left PQ status unchanged pending further merges.
[31 May 2008 10:10] Jon Stephens 
Closed per discussion with Jonas.