Bug #57336 Use instance no instead of its index when finding next instance
Submitted: 8 Oct 2010 7:09 Modified: 17 Oct 2010 9:00
Reporter: Maitrayi Sabaratnam Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:7.0 OS:Any
Assigned to: Maitrayi Sabaratnam CPU Architecture:Any

[8 Oct 2010 7:09] Maitrayi Sabaratnam
Description:
See snopsis

How to repeat:
This was discovered when introducing ndbinfo.diskpagebuffer, where the extra-worker instance number shown in the last line was wrong.

mysql> select * from ndbinfo.diskpagebuffer;
+---------+----------------+---------------+-------------------+------------+-----------+-----------------------------+--------------------------+-----------------------+
| node_id | block_instance | pages_written | pages_written_lcp | pages_read | log_waits | page_requests_direct_return | page_requests_wait_queue | page_requests_wait_io |
+---------+----------------+---------------+-------------------+------------+-----------+-----------------------------+--------------------------+-----------------------+
|       2 |              1 |           261 |                 0 |          0 |         0 |                           0 |                        0 |                     0 |
|       2 |              2 |           261 |                 0 |          0 |         0 |                           0 |                        0 |                     0 |
[8 Oct 2010 8:33] Bugs System
Pushed into mysql-5.1-telco-7.0 5.1.47-ndb-7.0.20 (revid:msabaratnam@mysql.com-20101008083134-52bz7p1hgrfm9tbj) (version source revid:msabaratnam@mysql.com-20101008083134-52bz7p1hgrfm9tbj) (merge vers: 5.1.47-ndb-7.0.20) (pib:21)
[17 Oct 2010 9:00] Jon Stephens
Issue doesn't seem to appear in a release. Closed w/o further action.