Bug #18451 Restoring a backup changes fragement type

• Submitted: 23 Mar 2006 8:46
• Modified: 19 Jun 2006 12:56
• Reporter: Geert Vanderkelen
• Status: Closed
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S1 (Critical)
• Version: 5.1
• Assigned to: Tomas Ulin
• CPU Architecture: Any

[23 Mar 2006 8:46] Geert Vanderkelen

Description:

When taking a backup and restoring it the 'Fragement Type' is changing to 2 when it was original 5. A consequence is that the hashing is changing and that data is not equally distributed so 1 group will get more data.

How to repeat:
- setup a cluster with 3 data nodes and NrOfReplicas=1 (unusual, but this is minimal setup to show the problem)
- load data, and ALL DUMP 1000 show should data usuage to be equal
- use ndb_desc on the table you loaded data in, 'Fragement Type' is 5
- take a backup on all data nodes
- restore the meta data
- restore the data on each data node
- use ndb_desc on the table again and 'Fragement Type' has changed to 2
- loading more data, and the 2nd node (group) will get more data

Suggested fix:
n/a

[23 Mar 2006 8:48] Geert Vanderkelen

Verified using 5.1.2.

[24 Mar 2006 12:33] 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/4117