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
• Status: Closed
• 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:[e-mail]-20101008083134-52bz7p1hgrfm9tbj) (version source revid:[e-mail]-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.