MySQL Bugs: #27444: DataMemory missing from report in cluster logs

Bug #27444	DataMemory missing from report in cluster logs
Submitted:	26 Mar 2007 14:20	Modified:	2 Apr 2007 11:26
Reporter:	Geert Vanderkelen	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S3 (Non-critical)
Version:	mysql-5.1.15_ndb-6.1.5	OS:	Linux (Linux)
Assigned to:	Tomas Ulin	CPU Architecture:	Any
Tags:	ndb, reporting

Description:
When using the option MemReportFrequency the DataMemory is not showing for one data node (usually the first one).

Doing a ALL DUMP 1000 in the ndb_mgm CLI every works as expected:

2007-03-26 16:10:23 [MgmSrvr] INFO     -- Node 3: Node 1: API mysql-5.1.15 ndb-6.1.5
2007-03-26 16:10:23 [MgmSrvr] INFO     -- Node 4: Node 1: API mysql-5.1.15 ndb-6.1.5
2007-03-26 16:10:23 [MgmSrvr] INFO     -- Node 4: Prepare arbitrator node 1 [ticket=4bac00018e955212]
2007-03-26 16:10:23 [MgmSrvr] INFO     -- Node 3: Started arbitrator node 1 [ticket=4bac00018e955212]

# Automated report of Memory report
2007-03-26 16:11:22 [MgmSrvr] INFO     -- Node 3: Index usage is 0%(8 8K pages of total 50464)
2007-03-26 16:11:22 [MgmSrvr] INFO     -- Node 4: Data usage is 0%(8 32K pages of total 15104)
2007-03-26 16:11:22 [MgmSrvr] INFO     -- Node 4: Index usage is 0%(8 8K pages of total 50464)

# ALL DUMP 1000 Output
2007-03-26 16:11:40 [MgmSrvr] INFO     -- Node 3: Data usage is 0%(8 32K pages of total 15104)
2007-03-26 16:11:40 [MgmSrvr] INFO     -- Node 3: Index usage is 0%(8 8K pages of total 50464)
2007-03-26 16:11:40 [MgmSrvr] INFO     -- Node 3: Resource 0 min: 0 max: 639 curr: 0
2007-03-26 16:11:40 [MgmSrvr] INFO     -- Node 4: Data usage is 0%(8 32K pages of total 15104)
2007-03-26 16:11:40 [MgmSrvr] INFO     -- Node 4: Index usage is 0%(8 8K pages of total 50464)
2007-03-26 16:11:40 [MgmSrvr] INFO     -- Node 4: Resource 0 min: 0 max: 639 curr: 0

# Automated report of Memory report
2007-03-26 16:12:22 [MgmSrvr] INFO     -- Node 3: Index usage is 0%(8 8K pages of total 50464)
2007-03-26 16:12:22 [MgmSrvr] INFO     -- Node 4: Data usage is 0%(8 32K pages of total 15104)
2007-03-26 16:12:22 [MgmSrvr] INFO     -- Node 4: Index usage is 0%(8 8K pages of total 50464)

How to repeat:
Setup simple cluster with 1 ndb_mgm and 2 ndbd's. Start them all with --initial using the configuration attached to this report.

(During tests I found a case where doing a restart of the node not reporting the DataMemory resulted in no reports at all anymore. Only the remaining node was getting log entries in the cluster log, though node 3 was happily up and showing in the SHOW output.
I could not yet repeat that.)

Configuration file

Attachment: bug27444_config.ini (text/plain), 1.11 KiB.

Verified using MySQL 5.1.15-6.1.5 (telco).

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/22986

ChangeSet@1.2448, 2007-03-27 11:12:26+02:00, tomas@whalegate.ndb.mysql.com +1 -0
  Bug #27444  	DataMemory missing from report in cluster logs
  - error in initial signal length giving uninitialized variable

5.1.18

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.18 changelog.