MySQL Bugs: #29674: restore of backup from different endian core dump

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	CPU Architecture:	Any

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.

backup data of the new test case for endian problem

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

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

looks ok.

pushed into ndb-bj tree 5.0.44

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

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

Pushed into 5.0.44 ndb-bj tree

Pushed into 5.0.50

Pushed into 5.1.23-beta

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.

Also documented in mysql-5.1.22-ndb-6.2.6 changelog.