Bug #29674 restore of backup from different endian core dump
Submitted: 10 Jul 2007 3:44 Modified: 15 Sep 2007 11:37
Reporter: li zhou Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:5.0.44 OS:Solaris (linux <-> solaris)
Assigned to: li zhou

[10 Jul 2007 3:44] li zhou
Description:
Do backup on a little-endian machine, and copy backuped data to a big-endian machine(e.g. solaris), then restore it. Restore program will core dump. 

How to repeat:
1. start a 2 data nodes cluster on a linux(little endian) machine.
2. create a table , and insert values into it.
   mysql> use test;
   mysql> create table t1 (a int , b int) engine ndb;
   mysql> insert into t1 values (1, 1);
3. start backup
   ./bin/ndb_mgm -e "start backup"
4. copy the backuped data to a solaris machine.
5. start a same cluster as linux machine on solaris machine.
6. restore database.
   ./bin/ndb_restore -n 1 -b 1 -m -r /PATH/TO/BACKUP/BACKUP-1

restore program will core dump

Suggested fix:
Ndb backup/restore should be endian compatible in 5.0.
[7 Aug 2007 10:19] li zhou
backup data of the new test case for endian problem

Attachment: ndb_backup50_data.tar.gz (application/x-gzip, text), 101.26 KiB.

[7 Aug 2007 10:22] 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/32195

ChangeSet@1.2477, 2007-08-07 18:07:57+00:00, lzhou@dev3-63.(none) +17 -0
  BUG#29674 Restore/backup are endian compatible in 5.0
[14 Aug 2007 3:54] Stewart Smith
looks ok.
[15 Aug 2007 8:49] li zhou
pushed into ndb-bj tree 5.0.44
[20 Aug 2007 2: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/32724

ChangeSet@1.2474, 2007-08-20 10:47:09+00:00, lzhou@dev3-63.(none) +1 -0
  BUG#29674 add install data of the new test case in makefile.am
[20 Aug 2007 7:09] 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/32727

ChangeSet@1.2475, 2007-08-20 14:57:04+00:00, lzhou@dev3-63.(none) +1 -0
  BUG#29674 Remove warning in pushbuild in 5.0
[5 Sep 2007 1:57] li zhou
Pushed into 5.0.44 ndb-bj tree
[14 Sep 2007 16:25] Bugs System
Pushed into 5.0.50
[14 Sep 2007 16:26] Bugs System
Pushed into 5.1.23-beta
[15 Sep 2007 11:37] Jon Stephens
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 in 5.0.50 and 5.1.23 changelogs as follows:

It was not possible to restore
          a backup made on a cluster host using one endian to a machine
          using the other endian.
[21 Sep 2007 8:29] Jon Stephens
Also documented in mysql-5.1.22-ndb-6.2.6 changelog.